Speaker

Zach Stagers

Zach Stagers

Principal Data Engineering Consultant at Advancing Analytics

Portsmouth, United Kingdom

Zach has well over a decade of experience across a range of industries, currently working as Principal Consultant with Advancing Analytics. Throughout his career, he has implemented a range of analytical platforms from traditional Microsoft Business Intelligence to cutting edge Data Lakehouse platforms, tackling a huge variety of complicated problems. One of Zach's main passions is digging into the hype of new technology to find out what helps to make analytics easier and faster to implement.

Area of Expertise

  • Information & Communications Technology

Topics

  • Azure
  • Azure Data Factory
  • Databricks
  • Data Lake
  • Azure Databricks
  • Azure Data Lake
  • Azure Data Lake Store
  • Azure SQL Database
  • Spark
  • Azure Synapse
  • Azure Data Platform

A Data Engineer's Guide to Azure Synapse

There has been an explosion of interest in Azure Synapse Analytics as everyone races to get to grips with the all-in-one data analytics platform. But when opening up the box, you find it's a lot more complex that it's made out to be, with several different powerful compute engines, each with their own idiosyncrasies! Why do we have different flavours of each engine? When should you use Spark pools over SQL? What's the most cost effective approach for different scenarios? What types of users should be using each service? The answers to these questions aren't always met with clarity!

This training day breaks down the Synapse workspace into it's component parts and provides a foundation of knowledge for each piece. During the day, we will cover:

- Fundamentals of building a Lake-based analytical platform - how you structure a lake, what file format to choose, what kinds of data work it's suited for
- How the SQL Pools work, patterns for optimising performance and cost and how we can use our SQL endpoints to integrate with other services
- The Synapse Spark engine, demonstrating how you can write dynamic workflows in Python or bring your existing SQL logic to spark directly.
- Data Explorer pools and how you can use it for deep exploration of logs, time series and other fast-moving unstructured data sources
- Synapse Integrations, how you can take your workspace and integrate directly with tools such as Azure Purview, CosmosDB and the wider Dataverse

There is a huge amount to cover, but you'll be guided by Data Platform MVP Simon Whiteley & veteran analytics consultant Zach Stagers, both of whom have deep knowledge across the whole of this wide and sprawling tech stack.

Data Lakehouse Serving Options

The lakehouse design paradigm is becoming more mainstream as tools like Azure Synapse and Databricks make querying lake-based data simple, and bring a huge amount of power. But there is yet to emerge a defacto industry standard in serving a lake-based model to end users, and with a growing number of options it can be difficult make a decision that best fits your scenario.

In this session we will establish a benchmark of what we're looking for in a good data serving layer. We will then review the serving options currently available to evaluate how well they meet our requirements, any additional benefits and some potential pitfalls and things to avoid with each. You will leave the session equipped with everything you need to open up your lake to the wider business and harness the power of the lakehouse model.

Data Relay 2022 Sessionize Event

October 2022

DATA:Scotland 2022 Sessionize Event

September 2022 Glasgow, United Kingdom

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

Zach Stagers

Principal Data Engineering Consultant at Advancing Analytics

Portsmouth, 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