Flagship practical analytics program

Excel + Power BI + Data Analytics Course

One connected program from Excel fundamentals to Power BI dashboards and business reporting, with real-world projects and career preparation.

Hands-on, project-based
Trainer feedback on every module
Free counselling & demo on request

Book Free Demo Call +91 81888 77720 WhatsApp

Get the curriculum and a free callback

We use your details only to reply to your enquiry. Privacy policy.

Format: Live, instructor-led
Duration: Shared at counselling
Fees: Shared on enquiry
Level: Beginner to advanced

Program overview

Analysts rarely use one tool. Data arrives in Excel, gets cleaned in Power Query, modeled in Power Pivot or Power BI, analysed with DAX and presented as a dashboard. This program teaches that chain in order, so each module builds on the last.

It combines the content of the Excel, Advanced Excel and Power BI courses with projects and career preparation from the Data Analytics course, so you do not need to join them separately.

Who this course is for

Beginners who want a single complete path into analytics
Graduates and career changers targeting analyst, MIS or reporting roles
Professionals who want one structured program instead of piecing courses together
Teams upskilling on Microsoft analytics tools

Prerequisites

Basic computer skills; no prior Excel or Power BI needed
A Windows PC is recommended (Power BI Desktop is Windows-only)

The learning journey

ExcelModules 1-4
Power Query & PivotModules 5-6
Power BIModules 7-11
ReportingModules 12-13
Career prepModule 14

Why one program instead of separate courses?

Concepts connect: Power Query in Excel is the same editor as in Power BI
You build one portfolio across tools, with consistent datasets
No repetition of fundamentals between courses
Clear progression from beginner to a defined end project

What you will learn

Use Excel confidently for analysis and reporting
Automate data preparation with Power Query
Build multi-table models with Power Pivot and Power BI
Write DAX measures including time intelligence
Create interactive dashboards and business reports
Complete end-to-end analytics projects
Prepare a portfolio, resume and interview answers for analyst roles

Tools covered

Microsoft Excel
Power Query
Power Pivot
Power BI Desktop
Power BI Service
DAX
Dashboards
AI assistants (optional module)

Practical projects

Sales analytics in Excel. Cleaning, pivots and a management report.

Automated reporting with Power Query. Multi-file consolidation with one refresh.

Power BI sales and finance dashboards. Star schema, DAX measures and publishing.

Capstone business case. Question to recommendation with a presented report.

Detailed curriculum

Fourteen core modules plus one optional module. Each module has a practical exercise; modules 13 and 14 are project and career work. Exact schedule and duration are confirmed at counselling.

Module 1Excel fundamentals

Tables, formatting, references
Core functions and lookups

Module 2Advanced Excel

XLOOKUP, SUMIFS, dynamic arrays
Validation and conditional formatting

Module 3Excel data analysis

Profiling, pivots, descriptive statistics
Variance and trend analysis

Module 4Pivot tables and dashboards

Pivot charts, slicers, KPI layout

Module 5Power Query

Import, clean, merge, append, unpivot
Folder queries and refresh

Module 6Power Pivot

Data Model, relationships, first measures

Module 7Power BI fundamentals

Desktop, Service, visuals, report workflow

Module 8Data cleaning

Quality checks and repeatable preparation patterns

Module 9Data modeling

Star schema, cardinality, date tables

Module 10DAX

Context, CALCULATE, iterators, time intelligence

Module 11Power BI dashboards

Design, interactivity, publishing

Module 12Business reporting

Management reporting packs, KPIs, narratives

Module 13Real-world projects

Two end-to-end projects with trainer review

Module 14Analytics career preparation

Portfolio, resume, interview questions, case tasks

Module 15Optional: AI-assisted data analysis

Using AI assistants to draft formulas, explain DAX and summarise findings - with verification habits
Limits: privacy, hallucinated formulas, checking results

Download Curriculum

Learning methodology

Every concept is taught on a working file. You see the business question first - for example, "which regions missed target last quarter?" - and then build the formula, query or measure that answers it.

Each module closes with an exercise you complete yourself, followed by trainer feedback. Mistakes are part of the process: we cover the errors people actually hit, such as text-formatted numbers, broken lookups and wrong relationship direction.

Training files and practice datasets are provided so you can repeat every exercise after class.

Training format, batches and certification

Format. Instructor-led, practical sessions. Online, classroom and hybrid options are confirmed when you speak to us.

Batches. Upcoming batch dates are shared during counselling so you get current information. Ask for weekday, weekend or fast-track availability.

Certification. You receive a CharterPeak course completion certificate on completing the program and its assessments. This is not a Microsoft certification. If you want to prepare for a Microsoft exam such as PL-300, tell us and we will map the syllabus to the official skills outline.

Your trainers

Trainer names, backgrounds and areas taught are listed on our trainers page. Ask for a short demo class or a call with the trainer before you enrol.

Sample project: month-end reporting pack

You receive twelve monthly sales files in different layouts. In Power Query you standardise them into one table, load it to a Power BI model with product and region dimensions, write DAX for revenue, margin and prior-year comparison, and publish a three-page pack. The same business question is first solved in Excel so you can see where Power BI is the better tool.

Career applications

Data analyst, business analyst, MIS and reporting analyst roles
Power BI developer entry paths
Finance, sales, HR and operations analytics
See the data analyst career guide and how to become a data analyst

Skills help you qualify for these kinds of work. CharterPeak does not guarantee placement, salary or any specific career outcome.

Continue your learning path

Compare tools in Excel vs Power BI
Read data analyst skills to see where you stand
Prefer to start smaller? Try the Excel course

Frequently asked questions

Who is this program for?

Anyone who wants a complete path into Excel and Power BI analytics, including complete beginners. It is also suitable if your Excel is solid and you want Power BI plus projects.

How is it different from the individual courses?

It is the same core content in one sequence, plus projects and career preparation, so you avoid repeated fundamentals.

Does it include SQL or Python?

No. The program is built on Excel, Power Query, Power Pivot, Power BI and DAX. We do not advertise tools that are not taught.

What is the AI module?

An optional module on using AI assistants carefully for analysis tasks - drafting formulas, explaining DAX and summarising results - with emphasis on checking the output.

Will I get a job after the program?

We cannot guarantee placement or salary. We help you build skills, projects, a portfolio and interview readiness.

What is the duration of the Excel + Power BI + Data Analytics Course?

Duration depends on the batch (weekday, weekend or fast-track). We confirm the schedule and total hours when you speak to us, so you get current information rather than a fixed number on a web page.

Who can join the Excel + Power BI + Data Analytics Course?

Students, graduates, working professionals and career changers. The prerequisites are listed on this page; if you are unsure, book a free counselling call and we will point you to the right starting course.

Is the training practical?

Yes. Each module is taught on working files with exercises you complete yourself, followed by trainer feedback and project work.

Is the training online or in a classroom?

Delivery options depend on the batch. Ask about current online, offline and hybrid availability when you enquire.

Is certification provided?

You receive a CharterPeak completion certificate after finishing the program and its assessments. It is not a Microsoft certification and we do not promise exam results.

What fees and payment options apply?

Fees depend on the batch and format and are shared on enquiry. See our refund policy before you enrol.

Related courses

Start here

Excel Course

Beginner-to-advanced Microsoft Excel training: formulas, data cleaning, pivot tables, charts and dashboards.

View course →

Next level

Related learning resources

Guide

Excel for Data Analysis: A Practical Workflow

A five-step workflow for analysing data in Excel, with the tools to use at each step.

Read guide →