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 →
Practical data analytics training
Data Analytics Course
Learn the analytics workflow businesses use - collect, clean, model, analyse, visualise and report - on the Microsoft tools most teams already have.
- Hands-on, project-based
- Trainer feedback on every module
- Free counselling & demo on request
- Format
- Live, instructor-led
- Duration
- Shared at counselling
- Fees
- Shared on enquiry
- Level
- Beginner to advanced
Data Analytics Course overview
Data analytics is a process more than a tool: define the question, get and clean the data, analyse it, visualise the findings and recommend an action. This course teaches that process on Excel, Power Query and Power BI.
It is the broad pillar of our curriculum. If you want the complete beginner-to-project sequence in one place, see the flagship program; for a role-focused view, see the Data Analyst course.
Who this course is for
- Graduates and professionals exploring analytics
- Excel users who want to move into BI
- Managers who commission analysis and want to understand it
Prerequisites
- Basic Excel familiarity
The analytics toolchain we teach
- ExcelWorking data
- Power QueryCleaning
- Power BIModeling + DAX
- VisualizationDashboards
- BIReporting systems
- ProjectsPortfolio
We teach the tools listed above. We do not list SQL or Python as part of this course unless they appear in the curriculum below.
Analytics skills you will use
Excel analytics
Pivots, statistics basics and variance analysis. Excel data analysis
Power BI analytics
Models, measures and exploratory analysis. Power BI analytics
Data visualization
Choosing charts and designing for decisions.
Business intelligence
Reporting that supports repeated decisions. BI course
What you will learn
- Frame business questions as measurable analysis tasks
- Clean and combine data in Excel and Power Query
- Model and analyse in Power BI with DAX
- Select and design effective visualizations
- Communicate findings to non-technical stakeholders
- Document and present a portfolio project
Tools covered
- Excel
- Power Query
- Power BI
- DAX
- Data visualization
- Business reporting
Practical projects
Retail sales analysis. Profitability by product, store and month.
Customer segmentation. Segment by value and behaviour.
Operational KPI dashboard. Service-level tracking.
Detailed curriculum
The program is taught module by module. Each module ends with a hands-on exercise built on business-style data.
Module 1Analytics foundations
- The analytics process, metrics and KPIs
- Types of analysis: descriptive, diagnostic
Module 2Excel for analysis
- Cleaning, lookups, pivots, statistics basics
Module 3Power Query
- Repeatable preparation
Module 4Power BI modeling and DAX
- Star schema, measures, time intelligence
Module 5Data visualization
- Chart selection and dashboard design
Module 6Business intelligence reporting
- Report packs, refresh, sharing
Module 7Projects and portfolio
- Two analytics projects with review
Module 8Career preparation
- Resume, interview questions, case tasks
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 lesson: choosing the right question
A request arrives: "Analyse our sales." We rewrite it into measurable questions - which products drive margin, which regions miss target and why - before opening any tool. Good analysis starts by narrowing the brief.
Career applications
- Data analyst and business analyst
- MIS and reporting analyst
- BI analyst or Power BI developer (entry level)
- Sales, finance, HR and operations analytics
Continue your learning path
- Read the data analyst career guide
- Choose a deeper track: flagship program or Power BI
- Browse student projects
Frequently asked questions
Is this a data science course?
No. It is a practical data analytics course focused on business reporting and decision support, not machine learning.
Does it teach SQL or Python?
The curriculum above is built on Excel, Power Query and Power BI. SQL and Python are not part of it.
What is the difference between a data analyst and a BI analyst?
There is overlap. Analysts tend to investigate questions; BI roles tend to build reporting systems. See the BI course.
Which career roles use these skills?
Data analyst, business analyst, MIS analyst and BI developer roles. Outcomes depend on your effort and the job market; we do not guarantee placement.
What is the duration of the 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 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
Data Analyst Course
Role-based training with the tools listed on the curriculum: Excel, Power Query, Power BI, DAX, reporting, projects and interview prep.
View course →Business Intelligence Course
From raw data to decision support: preparation, modeling, analysis, visualization and reporting in Power BI.
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 →Excel Data Analysis Course
The analytical process in Excel: frame the question, clean and profile data, analyse with pivots and statistics, and present findings.
View course →Related learning resources
What Is Data Analytics? Types, Process and Tools
A clear explanation of data analytics: what it is, the main types and the typical process.
Read guide →The Data Analytics Process: Six Steps from Question to Decision
Six steps that most analytics projects follow, with an example for each.
Read guide →Ready to start?
Talk to us about your background and goals. We will recommend the right batch and starting point - no pressure.