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.


The Future of AI Dashboards: Claude, Codex and Gemini Canvas
AI is changing how dashboards are built. Explore Claude Dashboards, Codex and Gemini Canvas, the move toward data apps, and where established BI still fits.

MirVel
Oct 148 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


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


Native Query in Power BI: How to Write SQL Directly Against Your Data Source
Learn how to use native queries in Power BI to write SQL directly against your data source. Step-by-step guide with M code, tips, and a practice file included.

MirVel
May 137 min read


ChatGPT Prompts for Data Science & Analytics: A Beginner's Guide
Why Use ChatGPT in Data Science? If you're new to data science or analytics, ChatGPT can be a game-changer in your learning and workflow. This AI chatbot has become incredibly popular for its ability to answer questions, generate code, and provide explanations in plain language. In fact, ChatGPT is one of the trending technologies transforming how data professionals work – it's “revolutionizing the way data scientists interact with machine learning systems”. From brainstormin

MirVel
Jun 22, 20257 min read


Why Do Low-End Laptops Struggle with Large Excel & Power BI Data?
Ever tried opening a huge Excel file or running a complex Power BI report on a basic laptop, only to watch it crawl or freeze up? You’re not alone. Many of us have felt the frustration of our computer chugging like it’s stuck in molasses when handling big data. In this post, we’ll break down why this happens and what you can do about it. We’ll keep it casual and clear—no overly techy jargon—so you can understand the issues and find solutions without a headache. Let’s dive int

MirVel
May 27, 202520 min read


Top Tools for All Data Analysts (and Those Who Will Be)
Data analytics is booming, and with it comes the need for the right tools to get the job done and make the process enjoyable and...

MirVel
Mar 26, 20254 min read


SQL: The Beginner's Guide to Mastering Databases
Welcome to the world of SQL – the language that powers the databases behind virtually every application and website you use daily....

MirVel
Mar 26, 20254 min read


The Unknown Impact: The Future of AI in Data Science - A Professional Analysis
Artificial intelligence (AI) and data science are merging in ways that could reshape entire industries. As we move forward into an age characterized by advanced automation and unprecedented data analysis abilities, the combination of these two fields holds both promise and uncertainty. This article explores the current state and future of AI in data science, highlighting trends, advancements, and the significant implications they carry. The Evolution of AI in Data Science The

MirVel
Mar 2, 20253 min read
bottom of page
