Suggested Prerequisites

Power BI – Level 1 or equivalent experience


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.


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


  • 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


  • Managing and Viewing Roles in Power BI
Power BI Desktop – Level 2
Tagged on:
WordPress management provided by