Explicit Measures Podcast

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 on the PowerBI.tips Podcast Page . Vi...

 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, the delivery, and the overall product...

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 stacks up with the Power BI Pro, and what this me...

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 on the PowerBI.tips Podcast Page . Visit Pow...

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 topic? Or never thought of it? You should now - The scale between Pro, PPU, and Gen 2 is huge.  Licensing Info: https://powerbi.microsoft.com/en-us/pricing/ Get in touch: Send in your questions or topics you want us to discuss by tweeting to @P...

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. What do we want to stop doing, what we want to improve on, and where should we focus our time. 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...

Based & inspired by an article by Bernat Agullo Rosello , the guys are back from Christmas focusing on what should be considered leaked data in Power BI. Who is responsible, and how do we ensure Power BI Reports do not contain sensitive information?  Topic goes into two main areas of Leaking Data: Leaking data externally, and grabbing data from an export into Excel and "fixing" the data....

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 tools are most needed, most wanted, more importantly, would we use them or re-gift them? This is a fun, with some great ideas! Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailba...

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 model label. Can labels actually hurt a report, and how important is consistency?  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...

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 actually get heated on what goes into one, and what does that mean to a business having a certified dataset. 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...

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 actively using, adopting, and having the expereince that they need to have a data driven and impactful expereince? Join the guys as they go through what goes into that experience, and what we can do to improve it.  Get in touch: Send in your questions...

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 (we like data more). However, one can argue the use of a standard and organized color pallete can make or destory a report.  The guys talk about the importance of Theming in Power BI, what they look for, and their tools and tricks to create prof...

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 reasons why DAX is not easy. The guys discuss the 7 reasons and their own experience around the article.  The guys run through the reasons and where it resonates from their own experience and how they have  tackled each. Read SQLBI's article...

A highly trending buzz word around Power BI is Data Culture. Growing, improving, and establishing a data culture is essential, and thanks to Melissa Coates' excellent Power BI Adoption Roadmap, we have a great framework on what to look for. That being said... How do you define and measure success for it? Can you even create measurable KPI's around it? Power BI adoption roadmap: Data culture - Powe...

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 Power BI in the future.  We all know that Microsoft heavily relies on the ideas.powerbi.com website for future development of features and services, and it counts the votes on those ideas. The guys pick their wish list.  Get in touch: Send...

Happy Thanksgiving!  The guys talk about their experience learning Power BI and what options are available for users nowadays. While the guys had more self-training, what does formal vs. informal training mean in the Power BI world, and what should people consider? Do you need both formal and self-taught? What about scenario based? Get in touch: Send in your questions or topics you want us to...

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 about what are the biggest game changers, and what we think is going to change the space.  Read the release wave here: https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/planned-features Get in touch: Send in your que...

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 features.  The Goal: take from all the Power BI service features that will best enable you to adopt and distribute Power BI to an organization. We are choosing from Goals to Export CSV, 12 rounds of arguing and picks? We would love your input on w...

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 been around for a long time, even before Power BI. That being said, what is the role and where does Power BI Paginated Reports fit in the ecosystem and should users use and learn it? Get in touch: Send in your questions or topics you want us to discus...

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 report. Regardless of what you do, or how you do it, don't you need a checklist? The guys discuss what goes in their own checklist for building a report, from the scope to the publish. Get in touch: Send in your questions or topics you want us to discuss...

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 Skill Toolset, and the guys share their experience, the use cases, and what role in plays in the Power BI World. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit o...

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 at you Jira)? The guys dive into what they consider an untapped component of BI Projects, and where a Help Desk stands in regards to importance of any Power BI Solution, along with why the lack of resources for BI Projects and Help Desk providers. The...

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 overall components of running a Governance Program. As always, we are using the Power BI Adoption Roadmap document (link below). Link to document: https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-governance#governance-chall...

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 possible? The guys go over what makes up a short term compromise to a long term solution, and offer their experience on what makes up "must have", "should have" , and "would like to have" for aligning expectations for users.  Get in touch: Send in y...

How do you do P ower BI workspace planning? Using the Melissa Coates article on planning Workspace and Criteria's, the guys discuss what goes into the role of a Workspace, how to migrate, and pain points.  Melissa Coates Workspace Planning Guide 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 Power...