Academy / MASIT / School of Innovation and Technology

Data Analytics

Turn raw numbers into decisions with spreadsheets, clear charts and a little SQL.

Beginner6 modulesAbout 13 hoursFreeCertificate

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. 1

    What data analytics is

    Explain what a data analyst does.

    3 lessons / 1 task / 2 quizzes / about 1.6 h

  2. 2

    Clean and organise data

    Find and remove duplicates and blank rows safely.

    3 lessons / 1 task / 2 quizzes / about 2.2 h

  3. 3

    Analyse with formulas and pivot tables

    Use SUM, AVERAGE, COUNT, MIN and MAX confidently.

    3 lessons / 1 task / 2 quizzes / about 2.4 h

  4. 4

    Charts and data storytelling

    Choose the right chart for the point you want to make.

    3 lessons / 1 task / 2 quizzes / about 2.3 h

  5. 5

    A first taste of SQL

    Explain what a database and a SQL query are.

    3 lessons / 1 task / 2 quizzes / about 2 h

  6. 6

    Your portfolio: data story

    Assemble your work into a short, clear data story.

    3 lessons / 1 task / 2 quizzes / about 2.3 h

  7. ★

    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
Register to start, free

Free for everyone. Learn on your phone. Stop and pick up where you left off.