Ask the Expert - Group A (Wed 11:10 to 13:00)

An Evolution of Data Architectures - Lambda, Kappa, Delta, Mesh & Fabric

How has advancements in highly scalable cloud technology influenced the design principals we apply when building data platform solutions?

Building an Azure Data Analytics Platform End-to-End

Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.

Creating a Metadata Driven Orchestration Framework Using Azure Data Integration Pipelines

We'll explore delivering this framework within an enterprise and consider an architect’s perspective on a wider platform of ingestion/transformation workloads with multiple batches and execution stages.

ETL in Azure Made Easy with Data Factory Data Flows

What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure.

Using Azure DevOps for Azure Data Factory

DevOps as a concept does not always translate to the technology when implemented. In this session we'll explore that problem when working with Azure Data Factory and what the different cloud only CI/CD options are.

Complex Azure Orchestration w Dynamic Data Factory Pipelines

If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you.

Building an End to End IoT Solution Using Pi Sensors & Azure

Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.

Scanning the skies above SQLBits - Realtime streaming of flight data with Microsoft Fabric

Using the real-time analytics capabilities of Microsoft Fabric we'll stream aircraft transponder data via a Raspberry PI and antenna into Microsoft Fabric. Through an end-to-end demo, we'll use Eventstream and KQL database to ingest the current locations of 100s of aircraft as they fly above the SQLBits venue. We'll then display and analyse these aircraft in Power BI, and use KQL DB's powerful spatial functions to determine the which parts of the area experience the most amount of air traffic.

Power BI Map Magic - Make amazing maps with Power BI

Liven up your Power BI reports with spatial analytics. Which visuals fit best for different map types with a deep dive of more advanced mapping themes.

Let's define Entities and attributes for tabular models in 20 minutes.

Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.

Lets play with a date field & Time Intelligence in Power BI

Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise

Lets do the cleansing with M and / or Python languages

This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.

Some transformations that can save your ETL in Power BI

To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.

Avoiding Turbulent Skies: Power BI Security Strategies for a Smooth Flight

As organizations increasingly adopt Power BI to transform data into actionable insights, the paramount concern is ensuring data security and compliance. This will delve into the intricacies of Power BI security, offering a comprehensive exploration of best practices, features, and strategies that safeguard your data assets.

"Beyond the barchart". Some top picks from "Get More Visuals" to enhance your reports

PowerBI has 37 visuals available to you. However, just a few clicks away, there are 200+ visuals just waiting to enhance your reports. Join me as I give you a quick tour of what is available. From awesome to downright quirky.

0 to an fully functional teams bot in 20 minutes!

0 to an fully functional teams bot in 20 minutes!

Rebooting your SME Data Analysis Strategy

A review of how the Power Platform can be adopted by an organization to successfully meet their data needs. Based on real-world implementations with customers.

Migrating my favorite past project from On Premise to Azure

A few years ago I had a client with a data need and I built an IaaS solution. Now, it would have been an ideal fit for a PaaS approach using Azure DB, Stream Analytics and Power BI. This session demos and explains why.

Intro to Azure Data Studio

Learn all about Azure Data Studio

Sensitivity labels - what do they look like

In this session we will go through setting up sensitivity labels and see them across multiple platforms ( Power BI, Microsoft Fabric, Azure SQL, Azure Purview)

Power Up with the Power Platform

During the session I will demonstrate solutions using different integrations to achieve a business use case - Power BI with Power Apps - Power Apps with Power BI - Power BI and Power Automate - Power Automate and Power BI - Teams and Power BI

Keeping historical data in tables forever – mission (im)possible!

Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.

Modern database design (anti)patterns

We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.

SQL Server Table partitioning – DOs and DON’Ts

When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?

Identify opportunities for In-Memory OLTP

The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.

Analytics Architectures on Microsoft Fabric

On this presentation we will see different analytics architectures, discuss the advantages and disadvantages of those and how Microsoft Fabric is a platform that we can rely on to implement those different architectures.

Data Quality Revolution : The Fabric-OpenAI Approach

In this session, we'll walk you through practical techniques for handling various data issues, such as formatting problems, conversion, and more. Whether you're a seasoned data professional or just starting your data journey, this session will equip you with the skills and knowledge needed to turn chaotic datasets into valuable insights. Don't miss this opportunity to master the art of data cleaning with Fabric and Open AI.

Navigating the Skies of Open AI: Perfect Your Grounding for a Smooth Landing

Explore the evolution of knowledge consumption with ChatGPT in this insightful session. We'll dive into the importance of "grounding" in Large Language Model (LLM) applications and introduce you to the emerging world of vector databases. While delving into OpenAI's technology, participants will gain an understanding of vector embeddings, scalability challenges, and efficient data retrieval methods. Designed for data scientists, engineers, and decision-makers, this Level 300 session offers a balanced overview for both technical and non-technical attendees.

The Hitchhiker's Guide to navigating Power BI

Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.