Excel + Power BI + Data Analytics
Our complete practical program: Excel, Power Query, Power Pivot, Power BI, DAX, dashboards, projects and analytics career preparation.
Explore the flagship program →
Excel · Power BI · Data Analytics
Master Excel, Power BI & Data Analytics with Practical Training
Learn the tools analysts use every day - formulas, pivot tables, Power Query, DAX and interactive dashboards - by building real reports, not watching slides.
- Instructor-led, project-based
- Beginner to advanced paths
- Free counselling & demo on request
- New to spreadsheets
- Start with Excel
- Comfortable with Excel
- Go to Power BI
- Want analyst skills
- Flagship program
- In your city
- Find training near you
What we do
A specialist academy for the tools business reporting actually runs on
CharterPeak teaches one family of skills in depth: Microsoft Excel, Power BI and the analytics workflow that connects them. Every course is built around the same chain - get the data, clean it, model it, analyse it, present it, and explain what it means for a decision.
You work on finance, sales, HR, marketing and operations style datasets, so the skills transfer directly to the reports your team asks for on Monday morning.
Featured courses
Flagship program Start here Next level Most popular path
Pick the course that matches where you are
Excel Course
Beginner-to-advanced Microsoft Excel training: formulas, data cleaning, pivot tables, charts and dashboards.
View course →Advanced Excel Course
XLOOKUP, dynamic arrays, advanced pivots, Power Query, Power Pivot and automation for people who already use Excel daily.
View course →Power BI Course
Power Query, data modeling, DAX, visuals, dashboards and Power BI Service - from first import to a published report.
View course →Data Analytics Course
The analytics workflow end to end: Excel, Power Query, Power BI, visualization and business intelligence with projects.
View course →Business Intelligence Course
From raw data to decision support: preparation, modeling, analysis, visualization and reporting in Power BI.
View course →
Learning paths
Three paths, one connected skill set
Excel path
- Excel basicsFormulas, formatting
- Advanced ExcelXLOOKUP, dynamic arrays
- Data analysisPivots, cleaning
- DashboardsReporting views
- Power QueryAutomated cleaning
Power BI path
- Power BI basicsImport and visuals
- Data modelingStar schema
- DAXMeasures, context
- DashboardsInteractive reports
- AnalyticsEnd-to-end projects
Data analytics path
- ExcelWorking data
- Power QueryCleaning
- Power BIModeling and DAX
- Business IntelligenceReporting systems
- Analyst careerPortfolio and interviews
Flagship program
Excel + Power BI + Data Analytics in one practical program
Fourteen modules take you from Excel fundamentals to Power Query, Power Pivot, data modeling, DAX and business dashboards, finishing with real-world projects and career preparation.
Skills students learn
- Excel formulas
- XLOOKUP
- Pivot tables
- Power Query
- Power Pivot
- Data modeling
- DAX measures
- Dashboards
- Business reporting
- Data storytelling
Who the courses are for
- Students and graduates building a data skill set
- Working professionals in finance, sales, HR, operations and marketing
- Career changers moving toward analyst roles
- Teams that need consistent, automated reporting
Practical projects
You finish with work you can show
Sales performance dashboard
Revenue, margin and target tracking by region and product, built with a star-schema model and DAX measures.
Read more →Excel management report
A pivot-driven monthly report with slicers, KPIs and conditional formatting a manager can read in a minute.
Read more →More project walkthroughs
Problem, dataset, process and insights for each project we publish.
Read more →
How we teach
Training methodology
- Business question first, tool second
- Every concept practised on a working file
- Common mistakes taught on purpose
- Trainer feedback on each module exercise
- Practice datasets and files to keep
Read more about CharterPeak and meet the trainers.
Questions
Frequently asked
Do I need prior Excel knowledge?
Not for the Excel course. For Power BI we recommend basic comfort with Excel tables and simple formulas; counselling will tell you whether to start with Excel first.
Is Power BI suitable for beginners?
Yes, if you are comfortable with data in rows and columns. The course starts from importing data and building simple visuals before moving to modeling and DAX.
Is certification provided?
You receive a CharterPeak course completion certificate. It is not a Microsoft certification, and we do not guarantee certification exam results.
Do you guarantee a job?
No. We teach skills and help you build a project portfolio and interview readiness, but we do not guarantee placement or salary.
Is the training online or in a classroom?
Formats vary by batch. Ask for current online, offline and hybrid options when you book a free counselling call.
Resources
Guide Guide Guide Guide
Learn more before you enrol
XLOOKUP in Excel: Syntax, Examples and Common Errors
How XLOOKUP works, how it differs from VLOOKUP, and how to fix the errors people hit most often.
Read guide →What Is Power BI? A Plain-English Introduction
A plain-English explanation of Power BI, its components and who uses it.
Read guide →DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →Pivot Tables in Excel: A Practical Guide
Create, group and refresh pivot tables, and avoid the mistakes that produce wrong summaries.
Read guide →Browse all articles · Excel vs Power BI · Data analyst career guide