Egyptian Cosmetics Analytics
A local-market data platform with a version-controlled Power BI reporting project.
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.
An omnichannel retail scenario brings together orders, customer records, inventory, targets, and exchange-rate inputs. Mixed formats and inconsistent values need a clear treatment before they can support reporting.
Follow the implementation.
- 01
Ingest CSV, Excel, and JSON inputs with Python and preserve raw records with lineage.
- 02
Standardize fields, validate relationships, and route invalid records into explicit quarantine tables.
- 03
Model dimensions and facts in SQL Server, including customer history with SCD Type 2.
- 04
Provide SQL Server and Power Query delivery paths with a DAX semantic layer.
See the work. Inspect the details.
The useful part is the complete chain: a source record can be traced through cleaning, validation, modeling, and reporting. The repository documents the scenario, architecture, and data-quality decisions.
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.
8 linked source files
No linked files match this view.