Projects
Real-world examples of how repetitive reports and scattered data become clear, automated solutions with Excel, Power Query and Power BI.
Ergonomic desk sales analysis
Power BI · DAX
Ergonomic desk sales analysis
12 monthly Excel files → a Power BI star-schema model and two interactive pages. Clear on where the profit hides and where it’s lost.
View project →
Solar plant report automation
Power Query · Excel
Solar plant report automation
Monthly grid-operator CSV files are combined automatically into one refreshing Excel dashboard. A new report in about a minute.
View project →
Automated Etsy sales dashboard
Excel · Power Query
Automated Etsy sales dashboard
Etsy sales CSV → one «Refresh» → a live dashboard: KPIs, top products and markets.
View project →
Truck fleet profitability report
Power BI · Power Query
Truck fleet profitability report
Three disconnected systems → one Power BI model → 6 loss-making trucks out of 24 and four different reasons why.
View project →
Note: some examples use sample data; no real client information is shown.