Mike, Seth, & Tommy discuss managing unstructured data in Power BI, including Excel files, exported data, self-service measures, and write-back. They explore challenges in dealing with data from different systems, and the importance of automation and tools like Power BI. They also discuss accountability in data management and the role of executive sponsors.
Managing unstructured data in Power BI is crucial for maintaining control and accuracy.
Creating a wow factor in product features can drive adoption and user excitement.
Clear communication and alignment of expectations are essential for effective data reporting and stewardship.
Deep dives
Power BI Desktop Update
The recent Power BI Desktop update includes substantial updates, such as validating theme files, additional color-safe themes, and conditional formatting on string fields.
Smart Narratives and Custom Visual Pages
The update introduces smart narratives, which provide textual descriptions of visuals, and the ability to customize them. It also includes custom visual pages, allowing for more control and organization of visuals within the report.
New DAX Functions and Bing Integration
The update brings two new DAX functions, line ST and line STX, simplifying linear regression and modeling within calculations. Additionally, the integration with Bing enables AI-powered data search and generation of descriptions for DAX formulas.
The Importance of Wow Factor in Product Adoption
The speaker emphasizes the importance of creating a wow factor in product features to drive adoption. They highlight the significance of exceeding users' expectations in the first few minutes of interaction with a product, which can generate excitement and encourage adoption.
Balancing Data Manipulation and Stewardship
The podcast explores the challenges of data manipulation and the need for stewardship and ownership of data. They discuss the importance of accountability and process in managing data quality. They also emphasize the need for clear communication and alignment of expectations between report authors and the organization, especially regarding the level of rigor and trust required in different types of reporting.
Mike, Seth, & Tommy dive into how to manage the wild world of unstructured data. How do we manage, control, and allow when teams can edit or modify data that goes into Power BI reports?
Situations:
Excel files that Power BI connects to
Exported data that users create their own excel data from
Self-service new filters and measures
write-back.
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.