Course 55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map, and Power BI — Lesson 1: Power Query Import, Cleanup, and Transformation

Learning Objectives

• Explain the role of data-source connections in the course scenario.
• Apply cleaning, shaping, and combining data through a guided implementation or analysis.
• Validate data types and transformation steps using documented evidence and acceptance criteria.
• Troubleshoot risks, quality issues, and operational gaps related to quality checks and refresh-ready queries.

Detailed Topics

• Data-Source Connections: Apply the concept to requirements, configuration, analysis, controls, and expected outcomes.
• Cleaning, Shaping, And Combining Data: Apply the concept to requirements, configuration, analysis, controls, and expected outcomes.
• Data Types And Transformation Steps: Apply the concept to requirements, configuration, analysis, controls, and expected outcomes.
• Quality Checks And Refresh-Ready Queries: Apply the concept to requirements, configuration, analysis, controls, and expected outcomes.

Guided Demonstration

1. Review the scenario, users, data, dependencies, permissions, risks, and expected result.
2. Demonstrate the relevant configuration, analysis, design, administration, or development workflow step by step.
3. Capture settings, outputs, logs, screenshots, calculations, tests, and other useful evidence.
4. Compare the observed result with acceptance criteria and explain corrective actions.

Hands-on Exercise

1. Translate the scenario into a short implementation or analysis plan.
2. Complete the workflow using the supplied checklist and secure working practices.
3. Test normal, edge, and failure conditions and record the results.
4. Document one improvement that increases quality, security, reliability, usability, or business value.

Validation Checklist

• Requirements, assumptions, owners, and success criteria are documented.
• Configuration or analysis results are supported by reproducible evidence.
• Security, privacy, accessibility, quality, and governance controls are reviewed.
• Errors and unexpected results are investigated before approval.
• The final outcome and next action are communicated clearly.

Troubleshooting and Improvement

Use logs, formulas, queries, settings, permissions, test outputs, and stakeholder feedback to isolate the cause of a problem. Correct the smallest verified cause first, retest the complete workflow, document the evidence, and add the learning to the final improvement plan.