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.

Power QueryStar schemaDAXPower BI

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.

Power QueryFrom FolderExcelRefresh

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.

Power QueryData ModelDAXSlicers

View project →

Note: these examples use sample data; no real client information is shown.