top of page

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


Power BI General Options Explained: Parallel Loading, Memory Limits, and Refresh Settings That Actually Matter
Learn how Power BI's parallel loading, memory limits, and General Options affect your dataset refresh speed. Compare Pro vs Premium settings with practical tips.

MirVel
1 day ago7 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


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 som

MirVel
Dec 21, 20253 min read


External Tools in Power BI: A Deep Dive into the Essential Add‑Ons and Their Trade‑offs
Microsoft Power BI Desktop contains a rich set of modelling and reporting features, yet many power users enhance their workflow with external tools . These tools attach to the Analysis Services instance behind a PBIX/Power BI semantic model and allow advanced editing, scripting, performance analysis and automation. The External Tools ribbon lists all registered tools, and Microsoft warns that these are produced by independent developers; editing metadata outside Power BI De

MirVel
Oct 5, 202510 min read


From Data to Presentation: How to Combine Power BI and PowerPoint for Impactful Insights
Imagine spending hours perfecting your Power BI reports, only to struggle when trying to present them clearly to your stakeholders or audience. Power BI is excellent for interactive dashboards, but sometimes, a good old PowerPoint presentation is what you really need. The good news? Combining these two powerful tools can take your data storytelling to the next level. In this post, you'll discover simple yet powerful ways to seamlessly integrate Power BI reports into your Powe

MirVel
Jul 11, 20253 min read


How to Convert Units in Excel
Excel’s CONVERT function makes it easy to switch between different units of measurement. This handy tool is ideal for school assignments,...

MirVel
Jun 14, 20253 min read


Power Automate for Real-Life Scenarios: From Personal Productivity to Business Workflows
Imagine if many of your daily repetitive tasks could happen automatically while you focus on more important work. Microsoft Power Automate (formerly known as Microsoft Flow) is a cloud-based service that makes this possible. Without writing code, it lets you create automated workflows (called “flows”) between your apps and services. You can tell Power Automate: “When X happens, do Y.” This post will introduce Power Automate in plain English and then walk through real-life ex

MirVel
May 7, 202517 min read
bottom of page
