Andy Cutler
Independent Business Intelligence Consultant
Milton Keynes, United Kingdom
Actions
I am an Azure Data Platform professional working predominantly with Azure Synapse Analytics (SQL Pools), Data Factory, SQL Server and Power BI. I hold an MSc in Business Intelligence and Data Mining. I am a current Microsoft Data Platform MVP.
Links
Awards
Area of Expertise
Topics
When Two Become One: Understanding SQL in Fabric Synapse Data Warehousing
It all started with Parallel Data Warehouse, then came Azure SQL Data Warehouse…then Dedicated SQL Pools in Synapse! That was joined by Serverless SQL Pools in Synapse too. However there were now 2 SQL engines to use with differing scenarios and syntax…which to choose was often the question.
Now in Microsoft Fabric we have a single SQL engine for all our workloads, no more having to pick an engine for data warehousing or lakehouse architectures, hooray!
In this session we’ll be looking at the history of Microsoft data warehousing platforms and how we’ve ended up with the Fabric SQL engine. We’ll dive into what the lakehouse SQL endpoints are, what Warehouses in Fabric are, and how we can develop for these services.
Attendees will leave the session understanding how to develop Data Warehouse solutions in Microsoft Fabric.
The Battle of the Lakehouse: Delta lake, Iceberg, and Hudi.
The Data Lakehouse is hotting up as the go-to cloud Data Warehouse and Analytics methodology. Combining the scale and flexibility of the data lake with the schema enforcement and transactional consistency of data warehouse database systems, the lakehouse pattern brings a huge advantage for organisations with both complex and large amounts of data. But what underpins lakehouse technology?...
In this session we'll be diving into 3 of the data storage formats that have emerged in recent years and understand how they work.
1. Delta Lake
2. Apache Iceberg
3. Apache Hudi
We'll discuss the benefits and drawbacks of each format and look at technology platforms and vendors that support these formats.
After this session you will have the power of knowledge to deal with the different formats in use with the Data Lakehouse and make an informed decision about the format(s) to use in a data solution.
Azure Synapse Analytics & Microsoft Fabric: The Showdown
With the release of Microsoft Fabric, Microsoft have consolidated Power BI, the world of Spark and Lakehouses, Data Warehousing, and large scale real-time streaming into a single platform.
What now for Azure Synapse Analytics? Well, in this session we’ll be looking at both services and comparing/contrasting their use cases. We’ll also be looking at how these services can work together.
Synapse Data Warehousing in Fabric: It's all just SQL...Or is it?
Fabric is Microsoft's new platform on the block, covering the world of lakehouses, warehouses, real-time streaming, data engineering, and Power BI data modelling and reporting.
In this session we'll be looking at the Microsoft Fabric Warehouse service and how it differs from the SQL services we all know and love from Microsoft. We'll look at how and why it's different, and dive into the differences we need to be aware of when developing data solutions.
It's all just SQL...or is it?
Microsoft Fabric Warehouses for the Database Administrator
No matter what data role you have, it’s important to handle data you use with care. If you’re a DBA (Database Administrator) who has been tasked with looking at how to “administrate” Fabric Warehouses, a cloud-based SQL service tailored towards data warehousing, what do you need to be aware of when working with this Software-as-a-Service product? Perhaps you’ve been asked to “look after this Fabric thing” or maybe you’ve overheard people talking about Fabric and thought “what’s my role in all of this?”
Microsoft Fabric is Microsoft's flagship Software-as-a-Service Analytics service combining Power BI, Data Engineering, Data Warehousing, Realtime Analytics, and Machine Learning.
Underpinning Fabric is a variety of workloads, engines, and languages to support in building a robust Analytics solution.
In this session we'll be taking a look at the
Fabric Warehouse service which is the SQL data warehousing service. However we'll be looking at this service from the perspective of the Database Administrator (DBA) role.
In this session attendees will understand the various aspects of Fabric Warehouses that are relevant in the scope of a DBA role.
The Reality of Fabric Warehouses and Deploying Models using Dbt
Microsoft Fabric is Microsoft's flagship Software-as-a-Service Analytics service combining Power BI, Data Engineering, Data Warehousing, Realtime Analytics, and Machine Learning. Underpinning Fabric is a variety of workloads, engines, and languages to support in building a robust Analytics solution.
Dbt (data build tools) is a data transformation tool that enables data analysts and engineers to transform data in a cloud analytics warehouse. Is is feasible to build a solution on Fabric Warehouses using Dbt? Why would we want to if so? In this session we'll be diving into the integration of Fabric Warehouses and Dbt including Dbt Core and Dbt Cloud.
In this session attendees will understand the use cases of Dbt with Fabric Warehouses and understand the relevant workloads, and crucially the limitations and caveats.
Up and Running: How to make your Microsoft Fabric Proof of Concept a Success
Microsoft Fabric is Microsoft's flagship Software-as-a-Service Analytics service combining Power BI, Data Engineering, Data Warehousing, Realtime Analytics, and Machine Learning. Underpinning Fabric is a variety of workloads, engines, and languages to support in building a robust Analytics solution.
In this "broad brush" session we'll look at how you and your organisation can provision a variety of Fabric workloads and how to conduct an effective proof-of-concept to ensure it succeeds in showing value. We'll be walking through a Proof-of-Concept guide to help us on our journey as we evaluate setting-up new Fabric workloads including timeframes for our proof-of-concept.
After this session you should feel more comfortable engaging with Microsoft Fabric and ensuring your proof-of-concept succeeds.
#DataWeekender #ExamCrams User group Sessionize Event
Microsoft Fabric Usergroup Denmark User group Sessionize Event
Festive Tech Calendar 2022 Sessionize Event
Data Relay 2022 Sessionize Event
DATA BASH '22 Sessionize Event
Data Toboggan - Cool Runnings 2022 Sessionize Event
Cloud Lunch and Learn Sessionize Event
#DataWeekender CU5 Sessionize Event
SQLBits 2022 Sessionize Event
DataMinutes #2 Sessionize Event
SQL Ireland Meetup - 2022 Sessionize Event
SQL Ireland – Annual Christmas Event 2021 Sessionize Event
Festive Tech Calendar 2021 Sessionize Event
Power BI Fest Sessionize Event
Data Toboggan - World Azure Synapse Day Sessionize Event
PASS Data Community Summit 2021 Sessionize Event
Data.Toboggan - Cool Runnings Sessionize Event
DataMinutes #1 Sessionize Event
dataTGIF Jun-Dec 2021 Sessionize Event
Data Toboggan User Group
Building a Data Warehouse Dimensional Model using Azure Synapse Analytics SQL Serverless
Virtual Power BI Days Germany 2021-03-23 Sessionize Event
Power Break
Power Break with Andy - Power BI & Azure Synapse
datasaturdays.com Pordenone 2021 #0001 Sessionize Event
Data Toboggan
Serverless SQL Pools Dimensional Model
Dublin Power BI User Group
Synapse Analytics SQL Serverless and Power BI Dataflows
Virtual Hamburg Power BI Days 2020-12-15 Sessionize Event
SQL Ireland User Group
Synapse Analytics SQL Serverless and Power BI Dataflows
Power BI User Group DC
Synapse Analytics SQL Serverless and Power BI Dataflows
Andy Cutler
Independent Business Intelligence Consultant
Milton Keynes, United Kingdom
Links
Actions
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