Business Data Analytics & Advanced Excel

Level 1 of 2

Beginner Level

Prerequisites

Basic computer use and simple spreadsheet skills (entering data, SUM and simple charts). No prior analytics experience is needed.

Duration

4 weeks · 52 guided hours · 5 modules. Taught live by an instructor — online or in person.

By the end of this level you can

  • Organise and clean business data so it can be analysed reliably
  • Calculate business figures — totals, shares, growth and averages — correctly in Excel
  • Build clear Excel reports and dashboards for managers
  • Create and share a first Power BI report
  • Produce simple, honest sales forecasts

Modules

  1. 1Module 1 · 10 h · 3 lessons · free taster lessonClean Data for Business Analysis
  2. 2Module 2 · 11 h · 3 lessons · free taster lessonExcel Analysis Functions and Charts
  3. 3Module 3 · 10 h · 3 lessons · free taster lessonExcel Dashboards and Business Reports
  4. 4Module 4 · 11 h · 3 lessons · free taster lessonGetting Started with Power BI
  5. 5Module 5 · 10 h · 3 lessons · free taster lessonBusiness Forecasting Basics
  6. Free course quizQuick Quiz — Business Data Analytics Basics

Beginner level project

Quarterly Business Performance Report

Clean and analyse a quarter of sales and expense records from a realistic small business or NGO, build an Excel dashboard and a matching Power BI report, and forecast next month's sales.

Deliverables

  • A cleaned data workbook with a documented cleaning log
  • An Excel analysis sheet with correctly calculated key figures
  • An Excel dashboard and a one-page Power BI report
  • A next-month sales forecast with a short explanation of its uncertainty

Assessed on

  • Data problems are found, fixed and documented
  • Percentages, growth and averages are calculated and described correctly
  • Reports answer the manager's questions clearly
  • The forecast method is appropriate and its limits are stated

All levels are taught live by an instructor — online or in person — see registration options.