Academy / MASIT / School of Innovation and Technology
Data Analytics
Turn raw numbers into decisions with spreadsheets, clear charts and a little SQL.
4 learners
You will finish with
A data story: a cleaned dataset, a clear question, an analysis with pivot tables and formulas, charts that make the point and a one-page recommendation a manager could act on.
- 01
A clear question and the source of your data, with a note on how you checked it was reliable
- 02
A cleaned dataset (view-only link) and a short list of the cleaning steps you took and why
- 03
An analysis using at least two formulas such as SUMIFS or COUNTIFS and at least one pivot table
- 04
Three charts that each answer one point, with clear titles and labels
- 05
A one-page recommendation: what you found, how sure you are and what to do next
Your journey, one step at a time.
-
1
What data analytics is
Explain what a data analyst does.
-
2
Clean and organise data
Find and remove duplicates and blank rows safely.
-
3
Analyse with formulas and pivot tables
Use SUM, AVERAGE, COUNT, MIN and MAX confidently.
-
4
Charts and data storytelling
Choose the right chart for the point you want to make.
-
5
A first taste of SQL
Explain what a database and a SQL query are.
-
6
Your portfolio: data story
Assemble your work into a short, clear data story.
- ★
Your capstone
Publish your pack as one link. Faculty review it, and you earn your certificate.
Who it is for
- Students and graduates who want a skill that every employer needs
- Business owners who have sales, attendance or survey data but no idea what it says
- Church, school and NGO administrators who report numbers to leaders and donors
- Anyone curious about a career in data, business analysis or research
What you will be able to do
- Frame a business question that data can answer
- Clean a messy dataset: duplicates, blanks, wrong formats and inconsistent text
- Summarise data with formulas such as SUMIFS and COUNTIFS and with pivot tables
- Choose and design charts that show the answer clearly and honestly
- Write simple SQL queries to filter, sort and summarise a table
- Present findings and a recommendation in a short, clear data story
Free for everyone. Learn on your phone. Stop and pick up where you left off.