PowerBI.tips

Posts – Page 13

Page 13 of 23

Measuring Organizational BI Skills – Ep. 255

Oct 4, 2023

Measuring Organizational BI Skills – Ep. 255

Ep. 255 outlines a practical Power BI skills matrix you can use to measure team capability, spot gaps and single points of failure, and turn vague 'we need a Power BI person' conversations into a clear hiring and training plan.

SQL in Fabric – Ep. 254

Sep 29, 2023

SQL in Fabric – Ep. 254

Ep. 254 explores what ‘SQL in Fabric’ really means—from querying Delta tables in OneLake to the practical gotchas of building lakehouse-style pipelines. You’ll hear why the storage/compute split matters, what it changes compared to Synapse-era patterns, and where Excel-first teams still hit friction.

Will Fabric Overwhelm the Business – Ep. 253

Sep 27, 2023

Will Fabric Overwhelm the Business – Ep. 253

Ep. 253 answers a mailbag question every org is about to face: will Microsoft Fabric’s bigger toolbox overwhelm business users—or can you introduce it without killing self-service momentum? Mike, Tommy, and Seth share practical rollout language, guardrails, and adoption patterns that keep Power BI approachable.

Types of Data Roles – Ep. 252

Sep 22, 2023

Types of Data Roles – Ep. 252

Ep. 252 clarifies the analytics job-title soup—data engineer, analyst, BI developer, analytics engineer, and data scientist—by mapping each role to the real deliverables your Power BI workflow needs. The crew shares how to set ownership boundaries so modeling, security, and reporting don’t fall into the cracks.

Where should we Use AI With BI? – Ep. 251

Sep 20, 2023

Where should we Use AI With BI? – Ep. 251

Ep. 251 focuses on where AI genuinely helps (and where it doesn’t) in a BI workflow—turning vague questions into clear requirements, accelerating DAX and documentation, and improving communication—while staying realistic about security, governance, and hallucinations.

Load all the data in OneLake – Ep. 250

Sep 15, 2023

Load all the data in OneLake – Ep. 250

Ep. 250 tackles the practical question every Fabric team hits fast: what belongs in OneLake, and how do you decide the right boundaries for lakehouses, workspaces, and semantic models. Mike, Tommy, and Seth break down the OneLake vs. lakehouse naming confusion, then land on governance-first patterns that keep shared dimensions, security, and reuse from turning into a data swamp.

Jevons Paradox & Demand for Insight – Ep. 249

Sep 13, 2023

Jevons Paradox & Demand for Insight – Ep. 249

Ep. 249 uses Jevons Paradox to explain a familiar analytics reality: when BI gets easier, demand for “just one more metric” accelerates. Mike, Tommy, and Seth unpack what that means for self-service, governance, and strategy—so your organization gets more clarity, not just more dashboards.

Workspace Design in Fabric – Ep. 248

Sep 8, 2023

Workspace Design in Fabric – Ep. 248

This episode breaks down practical Microsoft Fabric workspace design: how to separate environments, clarify ownership, and keep permissions sane as you scale. If your tenant is starting to feel messy, you’ll walk away with a repeatable pattern you can apply to new teams and new data products.

Working in Data is Hard – Ep. 247

Sep 6, 2023

Working in Data is Hard – Ep. 247

Working in data is hard for reasons most org charts ignore: shifting requirements, fuzzy definitions, and the constant translation between business goals and measurable outcomes. In Ep. 247, Mike, Tommy, and Seth break down where the friction comes from—and the small process changes that make delivery calmer and faster.

Knowledge, Understanding & Wisdom – Ep. 246

Sep 1, 2023

Knowledge, Understanding & Wisdom – Ep. 246

Ep. 246 is a practical guide to spotting the difference between Power BI trivia and real capability: knowledge, understanding, and wisdom—and how to hire for (and build) the kind of judgment that survives messy, real-world projects.

PBI Laptop to Cloud – Ep. 245

Aug 30, 2023

PBI Laptop to Cloud – Ep. 245

Moving a Power BI solution from your laptop to the cloud isn’t just ‘Publish’—it’s gateways, credentials, refresh, and ownership. In Ep. 245, Mike, Tommy, and Seth map the operational checklist that keeps a dataset reliable once it leaves Power BI Desktop.

Are we data driven? – Ep. 244

Aug 25, 2023

Are we data driven? – Ep. 244

Most orgs aren’t short on data—they’re short on agreement and follow-through. In Ep. 244, Mike, Tommy, and Seth break down what ‘data-driven’ really looks like: decisions tied to metrics, shared definitions, and a feedback loop that turns insight into action.

100 Dollars for Fabric – Ep. 243

Aug 23, 2023

100 Dollars for Fabric – Ep. 243

If you could spend $100 improving Microsoft Fabric, what would you buy? In Ep. 243, Mike, Tommy, and Seth build a no-nonsense wish list centered on cost clarity, stronger lineage, and admin tooling that scales beyond a single team.

Thinking Outside the Box – Ep. 242

Aug 18, 2023

Thinking Outside the Box – Ep. 242

In Ep. 242, Mike, Tommy, and Seth break down a sneaky performance lesson: you can cut render time dramatically without rewriting DAX by rethinking the visual and using constant lines from the Analytics pane.

Solving Data Problems – Ep. 241

Aug 16, 2023

Solving Data Problems – Ep. 241

Ep. 241 covers a practical Dataflows Gen2 approach to build history over time—and a bigger lesson: solving data problems means addressing technical, business, and adoption realities (not just shipping a clever automation).

The Art of the Possible – Ep. 240

Aug 11, 2023

The Art of the Possible – Ep. 240

Ep. 240 is a reminder that ‘the art of the possible’ isn’t just flashy dashboards—real Power BI/Fabric value comes from automation, clarity on the business outcome, and designing for adoption.

Contextualized Insights – Ep. 239

Aug 9, 2023

Contextualized Insights – Ep. 239

Ep. 239 breaks down six practical ways to add context to metrics—comparisons, history, scale, and confirmation—so your Power BI visuals actually drive decisions.

Let us Discuss Tooltips – Ep. 238

Aug 4, 2023

Let us Discuss Tooltips – Ep. 238

Episode 238 is a practical walkthrough of Power BI tooltips—why they matter, where they go wrong, and how to design them so users get answers without leaving the visual. Mike, Tommy, and Seth share patterns for tooltip pages, context-preserving visuals, and performance-friendly designs you can reuse across reports.

No more Chartjunk ! – Ep. 237

Aug 2, 2023

No more Chartjunk ! – Ep. 237

Episode 237 digs into chartjunk and visual clutter—how it erodes trust, hides the point of a chart, and slows down decision-making. You’ll get practical Power BI design tactics (tooltips, emphasis, and consistency) to add context without turning your report into noise.

SQL or OneLake – Ep. 236

Jul 28, 2023

SQL or OneLake – Ep. 236

Ep. 236 breaks down the Fabric ‘SQL vs OneLake’ decision: what’s just different interfaces over the same Delta storage, where governance and permissions still matter, and how to keep architectures understandable as the platform converges.

The Root of All Problems – Ep. 235

Jul 26, 2023

The Root of All Problems – Ep. 235

Ep. 235 is a practical episode for anyone stuck in ‘fix the dashboard’ mode: it shows how to trace undesirable effects back to real root causes using a systems mindset. You’ll also learn what Chris Webb’s Fabric tests reveal about Direct Lake ‘data hotness’, capacity limits, and why some queries can quietly fall back to DirectQuery.

The Perfect Data Analyst – Ep. 234

Jul 21, 2023

The Perfect Data Analyst – Ep. 234

Ep. 234 breaks down what makes a ‘perfect’ data analyst: not just technical ability, but the communication and business context needed to turn messy questions into decisions. The team also uses Fabric’s data-integration options (pipelines, Dataflow Gen2, notebooks) to talk through tradeoffs, missing ‘table stakes’ features, and what lock-in really means while the platform is still maturing.

Too Many Details? – Ep. 233

Jul 19, 2023

Too Many Details? – Ep. 233

In Ep. 233, the crew answers a mailbag question on how much detail belongs in a Power BI report—covering model grain, drillthrough patterns, and ways to keep users in flow without turning VertiPaq into a row-level warehouse.