))
Hosted by Mike Carlo, Seth Bauer, and Tommy Puglia, the Explicit Measures Podcast is a Power BI focused show that is like being around a Power BI Pro’s Water Cooler. With so many available resources in the community that focuses on the “how” in Power BI (how to do Drill Through, how to use DAX, etc.,), the Explicit Measures Podcast is all around the WHY. Why use a particular feature, does it make sense for my users? Build the toolset, learn the how, and then come to the Podcast to the listen ...
E
Explicit Measures Podcast
1
121: Architecture of Data Implementation - Power BI Usage Guides
1:01:22
1:01:22
Play later
Play later
Lists
Like
Liked
1:01:22
The guys are going back to the Usage Scenarios series in the Microsoft Docs, focusing on the scenarios below: Personal (review from last week) Team Departmental Enterprise https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-usage-scenario-overview Get in touch: Send in your questions or topics you want us to discuss b…
E
Explicit Measures Podcast
1
120: On Building Expertise - Adapting & Growing Your Power BI Skills
1:05:58
1:05:58
Play later
Play later
Lists
Like
Liked
1:05:58
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 in the last couple of months the Power Platform dramatically shift. From Data Marts (in progress) to creating a Power APP from a drawing, we are in the business to not only do our job well, but constan…
E
Explicit Measures Podcast
1
119: Measuring Trust - Adoption of Data & Power BI
1:02:47
1:02:47
Play later
Play later
Lists
Like
Liked
1:02:47
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 despite being data geeks, we are striving towards a goal we cannot measure! Or can we? How and what can we do to create a measurement around trust in the data. Get in touch: Send in your questions or t…
E
Explicit Measures Podcast
1
118: Power BI Implementation Usage Scenarios - Reviewing the Planning Documentation
1:09:48
1:09:48
Play later
Play later
Lists
Like
Liked
1:09:48
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 methods to implement and provide a lifecycle of data at an organization. Thanks again to Melissa Coates & Matthew Roche! Today is focused on the overview of different usage scenarios we can run into …
E
Explicit Measures Podcast
1
117: Asking the Right Data Questions and Asking The Data Questions Right
1:02:25
1:02:25
Play later
Play later
Lists
Like
Liked
1:02:25
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 to efficently and effectively talk to people, get the information you need, and translating a business problem into something you can measure (think "we need to see who is at risk over time" - we need …
E
Explicit Measures Podcast
1
116: Is The Power BI Platform Better Than the Classic Microsoft BI Architecture Stack?
1:04:32
1:04:32
Play later
Play later
Lists
Like
Liked
1:04:32
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 marts). Is the #PowerBI stack (not including Azure) BETTER than it was? Thanks to Marcus Wegener for the inspiration https://lnkd.in/gp64TiKC Get in touch: Send in your questions or topics you want u…
E
Explicit Measures Podcast
1
115: The Importance Of Push-Back on Power BI Reports
1:08:01
1:08:01
Play later
Play later
Lists
Like
Liked
1:08:01
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 the importance of pushing back. The guys discuss the why on evaluating requests that should be pushed back, how to resolve the conflict of the value based on the BI Team / Stakeholder, and what should we do…
E
Explicit Measures Podcast
1
114: Do We Need More Forecasting In Our Power BI Reports?
1:02:36
1:02:36
Play later
Play later
Lists
Like
Liked
1:02:36
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 pre-baked in Power BI (like the line chart feature), 1) do we need to think more about projections for our users in reporting and 2) should we rely on built in features?Why is forecasting not as apparen…
E
Explicit Measures Podcast
1
113: All About Microsoft Build 2022
1:11:09
1:11:09
Play later
Play later
Lists
Like
Liked
1:11:09
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. Goals now Metrics 3. Data Marts The guys give their take on these new features, and what they mean for the future. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @Power…
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, and when is truly helpful?The guys discuss text being a helper, part of a narrative, and the concept of data-ink ratio in any report.Get in touch:Send in your questions or topics you want us to discus…
E
Explicit Measures Podcast
1
111: Dealing With Spokes - Centralized Power BI and Departmental BI
59:27
59:27
Play later
Play later
Lists
Like
Liked
59:27
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 may be one of the spokes? How can we deal with this situation? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the…
E
Explicit Measures Podcast
1
110: Calculation Groups in Power BI
1:00:14
1:00:14
Play later
Play later
Lists
Like
Liked
1:00:14
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 think it is, and dive into how game changing Calculation Groups are in Power BI. Why should you use it, the benefits, and as always, what is it's role in the space? Get in touch: Send in your questions o…
E
Explicit Measures Podcast
1
109 - Peripheral Skills for a Power BI Professional
1:05:24
1:05:24
Play later
Play later
Lists
Like
Liked
1:05:24
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 anniversary, and talk about the new Field Parameters in the May update.
E
Explicit Measures Podcast
1
108: Adding Max(Value( )) - Brining, Developing, & Selling Solutions In-House
59:48
59:48
Play later
Play later
Lists
Like
Liked
59:48
You have an amazing solution that will change the business using #PowerBI & the #PowerPlatform - but how do you sell it? The guys discuss just that - becoming known as a solution provider at your business, and what you need to do to get there. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the…
E
Explicit Measures Podcast
1
107: How to Retire a Power BI Report
1:01:42
1:01:42
Play later
Play later
Lists
Like
Liked
1:01:42
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 and finally retiring it? The guys talk about what a process to identify reports that may be in need, who it effects, and what the impact is. Get in touch: Send in your questions or topics you want us t…
E
Explicit Measures Podcast
1
106: Teamwork & Aligning Goals for a Power BI Organization
58:49
58:49
Play later
Play later
Lists
Like
Liked
58:49
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 do we know if our team is on the right track, and what does it mean to have goals for our BI Team? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips wit…
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 success? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page. Visit PowerBI.tips: htt…
E
Explicit Measures Podcast
1
103: Improving The Report Request Process
55:58
55:58
Play later
Play later
Lists
Like
Liked
55:58
This is from a hot take online: https://twitter.com/WeHateData/status/1509538551993716736 Lukewarm take: nearly all request-based analytics workflows are destined to fail. It burns out talented analysts. It fails to connect related cross-org themes. The lack of friction to ask a question leads to poor quality questions from stakeholders. You can im…
(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 provides to manage and incorporate mass amounts of data from multiple sources to create a true model that transforms the business. HOWEVER, what happens our organization buys into their own solution? A…
E
Explicit Measures Podcast
1
102: Best Practice Analyzer for Visuals & Report Design Wishlist
57:05
57:05
Play later
Play later
Lists
Like
Liked
57:05
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 would our rules, fixes, and management look like? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.…
E
Explicit Measures Podcast
1
101: Where Do you Put Your Power BI Measures
1:02:51
1:02:51
Play later
Play later
Lists
Like
Liked
1:02:51
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 measures in DAX? Is there always a good place, a good method, or does it depend based on the solution? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips wit…
E
Explicit Measures Podcast
1
100: A Few Of Our Favorite Things / THANK YOU!
59:56
59:56
Play later
Play later
Lists
Like
Liked
59:56
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 origin of the podcast, why they are still doing it, and what makes it unique and the community feedback on a different vision of looking at the Power BI Professional. There was great submissions by you guy…
E
Explicit Measures Podcast
1
The Lost Episode (84): When It Fails
1:01:45
1:01:45
Play later
Play later
Lists
Like
Liked
1:01:45
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 reports completely fail on us? What is our methodology when something happens, and how do we deal with it at a company, or even when presenting? This goes through dealing with gateways, reports, demos, …
E
Explicit Measures Podcast
1
99: Overcoming DAX Evaluation Context in Power BI
1:02:21
1:02:21
Play later
Play later
Lists
Like
Liked
1:02:21
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 also the most essential. What have the guys learned in all of the years and situations on getting better, learning, and getting their minds around it? Get in touch: Send in your questions or topics you wan…
E
Explicit Measures Podcast
1
98: Exploring Write Back in Power BI
1:05:58
1:05:58
Play later
Play later
Lists
Like
Liked
1:05:58
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 Power Apps, threats, and what should you know? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.ti…
E
Explicit Measures Podcast
1
97: Report Features for Consumers - Just How Important?
1:06:15
1:06:15
Play later
Play later
Lists
Like
Liked
1:06:15
Personal Bookmarks, Personalize Visuals, and Comments - How important and what role do they play for #PowerBI Report consumers? The guys jump into the conversation, where they land on their importance, and what how do we get users to use them more (or even if they should). Get in touch: Send in your questions or topics you want us to discuss by twe…
E
Explicit Measures Podcast
1
96: Diving Into The Trend in Analytical Data Modeling for Power BI
1:06:52
1:06:52
Play later
Play later
Lists
Like
Liked
1:06:52
We have an amazing article that the guys dived into by Iteration Insights (Thanks to Steve Richardson) - article here: https://iterationinsights.com/article/the-trend-in-analytical-data-modeling/ The gap between data modeling for IT and for the business is shrinking. Not only that, but the barrier to entry, and flexibility to architect data models …
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, but is there a cut-off? The guys dive into all aspects, and focus on creating a group in a report file and what techincal debt ensues from it. We are near 100 episodes, and launching our next contest…
E
Explicit Measures Podcast
1
94: People, Process, & Technology - Integrating A Complete Power BI Solution
1:03:13
1:03:13
Play later
Play later
Lists
Like
Liked
1:03:13
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 matter if you have incredible vision and understand people's pain points in 2 minutes. What does matter is if you can manage and successfully roll out all 3. In the BI space, the ability to deliver hig…
E
Explicit Measures Podcast
1
93: Mailbag - Documentation Solutions in Power BI - How Much Or Too Little?
51:19
51:19
Play later
Play later
Lists
Like
Liked
51:19
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 documentation get updated? Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit …
E
Explicit Measures Podcast
1
92: Do We Like The New Power BI Formatter Pane?
59:13
59:13
Play later
Play later
Lists
Like
Liked
59:13
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 has changed, and how do we adapt? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Pa…
E
Explicit Measures Podcast
1
91: Power BI Worlds - Consulting vs. In-House Work
1:08:17
1:08:17
Play later
Play later
Lists
Like
Liked
1:08:17
One Power BI, two different worlds? You love Power BI, but you may have a vastly different viewpoint and experience in the platform depending where you work. Are you FTE (Full-Time Employee) or IC (Independent Consultant)? The guys wanted to know just how different and distinct the experience brings to a Power BI Pro, and what skillsets are develop…
E
Explicit Measures Podcast
1
90: The Importance of Drill-Through in Power BI
59:57
59:57
Play later
Play later
Lists
Like
Liked
59:57
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 Reports. We all use it, but it is used as much as it should be? Are we being too redundant with our pages, and what story are we really telling with our drill-through pages? Listen in for what Mike, …
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 DAX Debugger, there are many ways to hack your way to a value and a result. But are they are all worth it? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerB…
E
Explicit Measures Podcast
1
88: If I Had $100... Power BI Visuals Edition
1:12:01
1:12:01
Play later
Play later
Lists
Like
Liked
1:12:01
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 guys break down their budget and where their focus is (hint, Tables are a big deal). Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMail…
E
Explicit Measures Podcast
1
87: Getting Power BI Authors To Conform To Best Practices
1:01:54
1:01:54
Play later
Play later
Lists
Like
Liked
1:01:54
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, methods, and process? How can you get a group or entire team of #PowerBI Authors to follow the same process. The guys discuss do you need the carrot or the stick, and what makes up best practices for a team.…
E
Explicit Measures Podcast
1
86: What Do Incentives Mean in a Power BI Center of Excellence & Community of Practice
1:09:00
1:09:00
Play later
Play later
Lists
Like
Liked
1:09:00
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 motivates the people involved. Based on the Power BI Adoption Roadmap, how much do the incentives align with that is possible at most organizations? The guys break down the difference between audiences and level…
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 owns what, and what should ownership consist in regards to data, business, and reports? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #emp…
E
Explicit Measures Podcast
1
83: Are We Building the Wrong Power BI Reports?
1:09:11
1:09:11
Play later
Play later
Lists
Like
Liked
1:09:11
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 consumers come back and say it's confusing, does that mean the report is wrong? More so, is that a report problem or a people problem? The guys dive into the ability to scope out and derive what makes a rep…
E
Explicit Measures Podcast
1
82: Export Everything - Managing Power BI Exported Data
1:09:42
1:09:42
Play later
Play later
Lists
Like
Liked
1:09:42
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 consumers. What should be the purpose or the role of exported data, and what does it say about your reports? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips w…
E
Explicit Measures Podcast
1
81: Our Most Productive Methods Using Power BI
1:04:02
1:04:02
Play later
Play later
Lists
Like
Liked
1:04:02
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 productive (rolling average), and how to break down your work. What methods and tools are used? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hasht…
E
Explicit Measures Podcast
1
80: External Tools In Power BI - Their Role for the Pro
1:01:54
1:01:54
Play later
Play later
Lists
Like
Liked
1:01:54
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 not, then stop listening start learning! What is the role of External Tools, and should it be a requirement for a Pro to know and use them in Report Development? How essential are they? The guys cover t…
E
Explicit Measures Podcast
1
79: The Most Important DAX Functions In Power BI
1:02:48
1:02:48
Play later
Play later
Lists
Like
Liked
1:02:48
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 essential, important, or widely used? What should you know when you hit a wall, and do you have to know and master these important functions? Get in touch: Send in your questions or topics you want us…
E
Explicit Measures Podcast
1
78 - Talking About Incremental Refresh
1:01:14
1:01:14
Play later
Play later
Lists
Like
Liked
1:01:14
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 uses on utilizing XML endpoints for incremental refresh. Also, Goals in Power BI is a Pro feature now! You do not need Premium! https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refre…
E
Explicit Measures Podcast
1
77: Do We Have Too Much Interactivity In Our Power BI Reports? Simplifying Layouts & Interaction
1:07:57
1:07:57
Play later
Play later
Lists
Like
Liked
1:07:57
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 with the design and the application itself? Or is it a problem of poorly managed objectives? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the h…
E
Explicit Measures Podcast
1
76: Getting Your Feet Wet Doing Your First Power BI Presentation
1:05:17
1:05:17
Play later
Play later
Lists
Like
Liked
1:05:17
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 speaking on Power BI at user groups and conferences. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.ti…
E
Explicit Measures Podcast
1
75: Integration with Other Servies - Our Power BI Success Stories
59:59
59:59
Play later
Play later
Lists
Like
Liked
59:59
The guys are focusing on all the ways that we connect to Power BI - Basic (SQL), Advanced (API), Frustrating (Dynamics), and Future (Databricks). What have they seen that works, what doesn't? What to look out for? Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit…
E
Explicit Measures Podcast
1
74: Reviewing Matthew Roche's Article - Problem Domain, Solution Domain
59:37
59:37
Play later
Play later
Lists
Like
Liked
59:37
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 the Problem Domain & Solution Domain. Too many of us are delivering results but not true solutions for our clients, departments, and teams. But what should the Power BI Pro be? How do we change the culture…
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 Power BI Analyst) is becoming extinct. Enter the Power BI Analyst 2.0, which requires the ability to communicate, explain, and drive decisions. The guys dive into their experience, how this article stack…
E
Explicit Measures Podcast
1
72: Knowing Your Audience When Building Power BI Reports
1:03:46
1:03:46
Play later
Play later
Lists
Like
Liked
1:03:46
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 if you are not aware? The guys tackle this in today's episode. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit …
