Evolutionary History of Microsoft Fabric - Spreadsheets to Lakehouse

Рет қаралды 9,095

Күн бұрын

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

Пікірлер: 23

@sphscholz 3 ай бұрын

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!

@sanjay98317 4 ай бұрын

Superb! Thanks so much for connecting all the dots, and making the Fabric strategy and roadmap so clear.

@alexanderjacobs817 4 ай бұрын

Great content here. Filled in a lot of gaps that I have thought about from the last few years.

@bcrivatutub 4 ай бұрын

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.

@insightsoutliers 4 ай бұрын

Thank you! I've added a note to the description and the related LinkedIn post.

@blendcloud 3 ай бұрын

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.

@kdcapparelli 4 ай бұрын

Great presentation. Congratulations. I've always liked to "sense" the evolution of IT offerings (software products and services)

@ankeet1 4 ай бұрын

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!

@angelost1467 4 ай бұрын

Very nice summary, thank you for taking the time to share it!

@paulpurington8637 3 ай бұрын

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!

@insightsoutliers 3 ай бұрын

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.

@OMAKEM 4 ай бұрын

Great presentation, thanks

@Andrewskji 4 ай бұрын

Crazy to think about how fast this has happened

@barrysinni7556 4 ай бұрын

great presentation that cuts through all of the marketing nonsense and shows real lineage

@rifkiamil 4 ай бұрын

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)

@insightsoutliers 4 ай бұрын

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.

@Francesca-yu5cy 2 ай бұрын

omg you are genious - danke!

4 ай бұрын

Great job! Thank you!

@aamoody81 4 ай бұрын

Good stuff. Thank you.

@daustonian9331 4 ай бұрын

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.

@insightsoutliers 4 ай бұрын

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.