• Authored Course

Analysing Microsoft Dynamics 365 Data with Power BI

Learn via: Classroom / Attend from Anywhere

Price: £1440

Dates and Locations

About this Course

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.

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

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

  • 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). The instructions on how to set up a Microsoft account can be found here.

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.

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.