dataMinds.be

Detailed information and registration can be found here :
https://dataminds.be/unlock-the-power-of-real-time-intelligence-in-fabric-with-kql/

# Unlock the Power of Real-Time Intelligence in Fabric With KQL

Session:
Real-time Intelligence in Microsoft Fabric empowers data professionals and business users to seamlessly process and analyze highly granular, event-driven data. At its core lies the Kusto engine and the Kusto Query Language (KQL), delivering powerful capabilities for real-time data analysis. This session explores how you can leverage KQL to build efficient, event-driven solutions in Fabric with real-world examples.

In this session, we will discuss:
– The role of Kusto in Real-Time Intelligence and Fabric, including its integration across the Real-Time Hub, Eventstream, Real-Time Dashboard, and Activator Fabric items.
– Key features of KQL that make it a game-changer for analysis of data in motion, including syntax, built-in functions, and operators, demonstrated through live queries on sample real-time data.
– How you can use Kusto and Real-Time Intelligence to monitor and govern your Fabric estate by cataloging workspace item, capacity utilization, and OneLake events in the Real-Time Hub.

Come along if you are a developer, data engineer, or analyst seeking practical examples and best practices for crafting KQL queries to drive real-time data analysis and actions. You will leave this session equipped with the skills to unlock the full potential of real-time data in Fabric.

Speakers:
Abhinav Jayanty | Data Engineer @ Quorum

Agenda (CET, UTC+1):

18u30 Welcome and introductions

18u30 Unlock the Power of Real-Time Intelligence in Fabric With KQL (60 minutes)

19u45 Session End

Detailed information and registration can be found here :
https://dataminds.be/practical-data-modeling-in-power-bi-beyond-the-star-schema/

# Practical Data Modeling in Power BI: Beyond the Star Schema

Session:
This session focuses on data modeling with a strong emphasis on real-world scenarios. A solid foundation is assumed: familiarity with the star schema, the importance of correct data types, and the core principles of a well-designed Power BI data model.

During the session, I go beyond theory and show how to make practical design choices when building fact tables. For example, when should you use a snapshot fact table? What types of business questions does it support, and how do you design such a structure correctly?

Slowly Changing Dimensions Type 2 are also covered. I demonstrate how to set up an SCD Type 2 dimension and, more importantly, how to create correct and reliable DAX calculations on top of it. The focus is not only on the technical implementation, but also on the reasoning behind these choices.

Many-to-many relationships are another key topic. What happens when data exists at different levels of granularity? When do issues arise? And is a bridge table always the right solution, or are there alternative approaches, for example when dealing with budget data?

In short, this session goes beyond the classic star schema. It presents practical solutions for realistic modeling challenges, because customer data models are rarely as clean and straightforward as the well-known Contoso example.

Speakers:
Peter van den Bos | Freelance Business Intelligence Consultant

Agenda (CET, UTC+1):

18u30 Welcome and introductions

18u30 Practical Data Modeling in Power BI: Beyond the Star Schema (60 minutes)

19u45 Session End