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.


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


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


Power BI Drillthrough: Hidden Tips, Best Practices & Real-World Use Cases
Drillthrough is one of the most underrated Power BI features. This guide covers smart page design, DAX context tricks, tooltip integration, and real-world patterns that even experienced users often miss.

MirVel
Jan 103 min read


Mastering DAX Queries in Power BI: Structure, Logic & Best Practices
Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Introduction Ever wondered what happens behind the scenes when you drag a visual into Power BI? That’s DAX queries at work. While most users write DAX formulas to calculate measures or columns, DAX queries go one level deeper — they let you directly query your model, test logic, and debug calculations.In this post, we’ll break down what DAX queries are, how they work, their structure, examples, pit

MirVel
Nov 18, 20255 min read


Power BI: Relationships in Models – The Ultimate Guide
Introduction Building effective Power BI reports is not just about loading data and creating visuals—it’s about structuring your data model correctly. Relationships are at the heart of that structure. In this post, we’ll explore what relationships in Power BI are, why they matter, how to create and manage them, and some advanced tricks to avoid common pitfalls. Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Understanding Relationships in Power

MirVel
Sep 28, 20253 min read


Mastering Power BI: How to Navigate Components Like a Pro
Power BI is transforming the way we work with data. Whether you're a data analyst, a business intelligence pro, or just someone who loves data, getting the hang of Power BI is key for awesome data visualization and analysis. This guide will help you explore the different parts of Power BI like a total pro. Power BI dev - daily job Understanding the Power BI Interface Familiarize yourself with the user interface to harness Power BI's full potential effectively. Power BI is a p

MirVel
Mar 2, 202512 min read
bottom of page
