Get in Touch

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: Professionals tasked with analyzing and visualizing data to support informed decision-making.
  • Data Analysts: Experts working with data who seek to build interactive reports and dashboards.
  • Managers/ Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
  • Anyone with an interest in data visualization and analytics.

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

  •  A solid understanding of Power BI architecture, data sources, and transformation techniques.
  •  Proficiency in establishing table relationships and utilizing DAX functions.
  •  The capability to design effective visualizations and dashboards.
  •  Familiarity with collaboration and report sharing capabilities.
 7 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories