Ask the Expert - Group A (Thu 14:10 to 15:00)

Don’t Let Your Permissions Be Hijacked!

Learn how malicious users can lure a power user such as sysadmin to run code that performs action to the benefit of the evil user by something I call permission hijacking and what means you can take to prevent this from happening.

Packaging Permissions in Stored Procedures

Learn in this session how you can package any database- or server-level permission in a stored procedure with help of certificate signing or EXECUTE AS and why one method is to prefer over the other.

Zero to Lakehouse in Microsoft Fabric

Fabric is Microsoft's unified software as a service data platform, built around a Data Lakehouse architecture. In this session I'll share an array of data Lakehouse architecture patterns, and demonstrate how you can build a full Data Lakehouse platform without ever touching an Azure resource.

Building a Lakehouse on the Microsoft Intelligent Data Platform

This session session aims to give you that context. We'll look at how spark-based engines work and how we can use them within Synapse Analytics. We'll dig into Delta, the underlying file format that enables the Lakehouse, and take a tour of how the Synapse compute engines interact with it. Finally, we'll draw out our whole Lakehouse architecture

Designing Data Architectures that InfoSec will actually approve

In this session I'll guide you from through a secure reference architecture with Data Factory, Databricks, Data Lake, and Azure Synapse, working together as a secure, fully productionised platform. Each has their own idiosyncrasies, but this session will teach you the options available and the pitfalls to avoid.

Why the Lakehouse?

In this session I'll cover what the Data Lakehouse architecture is, where it fits against existing architectures like a data warehouse, and why you should build one. We'll also cover the underlying technology options to arm you with all of the information you need to plan your next data platform.

Keynote by The Community

Ben and Rob have found some wonderful folk to actually do the important parts of the community keynote. on the theme of How to be a nonpassive member of the data community

Optimising DAX fusion - Power BI

A deep dive into the Power BI DAX engine on how to optimise DAX fusion.

Analytics at the speed of Direct Lake

Advanced dive into the exciting new storage mode for Semantic Models.

One dataset and three use cases with Microsoft Fabric

Are you curious about how to leverage Open Data with Fabric? In this demo filled session, I will show you how I import World Bank Open Data into Fabric using different methods: Pipelines, Data factory Gen-II, Notebooks and a mix of all three. Then I will demonstrate how I do modelling using Warehouse, Power BI Dataset model and Notebooks. Finally, I will create stunning reports using Power BI. By the end of the session, attendees will get an idea of how each artifact would work, why one would use one over other artifacts, and understand how to create an end-to-end solution with Microsoft Fabric

Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks

Are you excited about Microsoft Fabric and its Notebooks feature, but also feel overwhelmed by the different languages it supports, this session is for you. You will learn the basics of Python and Spark, and how to use Notebooks to write and run code. You will also discover how to leverage tools like CoPilot to assist you with code suggestions and corrections. Moreover, you will see how to use libraries like SemPy to enrich your Power BI development with advanced analytics. Join Prathy in this session and get ready to explore the possibilities of Notebooks in Microsoft Fabric.

Demystifying Power BI Slicers and filters

When it comes to Power BI Reports design, both slicers and filters have their own space and use cases. However, Slicers and filters are probably among the most frequently misused terms in Power BI design. In this session, we will start with what are Power BI Slicers and filters. What are the differences between and when to use what? We will investigate the pros and cons of each and how to get the best of both filters and slicers in Power BI. By the end of the session, attendees will get an overall view of Power BI slicers and filters in Power BI designing.

Power BI bookmarks in 20 minutes

In this 20 minute session, you will learn everything you need to know about bookmarks. We will start with creating your first bookmark to multiple bookmarks by understanding advanced settings that usually get overlooked. We will also look at how we can ease the design and Maintainance of bookmarks by using features like grouping, renaming, selection pane, and naming conventions. By the end of the session, you will learn to apply bookmarks like a pro!

Power BI Report design Tips and Tricks

A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports

Introduction to PowerApps and Integration with Power BI

In this session, attendees learn about how to create PowerApps solutions, how to use PowerApps as data entry application for Power BI. How to integrate PowerApps in Power BI and Power BI in PowerApps.

Power BI deployment strategy for publishing and maintenance

It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.

Deep Dive into SSIDB Catalog

A session to understand the available functionality of SSISDB Catalog

The Dream Team: Synapse Analytics Serverless SQL Pools and Pipelines

Synapse Analytics Serverless SQL Pools and Pipelines are the dream team when it comes to managing big data in Azure Data Lake, this session will take you through the process!

How Leaders Can Support Their Employee’s Mental Health

Sometimes as leaders it's hard to know how to address the topic of of a an employee's mental health. Come to this session for come practical, straightforward strategies to be used to address a very difficult topic.

How To Get the Auditors Off Your Butt with dbachecks

Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.

Building Tomorrow's Warehouse Today: Modern Data Warehouse Modelling Insights

This session explores the fundamental shifts in data warehousing architecture and data processing design principles

The Decentralized Data Access Revolution

During this session, we will discuss why many companies shift towards decentralized data access architectures. We will discuss Data Mesh and Data Fabric paradigms, and explore their principles, benefits and challenges.

Analyzing Big Data in Azure cloud using Spark and Databricks

During this session, we will talk about Azure Databricks' key features, and typical scenarios where Spark can fit, will see a lot of demos and I will share my top list of Azure Databricks best practices.

Building Your Data Analytics Team - live RunAs Radio episode

Panel Discussion moderated by Richard Campbell of RunAs Radio!

Upgrade to First Class with Calculation Groups for Power BI

Learn how to create Calculation Groups in Power BI Desktop and Tabular Editor. Know how they work and what to watch out for as you create multiple Calculation Groups.