What The Hack: Do You Even Synapse?

Introduction

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 Objective

The purpose of this What The 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

Challenges

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

Contributors

• James Jones
• Art Rask
• Orrin Edenfield
• Frank Lopez