🇬🇧 Insights into Power BI & Fabric Governance, Administration, and Capacity Monitoring en

In this training day, we’ll dive into the essentials of effectively governing and managing Power BI/Fabric environments. You will gain insight into key administrative tasks, capacity management, and monitoring best practices to ensure optimal performance and resource utilization within their Fabric deployment.

By the end of this session, you will:
* Understand the role and responsibilities of a Fabric administrator
* Be equipped to manage and optimize Fabric capacities, including using the bursting and smoothing options
* Gain hands-on knowledge of tools such as the Fabric Capacity Metrics App and Admin Monitoring workspace to establish operational efficiency
* Learn about best practices for capacity planning, automation, and cost management in a Fabric deployment
* Walk away with troubleshooting techniques to maintain a high-performing Fabric environment

Topics covered during the day:
* The role of the Fabric Administrator: An overview of the permissions, responsibilities, and tools available to administrators within the Fabric environment
* Admin Monitoring Workspace: Explore the Admin Monitoring workspace to keep track of performance, potential issues, and system health
* Security and Compliance Monitoring: Ensuring compliance and security standards within Fabric, including audit logs
* Understanding Fabric Capacities: Dive into the mechanics of capacity units, resource allocation, and the different capacity management features such as bursting and smoothing
* Capacity Metrics App: Learn to leverage the Capacity Metrics App to gain insights into resource utilization, demand patterns, and allocation
* Capacity Planning and Optimization: Best practices for planning capacity needs and optimizing resources based on organizational demands
* Automation and Alerts: Implementing automated alerts, notifications, and actions based on capacity and usage thresholds
* Troubleshooting and Diagnostics: Identifying and addressing common issues within Fabric environments, focusing on proactive diagnostic tools

Key takeaways:
* Comprehensive understanding of Fabric governance and administration tasks
* Practical skills to manage and monitor performance in Fabric capacities
* Tools for proactive management and troubleshooting
* Strategies for ensuring compliance, security, and cost-efficiency

This session's target audience:
* Fabric Administrators and IT professionals responsible for managing Fabric environments
* IT Managers and leaders interested in governance and capacity planning
* System Analysts and Engineers who want to broaden their skillset and need insights into monitoring and optimization techniques
* Compliance Officers looking to understand Fabric’s audit and monitoring capabilities

This interactive session will provide valuable insights for both new and experienced professionals aiming to streamline governance and optimize the performance of their Fabric environments. There will also be plenty of time to bring your own problems to the table.

Optimizing Your Power BI Workflow with Project Files, Source Control, and TMDL en

Imagine you're part of a dynamic analytics team at a rapidly growing tech company. Your team relies heavily on Power BI to create insightful reports and dashboards that drive key business decisions. However, as the volume of data increases and more team members contribute to the projects, you start encountering challenges: messy project files, difficulty in tracking changes, and complex data models that are hard to manage.
One day, your team lead calls a meeting. She shares a story about another department that faced similar issues but managed to turn things around. Their secret? Implementing a structured approach to managing Power BI project files, using source control to track every change, and leveraging Tabular Model Definition Language (TMDL) to handle their complex data models. Inspired, your team decides to adopt these practices.
Fast forward a few months, and your team's workflow has transformed. Projects are well-organized, changes are easily tracked, and data models are efficiently managed. Reports are more accurate, collaboration is smoother, and your team's productivity has soared. This presentation will guide you through these strategies, showing you how to replicate this success in your own Power BI projects.

In this session, I will guide you through these strategies, demonstrating how to replicate this success in your own Power BI projects.
By the end of this session, you will be equipped with practical knowledge and tools to optimize their Power BI workflows, ensuring their data analytics projects are well-organized, versioned, and scalable.
We will start with a regular PBIX-file and gradually transform it into an organized, versioned model. Using Visual Studio Code, we will set up source control in Azure DevOps with the PBIP-format, apply TMDL and eventually integrate Git into the workspace.
Note: This session assumes a basic understanding of Power BI. Fundamentals of source control and branching will not be covered.

Fabric Capacity Metrics Demystified en

In the world of Power BI and Fabric we talk a lot about capacities, whether it's Premium Capacities or Fabric Capacities. However, when working on Power BI or Fabric these capacities often remain a bit unknown. How do they actually work? You've heard of this concept called 'bursting', what does that actually mean? How do you know if you're not paying too much for your capacity?

In this session, I will take you through the ins-and-outs of your capacity(ies). Starting with some key concepts on capacities and how they work, we'll quickly dive into how they operate and how your usage is actually charged to your capacity. Finally we'll look into some practical examples on managing your capacity, leveraging the Fabric REST APIs and Semantic Link to some really cool stuff.

This session is mainly geared towards Fabric and/or Capacity Administrators, though a better understanding of capacities and how they work will also help content creators in developing more efficient solutions. The session requires no prior knowledge, though some familiarity with capacities and/or the Capacity Metrics App will definitely lead to you getting more value out of this session.

Day after Dashboard in a Day with Microsoft Fabric en nl

5 seconds to sign-up and 5 minutes to WOW! with Power BI - and now that you’ve learned the basics of Power BI along comes Microsoft Fabric! How can you leverage this new platform to take your skills to the next level and create stunning reports in the process?

Join us for this session where we’ll dive deeper into data preparation, data modeling and data visualization - incorporating the best practices, patterns, and customer stories that we’ve learned along the way.

In this session, you’ll learn how to:
• Use Data Factory with Power Query Online to transform and enrich your data sources
• How to use the web model editing experience to create semantic models optimized for scale and performance usability
• Design effective and engaging visuals that communicate your insights clearly and persuasively
And much more…

This session is delivered by Microsoft employees who work with Fabric (and Power BI) daily and work with some of the largest enterprise customers in the Netherlands.

Don’t miss this opportunity to learn how to take your Power BI talents to the next level. Register now!

The following prerequisites and setup must be done for successful completion of the labs:

• You must be connected to the internet.
• You must be signed up for a Microsoft Fabric account.
• You must have a premium capacity backed workspace, through Fabric, Fabric Trial or Power BI Premium
• You must download and install Power BI Desktop

Notebooks in Fabric: why Power BI Developer should care (greatly) en

By heart, I'm a developer in Power BI, focusing on semantic models. I speak DAX and M fluently (okay, fairly fluent). I started in data with T SQL. So, when notebooks using Spark were introduced with Microsoft Fabric I didn't see how that would influence my day-to-day all to much. Man, how wrong was I..

Built into Fabric Notebooks is a feature called 'Semantic Link'. This feature enables notebooks to connect to semantic models living within your environment. Even more, using notebooks you can interact with these semantic models. For example, you can run DAX queries against the model to extract data. You can also access the XMLA endpoint or call on APIs to actually make changes to your model. The possibilities are endless!

In this session we'll dive into a number of hands-on examples of notebooks greatly improving the life of the Power BI Developer. Assessing the impact of a change in the semantic model? Checking whether that report aligns with your best practices? Validating your data before after a refresh? Or do you want to monitor the size of your model over time? Everything is possible and I'll show you how! And the best thing is: you barely need to learn yet another programming language!

In this session an introduction of notebooks and the features used will be made. An intermediate knowledge of semantic models is recommended to follow along some of the more deep examples shown.

De dag ná Dashboard in a Day en nl

Data analist of Power BI Developer, deze sessie is voor jou!

Met Power BI heb je de basis al onder de knie, en nu komt Microsoft Fabric om de hoek kijken! Hoe kun je dit nieuwe platform benutten om jouw vaardigheden naar een hoger niveau te tillen en jouw impact te vergroten?
Doe mee aan deze sessie waarin we dieper ingaan op data preparatie, datamodellering en visualisatie. Wij nemen je mee in de techniek en vertellen je de verhalen, best practices, en patronen die wij door de jaren heen hebben geleerd.
Tijdens onze sessie leer je hoe je:
• Power Query in Data Factory kunt gebruiken om je data te transformeren en verrijken.
• De web modelling ervaring kunt benutten om semantische modellen te maken die zijn geoptimaliseerd voor schaalbaarheid en prestaties.
• Effectieve en boeiende visuals kunt ontwerpen waarmee je je inzichten duidelijk en overtuigend kunt communiceren.
En nog veel meer…
Deze sessie wordt verzorgd door Microsoft-medewerkers die dagelijks met Fabric (en Power BI) werken en samenwerken met enkele van de grootste klanten in Nederland en Europa.
Mis deze kans niet om je Power BI-vaardigheden naar een hoger niveau te tillen.

Voor een succesvolle afronding van de labs zijn de volgende vereisten en instellingen van toepassing:

• Je moet verbonden zijn met internet.
• Je moet je aanmelden voor een Microsoft Fabric-account.
• Je moet beschikken over een werkruimte met premium capaciteit, via Fabric, Fabric Trial of Power BI Premium.
• Je moet Power BI Desktop downloaden en installeren.

Unveiling Shadow IT: Empowering Users with Microsoft Fabric en

This session will explore how organizations can leverage Microsoft Fabric to gain insights into shadow IT activities within their enterprise. Often, when activities are not happening within the governed IT infrastructure, they still occur through tools like Excel, which will lead to a lack of visibility and control. By empowering users with the tools offered by Microsoft Fabric, organizations can not only gain insights into these activities but also unlock greater value from everyone working with data.

Many of my customers express concerns about wanting to restrict users from creating workspaces or performing certain actions, fearing they will lose track of their data and its whereabouts. Common fears include data sprawl, unauthorized data access, and compliance risks. However, it's crucial to understand that if business users are unable to achieve their goals within Power BI, they will find alternative methods that are likely invisible to the organization. This scenario represents a losing proposition.

During this session, we will focus on strategies to empower users while implementing guardrails to ensure they operate within safe boundaries. Some of these guardrails, like sensitivity labels, endorsements, or deployment pipelines, can be real gamechangers when used effectively. We will demonstrate how Microsoft Fabric can alleviate these common fears by providing robust tools for monitoring, managing, and securing data activities. Attendees will learn how to balance user empowerment with necessary controls to prevent data sprawl and maintain organizational oversight.

Strategies for managing your Fabric Capacities en

As a concept, Fabric Capacities are something that most of us aren't accustomed to. A Fabric Capacity offers you a SaaS service of self-managed compute and storage. However, as an Azure resource, it also has some inherent PaaS attributes with a Pay-as-you-go model and the possibility to pause your capacity altogether.

These aspects of Capacities cause questions with many Fabric users and admins alike. How do you choose the appropriate size of capacity, for example? And how do you go about sharing resources within your capacity, scaling your capacity, utilizing pause/resume options, and isolating selected workloads to prevent the noisy neighbor problem?

Fortunately, Fabric capacities also offer a wonderful array of opportunities for dealing with these challenges and, even more interestingly, optimizing your setup. This session will focus on these opportunities. We'll investigate several strategies you can leverage to protect your most important workloads and how you can use the right tools to prevent capacity constraints from impacting your environment.

We'll dive into the mechanics of Fabric Capacities, exploring concepts like bursting and smoothing, and how they can help you manage your compute limits effectively. Additionally, we'll discuss practical tips for monitoring capacity usage, optimizing resource allocation, and the tools you can use to automate these processes. By the end of this session, you'll have a clear understanding of how to manage and optimize your Fabric Capacities to ensure seamless performance and cost-efficiency.

In this session we'll quickly revisit the basics of capacities and how they operate, however, some prior knowledge on these capacities (especially on the bursting and smoothing mechanisms) will greatly benefit the audience.