Power BI to Excel: How to Use OLAP Connections for Always-Up-to-Date Reports
Learn how to connect Power BI to Excel using OLAP tables for always-up-to-date reports. Save time, avoid manual exports, and empower management with live data.
Anas
LLM
Getting Started with Vibecoding: How AI Helps You Code Smarter
Discover vibecoding with AI. Use Copilot or any third party LLMs to generate DAX or SQL code faster. Learn tips, pros, and best practices.
Excel
Query Folding in Power Query: Complete Guide for Faster Data Loading
Learn how Query Folding in Power Query speeds up data refresh by pushing steps back to SQL. Understand what folds, what breaks, and how to optimize.
Excel
Mastering Excel: From Beginner Spreadsheets to Advanced Data Analytics
Microsoft Excel is one of the MOST powerful tools in the corporate world. In this guide, we’ll break down the three levels of Excel mastery, from beginner to advanced, along with examples of projects you can try at each stage.
Stories
Where It All Began
To understand why I do the things I do, you need to know my full story. How did someone with a background in Finance ended up in Data Analytics instead. Here's my story.