Get in Touch

Course Outline

Module 1: Fundamentals

  • Course structure and content overview
  • Download: project files
  • Introduction to the course project
  • Important course information

Module 2: Introduction to Microsoft in Power BI

  • Overview of Power BI Desktop and its components
  • Download, Installation, and Power BI Desktop settings
  • Important: settings and options
  • Power BI Service and mobile application

Module 3: Connecting and modeling data in Microsoft Power BI Desktop

  • Types of data connectors in Power BI Desktop
  • Query Editor (Power Query)
  • Data import from Excel and CSV
  • Basic table transformations in Power BI Desktop
  • Working with TEXT type tools
  • Working with NUMERIC type tools
  • Working with DATE and TIME tools
  • Generating conditional and index columns
  • Data grouping and aggregation
  • Pivot / Unpivot in Power BI
  • Data merging in Power Query (Merge)
  • Appending data in Power Query (Append)
  • Import from a Folder
  • Data source modification and refresh (Refresh)

Module 4: Creating links between tables and data models in Power BI Desktop

  • What is a Data Model?
  • DATE type tables and DIMENSION type tables
  • Creating Relationships between tables
  • Management and editing of relationships between tables
  • Relationship Cardinality; Filter Flow
  • Connecting multiple DATA type tables

Module 5: Data analysis with DAX calculations in Power BI

  • Introduction to DAX (Data Analysis Expressions) + SYNTAX
  • Intro DAX – Calculated Columns
  • Intro DAX – Measures
  • Measure Filter Context
  • Categories of DAX functions
  • Date and Time functions

Module 6: Data visualization in Power BI

  • Introduction to "Report" Mode
  • Inserting visuals in Power BI
  • Visual formatting options
  • Filtering options
  • Exploring data with the Matrix visual
  • Data filtering using Slicers
  • Displaying values using Card and KPI visuals
  • Editing interactions between reports

Module 7: Power BI Service and integration with Teams

  • Publishing reports from Power BI Desktop to Power BI Service
  • Creating Dashboards from published reports
  • Sharing options with team members via Microsoft Teams
  • Sharing and collaboration in Power BI Service
  • Data export: Excel, PowerPoint, PDF

Requirements

Power BI Desktop 64-bit

Power BI Service or Power Pro license for module 7.

 14 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories