Course Outline

Power BI Architecture

Data sources

  • On-premises and online data sources
  • Data transformations + M language

Modeling

Relationship between tables (single and multidirectional data filtering)

  • DAX - Understanding the syntax and best practices
  • Introduction to DAX
    • Most commonly used functions and context of calculations
    • Working with the time dimension (including fiscal periods, comparing periods, YTD)
    • Filter functions

Visualizations

  • Interactive data analysis
  • Select the appropriate visualization
  • Filters, grouping, exclusions
  • Visualization on maps

Teamwork with Power BI

  • Dashboards and Reports
  • Q & A 

Requirements

Audience that will most benefit from this training:

  • Business Analysts: Those who need to analyze and visualize data to make informed business decisions.
  • Data Analysts: Professionals working with data, who want to create interactive reports and dashboards.
  • Managers/ Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
  • Anyone interested in data visualization and analytics. 

By the end of this training, participants will be able to have:

  •  Understanding of Power BI architecture, data sources, and transformations.
  •  Proficiency in creating relationships between tables and using DAX functions.
  •  Ability to design effective visualizations and dashboards.
  •  Familiarity with teamwork/report sharing features 
 7 Hours

Number of participants


Price per participant

Testimonials (5)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories