The following Excel file contains a Power Pivot data model based on Microsoft’s latest sample data warehouse database (Wide World Importers) for SQL Server 2016:
The images in the slideshow at the bottom provide essential details of the model (size, schemas, metadata). I’ll likely use this model for upcoming presentations and/or training sessions and blog posts related to Excel 2016, DAX, and MSBI generally.
Per my post last week I wanted to blog about parameterized cube functions but the more I thought about that post I concluded we should first step back and A) build and share a sound model to support future technical posts and B) help address the question “Why blog about Power Pivot and Excel (2016) and not Power BI Desktop?”
Regarding Part B, I’d strongly recommend the following two videos from MS Data Insights Summit earlier this year. Per the first video, Excel has some distinct advantages for certain use cases and complements Power BI. Per the second video, Riccardo Muti does a great job in explaining the MSBI roadmap and how PBI, Excel, and SSRS (including its new mobile capability) each meet specific workloads. Therefore, although it’s exciting to see Power BI continue to evolve, it’s important to remember the bigger picture and many of my future posts (and projects) will focus on Excel and SSRS BI scenarios.