Microsoft 365 Power BI Desktop – 1 Day
- Course covers essential Power BI skills, data visualization, and sharing.
- Prerequisites include Excel knowledge, Pivot Tables, and Functions.
- Target students are those needing basic Power BI Desktop knowledge.
- Objectives include exploring environment, data sources, and visualizations.
- Course covers creating data model, visualizations, and DAX calculations.
Overview
This online Microsoft 365 Power BI Desktop training course aims to provide essential skills in Power BI, including data extraction, transformation, loading, and visualization. The course covers creating dashboards and sharing them with colleagues. Prerequisites include basic Excel knowledge, and the target students are those needing a basic understanding of Power BI Desktop. Objectives include exploring the Power BI Desktop environment, working with data sources, creating visualizations, understanding DAX calculations, using queries, and publishing and sharing dashboards.
Who should attend
Database Analyst, BI Specialist
Course Content
Course Aim:
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.
Prerequisites:
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.
Target Student:
Anyone requiring basic knowledge of Power BI Desktop
Objectives:
•explore the Power Bi Desktop Environment
•Different Data Sources in Power BI Desktop
•Work with Fields and different views
•Creating and understanding the Data Model
•Add different visualisations
•Introduction to DAX calculations
•Using Queries
•Publishing and sharing Dashboards
What is Microsoft Power BI
• Log in and Understanding the Power BI environment
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
