Mohamed A. Adel.

Phase 2 Exam — Reporting & Analytics Intermediate

Topic 11 of 12 · In Reporting Analytics · September 12, 2026

⏱ 75 minAssessment

Cumulative exam for Phase 2: automated reporting with Power Query and Power BI, advanced Excel reporting skills, and report-oriented SQL from window functions to performance.

++++FREE LEARNING PATHREPORTING ANALYTICSREPORTING ANALYTICS · PHASE 2 · INTERMEDIATEPHASE 2 EXAM —REPORTING &Cumulative exam for Phase 2: automated reporting wi…· 2 / 3ASSESSMENT75 MINmotif / matrixSEGMENT × MONTH9121 · 21 · MODULE 2.4

Phase 2 Exam — Reporting & Analytics Intermediate

This exam closes Phase 2 of the Reporting & Analytics path — the automation and data-detailing toolkit: Automated Reporting, Advanced Excel for Reporting and SQL for Reporting.

Treat it like a real assessment: answer from memory, and read each explanation carefully. You need 70% or higher to pass the phase.

Phase 2 Exam — Reporting & Analytics Intermediate

Answer all questions. Exam conditions: no notes, no going back, one pressure per question.

0 / 8

Question 1 of 8

You rebuild the same Excel workbook from a weekly CSV by hand. Which automation belongs first?

Finished? Review any question you missed, then revisit the related lessons via the hub or roadmap before moving on.