Hands-on Power BI
A project-first Power BI program for people who want to build reports that other people actually use. You begin with untidy spreadsheets and finish with a published, refreshable report you can show in an interview. Each…
Course description
A project-first Power BI program for people who want to build reports that other people actually use. You begin with untidy spreadsheets and finish with a published, refreshable report you can show in an interview.
Each week ends with a deliverable that I review with you: clean the data in Power Query, shape it into a proper star schema, write DAX measures you can explain out loud, and design pages that answer a question instead of decorating a screen.
Class schedule
- Days & time
- Saturday & Sunday
- Duration
- 8 weeks
What You'll Learn
Skills You'll Gain
Test Yourself
Import and profile a messy sales workbook
Load a multi-sheet Excel file from a Lahore FMCG distributor, profile every column for blanks, duplicates and wrong types, and write the problems down before you touch a single one. Fixing first and documenting later is how mistakes get buried.
Hands-on Lab Task
Reshape monthly columns into a tidy table
Unpivot twelve month columns into rows, merge product details from a second sheet and append three years of files into one query. Then drop in a fourth file and watch it refresh without you.
Hands-on Lab Task
Build a star schema with a date table
Split a flat export into FactSales and four dimensions, build a DAX date table, set one-to-many relationships and check the filter direction with a slicer before you trust a single total.
Hands-on Lab Task
Write ten core DAX measures
Write measures for total sales, cost, margin %, average order value, distinct customers and a top-N product rank, then test each against an Excel pivot. Two of them will disagree the first time. Find out why.
Hands-on Lab Task
Add time-intelligence comparisons
Add YTD, previous year, YoY growth % and a three-month rolling average to a Karachi bank's monthly branch deposits, and validate two months by hand.
Hands-on Lab Task
Publish a secured report
Publish to Power BI Service, set a scheduled refresh, create a regional RLS role, test it with 'View as' and share it through an app.
Hands-on Lab Task
Curriculum
Before you learn a single formula you need the shape of the tool and the whole journey from raw file to published page. Otherwise week four feels like magic and week seven feels like a different product. So Saturday is the map, Sunday is your first report.
What we cover
- What Power BI is, how it differs from Excel and Google's Looker Studio, and where it sits in a company
- Installing Power BI Desktop and a tour of the Report, Data and Model views
- Connecting to Excel, CSV, folders, SQL Server and PostgreSQL, with a first look at import versus DirectQuery
- Data types, column quality and a first walk through the Power Query editor
- Your first three visuals and a slicer, built from a retail sales file
In the lab
Import a Lahore distributor's workbook (three sheets, twelve months), profile every column for blanks and errors, and build a one-page report with total sales, sales by city and a month slicer. Expect to find at least one column of numbers stored as text. Everyone does.
Bring back next week
A .pbix file with the imported data and the one-page report, plus a short list of the data quality problems you found.
Batches
Pick a batch that fits your schedule, then use the enquiry form to reserve your seat.
No open batches right now, submit your details and we'll notify you when the next one starts.
An instructor will be assigned when the next batch is scheduled.
Student Reviews
No reviews yet, be the first to enroll and share your experience.
Requirements
- Comfortable with Excel basics such as formulas, sorting and filtering. No prior Power BI experience is needed.
Fee by mode