Topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second-day topics include creating Power Views with Excel, Power Map, and Power Query. Third-day topics include database design concepts, how to build both general purpose and customized data models, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Fourth-day topics cover Relational functions, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.

Outcomes

At the end of this course, the participants will learn. Everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. How to transform and query data sources using Power Query. Creating effective and professional reports and effectively applying new visualization techniques using Power View. How to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers.