This online, instructor-led Power BI course is your entrance to the world of analytics and dashboarding!

About This Event

The course is focused on introducing users to the fundamentals of Power BI and DAX in a hands-on and interactive environment. Throughout the course, students will be guided through an end to end solution using a combination of lectures and hands-on labs to reinforce concepts. Students will learn how to:

• Import data into a solution, transform, and cleanse data using Power Query Editor.
• Build a well-formed data model that is optimized and ready for flexible self-service reporting.
• Enhance the model using by applying introductory DAX.
• Build, publish, and share visualizations with end-users using the various methods available in the Power BI suite of products.

Audience

This course is for Business Analysts, IT Users, and others that are interested in learning how to elevate their data analytics techniques using Power BI. We will teach you how to develop efficient data analytics and further utilize visualizations in your organization.

About the Instructors

Chris Sorensen CPA, CGA, is the Founder and President of Iteration Insights, a tech-enabled data analytics solutions provider based in Calgary, Alberta.

He is a Microsoft Certified Data Analyst Associate and Microsoft Certified Trainer with a combined 20+ years of industry and teaching experience.

Chris provides our partners with the data-driven solutions they seek and has proven capabilities to train and empower their people in analytics. In his career, he has lead numerous Analytics projects in more than 15 industries across small to enterprise-sized organizations.

As an instructor of the Business Intelligence program at SAIT, he plays a significant role in shaping new talent in Calgary’s emerging tech sector. Following his lifelong learning approach, Chris also coordinates both Power Platform and Azure Analytics User Groups, providing a space dedicated to knowledge-sharing and growing Alberta’s tech community. His favourite hashtag is #neverstoplearning.

Pricing

• $675/Attendee + GST and Eventbrite Fees
• Groups of 2 or more receive a discount of 10% of the currently available ticket price. Please contact us for discount code.

Job Grant Eligibility

Combine this course with our Intermediate Power BI, Power Query, Data Modelling, and DAX and qualify for job grants. Your employer must apply for the job grant before purchasing the course. Visit the links below for more details on how to apply.

• Canada-Alberta Job Grant
• Canada-Saskatchewan Job Grant
• B.C. Employer Training Grant

Course Outline

1. Introductions and Setup
2. Power BI Overview
3. Dive into Power BI Desktop
   1. Exploring Data Sources
   2. Importing Data using Power Query
   3. Modelling Data
      1. Relationships
      2. Hierarchies
      3. Introduction to DAX
      4. Other Optimization Techniques
   4. Visualizing Data using the Desktop
      1. Visuals
      2. Reports
      3. Other features that enrich the end-user experience
4. Publishing to the Service
   1. Dive into Power BI Service
   2. Visualizing Data
   3. Building Dashboards
   4. Sharing Visualizations
   5. Additional Service Functionality
5. Integration with Excel
6. Other Power BI Resources
   1. Power BI Administration Concepts
   2. Power BI Community Resources

Key Words

Power BI, DAX, Power Query, Data Modelling, Data Visualizations, Calgary, Edmonton, Montreal, Toronto, Regina, Vancouver

Disclaimer

Filming and Photography may take place; please read our Notice for Filming and Photography for further information.

Related Events

• 

  Intermediate Power BI

  December 10 @ 9:00 am – December 13 @ 12:15 pm MST
• 

  Introduction to Power BI Paginated Reports

  January 28, 2025 @ 9:00 am – January 29, 2025 @ 12:15 pm MST
• 

  Introduction to Power BI

  February 4, 2025 @ 9:00 am – February 7, 2025 @ 12:15 pm MST