Explicit Measures Podcast

Yes, it's finally the guys time to review the biggest release by Microsoft this year. Data Marts. If you have not heard of this feature - GET TO IT. The guys are going to review what they think, what the implications are for this moving forward, and what should Power BI Developers be preparing for using for datamarts in our solutions. This is not something we are doing now, but in a year will this...

You poll 100 Power BI developers, and there is a good chance that the majority of every-day builders love to figure out technical puzzles. We have to deal with this in almost every situation, but how does Power BI become a tool and enabler as we figure out bad data, missing data, or overall problems where we need to provide the solution.  We love problem solving, but we need to be skilled her...

When we get in the weeds of a new / major report project, many times the models build on themselves. First we have the discovery, exploration, and figuring out what we need. All of the processes build on one another, and especially when we colloborate.  Now fast-forward, and all of sudden your Power BI model is handing by thread... Complicated, dependent, and slow. Where do we begin, and how...

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 by tweeting to @PowerBITips with the hashtag #empMa...

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 constantly identify the new skills and then tackle and gr...

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 topics you want us to discuss by...

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 and need to think seriously about what is best...

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 to know how to measure 'At Risk' and what over tim...

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 us to discuss by tweeting to @PowerBITips with the...

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 to create a standard for pushing back effec...

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 apparent in our metrics, what is holding us back, and...

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 @PowerBITips with the hashtag #empMailbag or submi...

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 discuss by tweeting to @PowerBITips with the hashtag...

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 PowerBI.tips Podcast Page . Visit PowerBI.t...

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 or topics you want us to discuss by tweeting to @Po...

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. 

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 hashtag #empMailbag or submit on the Po...

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 to discuss by tweeting to @PowerBITips with t...

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 with the hashtag #empMailbag or submit on the PowerBI...

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: https://powerbi.tips/ Watch the episodes live every...

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 imagine the conversation, one of best! Get in...

(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? And it doesn't just have be another BI soluti...

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.tips Podcast Page . Visit PowerBI.tips: https://po...

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 with the hashtag #empMailbag or submit on the PowerBI...

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 guys on your favorite episodes, which are brief...