Data Analytics Foundations
What data analytics is, how businesses use data to decide, and the core skills you need to start.
- Level
- Beginner
- Estimated time
- About 6 hours
- Content
- 10 lessons
- Project
- Final project
- Certificate
- Certificate
CloudTech Academy
Practical, self-paced courses in data, analytics and technology, designed to help you learn, practise and build real skills without expensive course fees.
1Data
shipment_id · customer · containers
100412 · Apex Foods · 4
100413 · Delta Motors · 2
100414 · Apex Foods · 6
2Analysis
SELECT customer, SUM(containers) FROM shipments GROUP BY customer;
3Insight
4Decision
Protect the top accounts; follow up the ones slowing down.
CloudTech Academy is text-first. You read a short explanation, then write the query, build the formula or answer the question yourself.
Every lesson starts with a realistic business problem, and you practise on real-looking company data.
Learn when you have the time. Lessons are short enough for a lunch break and read well on a phone.
The core courses are free. You can read every lesson without an account; sign up only to save progress and earn a certificate.
Finish with projects you can show and explain to an employer, not only a certificate.
All five courses are open and free. New to data? Start with Data Analytics Foundations, or go straight to the tool you need.
What data analytics is, how businesses use data to decide, and the core skills you need to start.
Clean, analyse and present business data in Excel, from formulas and XLOOKUP to pivot tables and charts.
Query real business data with SQL, from your first SELECT to window functions, using a logistics company's database.
Design databases and analytics models that stay correct: entities, keys, relationships, ERDs, normalisation and star schemas.
Build a data model, write DAX measures and design a dashboard people can use to run a business.
The SQL course comes with Harbourline Freight, a fictional logistics company with thousands of shipments, customers and payments. Write a query, run it, and get told straight away whether your result is right. Nothing to install.
Try the first lessonSELECT c.company_name,
SUM(s.containers) AS containers
FROM shipments AS s
JOIN customers AS c ON c.customer_id = s.customer_id
WHERE s.booking_date >= '2026-01-01'
GROUP BY c.customer_id, c.company_name
ORDER BY containers DESC
LIMIT 5;Correct. Your result matches the expected answer.
Whether you're starting your first data course or building your next professional skill, CloudTech Academy gives you a practical place to learn, practise and build.