This online instructor-led two-day course is your entrance to the world of Power BI!

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.

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 how to develop efficient data analytics and further utilize visualizations in your organization.

For more course information and details, visit the Iteration Insights website.

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.

Pricing

• Early Bird Savings of $124/seat ends Nov 2, 2020, at 11:30 pm.
• Groups of 3 or more receive a discount of 20% 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

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