Course 10 -Power BI Advanced

In this course you will go beyond the basics and learn more about Microsoft SQL Server to develop your database skills.

What You Will Learn

In this course you learn how to:

• PowerPivot data models (Advance)
• Pivot tables using PowerPivot
• Using Excel tables
• Using other data sources
• Getting data (Power Query)
• Transforming data (Power Query)
• Calculated columns
• Measures
• DAX basics
• The CALCULATE function
• More advanced DAX functions
• Calendars
• Date functions
• Hierarchies
• KPIs
• Perspectives