Data Analytics

Data Analytics

Beginner
Data Analytics
Overview
Curriculum
  • 9 Sections
  • 40 Lessons
  • 9 Quizzes
Expand All

Week 1: What Data Analysis Is, and Clean Data

5 Lessons 1 Quiz

Week 2: Excel for Analysis

5 Lessons 1 Quiz

Week 3: Charts and Clear Reporting

5 Lessons 1 Quiz

Week 4: SQL Basics

5 Lessons 1 Quiz

Week 5: SQL for Real Questions

5 Lessons 1 Quiz

Week 6: Power BI Dashboards

5 Lessons 1 Quiz

Week 7: Analysis That Answers a Question

5 Lessons 1 Quiz

Week 8: Capstone and Career

5 Lessons 1 Quiz

Final Exam

1 Quiz

Learn Data Analytics: From Spreadsheet to Dashboard

Turn raw business data into clear answers with Excel, SQL and Power BI, and finish with a portfolio project.

Beginner Friendly
No prior experience needed.
Hands-On Labs
One lab every week.
Excel, SQL, Power BI
The tools employers ask for.
8 Weeks
40 lessons at your own pace.
Capstone Project
Build a portfolio piece.
Final Exam
40 questions, 70% to pass.
Live Classes
Every weekend on Google Meet.
Scholarships
90% off for eligible learners.

Course Overview

Every business collects data, and few people can turn it into decisions. This programme takes you from your first spreadsheet to a working dashboard. You will clean messy data, answer questions with Excel and SQL, build a Power BI dashboard and explain your findings to a manager. Every week uses the same case: Bolanle Fresh Market, a fictional chain of supermarkets in Lagos and Ibadan.

Next Cohort

Starts October 31st

Duration: 8 weeks · Self-paced lessons in the week, live classes at weekends on Google Meet, a lab every week, and a final exam.

Learning Outcomes

  1. Clean and prepare messy data in Excel or Google Sheets.
  2. Answer business questions with formulas, lookups and pivot tables.
  3. Write SQL queries with joins, grouping, dates and CASE.
  4. Build a Power BI dashboard with a data model and DAX measures.
  5. Choose honest charts and explain your findings in a clear one-page report.

Career Opportunities

Almost every organisation that sells, stocks, teaches or lends needs people who can read its numbers. This programme prepares you for entry-level analyst work. It does not guarantee a job, but it gives you the skills and the portfolio to apply with confidence.

RoleWhat You'll Do
Junior Data AnalystClean data, answer questions and report to a team
Reporting AnalystBuild and refresh weekly and monthly reports and dashboards
Business Intelligence (BI) AssistantMaintain Power BI or Looker Studio dashboards
Sales or Operations AnalystTrack sales, stock and performance for a business unit
Finance or Admin Data OfficerPrepare and check figures in Excel and SQL

What You Will Learn

Week 1  Data Basics and Clean Data▼
  • What a data analyst does
  • Types of data
  • Spreadsheet basics
  • Cleaning duplicates, blanks and wrong spellings
  • Lab: clean the Bolanle Fresh Market sales file
Week 2  Excel for Analysis▼
  • Formulas that matter: SUM, AVERAGE, COUNT, IF
  • Lookups with XLOOKUP and VLOOKUP
  • Sorting, filtering and conditional formatting
  • Pivot tables
  • Lab: monthly sales by branch and product
Week 3  Charts and Clear Reporting▼
  • Choosing the right chart
  • Building charts in Excel
  • Mistakes that make charts lie
  • Writing a one-page finding
  • Lab: a one-page sales report
Week 4  SQL Basics▼
  • What a database is
  • SELECT, WHERE and ORDER BY
  • COUNT, SUM and AVG
  • GROUP BY and HAVING
  • Lab: first queries on the Bolanle database
Week 5  SQL for Real Questions▼
  • Joining two tables
  • Joining three or more tables
  • Dates, text and CASE
  • Subqueries and CTEs
  • Lab: find the best and worst branches and products
Week 6  Power BI Dashboards▼
  • Loading and shaping data with Power Query
  • The data model
  • Six DAX measures you need
  • Building a dashboard people can use
  • Lab: the Bolanle sales dashboard
Week 7  Analysis That Answers a Question▼
  • Asking a clear business question
  • Trends, seasons and comparisons
  • Averages, medians and outliers
  • Basic statistics for analysts
  • Lab: why did sales drop in March?
Week 8  Capstone and Career▼
  • Capstone brief: pick a business problem
  • Telling the story with slides
  • Building a portfolio on GitHub and LinkedIn
  • CV, interviews and first-job tasks
  • Final exam practice and next steps

Course Fees

The course fee is ₦150,000. Eligible learners can apply for a scholarship that covers 90% of the fee, so they pay ₦15,000. For questions about fees or scholarships, contact us using the details below.

Frequently Asked Questions

Are there live classes?▼
Yes. Live classes run every weekend on Google Meet, in addition to the self-paced lessons you can study during the week.
Do I need any experience?▼
No. You need to be comfortable using a computer and doing basic arithmetic such as percentages. The course teaches everything else from the start.
What do I need to take the course?▼
A laptop or desktop computer and a stable internet connection. We recommend 8 GB of RAM. Power BI Desktop runs on Windows only. If you use a Mac, the dashboard week also shows how to build the same dashboard in Looker Studio, which runs in your browser.
Do I have to buy software?▼
The tools are free or have free options: Google Sheets, SQLite with DB Browser, Power BI Desktop and Looker Studio. The lessons use Excel, and most tasks also work in Google Sheets.
Do I need to know programming?▼
No. SQL is taught from the first query. Python is not required, and lesson 8.5 shows you where to go next.
How is the course assessed?▼
Each week ends with a lab. At the end you complete a capstone project and a final exam of 40 questions in 75 minutes. The pass mark is 70%.
Will I get a job after the course?▼
We cannot promise a job. We teach the skills employers look for, help you build a portfolio and show you how to prepare a CV and interview. The result depends on your effort and the job market.
Is this an official Microsoft or vendor course?▼
No. This is a Grezitech Academy programme. It covers skills that support further study, such as Microsoft's Power BI data analyst certification.

Need Help?

Questions about the programme or payment?

Phone: +234 (0) 809 999 4624
Email: [email protected]

Contact Us

₦150,000
Buy Now
This course includes

8 weeks, starting October 31st, with a hands-on lab every week

Excel or Google Sheets, SQL and Power BI

Live weekend classes on Google Meet

One running case: Bolanle Fresh Market

Capstone project for your portfolio

Final exam: 40 questions, 75 minutes, 70% to pass

Beginner friendly, no experience needed

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Scroll to top