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.
Great content you’ve been publishing and awesome data model. I think you may have authored the very first WWI PowerPivot model. Appreciate your dedicated table for measures – did you add a table from WWI and strip out the columns? Did you add sheet 2 to the data model. Looking forward to upcoming content, especially SSRS and PBI hybrid models.
Thanks Vinnie! There are so many new BI scenarios and features to explore and think/blog about. Having an XLSX, PBIX, and now a Tabular version of this model will make it easier to write certain posts such as the upcoming SSRS 16′ (with AS Tabular as source).
For the dedicated measures table I used a SELECT statement without a FROM clause to return a single row of null values (SELECT ” as [Col1], ” as [Col2],…..). The query is connected to the same SQL Server WWI database.