#MSFABRICBRISTOL - April 25 - Python in Fabric & User Defined Formatting

When: Thursday 10th April 2025
Time: arrive for 5:45pm with talks starting from 6pm start prompt.

Location:
BJSS,
90 Victoria St,
Redcliffe,
BS1 6DP

Complimentary drinks & pizza provided by our hosts BJSS

Social drinks afterwards will be at Ye Shakespeare (50m away) for those interested.

This #MSFABRICBRISTOL will feature Sue Bayes and Antony Catella

Session 1 - Unleashing Python in Fabric: Supercharging Data Workflows & Power BI - Sue Bayes
Join us in Bristol for an immersive hour-long session that showcases the incredible power of Python within the Fabric environment. Discover how to effortlessly extract, clean, transform, and move data, and see how Python's versatility can streamline data workflows. In this demo-driven session, we’ll demonstrate how you can seamlessly integrate Python scripts with Fabric’s capabilities to create lightning-fast, scalable Power BI reports.
We'll also explore the new semantic-link-labs functionality to show how easy it is to automate Power BI documentation and processes using the power of Python. From data manipulation to real-time insights, this session is perfect for data enthusiasts and Power BI professionals looking to take their reporting to the next level using Python.
Don’t miss out on this hands-on opportunity to revolutionize your data processes!

About Sue
Sue Bayes is a Microsoft Data Platform MVP with over six years of independent consulting experience as a data analyst and Power BI developer, helping businesses harness the full potential of their data. Certified as a Fabric Analytics Engineer, an Azure Enterprise Data Analyst and Power BI Data Analyst Associate, Sue is passionate about leveraging the latest tools in Microsoft Fabric to provide end-to-end data engineering solutions, with a strong emphasis on integrating Python into workflows.
Her expertise spans a wide range of reporting solutions, from project management and financial reporting to bespoke data cleansing, sentiment analysis, and advanced data pipelines within the Fabric environment. Sue's technical skills include Python, SQL, R, and C#, but her real passion lies in Power BI's M language and DAX, which she uses to create high-performance, dynamic reports.
Before becoming an independent consultant, Sue spent 15 years lecturing in Business and Computing, helping to shape the next generation of data professionals. Her deep understanding of data engineering, paired with a love for creating streamlined, actionable insights, has made her a sought-after expert in both the public and private sectors.

Session 2 - User Defined Formatting in Power BI - Antony Catella
In general the formatting (column colours, display units, data label formats) in a Power BI report are fixed for the end user. How can we give end users the ability to format aspects of the visuals to suit their needs?
In this session, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow end users to change the formatting of visuals. We begin with the basic concepts of dynamic format strings, which allow for the customisation of displayed data based on context and user interactions. Attendees will then learn how to apply these strings in reports to enhance the readability of data visuals.
Moving onto the use of conditional formatting rules and expressions to change the colours of data points within visuals. We also demonstrate combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals.
By the end of this session, participants will have a comprehensive understanding of how to leverage these features and include them for their report end users.
About Antony
Antony works as a BI Consultant for a consultancy based in the UK, developing Power BI reports for multiple clients, primarily Non-Profit Organisations. Power BI is a rapidly evolving technology which is what he loves about it - constantly learning new things.

We all look forward to seeing you there!!