Power BI Development Best This is a Header

Power BI Development Best This is a Header 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 software THIS IS A SUBTITLE industries. • Email: ALetourneau@Pragmatic. Works. com • Twitter: @Lady. Runa

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? This is a Header • Are they relevant / correct? THIS IS A SUBTITLE • Who is working on them? • How can we track progress?

Tracking Backlog • Dev. Ops – dev. azure. com • One. Note • Excel This is a Header THIS IS A SUBTITLE • Planner in Office 365 – tasks. office. com

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 “column 1” 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 is to Power. BI. com This 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 • “Kon. Mari” your Existing Reports

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

Report Efficiencies – “Kon. Mari” Reports Kon. Mari 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 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 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 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