Suggested Prerequisites
Power BI – Level 1 or equivalent experience
Description
Power BI Level 2 is a complement to Level 1. This course completes the discussions regarding data, DAX calculations, and visualizations, and prepares the user to create and share dashboards across the Power BI user platform. A prerequisite to Level 2 is Power BI Level 1, which focuses on acquiring data, cleaning and transforming data, and introduction to visualizations.
Topics
Data Considerations
- ReviewCreating a rolling calendar
- Appending files from a folder
- Configuring Power BI Data Source and Refresh Settings
- Defining Hierarchies in Power BI
- Importing Models from Excel to Power BI
- Data Connection Best Practices
Next level DAX
- Implicit vs. Explicit DAX Measures
- DAX Date and Time functions
- DAX Conditional & Logical Functions
- DAX Count functions
- DAX Iterator Functions
- DAX Best Practices
Visualizations
- Matrix Visuals
- KPI Visuals
- Visualizing Geospatial Data with Maps
- Visualizing Data with Tree Maps
- Trends with Line and Area Charts
- Forecasts
- Goal Pacing with Gauge Charts
- Adding Drill Through Filters
- Report Bookmarks
- Testing Scenarios with What-if Parameters
- Visualization Best Practices
Sharing
- Managing and Viewing Roles in Power BI
Power BI Desktop – Level 2
