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.


How to Build a Proper Date Table in Power BI
A practical step-by-step guide to building a clean Power BI date table, writing better time-intelligence measures, and avoiding the most common calendar mistakes.

MirVel
Apr 216 min read


How to Use AI in Excel: Copilot, ChatGPT, and Smart Automation for Faster Analysis
AI is now built into Excel — from Copilot to ChatGPT-powered formulas. This guide covers the five most practical AI tools you can use today, with real examples and step-by-step instructions.

MirVel
Apr 205 min read


How to Build a Simple Environmental Pollutants Dashboard in Excel
Learn how to build a clean Excel dashboard using filters, KPI cards, AVERAGEIFS formulas, and charts — with a downloadable sample workbook based on European environmental pollutant data.

MirVel
Apr 65 min read


Excel Currency Converter & FX Dashboard – How‑to (Free download)
A ready-to-use Excel currency converter with a 90-day FX history, dropdown filters, KPI cards, and two interactive charts. Free download included with step-by-step setup instructions.

MirVel
Mar 272 min read


OpenAI Codex vs Gemini Canvas vs Claude Artifacts: Which AI Workspace Wins in 2026?
A side-by-side comparison of OpenAI Codex, Google Gemini Canvas, and Claude Artifacts — covering coding, content creation, data analysis, and real-time collaboration across all three AI workspaces.

MirVel
Mar 208 min read


Power BI Custom Connectors: Unlock Analytics for Every Corner of Your Organisation
Go beyond sales reports — connect Power BI to your IT, HR, finance, and admin systems using custom connectors. A practical guide to unlocking organisation-wide analytics.

MirVel
Mar 197 min read
bottom of page
