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!!

Fabric 101

This session will be an introduction to Microsoft Fabric, covering various aspects of Microsoft Fabric:

• What is Microsoft Fabric?
• Microsoft Fabric Experiences
• Onelake
• Capacities
• Data Ingestion
• Data Storage
• Data Analytics

The idea of this session to give attendees a high level overview of Fabric as we have a number of in-depth sessions on MS Fabric in January 2025.

Antony works as a BI Consultant at Adroit Data & Insight in the UK working primarily with Non-Profits to develop Power BI reports for them and provide Power BI training for their staff.

It is time for the November meetup!

This online meetup will feature Antony Catella talking about dynamic formatting in Power BI!

Title: Dynamic Formatting in Power BI using dynamic format strings and conditional formatting

Abstract: In general formatting of visuals in a Power BI report are fixed for the end user. How can we give end users more flexibility to format the visuals for their requirements? In this presentation, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow dynamic formatting of visuals. We begin with an overview of the basic concepts of dynamic format strings, which allow for the customisation of displayed data based on context and user interactions. Attendees will learn how to apply these strings to enhance the readability of data visuals. Moving onto the intricacies of conditional formatting and demonstrating how to use rules and expressions to highlight data points within visuals. We also demo combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals. By the end of this presentation, participants will have a comprehensive understanding of how to leverage these features to transform their Power BI reports into dynamic, insightful, and visually appealing tools for data analysis.

As usual, we'll start at 1900 on Teams, enjoy the session, and finish off with some news from the world of Power BI and Fabric.

See you in November!

Speaker: Antony Catella Start Date: Thu, Sep 19th 2024 · 7:00 PM EEST (4:00 PM UTC) Language: ENGLIGH Location: Online (link visible for attendees)

===============================================================

Description:

In general formatting of visuals in a Power BI report are fixed for the end user. How can we give end users more flexibility to format the visuals for their requirements?

In this presentation, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow dynamic formatting of visuals. We begin with an overview of the basic concepts of dynamic format strings, which allow for the customisation of displayed data based on context and user interactions. Attendees will learn how to apply these strings to enhance the readability of data visuals.

Moving onto the intricacies of conditional formatting and demonstrating how to use rules and expressions to highlight data points within visuals. We also demo combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals.

By the end of this presentation, participants will have a comprehensive understanding of how to leverage these features to transform their Power BI reports into dynamic, insightful, and visually appealing tools for data analysis.

===============================================================

At the end of the Meetup we'll have a Raffle with prizes offered by Enterprise DNA: 2 (two) 1 year FREE Membership Licenses on EDNA Platform for two lucky winners from the Live attendees !

===============================================================

Speaker: Antony Catella Senior BI Consultant

Antony is a BI Consultant @ Adroit Data & Insight Consultancy, UK, working primarily with Non-Profits to develop Power BI reports for them and provide Power BI training for their staff.

I am passionate about the natural world and enjoy mountain biking and baking in my spare time.

Connect with Antony here:

• LinkedIn

Session Description:

In general formatting of visuals in a Power BI report are fixed for the end user. How can we give end users more flexibility to format the visuals for their requirements?

In this presentation, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow dynamic formatting of visuals. We begin with an overview of the basic concepts of dynamic format strings, which allow for the customisation of displayed data based on context and user interactions. Attendees will learn how to apply these strings to enhance the readability of data visuals.

Moving onto the intricacies of conditional formatting and demonstrating how to use rules and expressions to highlight data points within visuals. We also demo combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals.

By the end of this presentation, participants will have a comprehensive understanding of how to leverage these features to transform their Power BI reports into dynamic, insightful, and visually appealing tools for data analysis.

Bio: Antony is a BI Consultant @ Adroit Data & Insight Consultancy, UK, working primarily with Non-Profits to develop Power BI reports for them and provide Power BI training for their staff.

I am passionate about the natural world and enjoy mountain biking and baking in my spare time.

https://www.linkedin.com/in/antonycatella/

Speaker: Antony Catella Start Date: Thu, Dec 21st 2023 · 7:00 PM EEST (5:00 PM GMT) Language: ENGLIGH Location: Online (link visible for attendees)

===============================================================

Description:

Ready to ramp up your report game?

Let's dive into "Field Parameters: The Swiss Army Knife of Dynamic Charts." Ever felt handcuffed by rigid visuals? Break free. One report, endless possibilities. This session's your key to unlocking them.

I'll walk you through field parameters, step-by-step.

Your audience? They'll navigate their data like pros, on their terms. No more one-size-fits-all nonsense.

===============================================================

At the end of the Meetup we'll have a Raffle with prizes offered by Enterprise DNA: 2 (two) 1 year FREE Membership Licenses on EDNA Platform for two lucky winners from the Live attendees !

===============================================================

Speaker: Antony Catella Power BI Consultant

I work 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 I love about it - the need to constantly learn.

Connect with Antony here:

• LinkedIn

Session: Ready to ramp up your report game? Let's dive into "Field Parameters: The Swiss Army Knife of Dynamic Charts."

Ever felt handcuffed by rigid visuals? Break free. One report, endless possibilities. This session's your key to unlocking them. I'll walk you through field parameters, step-by-step. Your audience? They'll navigate their data like pros, on their terms. No more one-size-fits-all nonsense.

Speaker: Antony Catella 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.

Session:

Exploring Field Parameters - making your charts more dynamic In this session Antony will show us how to implement field parameters in a report and allow multiple users to explore their data in a structured manner. An Excel pivot table can be very useful to explore data. So how can we replicate that functionality within a Power BI report - enter Field Parameters. Speaker: Antony Catella I work 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 I love about it - the need to constantly learn. https://www.linkedin.com/in/antonycatella/