Evolutionary History of Microsoft Fabric - Spreadsheets to Lakehouse
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- While some may believe that Microsoft Fabric was created in May 2023, this presentation reviews over two decades of the products leading up to Fabric. You've all heard of SQL Server and Excel, but what roles did ProClarity, Panorama, and Sharepoint play in the evolution of Power BI and Fabric? How did Microsoft analytic tools emerge from on-premises and begin existing in the Cloud? In order to explain the context of the tools currently in Fabric, this presentation attempts to provide an entertaining history of how Fabric evolved from simpler tools. For those new to Fabric, understanding the past provides content for the present and future. This is a recorded version of a presentation that I gave at SQL Saturday Minnesota 2023.
UPDATES:
1. I was originally mistaken that Datazen visuals were the basis for Power BI visuals, and have removed that portion of the video. The Power BI visuals were created by a Microsoft team.
2. I was notified by a viewer that the slide shows PowerPivot suddenly appearing as part of Excel, when the core engine was originally developed by the Analysis Services team.
Note that the content of this video is solely created by me, and is not endorsed by my employer. Content is not 100% correct, but it was the best I could do with the information that I had available.
MENU
00:00 - Intro
07:14 - SQL Server lineage
10:50 - Old SQL Server slides
13:01 - Sharepoint and Excel lineage
16:28 - Old ProClarity, Excel, PowerPivot, & Sharepoint slides
20:44 - Power BI SaaS lineage
23:10 - Azure Synapse & PaaS lineage
25:05 - Fabric & the Cloud Singularity
31:34 - Value of Fabric SaaS vs PaaS
32:57 - Outro
Liked this very much. Even though I have been involved with BI for a long time, I am relatively new to the MS tool stack and this is a really helpful overview, thnx!
Great content here. Filled in a lot of gaps that I have thought about from the last few years.
Superb! Thanks so much for connecting all the dots, and making the Fabric strategy and roadmap so clear.
Loved your presentation, thank you for creating and sharing it!
It may be worth mentioning that PowerPivot (the vertipaq engine) did not come from the blue (or green), but really from Analysis Services. It shipped initially only in Excel, but it was 100% analysis services.
Thank you! I've added a note to the description and the related LinkedIn post.
great presentation and thank you for providing this visual roadmap. even though i've experienced all of these technologies first hand since sql 7, it's actually a good reminder of how the individual components have evolved and now converged into fabric.
Things just went berserk around 2022, in a good way! I can totally relate to everything from SQL 7 until it had just started going Azure and then the advancement is exponential each year! Very informative reference video, Greg. Thank you!
Great presentation. Congratulations.
I've always liked to "sense" the evolution of IT offerings (software products and services)
What a great presentation! Excellent stroll down memory lane. I wrote a book with Dan English about PowerView back in the day and PowerView got scrapped within days of the book's release. LOL!
Thank you, it was fun to put it all together. It's unreal the velocity of change with product improvements and changes. The right side of my primary diagram would even be a little bit different today versus when I put it together a few months ago.
Crazy to think about how fast this has happened
Great presentation, thanks
omg you are genious - danke!
great presentation that cuts through all of the marketing nonsense and shows real lineage
Very nice summary, thank you for taking the time to share it!
Great job on compiling everything. I'd like to offer a small suggestion if that's all right.
Engine - VertiPaq
1. a box for VertiPaq which connected with
1.1 PowerPivot 2010 Add-In for Excel 2010
1.2 Analysis Services Tabular Mode
1.3 SQL Server 2012 - Columnstore storage
VertiPaq rename to xVelocity in 2012
Acquired
2. Maximal Innovative Intelligence which is connected
2.1 Microsoft Data Analyzer (2002) (for OLAP)
Excellent info that I didn't find anywhere on the web. Thank you! At some point I plan to update the presentation and I'll include this content.
Great job! Thank you!
Good stuff. Thank you.
Thanks for the insights, how much of the Fabric promised land is real vs roadmap/vision?
It's all there but some parts are more mature than others. This roadmap should help with any questions on this topic: aka.ms/fabricroadmap
Oh how I wanted the decomp tree to have colors... but alas MS locked the code and even the old Proclarity people were not permitted to implement it for us! I may still have a performance point book or two around. It was a tough use case for sure. Thanks for walking us older folks along the trail.
Agreed! I think the newer Decomp Tree in PBI can change colors based on KPIs, but I agree that the old PerformancePoint version was a step down form ProClarity.