top of page

KNOWLEDGE HUB
Practical explanations for better data work
Articles on Excel, Power BI, Power Query, dashboards, and automation—kept focused enough to use in your next project.


ETC Toll-Card Executive Dashboard in Excel
Turn raw ETC toll-card logs into a dark executive dashboard and a synchronized A4 report with Power Query, PivotTables, native slicers and PDF export.

MirVel
Sep 233 min read


Power BI ModelSweep: Clean Up Your Power BI Model Without the Toolchain
Power BI ModelSweep is an editable PBIP-based toolkit for model health, field usage, dependencies, best-practice checks and reviewable cleanup outputs.

MirVel
Sep 178 min read


Editable Sales Performance Dashboard in PowerPoint (€)
Explore a three-slide sales dashboard with euro labels, native charts and Morph transitions. Learn what updates through chart data and what needs manual editing.

MirVel
Sep 132 min read


Refresh All Power BI Dataflows with One Power Automate Button
Learn how to build a manually triggered Power Automate cloud flow that discovers active Power BI workspaces, submits a refresh for every Dataflow Gen1, supports pagination, and records failures without stopping the complete run.

MirVel
Aug 309 min read


Welcome to Excelized
Excelized helps turn messy data into clear dashboards and better decisions with Excel, Power BI, Power Query, Power Automate, practical training, templates, and free tools.

MirVel
Aug 291 min read


Humble tools - big impact
Over the years, I've used my fair share of these little online tools — converting currencies, turning files or images from one format into another. And always with the same hope: free, no spam, no ads, no subscription wall. Do you know the feeling? I bet you do. We've all been there at least once. So I decided to build my own. With my teammate Claude, I generated a set of HTML apps that work flawlessly and do exactly what they promise — for free, with no spam and no subscript

MirVel
Aug 213 min read
bottom of page
