Rectangle 11806-min
Microsoft Cloud Hack

Do You Even Synapse?

Students in a classroom-min

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


1 Day


  • 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! 

Ready to get started?