From Raw Data to Business Intelligence.
Learn Power BI by working with a real-world business dataset. Follow our practical video lessons, download the resources and build your own interactive business intelligence dashboard from scratch.
Analyse a real business, end to end
AdventureWorks is a fictional company with real-world data. You will investigate its sales, customers, products and territories — and answer the questions management actually asks.
What is our total revenue?
Which products generate the most sales?
Which regions perform best?
Who are our most valuable customers?
How are sales changing over time?
What insights can management use to make decisions?
Two ways through the same destination
Pick the path that matches your experience. You can change your selection at any time.
Your selection: Path A — Beginner (Excel/CSV)
Your Power BI Learning Toolkit
Everything you need for the programme, organised in one place. Resources marked “Coming soon” are being prepared by our team.
Software downloads
The free Microsoft application you will use to build your dashboards.
Free editions of Microsoft SQL Server for the Professional path.
The tool used to restore and explore the AdventureWorks database.
Sample datasets
The official Microsoft sample data warehouse used on the Professional path.
Prepared Excel workbook for the Beginner path.
Prepared CSV files for the Beginner path.
Extra practice data for the challenges section.
Learning documents
Step-by-step guide to installing Power BI Desktop.
A tour of the tables and columns in the AdventureWorks dataset.
How to restore the AdventureWorksDW2022 backup in SSMS.
The most useful Power Query steps on one page.
The DAX functions you will use most, with examples.
Choosing the right visual for each business question.
The full requirements for your final executive dashboard project.
Practice resources
Hands-on exercises accompanying each video episode.
Worked answers for the episode exercises.
A starting PBIX template for the final project.
How to package and submit your final project.
30 episodes, six modules
A structured journey from your first download to a finished executive dashboard. Video recordings are being added by our trainers.
Get to know the fictional company whose data you will analyse throughout the programme.
Explore the sales, customer, product and territory data AdventureWorks generates.
Learn how data is organised into tables and columns and why structure matters.
Download the starter dataset for your chosen learning path.
Test Your Data Skills
Short, practical challenges that prove you can apply what you have learned. Sign in to track the ones you complete.
Build a KPI card that shows total revenue for AdventureWorks.
Identify the five products that generate the most sales.
Build a visual that compares sales month by month.
Find which territory performs best and back it up with a visual.
Add a slicer that filters the whole report by product category.
Build Your First Executive Sales Dashboard
Bring everything together in a three-page report you can show to employers and clients.
- Executive Overview
- Product and Sales Analysis
- Customer and Territory Analysis
- Your PBIX project file
- Dashboard screenshots
- Optional written business insights
Submissions are reviewed by our administrators for assessment.
Earn your Softclue Power BI Lab certificate
Learners who meet the programme's completion criteria are eligible for a certificate carrying their name, the programme title, the completion date, a unique certificate reference and a QR verification code.
Certificates are reviewed and issued by our administrators — they are never granted automatically.
Frequently asked questions
Softclue Power BI Lab — Learn It. Build It. Visualise It.