PwC Switzerland Virtual Case Experience
An Excel and Power BI modeling portfolio based on the PwC Switzerland virtual case experience hosted on Forage.
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.
Enlarge preview 
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.
The source
keeps moving.
Source updated
PwC Switzerland Virtual Case Experience: Enterprise Business Intelligence, Ralph Kimball Galaxy Semantic Model (VertiPaq Engine), DAX KPI Engineering & Executive Excel Application Architecture
Current README excerpt
Engineered by Sohila Khaled Abbas Senior Analytics Engineer & BI Solutions Architect | Top 200 Arabic-Speaking Data Influencer
A source excerpt, not an independently verified outcome.