Since November 2021 I’ve delivered a regular webinar to help simplify the process of keeping up to date with the ever changing world of Microsoft 365. This webinar series is delivered on behalf of Leadership Through Data. Details & sign up can be found on their website. UK USA & Canada Australaisa
Included in these workshops are a breakdown of the areas roadmap items cover at the time. In this blog I’ll explain my process and also showcase the history since Nov 2021. I find it very interesting to observe the different focus on development in the roadmp.
The aim of this analysis is to give an idea of the breakdown of updates on the roadmap at the time of the webinar.
The Process
It starts with a download of the Microsoft 365 Roadmap in a CSV file. This file is converted into an Excel Workbook and the data formatted as an Excel table.
From there I use the Text to Columns feature to separate the Product tags column into separate columns to faciliate counting how many times each product tag appears in the roadmap.
Next I use a sheet which was created using a series of UNIQUE formulas to obtain a single list of all the product tags used. The outcome of this is then copied as text into a table against which I use COUNTIF function to count the number of times the tag appears. As there are too many tags for the graph, I have assign a category to group tags together.
This list is then turned into a Pie Chart using the Pivot Chart feature
The History
November 2021
January 2022
June 2022
October 2022
January 2023
April 2023
July 2023
November 2023
February 2024
Conclusion
It really is fascinating looking at the changes over time. But I do wonder if the product teams are all equally diligent in how they update the roadmap, which could also impact the way the numbers change.
This may not be the most exact methodology, but it does highlight the makeup of the Microsoft 365 Roadmap. Helpful sugestions for easier ways of carrying out this analysis or for improvements in the process are welcome.
Sara Fennah's Blog 