Month 3 — Data Visualization and BI
Power BI dashboards, storytelling, and professional reporting workflows.
1 lessonOffice & Data SkillsFree to enrol
Lessons
01
Power BI Dashboard Development
Video: enrol to watchPower BI turns a table of numbers into a dashboard people will actually look at.
The three stages
1. Get data - connect to Excel, a CSV, or a SQL database.
2. Model - clean the data and define relationships between tables.
3. Visualise - drag fields onto the canvas to build charts.
Power Query is where cleaning happens
Transform Data opens Power Query. Remove columns, filter rows, change data types, split columns. Crucially, every step is recorded in the Applied Steps list, so when next month's file arrives you press Refresh and the whole sequence re-runs. That repeatability is the real reason to use Power BI over a one-off chart in Excel.
Relationships
If you have an orders table and a customers table, link them on customer_id. Power BI then lets you slice orders by any customer attribute. A one-to-many relationship (one customer, many orders) is the normal case.
Choosing the right visual
- Bar or column chart for comparing categories
- Line chart for change over time
- Card for a single headline number
- Table when people need the exact figures
Resist pie charts beyond two or three slices; people cannot judge angles accurately.
Slicers
A slicer is an on-page filter. Add one for date or region and the whole page responds, which is what makes a dashboard feel interactive rather than static.
Design discipline
One page, one question. A dashboard answering "how are sales doing?" should not also try to cover staffing.
Practice
Load a sales file, create a relationship to a customer table, then build a page with a revenue card, a revenue-by-month line chart, and a region slicer.