Small front-end demos (mock data) to illustrate a few use cases.
What you can do with SQL: relational model, monthly KPIs, optimized queries (sargable), quality checks and execution log.
Case study: staging → clean → mart pipeline with audit area.
Focus: modeling, performance, traceability.
Report combining Power Query preparation and DAX model. Three parts: P1 Evolution, P2 Distribution, P3 Scenarios & Indicators.
Case study: census & economic indicators for Île-de-France (2011–2022). Focus: time-series, map, KPIs; zoomable screenshots.
Mock ETL (Extract → Transform → Load), normalized table, KPIs and charts. CSV export.
Case study: scattered monthly reporting → normalization + CHF KPIs. Expected result: ~50% less prep time, consistent figures.
Key fields + line items → structured JSON → CSV export.
Case study: manual invoice entry (CH/EU/US) → structured extraction. Expected result: fewer errors, faster ERP integration.
Summarize + classify + route to CRM/support (mock front-end).
Case study: overloaded shared inbox → summary, classification, routing. Expected result: faster triage and response times.
Key fields and QR reference (mock); CSV export.
Case study: Swiss specifics (IBAN, QR reference) → read/validate. Expected result: better compliance and reconciliation.
Simplified search over a JSON corpus (front-end only).
Case study: scattered internal docs → FR/EN search + tags + highlight. Expected result: faster, sourced answers.
