top of page

KNOWLEDGE HUB
All The Tips In One Place. Stay up-to-date!


SVG in Power BI Visuals: How to Build Them (and Maintain Them Without Pain)
Add micro visuals like KPI bars, icons, and sparklines directly inside Power BI tables and matrices using SVG measures — no custom visuals needed. Includes production-ready DAX patterns.

MirVel
Feb 203 min read


Hidden PivotTable Tips & Tricks You’ll Actually Use (Excel)
Most people use PivotTables but few use them well. These high-impact tricks cover custom sorting, calculated fields, grouping, and more — with a free European snacks dataset to practice on.

MirVel
Feb 123 min read


The Hangman Game in Excel: Build It + Play It
A formula-only Hangman game in Excel — no VBA needed. Uses data validation dropdowns, conditional formatting, and live letter-by-letter updates. Free download with a step-by-step build guide.

MirVel
Jan 253 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


Excel Xmas Tree Decorator (No VBA) — A Tiny Game You Can Share With Colleagues
Want something festive, quick, and surprisingly useful to show what Excel can do beyond tables? This little Xmas Tree Decorator is a macro-free Excel mini-game built only with native features like dropdown lists, icons/emojis, conditional formatting, and formulas. It’s perfect as a fun office share, an Excel training warm-up, or a creative example for what’s possible with “just Excel”. 🎄🎄🎄 Would you like to download this Xmas fun tool for free? Click here. Check out some o

MirVel
Dec 21, 20253 min read


SharePoint for Excel & Power BI: Best Practices, Permissions, and Real-World Hacks
SharePoint can be either your best “single source of truth”… or the reason your refreshes fail on Monday morning. This guide shows how to structure SharePoint properly (sites, libraries, lists), set permissions that scale, and connect everything cleanly to Excel and Power BI—with practical “do this / don’t do that” patterns. Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 1) SharePoint basics that matter for BI people Sites, Libraries, Lists (t

MirVel
Dec 14, 20254 min read
bottom of page
