Data Analysis

Turn raw data into decisions with Excel, SQL, Power BI and Python, using real business datasets.

  • BeginnerLevel
  • 12Lessons
  • 72 hrsDuration
  • 0Students

Taught by Lead Instructor

What you will learn

  • Clean and organise messy data

  • Use Excel formulas, pivot tables and charts

  • Query databases with SQL

  • Build interactive dashboards in Power BI

  • Analyse data with Python

  • Present insights to decision makers

Curriculum

4 modules, 12 lessons

Module 1 Excel for analysis 3 lessons
  1. YouTube video Data cleaning Free preview
  2. YouTube video Essential formulas Premium lesson
  3. YouTube video Pivot tables and charts Premium lesson
Module 2 SQL 3 lessons
  1. YouTube video Databases and SELECT queries Premium lesson
  2. YouTube video Filtering, sorting and joins Premium lesson
  3. YouTube video Grouping and aggregations Premium lesson
Module 3 Visualisation 3 lessons
  1. YouTube video Power BI basics Premium lesson
  2. YouTube video Building dashboards Premium lesson
  3. YouTube video Data storytelling Premium lesson
Module 4 Python for data 3 lessons
  1. YouTube video Python and pandas basics Premium lesson
  2. YouTube video Analysing a real dataset Premium lesson
  3. Assignment Final project: a business dashboard and report Premium lesson

About this course

Learn to collect, clean, analyse and present data, a skill every industry now needs. You'll master Excel, query databases with SQL, build dashboards in Power BI and get started with Python for analysis.

You'll finish with portfolio projects built on real datasets.

Student reviews

No reviews yet.

Requirements

  • A laptop (any brand, at least 4GB RAM)
  • Basic computer skills
  • Commitment to practise between classes

Pair it with

Data & AI

Artificial Intelligence

Understand how AI and machine learning work, use AI tools productively, and build your own AI-powered applications.

  • 9 lessons
  • 84 hours
  • 1 student
  • New
₦45,000
View course