Speaker

Reiss McSporran

Reiss McSporran

Purple Frog - Senior BI Developer

Telford, United Kingdom

Reiss is a Senior Business Intelligence Developer at Purple Frog and is co-organiser of the Birmingham Data Platform Meetup. He has been working with Reporting and Business Intelligence for over a decade, but is fairly new to the Speaker scene. Reiss has presented sessions at Data in Devon and also at the Birmingham Data Platform Meetup. He is currently specialising in Azure Synapse Analytics and has been working with this since it's Public Preview.
Outside of work and technology Reiss is a father of two, a frequent Musical Theatre Performer, a LARP Organiser and a keen gamer.

Area of Expertise

  • Information & Communications Technology

Topics

  • Azure Data Factory
  • Microsoft SQL Server
  • Business Intelligence
  • ETL
  • Azure Synapse Analytics

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

Join the Purple Frog Team for 5 x back to back 10-15 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 : Reiss McSporran
Scale up direct query over Synapse SQL pool

Getting Started with Azure Synapse Analytics

Azure Synapse Analytics is one of the newest additions to the Azure Platform. But what is it exactly and how do we use it?

This session will give you the answers to these questions and also a few small tips that can make a huge difference to your performance.

We'll cover:
- Creating the Azure Synapse Analytics Environment
- Configuring your SQL Pool
- Additional storage options for your data
- Data Distribution over your SQL Pool (Distribution types).
- Scaling your SQL Pool for differing workloads
- Assigning Workload Management to increase performance/concurrency
- And more!

By the end of the session you'll have seen how to get started with Azure Synapse Analytics and a few things to avoid when you do!

This is a one hour session, but I can deliver parts as shorter lightning sessions upon request.

New Stars of Data #3 Sessionize Event

October 2021

Reiss McSporran

Purple Frog - Senior BI Developer

Telford, United Kingdom

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top