Ask the Expert - Group A (Fri, 16:20 to 16:40)

Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights

This session focuses on how dbatools has revolutionized automation for Database Administrators (DBAs) in the SQL Server realm. It delves into the utilization of various dbatools cmdlets and practical applications. Participants will gain insights into performing migrations, setting up availability groups, data management within databases, and the backup and restoration of databases. These techniques are derived from real-world client scenarios encountered during the presenter's consulting practice.

What does Microsoft Fabric mean for a Finance/Business Analyst?

For a business team such as Finance, Microsoft Fabric allows you to go from being “IT reliant” to “IT enabled” and this session shows you how! Whether you’re a data explorer, data analyst, data engineer – or perhaps a newly coined analytics engineer – we will explore what Microsoft Fabric means for you. We will look at the need for the data platform components in Fabric, applied for a finance data use case, and consider the benefits of this being in a SaaS lakehouse architecture. We will also consider how you need to organise your Finance and IT teams to work best with Fabric so that you have the right capabilities to deliver meaningful financial insights at scale.

Prepare for Takeoff: Navigating Power BI Developer Mode - Is the Journey Worth the Flight?

The new Power BI Developer Mode changes dataset and report development, providing a faster, more accessible approach. This mode includes source control and seamless integration with DevOps and Fabric, making it an impressive tool for advanced users and IT professionals. However, the good news is that you don't need to be a full-time developer or have an extensive IT background to benefit from this feature. In this session, I will demonstrate how you can take advantage of Developer Mode without the need for advanced integrations like DevOps and Fabric.

Mastering Power BI Design with User-Centric Frameworks

Key to Power BI report success and user adoption is a deep understanding of the consumer. This session will explore essential tools and strategies that enable you to gain valuable insights into your audience's information and experience needs. From this, the presenter will delve into practical techniques for shaping and crafting a compelling data story or data application for your audience.

End-to-end data validation strategies in Microsoft Fabric

A strategic look at the WHY, WHEN, and HOW of validating your data through each stage of a medallion-style architecture in Microsoft Fabric. Your end-users will be glad you came to this talk.

Mastering Rapid Power BI Development with ChatGPT: A Deep Dive

This session offers a deep dive into how to leverage ChatGPT for your Power BI development, from generating power query, images, and cmdlets, to crafting intricate DAX with SVG and CSS.