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

About This Event

With this course, you will be able to go from never using Power BI to integrating insightful dashboards to benefit your organization. It has been designed to introduce users to the fundamentals of Power BI and DAX in a hands-on and interactive environment.

Throughout the course, students will be guided by an instructor through an end-to-end solution using a combination of lectures and interactive labs to reinforce the concepts presented.

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.

---

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 Sept 7, 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

• 

  Introduction to Power BI Paginated Reports | Beta Course

  April 23 @ 9:00 am – April 25 @ 12:00 pm MDT
• 

  Introduction to Power BI

  May 7 @ 9:00 am – May 10 @ 12:15 pm MDT
• 

  Introduction to Power BI Paginated Reports

  May 14 @ 9:00 am – May 15 @ 12:00 pm MDT