LEARN. DEVELOP. INSPIRE.
Power BI Essentials: Create Interactive Reports
Duration: 2-Day
Public Course Price:
Training Formats: Public Classroom, Public Online, Private Course
Certification on Completion
Bring your data to life with this hands-on Power BI course designed for beginners and self-taught users.
4.9/5 rated
From 6,000+ learners
30+ years
Delivering professional training
Live and practical
Trainer-led courses
Flexible delivery
Online, venue or onsite
YOUR NEXT STEP
How would you like to train?
01 · PUBLIC COURSE
Book a place for yourself or a colleague
View scheduled dates, locations and prices for this course when public sessions are available.
02 · PRIVATE TRAINING
Plan training around your team
Discuss your objectives, preferred dates and delivery location with us. We can tailor a course to your group.
Course Overview
Introduction
You’ll learn how to connect to different data sources, clean and shape your data, and transform raw figures into stunning, interactive dashboards and reports. From understanding relationships and building visualisations to applying powerful time intelligence and sharing your reports with others, this course is your gateway to confident, data-driven decision-making.
Course objectives
By the end of this course, you will be able to:
-
Connect to and transform data from a range of sources
-
Model relationships between tables for accurate reporting
-
Build engaging visualisations including charts, maps, and KPIs
-
Apply foundational DAX formulas and time intelligence
-
Share, publish and export interactive reports for your team
Who this course is for
This course is ideal for:
-
Professionals who are new to Power BI or self-taught and want a solid foundation
-
Business analysts, project managers or decision-makers who work with data
-
Anyone responsible for reporting, dashboards or data-driven insights
- Business owners looking to create visual reports for their business
Prerequisites: Familiarity with Excel and an understanding of data is strongly recommended. No coding or advanced technical experience is required.
Full course outline
Getting Started with Power BI
-
What is Power BI and how does it work?
-
Understanding the reporting lifecycle: from raw data → insights → decisions
-
Exploring the Power BI interface
-
Examples of stunning, interactive dashboards and business use cases
-
Understanding your current data and how you could apply to Power BI
Data Preparation & Modelling
-
Best practices for data modelling (star schema, avoiding pitfalls).
-
Performance optimisation (keeping reports fast with large data).
Obtaining and Transforming Data
-
Connecting to files, databases, and web data
-
Removing rows/columns and changing data types
-
Filtering, grouping, splitting, and combining data
-
Using Append, Merge, Pivot and Unpivot
-
Creating columns: conditional, index, and custom formulas
Data Relationships
-
Understanding model view and join types
-
Creating and managing relationships between tables
-
Working with hierarchies and related data
Intro to DAX & Measures
-
Basic DAX formulas and syntax
-
Creating calculated measures and quick measures
Time Intelligence & Date Tables
-
Creating and using Date Tables
-
Applying time-based formulas for comparison and analysis
Visualising Your Data
-
Tables, matrices, charts, and maps
-
KPIs, conditional formatting, and spatial insights
-
Using slicers, filters, and drill-through to enhance interactivity
Publishing & Sharing
-
Publishing reports to Power BI Service
-
Exporting to PDF and sharing dashboards with your team
Reflections & Planning
-
Recap key concepts and discuss next steps
-
Planning how to apply Power BI in your organisation
Public scheduled courses
Choose a scheduled session below if public dates are available for this course. If there isn’t a suitable date, or you’d like a private session for your team, send us an enquiry.
-
17 November2 days, 09:30 AM GMT - 04:30 PM GMT
-
19 November2 days, 09:30 AM GMT - 04:30 PM GMT
Booking for a team or need a different date?
Tell us the number of learners, your preferred format and what you’d like them to achieve. We’ll suggest a suitable private training option. Ask about this course →
Trusted by
What our learners say
Hear from people who have trained with SquareOne.
TRAINING LOCATIONS
Learn where it works for you
We offer scheduled public courses in selected locations and private training at your workplace. Check the dates on this page for this course’s current availability.
Training at your workplace: for private groups, we can deliver at your premises across the UK and discuss international options. Ask us about onsite training →
Questions before you book?
Practical answers about course formats, group sizes and what to expect.
What’s included in the training?
Sessions are led by a trainer and designed to be practical, with opportunities to ask questions. Course materials and certificates are provided where applicable; we’ll confirm the exact arrangements when you book.
How many people do you recommend for a private course?
For hands-on training, we usually recommend a small group so everyone can practise and get support. Around 8–10 people is often a good starting point, but we’ll advise based on the subject and your goals.
Can you tailor the course to our team?
Yes. Tell us what your team already knows and what they need to achieve, and we can discuss a private course built around those priorities.
Do you offer public and private courses?
It depends on the course. Public dates are shown on this page when available; we can discuss private training even if no public session is scheduled.
Can we train online or at our premises?
Yes, many courses can be delivered live online or privately at your workplace. We can also discuss venue-based training for your group.
What if I’m unsure about the right level?
Tell us about your current experience and what you want to learn. We’ll help you choose a suitable course or plan a session for your team.
Ready to Get Started?
Tell us which course you’re interested in, how many people you’re booking for and where you’d like to train. We’ll come back with the right options.
"*" indicates required fields