Microsoft Excel Power Query & Power Pivot3 Sections21 Lessons10 Weeks
Curriculum
- 3 Sections
- 21 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Day 1: Microsoft Excel Power Query & Power Pivot fundamentals7 Items
- 1.11. Microsoft Excel Power Query & Power Pivot: purpose, scope and workplace relevance.
- 1.22. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 1.33. Review relevant evidence, trade-offs and limitations associated with microsoft excel power query & power pivot: purpose, scope and workplace relevance.
- 1.44. Import and transformation workflow.
- 1.55. Work through a supplied scenario that requires decisions about import and transformation workflow.
- 1.66. Review relevant evidence, trade-offs and limitations associated with import and transformation workflow.
- 1.7Practical workshop: Complete linked exercises: identify a realistic microsoft excel power query & power pivot requirement, role and source of evidence; analyse a supplied scenario and document assumptions, limits and critical details.
- Day 2: Data model and relationship desig and DAX measures and refresh practices7 Items
- 2.11. Data model and relationship design.
- 2.22. Work through a supplied scenario that requires decisions about data model and relationship design.
- 2.33. Review relevant evidence, trade-offs and limitations associated with data model and relationship design.
- 2.44. DAX measures and refresh practices.
- 2.55. Work through a supplied scenario that requires decisions about dax measures and refresh practices.
- 2.66. Review relevant evidence, trade-offs and limitations associated with dax measures and refresh practices.
- 2.7Practical workshop: Complete linked exercises: compare methods or evidence with an approved guidance example or safe case; interpret results, note uncertainties and explain defensible decisions.
- Day 3: Quality checks and repeatable reporting7 Items
- 3.11. Quality checks and repeatable reporting.
- 3.22. Examine the quality and completeness of evidence or records used for quality checks and repeatable reporting.
- 3.33. Review relevant evidence, trade-offs and limitations associated with quality checks and repeatable reporting.
- 3.44. Microsoft Excel Power Query & Power Pivot: case assessment, review and next steps.
- 3.55. Integrate course evidence, review a realistic microsoft excel power query & power pivot: case assessment, review and next steps and explain the recommendations.
- 3.66. Review relevant evidence, trade-offs and limitations associated with microsoft excel power query & power pivot: case assessment, review and next steps.
- 3.7Practical workshop: Complete linked exercises: develop a concise improvement, study or quality assurance recommendation; present a case response and convert feedback into an action plan.

