Explicit Measures Podcast
Episodes
120: On Building Expertise - Adapting & Growing Your Power BI Skills
23 Jun 2022
Contributed by Lukas
This comes in hot from another great article by Matthew Roche - link here: https://ssbipolar.com/2022/04/16/on-building-expertise/ We have seen just i...
119: Measuring Trust - Adoption of Data & Power BI
21 Jun 2022
Contributed by Lukas
What does it mean that your organization and people have "successfully" adopted and utilize Power BI? One of our favorite buzz words is "trust", yet d...
118: Power BI Implementation Usage Scenarios - Reviewing the Planning Documentation
16 Jun 2022
Contributed by Lukas
The guys are taking a look at the next edition in the Power BI Adoption planning, this time over 10 more amazing articles focused around the different...
117: Asking the Right Data Questions and Asking The Data Questions Right
14 Jun 2022
Contributed by Lukas
Based off this BRILLANT article by Enrico Bertini, we are focusing on the one skills you never thought you needed when you got into data: Being able t...
116: Is The Power BI Platform Better Than the Classic Microsoft BI Architecture Stack?
09 Jun 2022
Contributed by Lukas
Today we are looking back on how the BI Architecture has changed - the tools of old (SSIS, Analysis Services) vs the "business" tools (dataflows, data...
115: The Importance Of Push-Back on Power BI Reports
07 Jun 2022
Contributed by Lukas
Anyone who creates Power BI reports for a living knows the dance of the request and the value. Does every request deserve time and effort? Thus ...
114: Do We Need More Forecasting In Our Power BI Reports?
02 Jun 2022
Contributed by Lukas
The guys give their first true impressions of Data Marts in Power BI, should we be using it, and what is needed first off. Forecasting - Not what is p...
113: All About Microsoft Build 2022
31 May 2022
Contributed by Lukas
The guys cannot wait to get into Microsoft Build 2022, covering all the announcements for the Power BI Developer. 1. PowerPoint for Power BI 2. ...
112: Leveraging Text in Power BI
26 May 2022
Contributed by Lukas
We all know the importance of labels and data on a Power BI Report. But what about the actual text? From Title's to help boxes, how much is too much, ...
111: Dealing With Spokes - Centralized Power BI and Departmental BI
24 May 2022
Contributed by Lukas
Today's #PowerBI podcast may be a situation you are in as a #PowerBI author: Centralized BI, with many "spokes" (different teams of BI)? Or you ...
110: Calculation Groups in Power BI
19 May 2022
Contributed by Lukas
The guys start off about the biggest shipment coming to Power BI in the last 3 years (what that is is being announced at Build 2022) and what they thi...
109: Peripheral Skills for a Power BI Professional
17 May 2022
Contributed by Lukas
This is all about the outside of Power BI - what soft skills can set you above and beyond in the BI space? The guys also celebrate their year annivers...
108: Adding Max(Value( )) - Brining, Developing, & Selling Solutions In-House
12 May 2022
Contributed by Lukas
You have an amazing solution that will change the business using #PowerBI & the #PowerPlatform - but how do you sell it? The guys discuss just tha...
107: How to Retire a Power BI Report
10 May 2022
Contributed by Lukas
We all love creating reports and trying new features out. However, there is another side to coin: What about removing a live report from the service a...
106: Teamwork & Aligning Goals for a Power BI Organization
05 May 2022
Contributed by Lukas
The guys focus on what it means to be in a BI Team. People has been a much discussed topic lately, but this time we are talking about our people! How ...
105: Analyze in Excel for Power BI
03 May 2022
Contributed by Lukas
The guys run through the use cases and where does Analyze in Excel fit in the Power BI Story. What are the best use cases and where have they seen suc...
103: Improving The Report Request Process
28 Apr 2022
Contributed by Lukas
This is from a hot take online: https://twitter.com/WeHateData/status/1509538551993716736 Lukewarm take: nearly all request-based analytics workflows ...
104: Dealing with Data Silos In Power BI
26 Apr 2022
Contributed by Lukas
(Note that we messed up on the live stream, so episode 103 is coming out on Thursday, you did not miss it!) We all love Power BI for the solution it p...
102: Best Practice Analyzer for Visuals & Report Design Wishlist
21 Apr 2022
Contributed by Lukas
The guys are diving into a mailbag! What if we had a Best Practice Analyzer (like in Tabular Editor ApS ) for visuals and the #PowerBI report? What w...
101: Where Do you Put Your Power BI Measures
19 Apr 2022
Contributed by Lukas
We are kicking off the other side of 100 with a topic you may think is simple but gets complicated. Where exactly do you create and organize your meas...
100: A Few Of Our Favorite Things / THANK YOU!
14 Apr 2022
Contributed by Lukas
We finally made it to 100! Time to update your Power BI filters that only searched for values with 2 characters! The guys go through the a brief...
84: The Lost Episode (84): When It Fails
13 Apr 2022
Contributed by Lukas
We have found the hidden episode! The guys got thinking after 84 was unable to be recorded: what happens when we do our demos, our systems, and our re...
99: Overcoming DAX Evaluation Context in Power BI
12 Apr 2022
Contributed by Lukas
The guys are at the penultimate of episode 100! DAX Evaluation Context is one of the hardest concepts to master and learn in Power BI, yet it is...
98: Exploring Write Back in Power BI
07 Apr 2022
Contributed by Lukas
The guys are uncovering what Write Back means for Authors in Power BI: What are the use cases, where does it fit, and where do we go from here? From P...
97: Report Features for Consumers - Just How Important?
05 Apr 2022
Contributed by Lukas
Personal Bookmarks, Personalize Visuals, and Comments - How important and what role do they play for #PowerBI Report consumers? The guys jump into the...
96: Diving Into The Trend in Analytical Data Modeling for Power BI
31 Mar 2022
Contributed by Lukas
We have an amazing article that the guys dived into by Iteration Insights (Thanks to Steve Richardson) - article here: https://iterationinsights...
95: Grouping In Power BI
29 Mar 2022
Contributed by Lukas
The guys are back from vacation! Jumping right into it, there are quite a few ways grouping works in Power BI, from visual grouping to field grouping,...
94: People, Process, & Technology - Integrating A Complete Power BI Solution
24 Mar 2022
Contributed by Lukas
It doesn't matter if you have the best design skillset in the world, or if you can develop DAX Measures people couldn't even dream about. It doesn't m...
93: Mailbag - Documentation Solutions in Power BI - How Much Or Too Little?
22 Mar 2022
Contributed by Lukas
Today is coming from a mailbag! The focus - How do people document their Power BI Solutions? What should included / not included, and when does the do...
92: Do We Like The New Power BI Formatter Pane?
17 Mar 2022
Contributed by Lukas
What a perfect day to release our episode! March 2022 Power BI is out, and the major release is the new formatting pane. What are our thoughts, what h...
91: Power BI Worlds - Consulting vs. In-House Work
15 Mar 2022
Contributed by Lukas
One Power BI, two different worlds? You love Power BI, but you may have a vastly different viewpoint and experience in the platform depending wh...
90: The Importance of Drill-Through in Power BI
10 Mar 2022
Contributed by Lukas
The guys dive into the use cases of Drill-Through in Power BI - from single zoom-in's all the way to using cross-report drill-through for Direct Query...
89: DAX Hacks for Power BI
08 Mar 2022
Contributed by Lukas
The guys share their deepest, darkest, maybe not best practices in Power BI's DAX language. From the value of Calculated Columns to Tabular Editor 3's...
88: If I Had $100... Power BI Visuals Edition
03 Mar 2022
Contributed by Lukas
if you had $100 to spend on improving the visuals and the experience building our visuals in #PowerBI Reports, where would your money go? The gu...
87: Getting Power BI Authors To Conform To Best Practices
01 Mar 2022
Contributed by Lukas
You have a great process developing and deploying Power BI Reports. I am sure you do. But what about your team? Do they follow the same rules, method...
86: What Do Incentives Mean in a Power BI Center of Excellence & Community of Practice
24 Feb 2022
Contributed by Lukas
The guys are back and dive into what it means and how important it is to reward, provide goals, and setting up a Center of Excellence that motiva...
85: What Does Ownership Mean?
17 Feb 2022
Contributed by Lukas
The guys are back (episode 84 is coming on Tuesday) with a talk on ownership - a conversation in need of discussion in the Power BI space. Who o...
83: Are We Building the Wrong Power BI Reports?
15 Feb 2022
Contributed by Lukas
By far one of the most engaged conversations the guys have had: We constantly evaluate if a report is "correct" or relevant for the users. When consum...
82: Export Everything - Managing Power BI Exported Data
10 Feb 2022
Contributed by Lukas
The guys run through all the ways data can be exported from Power BI, with a few hot takes in between on is it always a positive outcome from consumer...
81: Our Most Productive Methods Using Power BI
08 Feb 2022
Contributed by Lukas
The guys run through what it means to be productive in Power BI. Is it output, learning, or solutions? How to estimate your work, how to stay pr...
80: External Tools In Power BI - Their Role for the Pro
03 Feb 2022
Contributed by Lukas
If you consider yourself a master of the Power BI arts, there is a good chance you have used and know about External Tools in Power BI. If you have no...
79: The Most Important DAX Functions In Power BI
01 Feb 2022
Contributed by Lukas
The guys discuss a contested topic: What are the MOST IMPORTANT DAX functions in Power BI, and can they even rank them? What makes specific functions ...
78: Talking About Incremental Refresh
27 Jan 2022
Contributed by Lukas
The guys run through what Incremental Refresh is, why use it, and implications for how can impact your process. Mike gives a master class on advanced ...
77: Do We Have Too Much Interactivity In Our Power BI Reports? Simplifying Layouts & Interaction
25 Jan 2022
Contributed by Lukas
The guys talk through why our reports get complicated, and if we add more elements and objects than needed. What causes this, and how much has to do w...
76: Getting Your Feet Wet Doing Your First Power BI Presentation
20 Jan 2022
Contributed by Lukas
No matter if you have never spoken before, presented once, or never have before, the guys share their own stories and tips on how they started speakin...
75: Integration with Other Servies - Our Power BI Success Stories
18 Jan 2022
Contributed by Lukas
The guys are focusing on all the ways that we connect to Power BI - Basic (SQL), Advanced (API), Frustrating (Dynamics), and Future (Databricks). ...
74: Reviewing Matthew Roche's Article - Problem Domain, Solution Domain
13 Jan 2022
Contributed by Lukas
If you have not heard of Matthew Roche in the Power BI Space, it is time you get familiar with his blog and especially his series of articles on...
73: Power BI Analyst 2.0
11 Jan 2022
Contributed by Lukas
This is one of our more interesting topics. Based on this article by Toward's Data Science, the current iteration of the Analyst (In our case, the Pow...
72: Knowing Your Audience When Building Power BI Reports
06 Jan 2022
Contributed by Lukas
What are the different levels of users when building a report? What are they, and how do you approach each? What are the problems with audience types ...
71: Power BI Licenses
04 Jan 2022
Contributed by Lukas
The guys are back focusing on Power BI Licenses - what is the scale, the differences, and what should you look for? Think this could be a boring...
70: Our Power BI Resolutions
30 Dec 2021
Contributed by Lukas
The guys are rounding out the year with what else? Resolutions! Can we stick to them? The guys share our #PowerBI resolutions for the upcoming year. W...
69: Who's Leaking Power BI Data?
28 Dec 2021
Contributed by Lukas
Based & inspired by an article by Bernat Agullo Rosello, the guys are back from Christmas focusing on what should be considered leaked data in Pow...
68: Our Power BI Secret Santa
23 Dec 2021
Contributed by Lukas
It is holiday time! The guys are giving Power BI gifts to each other, ideal features and tools that we would love to have and use. What features or to...
67: Report & Model Labels In Power BI
21 Dec 2021
Contributed by Lukas
How important are data labels in Power BI, and where are they actually found? The guys focus in on their role, if they are underrated, and what is mod...
66: What Should be Required for a Power BI Certified vs. Promoted Dataset?
16 Dec 2021
Contributed by Lukas
We are having some fun with endorsements! There should be the utmost importance around what a certified dataset, but what should qualify one? The guys...
65: Continually Improving Users Experience in Power BI
14 Dec 2021
Contributed by Lukas
We have talked extensively about what a Power BI Report is, but what is that experience for the users? How do we ensure that our consumers are activel...
64: Talking About Power BI Themes
09 Dec 2021
Contributed by Lukas
Let's face it: You are not an expert on Color Theory. It is a common challenge that most Power BI Professionals struggle with design and color theory ...
63: 7 Reasons DAX Is Not Easy - A Review of SQLBI's Explanation
07 Dec 2021
Contributed by Lukas
An amazing new article by Marco Russo from SQLBI focuses on the complexities and pitfalls around the DAX language in Power BI. He outlines 7 unique re...
62: Power BI Data Culture - Can We Measure Success?
02 Dec 2021
Contributed by Lukas
A highly trending buzz word around Power BI is Data Culture. Growing, improving, and establishing a data culture is essential, and thanks to Melissa C...
61: Trolling the ideas.PowerBI.com Site
30 Nov 2021
Contributed by Lukas
The guys have some more fun and look to what can we can look forward to in new Power BI features, or more so what they want to see become reality for ...
60: Formal vs. Self Training - Is There a Mix or Best Solution for Power BI Users?
25 Nov 2021
Contributed by Lukas
Happy Thanksgiving! The guys talk about their experience learning Power BI and what options are available for users nowadays. While the guys had...
59: What Are We Most Looking Forward To On the Power BI Roadmap
23 Nov 2021
Contributed by Lukas
Microsoft recently announced the Power Platform Release Wave v2 for the upcoming months, and we could not wait to get our hands on it! The guys talk a...
58: The Power BI Service Feature Draft!
18 Nov 2021
Contributed by Lukas
It's Draft Day! But not just any draft, the guys are taking the best of the best from the Power BI service and compete with each other for the best fe...
57: What is the Role of Power BI Paginated Reports
16 Nov 2021
Contributed by Lukas
The guys talk about the November 2021 of Power BI, along with the next user group schedule among others. The big topic: Paginated Reports have b...
56: What's In Your Power BI Report Checklist
11 Nov 2021
Contributed by Lukas
Let's face it: Some of what we do in building reports can be mundane and repetitive. Other items we may miss that will effect the quality of the repor...
55: Why is Power Query in Power BI Underrated?
09 Nov 2021
Contributed by Lukas
The guys talk through out of all the tools available in Power BI, why can Power Query be the least known? It is a POWERFUL component of the Power BI S...
54: The Role of the Help Desk for Power BI
04 Nov 2021
Contributed by Lukas
What is the role of the Help Desk for Power BI? How should they behave, and why are there no templates for Business Intelligence Help Desks (looking a...
53: Power BI Governance Part 3: Challenges, People, and Running a Governance Program
02 Nov 2021
Contributed by Lukas
The guys are rounding out their series on Power BI Governance with Part 3 - what are the challenges involved, how do you get people on board, and the ...
52: Short Term vs. Long Term Solutions for Power BI Solutions
28 Oct 2021
Contributed by Lukas
Dealing with a client or a project, a #powerbi report build or any data solution, how do we handle understanding the “ideal” approach vs. What is ...
51: Workspace Planning In Power BI: How Do You Do It?
26 Oct 2021
Contributed by Lukas
How do you do Power BI workspace planning? Using the Melissa Coates article on planning Workspace and Criteria's, the guys discuss what goes into the ...
50: Nifty Fifty - Wrong Answers Only & The Best Power BI Jokes
21 Oct 2021
Contributed by Lukas
We made it to fifty (50!). To celebrate, the guys are taking a step back from technical deep dives, as they curated the best of the best Power BI joke...
49: Power BI Governance Part 2 - Vision, Strategy, & Staffing
19 Oct 2021
Contributed by Lukas
The guys are diving into Power BI Governance Part 2: Vision, Strategy, and Staffing. Again, we are using the amazing Microsoft Adoption Roadmap, focu...
48: Power BI Automated Insights First Thoughts
14 Oct 2021
Contributed by Lukas
The guys are still in Houston talking through the Community Summit 2021. Alot of Dynamics folks at the conference, where does Power BI fit into that s...
47: When I Failed at Building a Power BI Report!
12 Oct 2021
Contributed by Lukas
Mike & Tommy are live in Houston for the Community Summit NA 2021! Let's face it. We have all failed at building and delivering solutions via data...
46: Adding the Final Touches to a Power BI Report
07 Oct 2021
Contributed by Lukas
Anyone building Power BI Reports knows the amount of intricate tasks that are involved from data source to visuals in a Report. But what are the final...
45: Talking Governance in Power BI - Part 1
05 Oct 2021
Contributed by Lukas
This is the first part of what we believe will be at least a 3-part series on Governance in Power BI. Future Governance episodes will be released late...
44: Jack of All Trades or Master of One - Skills In Power BI
30 Sep 2021
Contributed by Lukas
We have a mailbag topic! In the Power BI Space, there are more than enough areas of expertise that require skill and knowledge on. I am going fr...
43: Reviewing Goals In the Power BI Service
28 Sep 2021
Contributed by Lukas
The last couple of weeks the Power BI team at Microsoft has released some major improvements to Goals in the Power BI Service (see articles below). Wi...
42: How Do You Resolve Power BI Technical Debt?
23 Sep 2021
Contributed by Lukas
Technical Debt. The concept of buildup of unscalable solutions that causes rework in a solution, and eventually catch up on you. Anyone in the Power B...
41: How Do You Clean Power BI Models? Tools and Approaches
21 Sep 2021
Contributed by Lukas
It does not matter if you are just starting off in Power BI or a season veteran, or even an all-star: You are going to run into complications with you...
40: I Had $100.... Spending Our Budget On The Power BI Service
16 Sep 2021
Contributed by Lukas
One of our more favorite segments, we imagine Microsoft gave us $100 to spend on however we want to enhance the Power BI Service. Where would we have ...
39: Where Does Power BI Mobile Fit Into the Story?
14 Sep 2021
Contributed by Lukas
We know how important phones and tablets are to our culture. This is the same for companies and users. Microsoft continually enhances the Power BI mob...
38: The Importance of Communication for a Power BI Pro
09 Sep 2021
Contributed by Lukas
Today's episode is all about the importance of communication skills for a Power BI Professional. First and foremost, why are even talking about commun...
37: Composite Models and Reusing DAX Measures and Objects in Power BI
07 Sep 2021
Contributed by Lukas
With some of the major new features available to connect to live datasets in Power BI (Direct Query on Analysis Services) that allows a Power BI repor...
36: Developing Insights When There Are None - How To Create Insights In Power BI For an Organization
02 Sep 2021
Contributed by Lukas
Based on this amazing article by Microsoft on how they developed their corporate KPI's, the guys wanted to run with it and talk about how any Power BI...
35: Power BI Filters - Slicers or The Filter Pane
31 Aug 2021
Contributed by Lukas
There are more than one way to filter a Power BI Report. You can use the Filter Pane, use Slicers, interact with a visual, or even use drill-through. ...
34: I.T Datasets vs. User Datasets in Power BI, and the Separation of BI from IT
26 Aug 2021
Contributed by Lukas
As companies evolve in their reporting and data systems, there has been an ongoing discussion around ownership of datasets in Power BI, including when...
33: What Makes a Good Power BI Executive Sponsor?
24 Aug 2021
Contributed by Lukas
Another bout with the Power BI Adoption Roadmap, this time focusing on the need for and importance of Executive Sponsorship & Support. What entail...
32: Do You Have To Join A User Group To Be A Better Power BI Pro?
19 Aug 2021
Contributed by Lukas
Note: Many of the guys have been working to still get episodes out despite vacation plans, we apologize for the spotty audio in some segments. We pre-...
31: What is the Role of Tables & Matrix's in Power BI?
17 Aug 2021
Contributed by Lukas
Note: Many of the guys have been working to still get episodes out despite vacation plans, we apologize for the spotty audio in some segments. We pre-...
30: Building a Data Culture in Power BI
12 Aug 2021
Contributed by Lukas
We are diving back into the Power BI Adoption Roadmap with what and why of Data Culture. How do you even define it , and how do you identify it? Join ...
29: To Degree Or Not To Degree? Do You Need a Degree for Power BI?
10 Aug 2021
Contributed by Lukas
The guys cover somewhat of a contentious topic in the Power BI community and for professionals throughout the industry: How essential is a college deg...
28: Adoption & Maturity Levels in Power BI
05 Aug 2021
Contributed by Lukas
The guys are using the amazing resource by Melissa Coates on the Power BI Adoption Roadmap (referenced here: https://docs.microsoft.com/en-us/power-bi...
27: What Do you Look For On a Power BI Pro's CV / Resume When Hiring?
03 Aug 2021
Contributed by Lukas
The guys focus on a topic that is widely discussed but seldom agreed upon - The Power BI Pro's Resume. What is impactful, what is important, and what ...
26: Experimenting in Power BI - Ways To Play & Not Break
29 Jul 2021
Contributed by Lukas
How often do you try new things in Power BI? What approaches or methods do you have? The guys focus today on their own experience on how they have use...
25: Discussing Your Power BI Work / Life Balance
27 Jul 2021
Contributed by Lukas
The guys are back discussing a little more heartfelt topic: How do you manage or balance work and life in the Power BI World? We all love what we do -...
24: Charticulator in Power BI: Is It Worth It?
22 Jul 2021
Contributed by Lukas
From Microsoft's Research Lab, a newly released custom visual in Power BI is the amazing visual named Charticulator. It gives you nearly infinite desi...
23: Explaining an Impactful Power BI Center of Excellence
20 Jul 2021
Contributed by Lukas
In case you missed it, Microsoft released an amazing new resource named the Power BI Adoption Roadmap - an in-depth and all-encompassing resource to b...
22: How Did You Learn DAX in Power BI?
15 Jul 2021
Contributed by Lukas
The journey of learning DAX for a Power BI Pro is quite a unique one. On one hand, the formulas seem straightforward enough, like Excel. On the other,...
21: Our Power BI Dev Studio: What Is Our Power BI Toolbelt?
13 Jul 2021
Contributed by Lukas
Any Power BI Pro knows they need more than just skills - they need some tools up their sleeve. The guys are talking about what makes up what they call...