Microsoft Power BI Advanced DAX & Data Modelling4 Sections28 Lessons10 Weeks
Curriculum
- 4 Sections
- 28 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Day 1: Microsoft Power BI Advanced DAX & Data Modelling fundamentals7 Items
- 1.11. Microsoft Power BI Advanced DAX & Data Modelling: purpose, scope and workplace relevance.
- 1.22. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 1.33. Review suitable example documents, data or stakeholder inputs for microsoft power bi advanced dax & data modelling: purpose, scope and workplace relevance.
- 1.44. Compare available methods, options and constraints relevant to microsoft power bi advanced dax & data modelling: purpose, scope and workplace relevance.
- 1.55. Develop a documented case finding using appropriate quality checks.
- 1.66. Discuss lessons, remaining questions and practical next steps.
- 1.7Practical workshop: Identify a realistic microsoft power bi advanced dax & data modelling requirement, role and source of evidence.
- Day 2: Star schema, relationships and filter context7 Items
- 2.11. Star schema, relationships and filter context.
- 2.22. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 2.33. Review relevant evidence, trade-offs and limitations associated with star schema, relationships and filter context.
- 2.44. DAX measures, evaluation context and calculation patterns.
- 2.55. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 2.66. Review relevant evidence, trade-offs and limitations associated with dax measures, evaluation context and calculation patterns.
- 2.7Practical workshop: Complete linked exercises: analyse a supplied scenario and document assumptions, limits and critical details; compare methods or evidence with an approved guidance example or safe case.
- Day 3: Performance optimisation and validatio7 Items
- 3.11. Performance optimisation and validation.
- 3.22. Work through a supplied scenario that requires decisions about performance optimisation and validation.
- 3.33. Review relevant evidence, trade-offs and limitations associated with performance optimisation and validation.
- 3.44. Report model review and technical documentation.
- 3.55. Examine the quality and completeness of evidence or records used for report model review and technical documentation.
- 3.66. Review relevant evidence, trade-offs and limitations associated with report model review and technical documentation.
- 3.7Practical workshop: Complete linked exercises: interpret results, note uncertainties and explain defensible decisions; develop a concise improvement, study or quality assurance recommendation.
- Day 4: Microsoft Power BI Advanced DAX & Data Modelling integrate7 Items
- 4.11. Microsoft Power BI Advanced DAX & Data Modelling: case assessment, review and next steps.
- 4.22. Integrate course evidence, review a realistic microsoft power bi advanced dax & data modelling: case assessment, review and next steps and explain the recommendations.
- 4.33. Review suitable example documents, data or stakeholder inputs for microsoft power bi advanced dax & data modelling: case assessment, review and next steps.
- 4.44. Compare available methods, options and constraints relevant to microsoft power bi advanced dax & data modelling: case assessment, review and next steps.
- 4.55. Develop a documented case finding using appropriate quality checks.
- 4.66. Discuss lessons, remaining questions and practical next steps.
- 4.7Practical workshop: Present a case response and convert feedback into an action plan.
Practical workshop: Complete linked exercises: interpret results, note uncertainties and explain defensible decisions; develop a concise improvement, study or quality assurance recommendation.
Prev 2. Integrate course evidence, review a realistic microsoft power bi advanced dax & data modelling: case assessment, review and next steps and explain the recommendations.
Next 
