Power BI Training
Unlock the power of data with our 7-session online Power BI training course, designed specifically for professionals looking to transform raw data into actionable insights. Whether you’re new to Power BI or looking to enhance your skills, this hands-on course will guide you through the fundamentals of data visualisation, reporting, and interactive dashboards. Each one-hour session includes live demonstrations, practical exercises, and real-world datasets, ensuring you gain practical, job-ready skills. You’ll receive session recordings, a data pack for each module, and a completion certificate to showcase your new expertise. Join us and take your data analysis skills to the next level!
- Remote/Online
- 7 one hour sessions
- Video recording of the sessions
- Certificate of completion
- Data packs for practice
- Hands on learning
- Groups of up to 6 per session
Price: £595 £520*
*Single Session pricing available – contact for details
Resources
Pre-Reading: Introduction to Power BI (document)
- Overview of Power BI: What it is and why it’s useful
- Key terminology (datasets, reports, dashboards, measures, visuals)
- Installing Power BI Desktop
Session 1: Creating Visualisations and Reports
- Connecting to Excel and simple CSV files
- Hands-on: Importing a basic dataset and exploring table view
- Hands-on: Building an interactive report with basic charts and tables
- Overview of visualisation types and best practices
- Using filters, slicers, and drill-through functionality
- Conditional formatting and tooltips
Session 2: Data Transformation with Power Query
- Introduction to Power Query and the ETL process
- Cleaning and shaping data
- Appending and merging queries
- Hands-on: Transforming a raw dataset into a usable format
Session 3: Building Data Models and Relationships
- Importance of data modelling in Power BI
- Creating relationships between tables
- Understanding cardinality and cross-filtering
- Introduction to the star schema for effective modelling
- Hands-on: Building a simple relational model
Session 4: Introduction to DAX (Data Analysis Expressions)
- What is DAX and why is it useful?
- Understanding calculated columns vs. measures
- Common DAX functions: SUM, AVERAGE, COUNT, DISTINCTCOUNT
- Hands-on: Writing basic DAX measures and applying them to reports
Session 5: Enhancing Reports with Bookmarks, Selections and Design Features
- Saving specific reports states using bookmarks
- Managing visibility of objects to create more interactive reports
- Using buttons and for navigation and actions
- Colour schemes and formatting
- Tips for optimising user experience with good design
- Hands-on: Creating an interactive dashboard
Session 6: Publishing and Sharing Reports (Power BI Service)
- Publishing reports to the Power BI Service
- Understanding workspaces and permissions
- Creating dashboards from reports
- Exporting and embedding reports
- Hands-on: Publishing and sharing reports securely
Session 7: Automation and Power BI Online Features
- Scheduling data refresh in Power BI Service
- Introduction to dataflows and cloud-based data sources
- Creating paginated reports
- Connecting Power BI with other Microsoft services (Excel, SharePoint, Power Automate)
- Hands-on: Automating refresh and sharing insights via Teams/SharePoint