My learning.

Find a course, enrol, and finish it with a verifiable certificate.

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 watch
Power 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.

Related courses

All courses