DATA MODERNIZATION
Azure Synapse Analytics Workshop
Need Of The Workshop
Organizations who would want to determine the optimal architecture for modern data and analytics environment should join this workshop. We will review the existing data analytics estate and understand its shortcomings , organizational KPIs, review business needs , data sources , data usage, strategy and data governance. Demo with a hands-on-lab Azure synapse Analytics workspace with data ingestions, reporting and data governance with Azure Purview
According to Gartner,75% of databases will be in the cloud by 2022.
Gartner goes on to add that the main driver for migrating data to the cloud is to
capture superior analytics and to take advantage of the pay as you go model.
35 % of organizations cite insufficient tools or technology as their primary challenge
35 % of organizations lack adequate in-house skills/knowledge
Who Can Attend
IT managers who seek to modernize their data environments to Azure
Data Engineers , Technical architects and DBAs
Business users who are at a discovery stage to modernize their data and analytics landscape
Business users with need for self service analytics and citizen data scientists
Outcome Of The Workshop
Capability , scalability and performance understanding of Azure Synapse modern data environment.
Identify OLAP workload for a pilot.
Deploy initial landing zone and demo capability to expand and blueprint.
Agenda (Day-1) & Pre-requisites :: Azure Synapse Analytics and Purview Workshop
- Identify a data source (Preferably excel or csv) for ingestion into synapse analytics.
- Lab material to be shared by Acuvate.
- One week notice if the workshop must be run on a data source from your organization.
- If data source is not provided, Acuvate will share the data sources and the material for the hands-on-lab.
Agenda (Times are approximate and will be fluid with the class)
| Day 1 – Morning | |
| 09:00 AM – 10:00 AM | The Heart of Analytics |
| 10:00 AM – 11:00 AM | Optimizing Analytics with Azure Synapse and Azure Purview |
| 11:00 AM – 11:15 AM | Break |
| 11:15 AM – 11:45 AM | Insights for all with Power BI + Azure Synapse |
| 11:30 AM – 12:30 PM | Environment setup and brief on the Labs |
| 12:30 PM – 1:30 PM | Break |
| Day 2 – Afternoon | |
| 1:30 PM – 2:15 PM | Lab1 Explore Data lake with Synapse SQL On-Demand and Synapse Spark |
| 2:15 PM – 3:15 PM | Lab1 Solution + Questions |
| 3:15 PM – 3:30 PM | Break |
| 3:30 PM – 4:15 PM | Lab2 Modern data warehouse with Synapse pipelines |
| 4:15 PM – 5:00 PM | Lab2 Solution + Questions |
Agenda (Day-2) :: Azure Synapse Analytics and Purview Workshop
Agenda (Times are approximate and will be fluid with the class)
| Day 2 – Morning | |
| 09:00 AM – 09:30 AM | Recap of Day 1 + Questions |
| 09:30 AM – 10:00 AM | Introduction to today’s lab and showcase industry specific usecases |
| 10:00 AM – 10:45 AM | Lab 3 Power BI integration |
| 10:45 AM – 11:00 AM | Break |
| 11:00 AM – 12:00 PM | Lab 3 Solution + Questions |
| 12:00 PM – 12:30 PM | Lab 4 High performance analysis with Synapse Pools |
| 12:30 PM – 1:30 PM | Break |
| Day 2 – Afternoon | |
| 1:30 PM – 2:15 PM | Lab 4 Solution + Questions |
| 2:15 PM – 3:15 PM | Lab 5 Data Science with Spark + Azure Purview walk through |
| 3:15 PM – 3:30 PM | Break |
| 3:30 PM – 4:15 PM | Lab 5 Solutions + Questions (Identify OLAP workload for migration in a 14-day pilot) |
| 4:15 PM – 5:00 PM | Best practices with Synapse – Tips and Tricks |
Trusted by the best
