ignite-learning-paths-training-data/data40

DATA40: Data loading best practices

Session Abstract

Tailwind Traders data loading lends itself to a variety of data ingestion methods, each uniquely identified by the shape or structure of the data. In this session you’ll discover data loading best practices and how to optimize for parallel loads into a cloud data warehouse.

Table of Content

Resources	Links
PowerPoint	- Presentation
PPT Recording	- Presentation
Videos	- Microsoft Ignite Orlando Recording
Demos	- Demo 1 - Loading Data into Azure Synapse Analytics
Demo Recordings	- Data40 - Demo

**Note:**Demo recordings do not have voice over or audio, for the purpose to serve as backup to deliveries

How To Use

Welcome,

We're glad you are here and look forward to your delivery of this amazing content. As an experienced presenter, we know you know HOW to present so this guide will focus on WHAT you need to present. It will provide you a full run-through of the presentation created by the presentation design team.

Along with the video of the presentation, this document will link to all the assets you need to successfully present including PowerPoint slides and demo instructions & code.

1. Read document in its entirety.
2. Watch the video presentation
3. Ask questions of the Lead Presenter

Get Started

This training repository is divided in to the following sections:

Slides	Demos	Deployment
27 slides - 30 minutes	1 demos - 15 minutes	Demo Deployment

Slides

The slides have presenter notes on each slide

Timing

Time	Description
0:00 - 5:00	Intro to the session
5:00 - 15:00	What is Azure Synapse Analytics
15:00 - 20:00	Loading Design Goals
20:00 - 35:00	Loading Best Practices
35:00 - 40:00	Loading Data into Azure Synapse Analytics Data Warehouse
40:00 - 45:00	Session Summary

Deployment / Preparation

What's Here? Deploying the demo environment on Azure - including the prerequisites.

Instructions and prerequisites are outlined here.

Demos

What's Here? Pre-delivery preparation, stage ready videos, required files (such as JSON templates), and walk-through videos

Detailed explanations of each demonstration associated with this presentation can be found in this section. There are 3 "live from stage" technical demonstrations that utilize a number of tools both in and out of Azure. You can get a high level overview of the tools and how we will be using them here.

Demo	Minutes	Video
1 - Loading data into Azure Synapse Analytics Data Warehouse	?	Link

Trained Presenters

Chris Testa-O'Neill 📢