Power BI Desktop Introduction
- Training covers essential Power BI skills: ETL, Data Modeling, Visualization, and Sharing.
- Attendees need Excel knowledge, Database, Programming, or BI experience.
- Course includes Power BI basics, Data Sources, Data Modeling, and DAX.
- Learn to filter data, create visualizations, use queries, and publish reports.
- Understand Power BI environment, create data models, and share dashboards.
Overview
The Power BI Desktop Training course aims to equip attendees with essential skills in Power BI, focusing on data extraction, transformation, loading, and visualization through graphics, charts, and dashboards. Participants are expected to have prior knowledge of Excel, including Pivot Tables and functions like SUMIFS and VLOOKUP. The course covers topics such as understanding data sources, creating data models, visualizations, DAX calculations, and publishing reports to the Power BI service. Participants will also learn to share interactive dashboards and content packs.
Who should attend
Database Analyst, Business Intelligence Specialist
Course Content
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.
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.
What is Microsoft Power BI
Power BI Desktop Vs Power BI Online
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 sources.
Exploring Power BI Desktop
Working with the Fields and Visualisation Panes
Using Report View to create visualisations
Using Report View to Sort and Format Data
Using Data View to sort and Format data
Filtering Data in Power BI Desktop
Using the Filters Pane
Single Selection
Advanced Filter on a Field
Filters on Current Page
Filter on all Pages
Show/display Filters Pane
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
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
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.
