Microsoft Power BI

---

Course Overview

This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop. 

Duration: 2 day course

---

Course Content

Topics covered include-

Introducing Power BI
The Power BI Interface
Overview of the Power BI Data Model.

Using Power BI
Connecting to Power BI data
Create a Power BI dashboard
Using Excel as a data source for Power BI
Using databases as a data source for Power BI
Importing data into Power BI
Importing different data sources into Power BI
Viewing reports from Excel files

Shaping and Combining Data
Power BI desktop queries
Shape data using formatting and transformations.
Combine data together from tables in your dataset.

Modeling data
Create relationships between data tables.
Understand the DAX syntax and use DAX functions to enhance your dataset.
Create calculated columns, calculated tables and measures.

Interactive Data Visualisations
Creating Power BI reports
Managing a Power BI solution
Use Power Bi desktop to create interactive data visualisations.

Direct Connectivity
Direct connectivity from Power BI desktop
Direct connectivity from the Power BI service
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode.

The Developer API
The developer API
Custom visuals

Power BI mobile app
Using the Power BI mobile app
Power BI embedded

Email us about this courses


Telephone on 01952 938014