Azure Synapse Analytics and Purview Workshop Admin October 14, 2021

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

Are Currently Evaluating The Power Platform Icon

IT managers who seek to modernize their data environments to Azure

Seek To Understand The Value Of Powerapps Icon

Data Engineers , Technical architects and DBAs

Have Deployed The Power Platform Icon

Business users who are at a discovery stage to modernize their data and analytics landscape

Experienced Powerapps Partner

Business users with need for self service analytics and citizen data scientists

Outcome Of The Workshop

Plan With Timelines Icon

Capability , scalability and performance understanding of Azure Synapse modern data environment.

Identify Risks And Mitigations Icon

Identify OLAP workload for a pilot.

Recommendations Icon

Deploy initial landing zone and demo capability to expand and blueprint.

Agenda (Day-1) & Pre-requisites :: Azure Synapse Analytics and Purview Workshop

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

200+ enterprises worldwide including several Fortune 500