Model data with Power BI

Course Description (Long)

This course introduces the foundational components of designing scalable tabular models using Power BI. It covers the various methods and best practices that align with business and technical requirements for modeling, visualising, and analysing data with Power BI.

Participants will learn about the Power BI Desktop model structure, star schema design basics, analytics queries, and report visual configuration. The course also delves into creating calculated tables and columns, writing DAX formulas, adding measures, and optimising model performance.

By the end of this learning path, learners will be equipped with the skills necessary to build efficient and effective data models in Power BI.

Course Format

Online learning, video tutorials, interactive modules, practical exercises

Course Length

6 hours 26 minutes

Course Accreditation

Check provider website for details on certification

Cost

Free (but there is a fee to take the certificated exam) 50% off for NHS staff

Access

General access

Skills Covered

- Power BI Desktop model structure
- Star schema design
- Analytic queries
- Report visual configuration
- DAX formulas
- Calculated tables and columns
- Measures
- Model performance optimisation

Mapped to NCF

• SA24.1 Intermediate: Skilled in using DAX (Data Analysis Expressions) to create calculated columns, measures, and advanced aggregations, effectively communicating insights to stakeholders, along with utilising external tools like DAX Studio and Tabular Editor to optimise data models and streamline workflows.

• SA24.2 Intermediate: Able to design and implement robust data models, understanding relationships, cardinality, and hierarchies within Power BI.