Live in-person instructors      Always guaranteed to run      Customizable objectives   

Book Power BI Training

At The Great Canadian Training & Consulting Company our Power BI training includes three courses which can be taken separately as individual 2 day classes or as one 5 day all-encompassing class. Please see each course page for an outline of specific topics covered.

The Fundamentals of Power BI

Designed for: Business Managers, Report Developers, Analysts, Project Managers and Team Leads

Goals: By the end of this class you will be able to create an Excel data model, create and manage relationships in Excel, and understand the components of Power BI Service and Power BI Desktop. You will be able to transform data using Power Query and create calculated columns and DAX measures. You will also be able to create and share a Dashboard.
Upcoming Classes:
  • October 17 & 18, 2022 9am to 4pm ET
  • January 10 & 11, 2022 9am to 4pm ET
Becoming a Pro with Power BI

Designed for: Business Analysts, Business Intelligence Developers, and Reporting Professionals

Goals: Upon completing this course, you will be able to explain the ETL process, understand data modeling and define and manage relationships. You will also be able to create Bookmarks, use Parameters, filters, and Conditional formatting in reports, and work with additional built-in analytical tools
Upcoming Classes:
  • December 8 & 9, 2022 9am to 4pm ET
Discovering The Power of Data Analytic Expressions (DAX) Using Power BI and Excel

Designed for: Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling

Goals: This class will enable you to explain and use the Data Analytic Expressions (DAX) formula language. You will learn DAX syntax, operators, and values, as well as how to use many types of functions and evaluations. You will also create and configure calculated fields and columns. You’ll feel comfortable using many of PowerPivot’s advanced DAX capabilities.
Upcoming Classes:
  • November 28 & 29, 2022 9am to 4pm ET
  • February 13 & 14, 2023 9am to 4pm ET
Microsoft Power BI Boot Camp

Designed for: Business Managers, Report Developers, Analysts, Project Managers and Team Leads

Goals: This Five-day instructor-led course is a complete high-level tour of the Microsoft Business Intelligence stack.
Upcoming Classes:
  • November 21-25, 2022 9am to 4pm ET
Combine topics from different courses into one class by creating your own Custom Outline
Booking training for your company? Learn more about how we can help Managers, HR Professionals and IT Departments.
Knowing how to create data models is a key business skill. Learn how to do so in this free webinar. Our special guest speaker will show you how you can make business intelligence simple.

With our Microsoft Excel Power BI Training you can learn to...

  • Work Efficiently
    • Become familiar with each of the Power View, PowerPivot, Power Query, Power Map, and Power BI interfaces
    • Use CSV, TXT, or Excel worksheet resources to their full potential
    • Explain and use DAX syntax, data types, operators, and values
  • Work Effectively
    • Connect to databases and work with relationships
    • Apply filters and create essential and dynamic charts and reports
    • Use single table and multiple table evaluation contexts
  • Work Brilliantly
    • Create powerful reports using the Matrix, Map, Card, and Chart visualizations, along with Slicers
    • Utilize the power of Data Analytic Expressions (DAX)
    • Work with KPIs, hierarchies, and perspectives
  • And More!

Professional Excel Power BI Training That Gives You the Edge

Sign up now for our Microsoft Excel Power BI courses to help you:
  • Use Business Intelligence (BI) to understand relationships and work with relational data in databases
  • Remain organized by performing merges and summarizing your data
  • Create and configure your own calculated fields and columns
  • Use the power of DAX functionality
  • Utilize various types of functions, including Mathematical, Statistical, Logical, Relational, Text, Aggregation, and more
  • Work with a variety of calendars and date functions
  • And so much more…

Why You Need It

Power View, PowerPivot, Power Query, Power Map, and Power BI are all parts of the Business Intelligence (BI) set of tools that allows you to create powerful graphics, manage and merge datasets, and perform extremely powerful queries. Microsoft PowerPivot DAX syntax enables you to write formulas to transform your Excel PowerPivot data with rich, powerful relationships. Combining each of the Microsoft Power BI tools will help you transform your company’s facts and figures into rich visuals that enable new ways of thinking about and organizing your data, so that you can focus on reaching your goals.

  • Have a hard time understanding DAX syntax and values?
  • Struggling to import, filter, and merge your data in a meaningful way?
  • Wish you could perform more advanced queries or create powerful graphics to showcase your queries effectively?
Our Microsoft Power BI training is the perfect solution. With it you can acquire the Business Intelligence skills you need to manage and interpret your data with ease.

Available With These Courses

Your course comes with the following

eBook Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned
Order the following add-ons for your session

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

How You’ll Learn

In private classes, or in groups, you’ll learn from experienced, friendly facilitators who know how to make you feel comfortable in your learning environment.

One-on-one tutoring provides the best student experience, allowing the trainer to work along with you in-depth on your workflow and specific needs.

Private group classes provide a more cost effective way to train multiple students in the same organization with the training optimized to focus on the topics you specifically need.

These classes can be conveniently delivered right at your location, saving you the trouble of travelling offsite.

Why Learn With Us

The Great Canadian Training & Consulting Company is patient and reliable. We will help you find and use the features you need, allowing you to work more efficiently and painlessly. We offer private training and consulting services to address your Power BI training needs. We’ve got the experience and the passion to help you learn at your own pace and convenience. We can help you customize your course with very little difficulty and with very competitive pricing.

We care and we are there for you every step of the way. We stick by you even after training is over, by ensuring your Power View, PowerPivot, Power Query, Power Map, and Power BI training success with our after-training support options as well.

Contact us today to book your worry-free Microsoft Excel Power BI training. Working with us is easy!

Tailor or Customize Your Course

We can also provide customized Excel Power BI training to suit your specific requirements, even using your own files if desired. You can pick and choose from our outlines to build a course especially suited to you. Let us know what you want and we’ll work with you to develop the course you’d like.
  • Share details about your training needs so we can tailor your class
  • Discuss your needs with one of our training coordinators
  • Select the objectives you would like to focus on
  • Select objectives from any of our courses to create a custom outline
  • Submit files you would like to learn how to use during the class
  • Order custom manuals
  • If you prefer, you can take any of the individual three topics as a single 2-day class instead