Power BI - Introduction
Learn how to use this powerful tool to import and clean data and create some amazing visuals.
Enquire Now
Course overview
Duration: 2 days (13 hours)
Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports.
This course is an introduction to Power BI to get you started on creating a powerful reporting capability.
You should have a good working knowledge of Excel and managing data before attending.
Objectives
By the end of the course you will be able to:
- Import data from multiple data sources
- Edit and transform data before importing
- Create reports
- Create different visualisations
- Create data models
- Build data relationships
- Use the drill down features
- Create measures
- Use the Power BI Service
- Build dashboards
- Use the mobile app
Content
Essentials
Importing Data
- Power BI Overview
- Data sources
- Importing data
Transforming Your Data
- Editing your data
- Setting data types
- Removing columns/rows
- Choosing columns to keep
- Setting header rows
- Splitting columns
Creating Reports
- Creating and saving reports
- Adding pages
- Renaming pages
- Interactivity
- Refreshing your data
Adding Columns
- Columns from example
- Custom columns
- Conditional columns
Append Queries
- Importing folders
- Setting up and using append queries
Creating Chart Visualisations
- Adding chart elements
- Choosing chart types
- Setting properties
- Setting values, axis and legends
- Using tooltips
- Visual filters
- Setting page and report filters
Creating Tables, Cards, Gauges and Maps
- Adding table elements
- Adding maps
- Working with cards
- Working with matrices
- KPIs and Gauges
Conditional Formatting
- Setting rules
- Removing conditional formatting
Working with Data Models
Merge Queries
- Setting up and using merge queries
- Merging in columns of data
Creating a Data Model
- The data model
- Multiple data tables
- Connecting tables
- Building relationships
- Relationship types
- Building visuals from multiple tables
Unpivoting Data
- Working with summary data
- Unpivoting data
Using Hierarchies
- Using built in hierarchies
- Drill down
- Drill up
- See next level
- Expand a hierarchy
- Create a new hierarchy
Grouping
- Grouping text fields
- Grouping date and number fields
Creating Measures
- DAX functions
- DAX syntax
- Creating a new measure
- Using quick measures
Using the PowerBI Service
- Shared workspaces
- My workspace
- Dashboards
- Reports
- Datasets
- Drill down in dashboards
- Focus mode
- Using Q&A
- Refreshing data
- Using Quick Insights
Power BI Mobile App
- Using the Power BI Mobile App
Testimonials
Frequently Asked Questions
Who should attend this Power BI Introduction course?
What skills will I gain by the end of the course?
What prior knowledge do I need before attending?
Is this course delivered live/online or only onsite?
Will I have access to support after the training?
How can I enquire about cost, group bookings, or schedule for this course?
Get in Touch
Still have questions about this course?
Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.
Enquire NowRelated Courses
Power BI - Advanced Reporting
Expand your Power BI knowledge and take your reports to the next level.
Power BI - DAX Calculations and Measures
Unlock the power of DAX in Power BI to create dynamic calculations and gain deeper data insights.
Excel Module 2 – Data Analysis and Pivot Tables
Expand your Excel knowledge and learn how to structure and analyse large data sets.
Explore More Training Options
Public Training Programme
Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.
Engage with expert instructors and a diverse peer group in an interactive, online learning environment.
Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.
Check Public DatesFull Training Catalogue
We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.
Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.
