Explicit Measures Podcast

We have a great mailbag today! Mike, Seth, & Tommy discuss the following question: I'm the chief cook and bottle washer in IT for Power BI in my subsidiary of my org. I've shown some business users how to integrate live Power BI pages into ppt and it's really sparked a lot of interest. And I think this could be a really fruitful topic for you three to discuss. My angle is this. I think the corporation that I work for is probably pretty typical in that PowerPoint is THE format for all visual communication at a director-level and above. PBI's role in this up til now has been either screen shots into ppt or data dumps that individuals use to create their own visuals in Excel and then paste into ppt. And no one has wanted to give direct access to PBI apps to VPs, let alone our group president because it's "too hard. They just want it laid right out for them". I think a big part of this is really that directors want to be between the data and the execs, so that they can interpret it for them. And maybe add some business logic that they're holding a little too close to the vest into the presentation. Kind of the intersection between data culture and tribal knowledge. (Some departments are worse about this than others.) I think the live PBI integration into ppt can help break this down a little. First, it means that all the business logic needs to be directly in PBI, but at the same time, it allows commentary to be inserted in the usual ppt way of bullet points. To that end, I've created some custom reports on existing datasets that are stripped down (no header, no company logo as those are in the corporate ppt template) and have custom dimensions to fit the space in ppt better. I have them sized so that they take up about 2/3 of the slide with 1/3 on the right left for bullet points. Also, since the embedded PBI pages are still interactive, I'm trying to sneakily introduce PBI functionality to the execs that see them and maybe they'll ask for access to the original reports/apps themselves. I could go on, but what do you guys think? Do you like this approach? Do you have any other ideas? 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 Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

The podcast discusses major updates to Q&A tooling in Power BI, including the ability for organizations to integrate it into their workflow. They also talk about the Power BI contributor program, new updates in Power BI visuals, and the challenges and potential of language models in business outputs.

Mike, Seth, & Tommy ask if we can create a measurement system around BI skills? Can we actually scale and measure up the quality of our work, both from technical skills to soft skills? Great discussion around qualifying the Power BI Champions. 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 Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

Topics discussed include Microsoft's Fabric and the Delta Format, incremental refresh in Microsoft Fabric, scalability and flexibility in Azure for data engineering, upcoming cost activation and uncertainties with Fabric Artifacts, and the changing role of SQL and data engineering professionals in Microsoft Fabric Ecosystem.

The podcast discusses the potential impact of Fabric on the adoption of Power BI desktop, highlighting the concerns of business analysts and the challenges faced by IT organizations. It explores the advantages and disadvantages of using Fabric for business purposes, emphasizing its quick adoption and data visualization capabilities. The concept of creating separate pipelines and curating data sets is also explored, highlighting the importance of relevant data and permission levels. The podcast delves into the features and benefits of Fabric in comparison to existing solutions, discussing its value for organizations with a focus on SQL and data culture.

The podcast discusses the concept of the 'data strategist' role and its importance. It explores different data science roles and the blending of roles in business intelligence and data analysis. The podcast also emphasizes the importance of defining metrics and the role of business intelligence in creating value for the business. It highlights the significance of data strategy and simplifying measurements for an organization.

The hosts discuss the benefits of AI in improving efficiency in the workplace, including areas like reports, modeling, and DAX measures. They explore the impact of AI on users and organizations, including misleading advertisements and AI's potential in assisting with report requirements. They also discuss how AI has seeped into their non-technical tasks, streamlining administrative activities and assisting with business engagement. The chapter emphasizes the value of integrating AI into teams and simplifying tasks, and discusses the potential uses of AI in business intelligence.

The podcast discusses the integration of data into a fabric lakehouse and the benefits it brings. They explore the concept of a lake house, the layers of data within it, and the challenges of managing permissions and governance. They also touch on the integration of Synapse and Data Factory into Power BI, and the new roles added for real-time model training. Overall, they provide insights into how much data should be integrated into a lakehouse and its impact on businesses.

The hosts discuss Jevon's Paradox and its impact on energy consumption. They also explore the increase in workload due to new technologies like Power BI and AI. The availability of data and efficient analysis leads to a higher demand for data-related tasks. They delve into the adoption and potential of Power BI, fabric, and AI tools, highlighting the significance of valuable insights from production data. The chapter concludes with a discussion on challenges in keeping up with technology and data governance.

What has become a harsh truth is we need to reevaluate how we design and consider what a Workspace is when we are dealing with more than just datasets and reports. We have the data engineer, the data scientist, and more that confuses the amount of items and who is working in a workspace. From organization to security, what is best practice? 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 Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/