Use Power BI to shape and cleanse data, preparing it for output to visualizations and reports. Learn to work with more advanced data models, and to create and use data hierarchies. Understand how to create/apply reference lines using the Analytics panel, and how to create and use measures. Learn to make calculated columns using Data Analysis Expression (DAX) functions and to use DAX to calculate across multiple tables. Discover the CALCULATE function to generate multiple criteria filters, the RANK function to order data, and other functions to manage date arithmetic. Understand how to use logical functions to create alerts and custom groups. Topics include in-depth calculated columns and measures, and creating end-user parameter controls. Additonal topics include advanced aggregation and filtering using the “X” functions (SUMX, AVERAGEX, MINX, MAXX, COUNTX).
In this class, you will learn how to:
Creating calculated columns
Creating Quick Measures
Performing joins in data queries
Advanced applications of tooltips
PrerequisitesIntermediate Power BI or equivalent experience.
Applies Towards the Following Certificates
- Data Analysis Certificate : Data Analytics and Visualization