We generally offer face-to-face training at client site. We also offer Power BI training by videoconferencing means, 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:
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.