Classroom Training

MS Power BI (Two Days)

(9:30 a.m. - 12:30 p.m and 2:00 p.m. - 5:00 p.m.)


     

    • Introduction to Power BI
      • An introduction to Power BI
      • Power BI features
      • Power BI platforms
      • Power BI licensing models
      • Set up Power BI
      • Prepare a dashboard in Power BI service
    • Power Query Fundamentals
      • What is Power Query?
      • A Brief History of Power Query
      • Where Can I Find Power Query?
      • Main Components of Power Query
      • Get Data and Connectors
    • Data Model Fundamentals
      • Adding data Types within Query Editor
      • Using Parameters to enable Sharing
    • Collect data from various data sources
      • Data sources supported by Power BI
      • Build a Power BI report in Power BI Desktop
      • Publish you report to Power BI service
    • DAX Functions
      • Calculated columns and measures
      • DAX expressions syntax and context
      • DAX functions
    • Create Power BI Report
      • Import data from an Excel workbook into Power BI
      • Add a meaure and a calculated column
      • Add Power BI visuals to the report
      • Arrange the visuals
      • Prepare the report for mobile view
      • Publish and view the report
    • Create PivotTable/PivotChart from Data Model
      • Enable the Data Model
      • Import the Data Tables
      • Define Relationships
      • Build the PivotTable and PivotChart