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.

Created by: Sander Kollerie
ICT Consultant and trainer

What Will I 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

Requirements

• Basic knowledge of computers
• A basic understanding of databases is a pro
• Know the basics of Excel

Target audience

• People who do analytics and want to use PowerPivot
• Database designers who need to design a datawarehouse schema using the star schema