We generally train face-to-face at client site. We also offer remote Power BI training, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.
| Number on course | Price per day |
|---|---|
| 1 - 1 training | £375 + VAT |
| 2 - 4 people | £625 + VAT |
| 5 - 8 people | £845 + VAT |
Aims of the course
This course aims to introduce the learner to using Power BI.
Course Objectives
On completion of the course, delegates will be able to:
- Demonstrate Power BI Desktop concepts and main features
- Utilise data sources that are compatible with Power BI Desktop
- Connect to data with Power BI Desktop
- Explore Data Visualisations
- Apply common query tasks to shape data in Power BI Desktop
- Create and publish reports
The course is of two days’ duration.
How the course is run
This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.
Pre-requisites – Familiarity with Excel including IF, XLOOKUP, Pivot Tables etc would be an advantage.
Provisional Course Outline
Getting Started
- The Power BI Process
- Launching Power Bi Desktop
- The Four Views of Power BI
- Creating Report Visuals
Getting Data
- Connecting to Data Sources
- Connecting to an Excel workbook
- Connecting to a CSV file
- Connecting to a Database
- Connecting to a Web Sources
- Connecting to a file folder
- Creating a Data Table
Transforming and Appending Data
- Cleaning Data in the Query Editor
- Removing Rows by Filter
- Replacing Values
- Query Data Types
- Detecting Data Types
- Adding Custom Columns
- Appending Data to a Query
- Adding an Index Column
- Resolving Error Issues
- Performing Basic Mathematical Operations
The Power Query Editor
- Filling Data Up and Down
- Splitting Columns with Delimiters
- Adding Conditional and Custom Columns
- Merging Columns
Pivoting and Unpivoting Data
- Pivoting Data in Power Query
- Pivoting and Appending Data
- Pivoting without summarizing
- Unpivoting Data
- Appending Mismatched Headers
Managing Table Relationships and Merging Queries
- Table Join Kinds
- Merging
Grouping Data in Power Query
- Grouping Rows in a Table
Building a Data Model
- Relating Tables in a Data Model
- Cardinality
- Data Modelling schema
- Filter Flow
- Joining Tables
- Hiding in Report View
DAX Calculated Columns
- Creating Calculated Columns
- Best practice with calculated columns
- DAX Syntax
- Common Function Categories
Introduction to DAX Measures
- DAX Rules
- Turning off Field Summarisation
- COUNTROWS function
- DISTINCTCOUT function
- CALCULATE function
- SUMX function and when to use it
Introduction to Time Intelligence
- Standard and Custom Calendars
- Marking a Calendar as a Date Table
- Time Intelligence functions
- TOTALYTD functions
Creating Report Visualisations
- Creating and formatting Visuals
- Creating a Map Visual
- Creating a Chart Visual
- Formatting Map and Chart Visuals
- Creating Table, Matrix and Card Visuals
- KPI, Gauge and Waterfall Visuals
- Formatting Table Visuals
- Controlling a Visual’s Number format
- Filtering Data with Slicers
- Syncing Slicers Across Pages
- Visuals from the Marketplace
- Exporting Report Data to Excel
Hierarchy, Groups and Conditional Formatting
- Creating a Hierarchy to “Drill” Data
- Comparing Data in Groups
- Conditional Formatting
Publishing and Sharing Reports Online
- Publishing to the Online Power BI Service
- Getting Reports from the Power BI Service
- Getting Quick Insights
- Sharing Reports
Clients who have benefitted from our Power BI training include:
- Velcourt
- Jordans Dorset Ryvita
- ITEL Electronics
- University of Portsmouth
- Morrish Homes
- United Oilseeds
We also offer Power Automate and Power Apps training courses.
To request further details of any of our courses, or to make a booking, please contact us by ringing 01747 820396 or 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.