The Power BI Playbook
Practical Power BI guides from real work for teams in the Gulf: Gulf calendars and Ramadan, Copilot-ready models, report design, DAX and licensing.
Latest from the Playbook
Newest first. Pick a topic or search.
A Gulf Calendar in Power BI: Hijri Dates, Ramadan, Eid and the Right Weekend
Ramadan and Eid move, and the UAE changed its weekend in 2022. One DAX calendar with Hijri dates, announced Ramadan and Eid days, each country's weekend, and an Eid window measure.
Read PlaybookIs Your Power BI Model Ready for AI? A 7-Point Check
Copilot, data agents and the new Power BI apps all answer from your semantic model. The 7 things to fix first, from names and descriptions to Prep data for AI.
Read PlaybookOne Design Doesn’t Fit All: 7 Power BI Report Styles
Executive, sales, finance, marketing, operations, HR and customer service reports each answer a different question. The 7 styles with example pages, and a 3-question quiz to pick yours.
Read PlaybookSame Visuals, New Design: How We Redesigned a Power BI Report in 5 Minutes
A leads report with the right visuals but loud colours and a messy layout. The five design changes that fixed it, and how to make them in 5 minutes with a free tool.
Read PlaybookWe Ran a Health Check on a Microsoft Power BI Sample. It Scored 84.
Microsoft's public COVID-19 sample, checked in under a second: a quarter of its columns unused, two bookmarks pointing at a deleted column and auto date/time left on. What we found and how to check yours.
Read PlaybookRamadan Sales in Power BI: Compare This Ramadan With Last Ramadan
SAMEPERIODLASTYEAR compares March with March, but Ramadan moved 11 days. The Hijri calendar and the one DAX measure that line up every Ramadan day by day.
Read PlaybookPower BI Pro, Premium Per User or Fabric: Which License Do You Actually Need?
One number decides your Power BI license: how many people only view reports. Current prices, the F64 break-even point and a worked example.
Read PlaybookResolve Once, Hydrate Many: A DAX Pattern for Lead Attribution
Why matching the same lead five times produces disagreeing KPIs, and the single-resolution DAX pattern that matched every lead exactly before replacing scattered join logic.
Read PlaybookBeyond "Traffic Lights": How Earned Value Management (EVM) Predicts Project Risk
Most project dashboards tell you what happened yesterday. Learn how to use CPI and SPI to mathematically forecast tomorrow's delays and budget overruns.
Read PlaybookThe Ultimate Shopify Dashboard: How to Build a Single Source of Truth in Power BI
A playbook for e-commerce leaders on building a single source of truth from Shopify data in Power BI to track sales, marketing ROI, and customer behavior.
Read Playbook5 Marketing KPIs Your E-commerce Store is Ignoring
Our new playbook dives into the advanced marketing analytics, including Customer Acquisition Cost (CAC) and Marketing Efficiency Ratio (MER), that drive profitable growth.
Read PlaybookETL vs Power Query: The Right Data Strategy for Your E-commerce Store
A practical framework for deciding when to use engineered pipelines for your Shopify/backend data vs. keeping logic in Power Query for marketing analytics.
Read PlaybookThe One Metric That Defines Your E-commerce Future (And How to Track It)
Why Customer Lifetime Value (not just revenue) is the north-star KPI for e-commerce growth, and a concrete path to model it in Power BI.
Read PlaybookGet the Next Power BI Guide
NO SPAMNew guides as they come out: Power BI for teams in the Gulf, from real work. No fluff, just what works.