Steve Campbell

As we journey through designing strategy to implementing policies, we will dive into the creation of process maps and establishing roles and responsibilities through the RACI model. Attendees will gain a comprehensive understanding of the Optimized Architectures Document, which serves as a blueprint for optimizing content delivery infrastructure. Architecture will highlight asset certification and endorsement. On top, we'll see how Fabric architectures contribute and what needs to be included. Walk away equipped with a toolkit of proven methodologies and real-world-tested frameworks. Armed with these insights, you'll be poised to not only design but also implement effective and secure content delivery architectures within your organization. The session is for those who are responsible for, or involved in, rolling out, governing, or designing Power BI architecture, or interested in expanding their knowledge of Power BI Governance.

This session explains enhanced refresh techniques in Power BI, extending with end-to-end enterprise grade metadata driven pipelines in Fabric. It is suitable for aspiring data analysts and Power BI engineers looking to improve their ability to design scalable, flexible, and maintainable data solutions. First, we will cover enhanced refreshes and partitions in Power BI. This is needed for incremental or custom refresh patterns. Next we will deconstruct the refresh process, learning how to measure and optimise it. After this, we will learn how to build a metadata-driven framework using Fabric. This uses an external data source, such as a SQL table or a JSON file to dynamically control the pipeline behaviour, rather than hardcoding those details. This is key for enterprise solutions as it reduces duplication, improves scalability, and simplifies maintenance. We will then use this pipeline to send requests to refresh tables incrementally or full loads. We can also send custom requests to refresh only specific tables end-to-end, including source loads, transformations, and loading to the Power BI semantic model. Audience: • BI/SQL Professionals looking to broaden their knowledge of data engineering. • Data Analysts seeking to deepen their understanding of data architecture. • Power BI Engineers aiming to master scalable data pipeline architectures. Prerequisites: Basic familiarity with Power BI, Fabric, Pipelines, and fundamental data engineering principles. Knowledge of Python or SQL is helpful but not mandatory. All topics will be explained clearly and advanced knowledge of any tool is not needed.

Power BI Desktop shines with the right tooling. This workshop dives into external tools, governance services, modern modeling features, and scalable self-service patterns so you can build reliable, high-quality semantic models end to end.

Learn how to design and maintain a clean, scalable Power BI semantic model that supports growth and self-service. We’ll cover what belongs in the core model vs. the report layer, how to extend safely with composite models, when to use UDFs vs. calculation groups, and how tools like Tabular...

Solid data architecture is key for a scalable and maintainable pipeline, but can be difficult to implement.This session is for those familiar with Power BI or new data engineers, providing a step-by-step guide to Bronze, Silver, and Gold layers.Users will gain an overview of Medallion Architecture, Warehouses and Lakehouses, Delta and Parquet, GIT integration, monitoring, and compare available...

Microsoft Fabric is a lake-centric data analytics platform, focused around Microsoft OneLake. A core feature of Fabric is that data items, like data warehouses and lakehouses, store their data automatically in OneLake in Delta format.

Microsoft Fabric is a lake-centric data analytics platform, focused around OneLake. A core feature of Fabric is that all data items, like data warehouses and lakehouses, store their data automatically in OneLake in Delta format.

Transform your data solutions with a streamlined Medallion Architecture using Microsoft Fabric. This session is tailored for professionals familiar with Power BI and basic dataflows, providing a step-by-step guide to implementing Bronze, Silver, and Gold layers for a scalable and maintainable pipeline.

This session will guide you through the basics of version control, ensuring you understand its significance for efficient Power BI project management. We will introduce you to GIT, a widely used version control system, without delving into intricate code or overly technical jargon.

Developers often create excellent reports, only to be asked for data exports to Excel. Ultimately, users want only one thing: easy access to data that helps them do their job.

Transform your data solutions with a streamlined Medallion Architecture using Microsoft Fabric. This session is tailored for professionals familiar with Power BI and basic dataflows, providing a step-by-step guide to implementing Bronze, Silver, and Gold layers for a scalable and maintainable...

Transform your data solutions with a streamlined Medallion Architecture using Microsoft Fabric. This session is tailored for professionals familiar with Power BI and basic dataflows, providing a step-by-step guide to implementing Bronze, Silver, and Gold layers for a scalable and maintainable...

Developers often create excellent reports, only to be asked for data exports to Excel. Ultimately, users want only one thing: easy access to data that helps them do their job.

This session aims to demystify the concept of filter context, illustrating how it interacts with other contexts such as row context. We will explore how DAX processes and modifies filter context through various functions and expressions, demonstrating with how it influences the behavior of measures. This will be a theoretical session, looking to understand the specific theory and how filter context works under the surface. Attendees will learn how to effectively manipulate filter context to build more intuitive and responsive data models. The session is designed for intermediate users looking to deepen their understanding of DAX and enhance their skills.

This course is designed for users who want to learn to enhance Power BI models for enterprise deployment, creating sharing strategies, and ensuring security. In this course, you will learn valuable tools and skills to create, configure, and manage enterprise-grade Power BI models and take your organization's data analytics to the next level. First, the session will review how to architect models for enterprise. It will look at configuring tables, columns, hierarchies, and measures using tools such as Tabular Editor. It covers advanced features such as incremental refresh and Next, we’ll look at the deployment of Power BI models and how to manage the content effectively. It covers version control, DevOps, and build and deployment pipelines. We’ll look at a range of tools such as Tabular Editor, Visual Studio, Azure DevOps, or GitHub. We’ll cover all terminology at a introductory level so you won’t get left behind. You will learn publication options, how to configure datasets, refresh and monitor datasets, very large datasets, configure workspaces, and control workspace access. We’ll cover different sharing strategies for sharing distributing content and how to collaborate with workspaces and compare different sharing techniques. You will learn how to configure role-based access control (RBAC), implement RLS and OLS, and apply security labels. We’ll learn some common data leak pitfalls and how to avoid them. Participants should have a basic understanding of Power BI and data modeling concepts, including tables, relationships, and measures. Prior experience with Tabular Editor and DevOps is not required, but it may be helpful.