Power BI Semantic Model Best Practices (PIMP) Script!

Video by: Reid Havens

Learn how to run a series of scripts in Tabular Editor 2/3 to (PIMP) out your Power BI semantic model. Quickly and efficiently enhancing it's design, features, and other items! Tune in to learn more! GUEST BIO (Alexander Korn) 👤 Expert in Power BI and experienced business analyst with a demonstrated history of successfully implementing BI reporting solutions in various industries. Further skills: SSAS, IBCS, PBIRS, Excel, T-SQL, DAX, MDX, and PowerShell.

GUEST BIO 👤

Expert in Power BI and experienced business analyst with a demonstrated history of successfully implementing BI reporting solutions in various industries. Further skills: SSAS, IBCS, PBIRS, Excel, T-SQL, DAX, MDX, and PowerShell.

RELATED CONTENT 🔗

Link for the script
PBI Idea for “Write Operations for External Tools”
Alexander's Blog
Alexander's Employer
Alexander's LinkedIn

(Livestream Replay) VisOps with PBI Inspector - with Nat Van Gulck

DESCRIPTION 📄

Testing the visual layer of Power BI reports has usually been a manual task. Thanks to the new Power BI Project file format however there is an opportunity to automatically check for visuals' issues around accessibility, consistency and performance and thereby align with your organizations Power BI Center of Excellence guidelines. In this session we will see how PBI Inspector, an open-source community tool, supports this process.

GUEST BIO (Nat Van Gulck) 👤

I started my career over twenty years ago as a .NET Software Developer while also developing an interest for Data Visualization. This led me to work on Qlik and Tableau data projects. Then Power BI became so compelling that I had to join Microsoft. As a Cloud Solutions Architect I help customers be successful with Power BI; PBI Inspector is part of this endeavor. The adventure continues with Microsoft Fabric.

RELATED CONTENT 🔗

PBI Inspector GitHub repository
Tutorial: PBI Inspector as part of an Azure DevOps Build Pipeline
LinkedIn

(Livestream Replay) New & Exciting Features for the Measure Killer - with Gregor Brunner

DESCRIPTION 📄

Upgrade your Power BI Desktop experience with Measure Killer, a streamlined external tool for better efficiency and clean organization. It expertly finds and deletes unnecessary columns and measures, reducing clutter.
Beyond the Desktop, Measure Killer works with Power BI Service, scanning linked reports to safely clean shared datasets without needing extra software downloads.
Additionally, we're gearing up to launch an insightful tenant analysis feature. It will give a clear picture of your tenant's use, showing reports with custom visuals, the count of report-level measures, and frequent DAX expressions, all aimed at boosting your Power BI's performance and management.

GUEST BIO (Gregor Brunner) 👤

Gregor Brunner has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting. In 2022 his team started building Power BI external tool "Measure Killer".

RELATED CONTENT 🔗

Measure Killer
LinkedIn

(Livestream Replay) Creating a Measurement Framework - with Tommy Puglia

DESCRIPTION 📄

Let's face it. too many of our reporting solutions do not have the impact we expect, and it usually comes down to what we are measuring. Too many organizations may not be measuring the rights things and measuring them the right way. So how do we frame and move teams, users, and organizations to measure their metrics the right way, the way that causes impact? Tommy introduces the Measurement Framework, a project based plan that works with organizations and teams on calibrating their metrics to direct impact.

GUEST BIO (Tommy Puglia) 👤

Tommy is the founder of Puglia BI Consulting, a firm focused on advisory for Adoption & Process, Training, and Development around Power BI at organizations. He is currently leading various implementations of a new Training Program as well. He is the one of the co-hosts on the Explicit Measures Podcasts, a Power BI dedicated podcast that dives into the impact and the why around Microsoft's Power BI features, tools, and solutions. You can hear him along with Mike Carlo & Seth Bauer of PowerBI.tips every Tuesday and Thursday at 7:30am on YouTube.

RELATED CONTENT 🔗

Tommy's Website
Tommy's LinkedIn