Loading…
Get job-ready as a junior data analyst
The route we recommend from no experience to a junior data analyst role. Learn how analysis works, then the tools teams use every day (Excel, SQL, Power BI and Python) on realistic company data. Build portfolio projects that answer real business questions, and finish with your CV, LinkedIn and interview preparation.
What you'll be able to do
CloudTech Data Analyst
Complete every required course to earn the track badge, free, with a credential ID anyone can verify.
Start with Data Analytics FoundationsHow analysis works, and the spreadsheet skills every analyst uses.
How analysis works: questions, data types, cleaning and telling the story.
About 6 hours
The tool almost every business already uses, from formulas to pivot tables.
About 7 hours
Statistics for Data Analysis
Averages, spread, distributions, sampling and comparing groups without fooling yourself.
Get data out of databases, model it properly and turn it into dashboards.
Pull and summarise data straight from a database.
About 7 hours
Design the tables, keys and star schemas reliable reports are built on.
About 6 hours
Turn the numbers into dashboards people can use.
About 8 hours
Power BI DAX
Measures, filter context, CALCULATE and time intelligence in depth.
Automate and scale your analysis, and handle harder questions.
Write an analysis once and run it again in seconds, with every step on record.
About 9 hours
Advanced SQL
Window functions in depth, query performance, date logic and data cleaning in SQL.
Portfolio projects on realistic data. Each one answers a business question end to end.
Where is a distributor's revenue coming from, and where is it slipping?
Find the late routes and the customers who owe money.
Who leaves, when, and why: an HR analysis.
Turn a messy export into a list a business can trust.
Capstone: End-to-End Business Intelligence Project
From raw data to a reviewed dashboard and written recommendations.
Turn your skills into applications that get interviews.
An ATS-friendly CV and a LinkedIn profile recruiters can find.
1 hr 30 min
One link that shows your projects.
1 hr 25 min
Find, apply for and interview for your first role.
1 hr 30 min
Courses marked "In preparation" join the track when they're ready. If you've already earned the track badge by then, you keep it.