Course description
Learning Objectives
This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards. Delegates will learn how to:
Overview of Microsoft Power BI
- Build a Basic Report
- Get & Transform Data - Power Query
- Build the Data Model
- Build a visual Report
- Power BI Service
Upcoming start dates
Suitability - Who should attend?
Prerequisites
A strong knowledge of Microsoft Excel is recommended and this course will use Power BI Pro Desktop in its delivery.
Training Course Content
1. Overview of Microsoft Power BI
- Understand the Applications
- Power BI Desktop and Power Query
- The Power BI Service
2. Build a Basic Report
- Import Data
- Add Visualisations
3. Get & Transform Data - Power Query
- Import Data – from various sources
- Transform Data (Tidy, Convert, Clean)
- Edit Queries
4. Build the Data Model
- Relationships Between Tables
- Introduction to DAX Formulas:
- Calculated Columns, Tables & Measures
5. Build a visual Report
- Report Pages
- Handle Visualisations (Tiles)
- Format Visuals - Fields, Format, Analytics
6. Power BI Service
- Publish Desktop Report to PBI Service
- View/Edit Report in PBI Service
- Create Dashboard
Request info
Nexus Human
For over 20 years Nexus Human has specialised in IT and Business Skills Training and Certification in the UK and Ireland. What makes Nexus Human different is putting people at the core of what we do. We deliver both private...