SkillPath Africa
Beginner → Professional

Data Analysis & Visualization

Learn to turn raw data into clear dashboards using Power BI and Google Looker Studio. By the end you'll be able to build interactive reports and present data insights the way clients and employers expect.

16 lessons · 4 levelsKSh 500

Every lesson comes with written notes, a practice task and a knowledge check.

Watch the first lesson free

Power BI Tutorial for Beginners (Step-by-Step in 30 Minutes) — A quick, practical introduction to the Power BI interface and workflow.

Create a free account to watch it. No payment needed.

On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.

Level 1 — Foundations

Start from zero: what this skill is, the tools you need, and your first hands-on practice.

Module 1 — Getting Started

  • Lesson 1 — Power BI Tutorial for Beginners (Step-by-Step in 30 Minutes)· 31 min· ~221 MB

    A quick, practical introduction to the Power BI interface and workflow.

    • Explain what a business intelligence tool adds over a spreadsheet
    • Follow the four stages every BI tool works in
    • Choose a tool you can actually run and afford
  • Lesson 2 — Looker Studio Tutorial For Beginners· 8 min· ~58 MB

    Introduces Looker Studio's interface and how to connect and visualize a data source.

    • Connect a data source and build a report in the browser
    • Use calculated fields, filters and date ranges
    • Share a report so the right people can read it

Module 2 — Core Skills in Practice

  • Lesson 1 — Complete Power BI Tutorial for Beginners in 3 Hours· 2h 40m· ~1154 MB

    Hands-on practice importing data, creating visuals, and building a Power BI report.

    • Work through the full Power BI cycle on real data
    • Do the transform stage properly before modelling
    • Build relationships between tables correctly
  • Lesson 2 — Build Your First Dashboard — Looker Studio Full Tutorial· 50 min· ~362 MB

    Walks through building a complete marketing-style dashboard in Looker Studio.

    • Build a complete dashboard from a real source
    • Lay a page out so it answers questions in order
    • Deliver something a client will actually open

Module 3 — Before the Dashboard: Getting the Data Right

  • Lesson 1 — What Dirty Data Looks Like· 7 min· ~48 MB

    Google's Data Analytics programme on the errors that make data untrustworthy — spelling, inconsistent labels, missing values and duplicates. Under 7 minutes.

    • Recognise the common ways a dataset is dirty
    • Explain why one inconsistent label breaks an entire chart
    • Decide what to do about missing values instead of ignoring them
  • Lesson 2 — Cleaning It: Sorting, Filtering, Pivots and Lookups· 10 min· ~71 MB

    Google's Data Analytics programme on the actual techniques — sorting, filtering, pivot tables and VLOOKUP — that turn a messy export into something you can chart. About 10 minutes.

    • Sort and filter to isolate the rows that matter
    • Summarise data with a pivot table instead of by hand
    • Bring two datasets together with a lookup

Module 4 — Charts That Tell the Truth

  • Lesson 1 — Choosing the Right Chart· 7 min· ~52 MB

    Maven Analytics on the nine chart types that cover almost every real need, and which question each one answers. About 7 minutes.

    • Match a chart type to the question being asked
    • Explain why a pie chart is usually the wrong choice
    • Choose a chart your reader can understand without explanation
  • Lesson 2 — How Charts Mislead — Including Yours· 4 min· ~30 MB

    TED-Ed's classic explainer on misleading graphs: the tricks that make true numbers tell a false story. About 4 minutes, and worth watching twice.

    • Spot a truncated axis, a cherry-picked range and a misused scale
    • Check a chart before believing it, including your own
    • Present an honest chart even when the finding is inconvenient

Level 2 — Intermediate Skills

Move past the basics into the techniques that separate a beginner from someone genuinely useful.

Module 5 — Advanced Data Wrangling & Visualization

  • Lesson 1 — Advanced Pandas: GroupBy, Merge & Cleaning· 1h 34m· ~678 MB

    Go beyond basic pandas to group, merge, and clean messy multi-file datasets the way working analysts do.

    • Do in code what a spreadsheet cannot repeat reliably
    • Group, join and reshape a real dataset
    • Run Python without a capable laptop
  • Lesson 2 — Building a Marketing Dashboard with Matplotlib & Seaborn· 8 min· ~58 MB

    Turn raw KPI data into a polished multi-chart dashboard using Matplotlib and Seaborn together.

    • Produce charts in code that are readable by someone else
    • Choose the chart from the question, as in Module 4
    • Know when a coded chart beats a dashboard tool

Level 3 — Professional Practice

Work the way professionals do, then apply everything to a complete real-world project.

Module 6 — Working Like a Pro

  • Lesson 1 — Power BI Dashboard Tutorial — Full Project with DAX· 2h 59m· ~1288 MB

    Builds a full end-to-end Power BI dashboard project using DAX formulas.

    • Write measures that calculate correctly in every context
    • Build the time comparisons every report needs
    • Debug a number that looks wrong
  • Lesson 2 — Storytelling with Data (Crash Course)· 11 min· ~80 MB

    Teaches how to present charts and dashboards as a clear, persuasive story for stakeholders.

    • Lead with the finding rather than the method
    • Structure an analysis so a decision follows from it
    • Present to someone who will not read a report

Module 7 — Real-World Data Analytics Project

  • Lesson 1 — End-to-End Data Analytics Project (Python + SQL)· 47 min· ~337 MB

    Pull a real dataset via the Kaggle API, clean it, analyze it with SQL and Python, and present findings, start to finish.

    • Take a project from raw data to a stated conclusion
    • Use SQL and Python for the parts each does best
    • Document the work so someone else can check it
  • Lesson 2 — Build a Complete Power BI Dashboard Project· 59 min· ~425 MB

    Connect a real dataset, clean it, and build an interactive Power BI dashboard with filters and slicers a client could use.

    • Deliver a full Power BI report as a finished piece of work
    • Design for the person who will use it, not for yourself
    • Hand it over so it survives without you

Level 4 — Freelance & Career

Turn the skill into income: finding clients, pricing your work, and building a career around it.

Module 8 — Freelance & Career Path for Data Analysts

  • Lesson 1 — How to Become a Freelance Data Analyst· 45 min· ~322 MB

    Steps to package your analysis skills into freelance income: niche, portfolio, and where to find first clients.

    • Define a service a client will recognise and buy
    • Find the organisations here that genuinely need analysis
    • Price and scope data work so it stays profitable
  • Lesson 2 — 3 Data Analyst Portfolio Projects to Get Hired· 13 min· ~95 MB

    Build the specific 3-project portfolio pattern that recruiters and hiring managers respond to for data analyst roles.

    • Build projects that show judgement rather than tool use
    • Write each one up so a hiring manager reads it
    • Choose subjects that make you memorable here

Spin for a discount

One spin, one discount on this Learning Path.

10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF
Get Full Access — KSh 500

Reviews

No reviews yet.