Case files · the work in full
SAP · Power BI · Python · BigQuery · multiple medical centres, ES
Brief
Leadership could not see productivity across two provinces. Reporting was manual and slow.
Approach
Consolidated SAP and Odoo operational data into SQL Server and Power BI, then built KPI views leadership actually used.
Stack
SAP · Odoo · SQL Server · Power BI · DAX
Result
Around 30% less reporting time and bottlenecks that had previously been invisible to management.
Brief
Analyse readmission patterns to spot risk and inform care planning.
Approach
Prepared and modelled healthcare data in BigQuery, analysed it in Python, and published an interactive Looker Studio layer.
Result
A reproducible pipeline and live report that can be reused for other clinical metrics.
Brief
A centre looked profitable, but the numbers did not add up under scrutiny.
Approach
Traced allocation logic in SAP, found a misassigned cost hiding real losses, and implemented the correction with leadership.
Stack
SAP ERP · Excel · reconciliation
Result
Hidden losses were corrected and future budgeting gained a more reliable cost view.
Power BI · Power Query · DAX · SQL · work across Colombia and Spain
Brief
A small business ran sales on one fragile manual spreadsheet.
Approach
Built a reusable star schema in Power Query with dimensions, transformations, DAX measures, and KPI views.
Result
Decision-ready sales views replaced the manual spreadsheet.
Brief
The client needed to understand who joined and what kept them engaged for the following year’s planning.
Approach
SQL analysis of registration data produced demographic segments and engagement trend reporting.
Stack
SQL · segmentation · reporting
Result
A repeatable evidence base for programme planning and future cohorts.
Brief
Make a messy physician directory usable for analysis.
Approach
Cleaned and explored profiles in pandas, then produced interpretable segments for operational analysis.
Result
Clear segments and a practical basis for targeting and operational decisions.
A useful case starts with a real constraint