Data analysis · Beginner to intermediate · 24 live learning hours

Certificate of completion

Learners who meet the course participation and practical assessment requirements receive a Solid Elf certificate of completion.

What you will learn

  • Clean and reshape data with Power Query
  • Build relationships and basic DAX measures
  • Design accessible dashboards for specific decisions
  • Review sharing, access and refresh assumptions

Course outline

  1. Week 1: Data quality, Power Query and transformation logs
  2. Week 2: Data models, relationships and DAX foundations
  3. Week 3: Dashboard design, filters and interpretation
  4. Week 4: Access, refresh, validation and presentation
  5. Week 5: Report usability, access controls and refresh planning
  6. Week 6: Dashboard validation, presentation and project feedback

Practical project

A Power BI report with a cleaned dataset, documented model, DAX measures and a sharing checklist.

Before you start

Comfort with spreadsheets and a compatible computer running Power BI Desktop. Any paid Power BI service licences are separate.

Learning format

Fully online and live. 6 weeks · 12 sessions · 2 hours per session, twice each week. Cohort dates and the two weekly meeting days are agreed during enrolment. Allow an additional 1–2 hours of independent practice each week.

Exercises should use synthetic, de-identified or otherwise authorised material. Do not bring confidential client records or live credentials into a training session.

What the fee includes

Live tuition, guided exercises, reusable templates and feedback on your practical assignment. Software licences and internet access are not included. The published fee is per learner; any applicable tax and payment instructions are stated in writing before you pay. Certificate of completion is provided to learners who meet the course participation and assessment requirements.

Software and reference material

Explore official reference material ↗. Training is independently offered by Solid Elf; no software-vendor accreditation or certification is claimed unless explicitly stated.

Continue learning

Explore the related consultancy service, browse practical articles, or view our free workshops.