0345 4506120

Analysing Microsoft Dynamics CRM Data with Power BI

This course demonstrates how to analyse Dynamics CRM data using the new tool of Power BI Desktop.

Delegates will gain experience of working with the Power BI desktop tool.

Load data from their CRM deployment to Power BI and create Visualisations to display Dynamics CRM Data.


Learning Objectives

This course provides delegates with a full understanding on how to use the new Power BI Desktop tool. They will learn how to connect to their CRM data source to load CRM data into Power BI.

Delegates will then be able to Shape, Combine and Model their data before creating interactive visualisations. Finally the visualisations & data will be published as well as create Content Packs for their organisation.


  •   Working knowledge of Dynamics CRM.
  •   Working knowledge of Excel.
  •   Some Database experience would be a benefit.

Please note: Before attending this class delegates must have a Microsoft account (signing up one is free).

Course Content

Module 1- Introduction to Power BI

  •   Power BI
  •   The Power BI Service
  •   Power BI Mobile Apps
  •   Lab: Creating a Power BI Dashboard

Module 2- Power BI Data

  •   Using Excel as a Data Source
  •   Using Databases as a Data Source
  •   Using Dynamics CRM as a Data Source
  •   Lab: Importing Dynamics CRM Data Into Power BI

Module 3- Combining Data

  •   Power BI Desktop Queries
  •   Combining Data
  •   Merging Data
  •   Importing Data
  •   Lab: Combining Data

Module 4 - Relationships

  •   Viewing Relationships in Power BI Desktop
  •   Relationship types (Caardinality)
  •   Support for Many Relationships
  •   Creating Relationships
  •   Lab A - Creating Relationships
  •   Editing Relationships
  •   Lab B - Relations in Microsoft Dynamics CRM & Dynamics 365

Module 5- Shaping Data

  •   Using Data Fields to Drill Visualisations
  •   Filter Records
  •   Pivot/unpivot data
  •   Data Subsets
  •   Group By
  •   Lab A - Shape data using Group By
  •   Lab B - Using Pivot to display Opportunity Data
  •   :ab C - Create Query Parameters
  •   Add custom and Calculated Columns
  •   Lab D - Creating Conditional Columns

Module 6- Interactive Data Visualisations

  •   Overview of Data visualisations
  •   Data Visuualisations Types
  •   Table and Matrix visualisations
  •   Charts
  •   KPI Visualisation
  •   Interactive Slicers
  •   Geo-Data, Data Categorisation and Maps
  •   Lab A - Creating Visualisations
  •   Appendix A - Reports and Output Options
  •   Appendix B- Publishing from Power BI Desktop

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include