Description

This course builds on foundational Power BI knowledge, guiding participants through advanced concepts for optimizing data manipulation and creating more sophisticated visualizations and dashboards. Participants will explore key techniques to enhance efficiency, improve data modeling, and apply complex calculations to meet organizational reporting needs.

This course covers:

  • Best practices for data modeling and optimization
  • Advanced data wrangling techniques in Power Query
  • Using parameters to enhance flexibility and interactivity
  • Complex DAX operations for advanced calculations
  • Aggregating and merging data tables effectively
  • Managing non-calendar time periods, such as fiscal years
  • Government of Canada-specific Power BI use cases, including fiscal year conversion and bilingual dashboard management

Learning Outcomes

At the end of this course, participants will be able to:

  • Import and integrate data from a wide range of sources
  • Build complex and efficient data models
  • Perform advanced data transformations and manipulations
  • Apply complex calculations using DAX
  • Implement dynamic formatting for data visualizations
  • Manage and analyze fiscal years that do not align with the calendar year
  • Execute advanced filtering operations for more precise data analysis

Duration

9 hours

Register

No content found

No content found

Instructors

Stephen Davies is the CEO of DAVHILL Group, a business intelligence and data analytics company serving the Canadian Federal Government, and large public and private organizations. Stephen has more than 25 years of experience working as a consultant and corporate trainer. With an academic background in Physics and Engineering, he has previously worked in semiconductor and OEM manufacturing as an engineer and supply chain director. Early in his career, he started to do data analysis and never quite escaped.