Week 3: Turning Data into Visual Reports
A good dashboard answers questions at a glance. This week covers dashboard fundamentals and reporting principles, then puts them into practice in Looker Studio using a prepared dataset. The focus is on clarity and useful metrics, not on complex data pipelines.
Learning objectives
- Understand what makes a dashboard useful
- Choose metrics and KPIs that match a goal
- Use scorecards, charts and tables appropriately
- Add filters and date controls
- Design a clear layout with visual hierarchy
- Present business performance to an audience
Store Performance · Q2 (sample data)
Illustrative mockup created for this website.
Practical skills
- Dashboard fundamentals
- Choosing useful metrics
- Understanding KPIs
- Charts and tables
- Filters and scorecards
- Dashboard layout
- Visual hierarchy

Questions you will answer
- Is revenue trending up or down this quarter?
- Which channel brings the most orders?
- Which products should we feature next month?
Practical business case
Build a simple business performance dashboard showing revenue, orders, average order value and top products, with a date filter.
Weekly assignment
Create a dashboard using a prepared dataset, and write three sentences describing what a manager should notice.
The course uses prepared datasets. Live data integrations and automated data pipelines are not part of this course.