PwC Virtual Case — Architecture & Analytics
Original GitHub README diagrams covering the galaxy semantic model, Power Query ETL, executive KPIs, and workforce progression in the Forage virtual case.
A question. A process.
Work you can explore.
Follow the decisions behind the implementation, then inspect the original work.
Chapter 1 of 4 · The question
The question behind the build.
Call-center operations, customer retention, and workforce questions require different fact grains and clearly defined KPIs. Combining the domains needs shared dimensions without losing those differences.
Follow the implementation.
- 01
Organize telephony, retention, and workforce data into a galaxy semantic model.
- 02
Use Power Query for transformation and Power Pivot / VertiPaq for analytical modeling.
- 03
Define DAX measures and build domain-specific reporting views.
- 04
Develop workbook navigation and VBA controls around the reporting experience.
See the work. Inspect the details.
Explore the semantic-model documentation, KPI catalog, Power Query transformations, and VBA modules. The project shows how spreadsheet delivery can be structured and versioned.
Galaxy schema architecture · Original SVG from the project README. Select to enlarge.
Galaxy schema architecture · GitHub · Power Query ETL pipeline · GitHub · Executive KPI decomposition · GitHub · Workforce progression analysis · GitHub
Choose where to look deeper.
Search the linked source inventory or narrow it to the kind of artifact you want to inspect. Files open at their original source.