(Livestream Replay) PowerShell Hacks for Power BI - with James Bartlett

ABSTRACT 📝

There's never a dull moment in the life of a Power BI Administrator. In order to protect our time and sanity, it's important to automate as many of our usual tasks and processes as possible. Additionally, since the top priority of the Power BI development team is the end user experience, there are many edge cases and "power user" type activities that cannot yet be accomplished using only Power BI Desktop and the Power BI web service.

Fortunately, Microsoft has provided two priceless tools that allow us to automate and add functionality to Power BI: The Power BI REST APIs and the MicrosoftPowerBIMgmt module for PowerShell. This presentation will demonstrate several techniques for harnessing these powerful tools to make your job as a Power BI Administrator less time-consuming and more fun!

GUEST BIO 👤

James D. Bartlett III is a Senior Business Intelligence Analyst and Power BI Administrator at Des Moines University in Iowa, USA. He started working in IT way back in 2002, while he was a student in the Business Administration program at Colorado State University. After graduation, James dabbled in banking, real estate, healthcare, and even had a short stint as a resident DJ at Denver's top nightclub, before finally stumbling upon his true calling in the Business Intelligence field in 2018. James is a blogger and co-developer of the Business Ops app on PowerBI.tips, co-leader of the Iowa Power BI User Group, and recently completed his Microsoft Power BI Data Analyst Associate certification. In his spare time, James enjoys longboarding, playing the guitar, and producing electronic music in his home studio.

RELATED CONTENT 🔗

Power BI REST APIs
PowerShell Module
James’ Blog
James’ LinkedIn
James’ Twitter
James’ GitHub

(Livestream Replay) Configuring Incremental Refresh PBI-Tools - with Mathias Thierbach

ABSTRACT 📝

You've heard about Power BI Incremental Refresh for datasets but you're missing powerful tooling? pbi-tools is here to help! Learn how pbi-tools supports you manage, configure, monitor and optimize incremental refresh for your largest datasets. Ask questions and see demos how to automate deploying and refreshing incremental refresh datasets. You'll hear about refresh policies, auto-managed partitions, effective date and many more technical details.

GUEST BIO 👤

In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.

RELATED CONTENT 🔗

PBI Tools
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub

(Livestream Replay) Exploring Azure Synapse Analytics - with Eric Gleiter & Justin Moen

ABSTRACT 📝

Have you considered using Azure Synapse Analytics? You may have wondered how it differs from some of the other Azure tools you're familiar with (such as Data Factory, Data Lake Gen2, SQL Data Warehouse, etc.) and when you should use Synapse over the others. We'll review what Azure Synapse is, how to get started using it, some "gotchas" to watch out for, and we'll show how we help get data into Synapse in an organized and usable way for reporting and analytics in a matter of weeks.

GUEST BIO 👤

Justin Moen is a business intelligence professional who has a passion for working with data and working with his clients to leverage data as a competitive advantage. Over the past 20 years, Justin has worked with many database solutions, such as Oracle, SQL Server, and Snowflake. He is quick at mastering new tools and has a great understanding of current trends in the industry. To complement his technical knowledge, Justin is excellent at working with both business and IT team members to help bring both sides together to produce strategies and solutions that propel businesses forward.

Eric Gleiter is a dedicated and driven application developer knowledgeable in a wide variety of tools. He is experienced in Data Governance and Data Engineering. His ability to learn and digest new information and technologies enables him to quickly understand, implement, and innovate solutions to client’s needs. Eric's mathematics background makes him both flexible and rigorous when it comes to implementing solutions- enabling him to break down complex problems into manageable parts that can be quickly addressed- allowing for fast and effective solutions.

RELATED CONTENT 🔗

Website
Eric's LinkedIn
Justin LinkedIn

(Livestream Replay) Sharing Power BI Content with Multiple Audiences - with Tom Martens

ABSTRACT 📝

Supporting multiple audiences with Power BI Apps has finally arrived! Now it’s possible to provide content to different audiences from within a single app. An audience is a group of consumers, that now can be provided the information in need without creating multiple apps, duplicating data, and various versions of the same report. Solution design will become more simple, and information will travel faster. An introduction into this feature is provided, plus how it will be configured, and why Azure security groups are so important, and how this feature will impact our report design.

GUEST BIO 👤

Thomas "Tom" Martens has been awarded as an MSFT Data Platform MVP and works as Solution Architect at Munich Re (www.munichre.com). For 20+ years, Tom delivers Business Intelligence, Data Warehousing, and Analytics solutions. His current interest is in data visualization and applying analytical methods to small and large amounts of data, next to providing the Power BI Platform to users for tackling analytical challenges. Tom is a regular speaker at international conferences and user meetings. Tom is the co-author of the book "Pro DAX with Power BI."

RELATED CONTENT 🔗

Tom's Website
Tom's Twitter
Tom's LinkedIn