- Duration
- 8 weeks · 96 hours
- Mode
- Online / Hybrid
- Level
- Beginner
- Certification
- Knowplicity Data Analytics Certificate
Overview
A practical program for aspiring analysts and business professionals who want to make data-driven decisions. Every module ends with a hands-on case study drawn from sales, finance and operations.
Curriculum
01Advanced Excel for Analysis
- Lookups, pivot tables and Power Query
- Data cleaning techniques
- Dashboarding in Excel
02SQL for Data Analysis
- SELECT, JOIN, GROUP BY and window functions
- Subqueries and CTEs
- Querying real databases
03Power BI
- Data modelling and DAX
- Interactive visualisations
- Publishing and sharing reports
04Capstone Project
- End-to-end business analytics case
- Presenting insights to stakeholders
What you’ll gain
- Clean, analyse and visualise business data with confidence
- Write SQL queries against real-world databases
- Build interactive Power BI dashboards
Who should attend
- Aspiring data and business analysts
- Finance, sales and operations professionals
- MBA students and graduates
You may also like
TechnicalBeginner
Full-Stack Web Development Bootcamp (MERN)
Go from fundamentals to job-ready with hands-on projects in React, Node.js, Express and MongoDB — plus interview preparation and placement support.
- 12 weeks · 180 hours
- Online · Classroom
- Knowplicity Full-Stack Developer Certificate
View program