Get in Touch

Course Outline

Module 1: Fundamentals

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

Module 2: Getting Started with Power BI

  • Overview of Power BI Desktop and its components
  • Download, installation, and desktop settings
  • Key settings and options
  • Power BI Service and mobile app

Module 3: Connecting and modeling data in Power BI Desktop

  • Data connectors in Power BI Desktop
  • Query Editor (Power Query)
  • Importing data from Excel and CSV
  • Basic table transformations in Power BI Desktop
  • Working with text tools
  • Working with numeric tools
  • Working with date and time tools
  • Creating conditional and index columns
  • Data grouping and aggregation
  • Pivoting and unpivoting in Power BI
  • Merging data in Power Query
  • Appending data in Power Query
  • Importing from a folder
  • Modifying data sources and refreshing data

Module 4: Establishing relationships between tables and data models in Power BI Desktop

  • Understanding Data Models
  • Date and dimension tables
  • Creating relationships between tables
  • Managing and editing table relationships
  • Relationship cardinality and filter flow
  • Connecting multiple data tables

Module 5: Analyzing data with DAX calculations in Power BI

  • Introduction to DAX (Data Analysis Expressions) + syntax
  • DAX basics: Calculated columns
  • DAX basics: Measures
  • Filter context of measures
  • DAX function categories
  • Date and time functions

Module 6: Data visualization in Power BI

  • Introduction to Report view
  • Adding visuals in Power BI
  • Visual formatting options
  • Filtering options
  • Exploring data with the Matrix visual
  • Filtering data 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 using 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