Catalogue example · Programme preview
Data analysis with Excel and Power BI
Practise cleaning data, building dashboards and presenting findings. Complete a project using a sample sales dataset.
This is a sample course page for Kavinoq Training. Use it to explore the programme details your learners can review before joining.
What you’ll learn
Clean messy data
Import spreadsheet exports, combine tables and check for missing or inconsistent values.
Build dashboards
Model data in Power BI, create measures and present useful views of sales performance.
Present findings
Explain what the figures show, where the data is limited and which questions need more investigation.
Course outline
- Weeks 1–3Excel for analysis: tables, lookups and pivot tables
- Weeks 4–6Power Query: cleaning and combining data
- Weeks 7–10Power BI: models, measures and dashboards
- Weeks 11–12Capstone project using a sample sales dataset
Help learners prepare before they join.
A programme page can explain who the course is for, what learners need and how completion is assessed. This example is aimed at beginners who have used spreadsheets and want to develop their analysis skills.
Prerequisites
Basic spreadsheet skills and access to a computer that can run Excel and Power BI Desktop.
Assessment
Guided exercises and a final project reviewed against published criteria.
Completion requirements
Complete the required activities and meet the project criteria to earn a certificate.
Publish your programmes with Kavinoq.
Connect programme discovery with applications, funding and course delivery. Explore Training to see how cohorts, self-paced courses and client bookings fit together.