Dimensional modeling: Pivot reports with multiple tables
The schema you need to know to build reports in Excel and Power BI with multiple tables using the Excel Data Model.
4.14 (38 reviews)
823
students
2 hours
content
May 2015
last update
$13.99
regular price
What you will learn
Design a database based on the star schema for data analysis
Design tables for Excel PowerPivot
Know why you don't use a relational database model for analytics
What a datawarehouse is
What a star schema is
What de-normalization is and why you should use it in the case of analytics
Make more flexible reports
Screenshots
Related Topics
436868
udemy ID
3/2/2015
course created date
4/18/2020
course indexed date
Bot
course submited by