Do You Even Synapse?

Do You Even Synapse?​
Instructor-led Training

Course Description

Contoso Powerlifting Federation (CPF) are in dire need to modernize their data approach. Among the tasks required by your team, you will be challenged to retrieve the source data and upload it into a modern data warehouse repository in a cleansed/modelled format to be able to report and visualize. 

 Learning Objectives 

The purpose of this hack is to learn: 

  • About some of the features of Azure Synapse 
  • The power of data visualization 
  • How to add additional data into Azure Synapse 
  • How Machine Learning is incorporated 
 

About this Course

  • Challenge 0: Pre-requisites – Ready, Set, GO!
    • Prepare your workstation to work with Azure
  • Challenge 1: Gathering Open Powerlifting Data
    • Retrieve data and upload to Azure using a storage service
  • Challenge 2: Load data into a relational database/warehouse
    • Loading the data
  • Challenge 3: Visualization
    • Visualizing the data
  • Challenge 4: Incremental Loads
    • Load incrementals
  • Challenge 5: Mask Data for Privacy
    • Putting your mask on
  • Challenge 6: Add New Data Source(s)
    • Additional data sources
  • Challenge 7: Leverage Machine Learning
    • The machines know too much! 
 

1 Day

Advanced

Azure Synapse

Database Administrator

Need to Train a Team?

Contact us to schedule a dedicated class for your team.