This is a Header Power BI Development Best Practices THIS IS

This is a Header Power BI Development Best Practices THIS IS A SUBTITLE Making Your Power BI Environment Great

About Me BI Consultant with Pragmatic Works This is a Header 20 years as a MSSQL Server Developer & DBA for financial and accounting THIS IS industries. A SUBTITLE software Email: [email protected] Twitter: @LadyRuna

So Many Reports. So Little Time. This is a Header THIS IS A SUBTITLE

Reining in the Report Development Backlog What reports do we need? Are they duplicates? Are they relevant / correct? This is a Header THIS IS A SUBTITLE Who is working on them? How can we track progress?

Tracking Backlog DevOps – dev.azure.com OneNote Excel This is ainHeader Planner Office 365 – THIStasks.office.com IS A SUBTITLE

DEMO This is a Header THIS IS A SUBTITLE

Managing the Backlog Remove Duplicates Prioritize items Estimate work effort Iterative approach Assign to Content Creators This is a Header THIS IS A SUBTITLE

Report Efficiencies Create Measure Tables This is a Header THIS IS A SUBTITLE

Report Efficiencies – Measure Table In Edit Queries, Click Edit Data to create a one column one row table Click OK This is a Header Close & Apply Select Measure THIS IS A SUBTITLE On Modeling Tab, set Home Table to Measure Table Hide “column1” in Measure Table

Report Efficiencies Create Measure Tables Use Shared Data Models This is a Header THIS IS A SUBTITLE

Report Efficiencies – Shared Data Model Create Master Data Model Data Model Only in PBIX file “One Source of the Truth” Contains all measures Deploy to This isPowerBI.com a Header Use “Power BI Datasets” as source THIS A SUBTITLE for IS report data

Report Efficiencies Create Measure Tables Use Shared Data Models This is a Header Use Source Control THIS IS A SUBTITLE

Report Efficiencies – Source Control This is a Header THIS IS A SUBTITLE

Report Efficiencies Create Measure Tables Use Shared Data Models This is a Header Use Source Control THIS IS A SUBTITLE “KonMari” your Existing Reports

Report Efficiencies – “KonMari” Reports There is no “joy” in Duplicate reports Unused reports Empty or Wrong reports Reports referencing retired systems This is a Header THIS IS A SUBTITLE

Report Efficiencies – “KonMari” Reports KonMari Steps See who is using the reports Remove access to reports Tag “official” reports This is a Header THIS IS A SUBTITLE

Report Efficiencies - Other Handle transformation logic closest to source Leverage query folding Use self-describing names for Columns and This is a Header Measures THIS IS A SUBTITLE Remove Unnecessary columns Avoid bidirectional filters

Keeping up with Power BI Features This is a Header THIS IS A SUBTITLE

Keeping up with Power BI Power BI Blog This is a Header THIS IS A SUBTITLE

Keeping Up With Power BI Follow Power BI Blog (RSS Feed) This is a Header THIS IS A SUBTITLE

Keeping up with Power BI Power BI Blog Lunch & Learn This is a Header THIS IS A SUBTITLE https://powerbi.microsoft.com/en-us/blog/feed/

Keeping Up With Power BI Lunch & Learn This is a Header THIS IS A SUBTITLE

Keeping up with Power BI Power BI Blog This is a Header THIS IS A SUBTITLE https://powerbi.microsoft.com/en-us/blog/feed/ Power BI SME

Keeping Up With Power BI Get a Power BI SME (Subject Matter Expert) This is a Header THIS IS A SUBTITLE

Have Any Questions? This is a Header THIS IS A SUBTITLE