• Data Warehousing with Snowflake - Christina Leo

    Online event

    Microsoft Data Platform Group Birmingham - Thursday 7th October 2021 @ 1:00pm BST.

    Session: Data Warehousing with Snowflake - Christina Leo

    Abstract:

    In this session, you'll learn about the Snowflake Data Cloud Platform. We will talk about what features make Snowflake different from other Azure databases, discuss where it fits in the wider Azure ecosystem, and look at what decision points might influence your choices when designing your modern data warehouse architecture. This will be a high-level architectural discussion with some basic demos to highlight Snowflake functionality. Robust audience interaction is very welcome.

    Speaker Bio:

    Christina Leo is a Senior Partner Sales Engineer at Snowflake enabling ISV partners to make the most of their integrations with The Data Cloud.
    She joined Snowflake in April of this year after spending five years as a Solution Architect with Microsoft. Prior to that, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn't sharing her 20 years of technical expertise with the data community, you can find her racing around the Solent on a sailboat or often competing in longer offshore races.

    Agenda:

    12.45pm – 1:00pm : Setup and Join

    1:00pm - 1.05pm : Introductions

    1:05pm - 2:30pm : Data Warehousing with Snowflake

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:

    Purple Frog Systems
    PowerBI Sentinel

  • Machine Learning in Azure Synapse - MVP Terry McCann

    Online event

    Microsoft Data Platform Group Birmingham - Thursday 2nd September 2021 @ 1:00pm BST.

    Session: Machine Learning in Azure Synapse - MVP Terry McCann

    Abstract:

    There is a lot of content available on Synapse for Data Engineering, but what about Machine Learning? In this session we will look at how to Azure Synapse handles Machine Learning and also to integrate a SparkML model in Synapse.

    Speaker Bio:

    Terry is the Director of Artificial Intelligence for Advancing Analytics and Microsoft Artificial Intelligence MVP. His focus is on all things AI and Data Science. Terry has a passion for applying traditional Software Engineering techniques to Data, to improve the way teams deliver Machine Learning projects. Terry holds an Masters degree in Machine Learning and is continually interested in the application of academic research in industry. Terry is the host of the popular podcast Data Science in Production, where he interviews leading Data Scientists. His spare time is spent with his wife and two boys in their home in Devon.

    Agenda:

    12.45pm – 1:00pm : Setup and Join

    1:00pm - 1.05pm : Introductions

    1:05pm - 2:30pm : Machine Learning in Azure Synapse

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:

    Purple Frog Systems
    PowerBI Sentinel

  • Building an Empire - Implementing PowerBI Step by Step - MVP Alexander Arvidsson

    Microsoft Data Platform Group Birmingham - Thursday 5th August 2021 @ 1:00pm BST.

    Session: Building an Empire - Implementing Power BI Step by Step! MVP Alexander Arvidsson

    Abstract:

    Trying to implement a BI project can be extremely tedious, take unreasonable amounts of time and in the end turn out to be something that the users didn't want.

    This session goes through how to use Power BI and dataflows to iteratively build a BI solution - starting from the absolute beginning with just an excel file, moving to combining data from several data sources, and finally explaining how to use Power BI dataflows and shared datasets to deliver maximum analytical power to the right users with a minimum of wasted time. You will walk away with new ideas how to start and grow your BI projects as well as an insight into Power BI dataflows and its uses.

    Speaker Bio:

    I make data matter, as only data that matter can inspire change.
    You hire me to answer questions you have, and help you find answers to questions you didn’t even know you needed to ask.

    I use my 25 years of data experience to guide you in choosing the right tools, methods and solutions from the vast sea of opportunity and challenge that is today’s data landscape.

    I am a very experienced technical expert, international speaker, speaker trainer, and Microsoft Certified Trainer, focusing on Microsoft data platform technologies such as SQL Server, Azure Synapse Analytics, Power BI and Azure Data Lake.

    I am heavily involved in the international data community, and thanks to my contributions over the years I have been awarded the Microsoft Most Valuable Professional (MVP) award in the Data Platform category since 2018.

    I run the Swedish Power BI User Group, I speak at several international conferences every year, I co-host a podcast called Knee-Deep in Tech and I have authored courses for Pluralsight.

    I live in the metropolis of Linköping, Sweden, with my wife, two cats and way too much Star Wars stuff.

    Oh yeah – and I hate cold weather.

    Twitter: @arcticdba

    Agenda:

    12.45pm – 1:00pm : Setup and Join

    1:00pm - 1.05pm : Introductions

    1:05pm - 2:30pm : Building an Empire - Implementing Power BI Step by Step

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:

    Purple Frog Systems
    PowerBI Sentinel

    4
  • Power BI Tips & Tricks! Back to back lightning talks with the Purple Frog Team!

    Microsoft Data Platform Group Birmingham - Thursday 1st July 2021 @ 1:00pm BST.

    Session: Power BI Tips & Tricks! Back to back lightning talks with the Purple Frog Team!

    Abstract:

    Join the Purple Frog Team for 6 x back to back 5 - 10 minute lightning talks related to all things Power BI!

    Lightning Talk 1 : Joe Billingham
    Dynamic Visuals using Bookmarks in Power BI

    Lightning Talk 2 : Nick Edwards
    Windowing functions in Power Query

    Lightning Talk 3 : Jeet Kainth
    Improving your DAX game with VAR

    Lightning Talk 4 : Jon Fletcher
    Using Python visual in Power BI

    Lightning Talk 5 : MVP Alex Whittles
    Composite Models in Power BI

    Lightning Talk 6 : Reiss McSporran
    Scale up direct query over Synapse SQL pool

    Agenda:

    12.30pm – 1:00pm : Setup and Join

    1:00pm - 1.05pm : Introductions

    1:05pm - 2:15pm : Power BI Tips & Tricks! Back to back Power BI lightning talks with the Purple Frog Team!

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:

    Purple Frog Systems
    PowerBI Sentinel

    1
  • Demystifying Power BI Datasets with Peter Myers & Chris Webb

    Microsoft Data Platform Group Birmingham - Thursday 3rd June 2021 @ 1:00pm BST.

    Session:

    Abstract: Demystifying Power BI Datasets with Peter Myers & Chris Webb

    Demystifying Power BI Datasets

    When it comes to Power BI datasets, there are often many questions. Like, isn’t DirectQuery and Live Connection the same thing? What’s the difference between a local and remote model? What is chaining?

    Join Microsoft Data Platform MVP Peter Myers and Power BI CAT Principal Program Manager Chris Webb to learn about all of this and more. Together, they have over 40 years’ experience delivering analytic solutions on the Microsoft data platform.

    In a conversational way, they’ll introduce and define over 50 dataset-related terms—and most importantly, explain how they relate to one another. This session will no doubt be valuable for beginners as well as advanced practitioners. We’re sure you’ll learn something unexpected!

    Agenda:

    12.30pm – 1:00pm : Setup and Join

    1:00pm - 1.05pm : Introductions

    1:05pm - 2:15pm : Demystifying Power BI Datasets with Peter Myers & Chris Webb

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    ***Link now live as of 9am 26/05/21***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:

    Purple Frog Systems
    PowerBI Sentinel

    4
  • ETL In Azure Made Easy With Integration Pipeline Data Flows - Paul Andrew

    Microsoft Data Platform Group Birmingham - Thursday 6th May 2021 @ 1:00pm

    Session: ETL in Azure Made Easy with Integration Pipeline Data Flows with Paul Andrew

    Abstract:

    ETL in Azure Made Easy with Integration Pipeline Data Flows

    What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a set of feature rich, graphical, scalable data transformation capabilities to rival the ETL tech we’ve previously had available in Azure.

    In this session we will look at Azure Data Factory/Synapse Analytics Integration Pipelines and how they offer a powerful abstraction over the Apache Spark analytics ecosystem. If you have ever transformed datasets using SQL Server Integration Services (SSIS) packages or via Power BI’s Power Query tool, this is the session for you.

    Now we can transform data in Azure using our favourite pipeline interfaces but with the support of Spark compute to do the heavy lifting. In this session you will get a quick introduction to the core Integration Pipeline components before we go deeper into the resource Data Flow features. Start using cloud native technology with distributed compute in a convenient, easy to use and rich set of graphical interfaces.

    Speaker Bio:

    Group Manager & Analytics Architect specialising in big data solutions on the Microsoft Azure cloud platform.

    Data engineering competencies include Azure Synapse Analytics, Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps and of course the complete SQL Server business intelligence stack.

    Many years’ experience working within healthcare, retail and gaming verticals delivering analytics using industry leading methods and technical design patterns.

    STEM ambassador and very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally.

    Father, husband, swimmer, cyclist, runner, blood donor, geek, Lego and Star Wars fan!

    Agenda:

    12.30pm – 1:00pm Setup and Join

    1:00pm - 1.05pm Introductions

    1:05pm - 2:15pm ETL in Azure Made Easy with Integration Pipeline Data Flows with Paul Andrew

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the Teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:
    Purple Frog Systems
    PowerBI Sentinel

  • Birmingham Data Platform - Azure Purview with Synapse Analytics - Simon Whiteley

    Microsoft Data Platform Group Birmingham - Thursday 8th April 2021 @ 1:00pm

    Session: A first look at Azure Purview with Azure Synapse Analytics - Simon Whiteley from Advancing Analytics

    Abstract:

    The data industry has come a long way in the past few years, we’re seeing the massive growth of data lakes, data mesh architectures, distributed data stores and an explosion in self-service analytics. But how do you govern this sprawling array of desperate data stores? How can you be certain you’re adhering to data sensitivity guidelines? How do your users know where to find the right dataset for their analytics?

    True Data Governance has long been a missing piece of the Azure landscape, but with the preview release of Azure Purview, we now have an answer. This tool allows you to scrape metadata from a whole range of sources, automatically classify and catalogue the data within and present it to your users as a one-stop data catalogue & security management service.

    This session will take you through a first look at the tool, how we go about basic operations and begin to implement purview in our environment. We’ll look at several different governance scenarios, use several different data sources and give you a good initial impression of where the tool fits in your organisation. As this is a preview tool, we won’t have all the answers – but bring along your questions & scenarios and we’ll see what we can do!

    Speaker Bio:

    Simon is a Microsoft Data Platform MVP, awarded in recognition of his contributions to the Microsoft Data Platform Community. Simon is a seasoned Cloud Solution Architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying "big data" thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.

    Agenda:

    12.30pm – 1:00pm Setup and Join

    1:00pm - 1.05pm Introductions

    1:05pm - 2:15pm A first look at Azure Purview with Azure Synapse Analytics - Simon Whiteley from Advancing Analytics

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Please note registration on MeetUp is required to gain access to the teams remote link!***

    You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:
    Purple Frog Systems
    PowerBI Sentinel

    3
  • Birmingham Data Platform - Power BI Composite Models With Alex Whittles

    Microsoft Data Platform Group Birmingham - Thursday 4th March 2021 @ 1:00pm

    Session: Power BI Composite Models; enhancing and combining multiple datasets together with Alex Whittles

    Abstract:

    Power BI now offers ‘Direct Query over Datasets and SSAS’, but what does this mean? Often also referred to as Composite Models (an ambiguous term!), this means that you can use Power BI to add a layer of enhancement to existing Power BI datasets, or even Analysis Services cubes.

    This could be expanding with additional facts, dimensions or reference data, or even combining multiple datasets/cubes together into one.

    Join this demo-led session to learn more about how to create them, and how they can transform your Power BI and SSAS reporting architecture.

    Speaker Bio:

    Alex is a 7 year Data Platform MVP, and is the owner and principle consultant at Purple Frog, a Microsoft Data Analytics consultancy in the UK with multinational clients in a variety of sectors. He specialises in the architecture and design of all aspects of data warehousing, ETL, cubes, Power BI and Machine Learning. He’s also the creator of Power BI Sentinel. He’s on the organizing committee for SQL Bits, is a regular speaker at many data events around the world including SQL Bits, Data Relay, SQL Saturdays, Data Grillen, 24 HOP and the PASS Summit, and has a Masters degree in Business Intelligence.

    Agenda:

    12.30pm – 1:00pm Setup and Join

    1:00pm - 1.05pm Introductions

    1:05pm - 2:15pm Power BI Composite Models; enhancing and combining multiple datasets together - Alex Whittles

    Venue:

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details:

    *** Registration on MeetUp required to gain access to remote link! ***

    ***This is using GoToWebinar! ***

    The link to GoToWebinar will be made available prior to the event and will be open from 12:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details:

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Nick Edwards
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors:
    RP Analytics Recruitment
    Ricoh Digital Services
    Purple Frog Systems

    2
  • Birmingham Data Platform - 4th February 2021 - PBI Streaming | Big Data Clusters

    Microsoft Data Platform Group Birmingham - Thursday 4th February 2021, 1:00pm

    *** Registration on MeetUp required to gain access to remote link! ***

    ***This is using GoToWebinar! ***

    Agenda

    12.30pm – 1:00pm Setup and Join

    1:00pm - 1.05pm Introductions

    1:05pm - 1:20pm Lightening Talk on PBI Streaming and Dashboards with Jon Lunn

    1:20pm - 2:30pm Big Data Clusters with Ben Weissman

    Venue

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details

    The link to GoToWebinar will be made available prior to the event and will be open from 12:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Alex Whittles
    Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex)
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Sponsors
    RP Analytics recruitment
    Ricoh Digital Services
    Purple Frog

    2
  • Birmingham Data Platform - December - SQL On Transactions and Atomic Operations

    Microsoft Data Platform Group Birmingham - Thursday 3rd December 2020, 7:00pm

    *** Registration on MeetUp required to gain access to remote link! ***

    ***This is using GoToWebinar! ***

    Session: On Transactions and Atomic Operations

    Agenda

    6:30pm – 7:00pm Setup and Join

    7.00pm - 7.15pm - Understanding the Statistics in SQL Server - Lightning Talk with Deepthi Goguri

    7:15pm - 8:30pm - On Transactions and Atomic Operations with Gail Shaw

    If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

    Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

    In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

    1)
    Understand what transactions are and what they do.
    2)
    Learn how to use transactions in combination with error handling to roll back changes on errors
    3)
    Learn how transactions affect logging and locking.

    Venue

    Wherever you have access to Computer or Smart Device! This session will be online only!

    Other Details

    The link to GoToWebinar will be made available prior to the event and will be open from 6:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

    Event Organiser Contact Details

    If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

    Alex Whittles
    Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex)
    Email: [masked]

    Reiss McSporran
    Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss)
    Email: [masked]

    Microsoft Data Platform Group - Birmingham
    Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

    Main Speaker Profile

    Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully.

    Gail is a Data Platform MVP, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit.

    Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related.

    She lives in Johannesburg, South Africa.

    Sponsors
    RP Analytics recruitment
    Ricoh
    Purple Frog handle the organisation.