Data, Design & Product · Data Analyst
Go deeper. Real-world tasks that need more research, planning and a polished result.
Task 1 of 3
5 charts with filters.
What to do
Build a Looker Studio or Power BI dashboard for a brand's marketing data (demo data is fine): traffic, sources, conversions, top content and spend.
You’ll make
Done looks like
A dashboard with 5 charts and filters.
Task 2 of 3
3 insights with recommendations.
What to do
Analyse 3 months of a brand's social posts (yours, a club's or public data). Find 3 insights about what performs best and what to do next.
You’ll make
Done looks like
A short deck of 3 insights and actions.
Task 3 of 3
Real questions, real queries.
What to do
Write 10 SQL queries that answer business questions on a sample store database (revenue by month, top customers, churn).
You’ll make
Done looks like
10 working queries, each explained.
Learn before you build
Free course
Free hands-on micro-courses in Python, pandas and visualisation.
Free course
Free Google courses on Analytics, Ads and more, with certificates.
Free course
Free interactive SQL lessons.
Free tool
Free dashboards that connect to Sheets, Analytics and more.
Article guide
How to present data clearly.