Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Summary
Here Power BI is used to analyze Office 365 roadmap items. What can be a better approach to use an Office 365 tool to analyze Office 365 next technological waves?
Approach
I love the idea that we are (especially people working on Office 365) surfing on technology trends to help our customers and companies do their best. It’s also a great imperative in order to never be trapped in old or outdated technologies where employability will be bad (at least). It is the same for our customers trying to get the right set of tools to have the work done at the end of the day.
But we can ask: What will be the next waves of innovation in the Office 365 product set?
To answer this question, we should first go to the Office 365 roadmap site, the purpose of which is to list all incoming improvements on products in the suite.
But despite very precise and accurate information present on this site, it’s really hard to get an overview of where Microsoft is investing in the next months or quarters. It’s also difficult to tell which products currently get the most investment in development teams and which ones will probably be most important in the next months and years.
Here’s where Power BI can be of great help. You can download a spreadsheet version of the roadmap and then manipulate it more easily. The following analysis is based on the Office 365 Roadmap Excel file as of June 10th, 2018. After quick transformations in Power BI, here is a view of the number of features currently under development or recently released.
More explanations on this can be found on this blog post: Surfing Office 365 waves
For any questions, you can reach me at @patricg
eyJrIjoiNWRjNGQyNjgtNjk3MS00MmZiLTgwMjItZDBmZmM4NmY4YzYwIiwidCI6IjRiOThiZmM2LTUwNTItNDVmMC1iYjlhLTEzZTkyMjhkNGNmMSIsImMiOjh9
@Patricg With the update of the official Microsoft Office Roadmap page, the export file has also changed. The format has changed from .xlsx to .csv. In the course of this also the contained fields and their names were changed, whereby the template cannot simply be updated, and the fields must be assigned anew.
Will there be a template adapted to the new export format?
Yes sure! I plan to update it anytime soon in the coming weeks.