Data Analysis (Excel / PowerBI)
Adeola Juliet Odumeru
Governor road second junction idimu lagos. Nigeria Lagos
•
4 Yrs Exp.
🎨 Digital Skills Mentor
Duration
1 Month
Days/Week
Days
Total Classes
Sessions
Delivery
Online
Course Overview
INTRODUCTION TO DATA ANALYSIS COURSE OUTLINE
OVERVIEW
The Data Analytics Combo Course is a beginner-level program designed to provide individuals with the essential skills and knowledge required in data analytics. Participants will be trained in the use of industry-standard tools and software, specifically Microsoft Excel and SQL, over a period of several months.
The curriculum includes a series of assessments, comprising assignments and examinations, which facilitate the practical application of the acquired knowledge.
Course Modules:
- Data Literacy
- Microsoft Excel
- Structured Query Language (SQL)
- Introduction to AI
📅 Dynamic Week-by-Week Syllabus
Module 1
Data Literacy Foundations (Weeks 1–2)
Week 2
Week 1 & 2— Thinking Like an Analyst
Week 3
What is data literacy, and why it matters
Types of data
qualitative vs. quantitative, structured vs. unstructured
The data analysis lifecycle
ask → collect → clean → explore → analyze → communicate
Week 6
Asking good analytical questions
Week 7
Understanding tables, charts, and summary statistics.
Module 2
Excel for Data Analysis (Weeks 3–5)
Week 9
Week 3 — Excel Fundamentals
Week 10
Spreadsheet structure, data types, formatting
Core formulas
SUM, AVERAGE, COUNT, IF, nested IFs
Week 12
Sorting, filtering, and data validation
Week 13
Cleaning messy data (Text-to-Columns, TRIM, duplicates)
Week 14
Week 4 — Analysis in Excel
Lookup formulas
VLOOKUP, XLOOKUP, INDEX/MATCH
Week 16
PivotTables and PivotCharts
Week 17
Conditional formatting for quick insights
Week 18
Intro to Excel charts and dashboard basics
Week 19
Week 5 — Advanced Excel Techniques
Week 20
Intro to Power Query (import, clean, transform data)
Week 21
Building a simple one-page Excel dashboard
Project 1
Analyze and visualize a sale/operations dataset in Excel
Module 3
Power BI (Weeks 6–7)
Week 24
Week 6 — Power BI Basics
Week 25
Power BI interface and workflow (Power Query, Data Model, Report view)
Week 26
Importing and shaping data
Building basic visuals
bar, line, pie, cards, tables
Week 28
Filters, slicers, and interactivity
Week 29
Week 7 — Data Modeling & Dashboards
Week 30
Relationships between tables (star schema basics)
Intro to DAX
calculated columns and measures
Week 32
Designing a clear, effective dashboard
Week 33
Publishing and sharing reports
Project 2
Build an interactive Power BI dashboard from a business dataset
Module 4
SQL for Analysts (Weeks 8–9)
Week 36
Week 8 — SQL Fundamentals
Databases and tables
how data is stored
Week 38
SELECT, WHERE, ORDER BY, basic filtering
Aggregate functions
COUNT, SUM, AVG, GROUP BY, HAVING
Week 40
Week 9 — Combining & Querying Data
Week 41
JOINs (INNER, LEFT, RIGHT) to combine tables
Week 42
Writing queries to answer real business questions
Week 43
Connecting SQL data to Excel
Project 3
Write SQL queries to extract insights from a multi-table database
Module 5
AI-Assisted Data Analysis (Weeks 10–11)
Week 46
Week 10 & 11 — AI as an Analysis Partner
Week 47
Overview of AI tools for data work (chat-based assistants, Copilot in Excel/Power BI)
Week 48
Using AI to clean data, write formulas, and generate SQL queries
Week 49
Prompting effectively for data tasks
Understanding AI limitations
hallucinations, verifying outputs
Week 51
Using AI to summarize datasets and generate narrative insights
Module 6
Capstone Project (Week 12)
Week 53
Week 12 — End-to-End Capstone
Week 54
Choose a real or provided business dataset
Deliverable
Power BI dashboard + short written insight summary + presentation
Week 56
Peer review and feedback session
Class Schedule & Venue
Weekly Time Slot
Mondays & Wednesdays, 4:00 PM - 6:00 PM
Online Platform
Conducted live via Google Meet. Full meeting links and video instructions will be sent upon course enrollment.
Rules & Prerequisites
Student Requirements & Prerequisites
Laptop , Good Internet Connectivity and Note pad
Class Rules & Conduct
80% attendance is complusory
About the Instructor
Adeola Juliet Odumeru
B.Sc in Statistics Certificate in Data Analysis
🎨 Digital Skills Mentor
I am Odumeru Adeola Juliet, a data analysis instructor with over three years of experience in in-person and virtual training. Based in Lagos, I am inquiring about current openings for a data analysis instructor position. My practical expertise and teaching passion align with your organization's …
View Full Tutor Profile & Reviews