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.


Build a Dynamic FIFA World Cup 2026 Dashboard in Excel
Spain, 308 goals and 6.8 million fans. Turn the 2026 World Cup into a dark, pitch-green Excel dashboard using XLOOKUP, FILTER, LET, GROUPBY, LAMBDA and the spill operator. Full workbook included.

MirVel
Aug 1610 min read


The Excelized Converter: Read, Clean, Export — Without Uploading a Thing
Most file converters ask you to hand your data to a stranger's server. For anyone working with client figures, personnel lists, or anything covered by a confidentiality clause, that is a non-starter. So I built one that doesn't. The Excelized Converter is a single HTML file that runs entirely in your browser. You open it, drop in a file, and it reads, cleans, and exports — with no upload, no account, and no backend. The file you drop in never leaves your device. You can also

MirVel
Aug 23 min read


How Does a Money Converter Work and Are the Rates Live (HTML version provided)
A money converter looks simple: enter 100, choose euros to pounds, and get an answer. Behind that small result is a short chain of checks, a daily exchange rate source, and one basic calculation. The key point is this: most free web converters do not show live trading prices that move every second. They usually show daily reference rates, which are accurate for many everyday uses but not the same as a bank’s live dealing price. A converter starts with an amount, a currency pa

MirVel
Jul 245 min read


Power BI DirectQuery: Usage, Performance and Best Practices
Learn when to use Power BI DirectQuery, how to improve report performance, and which modeling, DAX, source-design, and visual mistakes to avoid.

MirVel
Jul 97 min read


Build a Live European Weather Forecast in Excel (+ Power BI) with Open-Meteo (part 2)
Connect Excel to the Open-Meteo API and build a refreshable seven-day European weather forecast with reusable Power Query M code, governance controls, KPI cards, and charts.

MirVel
Jul 72 min read


Build a Live European Weather Forecast in Excel with Open-Meteo (part 1)
Connect Excel to the Open-Meteo API and build a refreshable seven-day European weather forecast with reusable Power Query M code, governance controls, KPI cards, and charts.

MirVel
Jun 234 min read
bottom of page
