Excel
When to Move from Excel to Power BI (A Practical Decision Guide)
Still using Excel for complex reporting? Here’s how to know when it’s time to move from Excel to Power BI, with real use cases and trade-offs.
Anas
LLM
How to Get Better Microsoft 365 Copilot Output with Smarter Prompts and Improved Contexts
Boost your Microsoft 365 Copilot results with precise prompts and full context. Learn tips for better AI outputs and maximize GPT-5 efficiency.
Stories
Best Tools for Data Analysts in the Corporate World (2025 Guide)
The best tools for data analysts in 2025. A practical guide to the essential corporate analytics stack: Excel, SQL, Power BI, and AI assistants.
Excel
How to Build an Internal Data Repository Using Microsoft Forms (and Connect It to External Databases)
Create your own internal data repository with Microsoft Forms and connect it to external databases like Power BI or SQL, no coding required.
Power BI
How to Practice SQL Data Extraction Yourself (Free Guide with Neon.tech + Power Query)
Learn how to practice SQL data extraction for free using Neon.tech PostgreSQL and Power Query. Step-by-step guide to set up your own SQL database and connect it to Power BI or Excel.
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.
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.