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


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


Excel Template: Financial & Business Analytics tool
Managing business performance doesn’t always require complex BI tools. With the right Excel setup, you can track sales, purchases, costs, and margins in a clean, interactive way. This Financial & Business Analytics template is designed for small to medium businesses who want a ready-to-use reporting system. In this post, I’ll walk you through the workbook page by page, explain how calculations work, and show how to interpret the dashboards. At the end, you’ll find a practical

MirVel
Sep 11, 20253 min read


Excel Template: CRM Dashboard for Small Businesses
This tool is designed to help you manage customers, employees, services, and sales, all in one place, with automated dashboards and KPIs. Below is the data flow of the dashboard and a short explanation of the pages. (link for download is below) Data flow diagram illustrating an Excel CRM template, showcasing interactions between the Customer Database, Employee Database, KPI Plan, and Order Form, all converging into the All Orders module, which then feeds into Processing/Setti

MirVel
Sep 7, 20253 min read
bottom of page
