Microsoft Power BI Office 365 Training
Training Aims:
Training in this course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards. These can then be shared with colleagues or others with the Power BI service, and in many other ways.
Course Requirements:-
Attendees should previously have knowledge of Excel with some familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP. People with Database, Programming, or other BI experience will be qualified for the course even if they don’t have direct Excel experience.
Course Contents
What is Microsoft Power BI
Understanding the Power BI environment
Installing Power BI Desktop
Understanding Data Sources in Power BI Desktop
Importing a variety of data sources into Power BI Desktop
Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.
Exploring Power BI Desktop
Working with the Fields and Visualisation Panes
Using Report View to create visualisations
Using Data View to sort and Format data
Creating a Data Model in Power BI desktop
Understanding the Data Model
Using Relationship View
Creating Many-to-One relationships
Refreshing Data
Visualisations Workshop using Power BI Desktop
Adding visualisation to the Report Canvas
Understanding and controlling interactions between Visualisations
Using Drill Down and Drill Through on visualisations
Creating and using Hierarchies
Introduction to DAX in Power BI Desktop
Exploring the importance of custom calculation within the Data Model
Creating Calculated Columns & Measures
Understanding Evaluation Context
Using CountRows and DistinctCount Functions
Using Queries in Power BI Desktop
Understanding the role of Queries in data import
Understanding Extract, Transform & Load (ETL)
Data transformations
Applied Steps
Creating and using Query Parameters
Publishing to Power BI Service
Publish your Report to PowerBI.com
Creating Dashboards
Using Power Pivot Data Model in Power BI Service
Creating visualisations in Power BI Service using Power Pivot data
Sharing your Dashboards & Content Packs
How to share your interactive Power BI Dashboards with people both inside and outside your organisation
Sharing using Power BI, Web, PowerPoint and others
Duration: 1 Day
Cost: £235 + VAT
Office 365 Training,Inverness, Aberdeen, Glasgow, Edinburgh, Scotland and onsite UK Training available.