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, MCSE (Data Management and Analytics) and MCT, is the Founder and President of Iteration Insights based in Calgary, Alberta. He is a consultant, architect, educator, author, and coach that has been working in the Analytics space for nearly 20 years.

Over his career, he has provided strategic and architectural advisory services to many clients. Most recently, Chris has lead several projects in Microsoft Power BI and Excel PowerPivot. He has evangelized both Excel and Power BI with Microsoft since July 2015 and is the author of the Microsoft Press Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel.

Duration

• This course runs from 8:30 am to 4:00 pm MST on both days.

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 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, Regina, Toronto, Vancouver, Power BI Training

Disclaimer

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