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 →Data Analyst Skills
A practical checklist of what junior analyst roles tend to expect - and how to practise each skill.
Technical skills
| Skill | What it looks like in practice | How to practise |
|---|---|---|
| Excel | Lookups, SUMIFS, pivot tables, clean tables | Excel course |
| Data cleaning | Fix dates, duplicates, inconsistent categories | Power Query |
| Data modeling | Separate facts and dimensions; correct relationships | Data modeling |
| BI and DAX | Measures such as YTD revenue and percent of total | DAX course |
| Visualization | Choosing charts, designing readable pages | Dashboards |
| Statistics basics | Averages vs medians, spread, correlation | Excel data analysis |
Business and communication skills
- Question framing: turn “analyse sales” into three measurable questions.
- Skepticism: check totals against a known source before trusting a number.
- Storytelling: lead with the finding, then evidence.
- Domain knowledge: understand how the business earns and spends money.
Other tools you may see
Job listings frequently also mention SQL and Python. If your target roles require them, plan to learn them alongside the tools taught here; check the curriculum for what CharterPeak teaches.
Building evidence
Employers respond to proof: two or three projects with a clear problem, a clean dashboard and a short write-up. See project format and resume tips.
Related courses
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 →Power BI Course
Power Query, data modeling, DAX, visuals, dashboards and Power BI Service - from first import to a published report.
View course →Talk to a CharterPeak counsellor
Tell us your background and goal, and we will suggest the right starting point - Excel, Power BI or the full Excel + Power BI program.