Microsoft Power BI (Two Days)

  • 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