Introduction to Azure Synapse Webinar

WARDY IT Solutions
AUSTRALIA’S LEADING PROVIDER OF MICROSOFT DATA PLATFORM CONSULTANTS,
DATA ANALYTICS SPECIALISTS & TRAINERS
WARDY IT Solutions

Cloud Solutions Architect
Arpit Bhardwaj
He has worked with many organisations to help plan,
architect and implement Business Intelligence & Data
Analytics solutions using the Microsoft Azure Platform.
Data Architect
David Alzamendi
Delivering Business Intelligence and Data Analytics
Solutions with On-Premises and Cloud technologies since
2011.

Agenda
• Introduction
• Modern Data Warehouse
• Overview of Azure Synapse Analytics
• Demo
• Q&A

80%
report struggling to
become mature users
of data*
55%
report data silos and
data management
difficulties as roadblocks*
Analytics & AI is the key priority for organizations
with ROI as a consideration
* Harvard Business Review (2019), Understanding why analytics strategies fall short for some, but not for others

Experimentation
Fast exploration
Semi-structured data
Big Data
OR
Need to maintain
independent analytics systems
Proven security & privacy
Dependable performance
Operational data
Relational Data
Data Lake Data Warehouse

Azure Synapse Analytics
Azure brings these two worlds together, in a single service,
to provide limitless analytics
Data warehousing & big data analytics—all in one service

LIMITLESS
SCALE
POWERFUL
INSIGHTS
UNIFIED
EXPERIENCE
UNMATCHED
SECURITY

What is Modern Data Warehouse?
MITIGATE DATA SILOS SUPPORT DIVERSE TYPE
OF DATA
UNLIMITED DATA SCALE ALLOWS INTERACTIONS
WITH VARIOUS TOOLS
AND ECOSYSTEM
LOWER COST OF
OWNERSHIP
PERFORMANCE
EFFICIENCY
RELIABLE SECURE

INGEST STORE PREP & TRAIN MODEL & SERVE
Modern Data Warehouse
Azure Data Lake
Logs (unstructured)
Azure Data Factory
Azure Databricks
Example
Media (unstructured)
Files (unstructured)
Business/custom apps
(structured)
Azure Synapse
Analytics
(SQL pools)
Analysis Services
Engine
Power BI

INGEST STORE PREP & TRAIN MODEL & SERVE
Modern Data Warehouse
Azure Data Lake
Logs (unstructured)
Azure Data Factory
Apache Spark pools
Example
Media (unstructured)
Files (unstructured)
Business/custom apps
(structured)
Azure Synapse
Analytics
(SQL pools)
Power BI
Azure Synapse
Analytics
Workspaces
Analysis Services
Engine

Integrated data platform for BI, AI and continuous intelligence
Platform
Azure
Data Lake Storage
Common Data Model
Enterprise Security
Optimized for Analytics
METASTORE
SECURITY
MANAGEMENT
MONITORING
DATA INTEGRATION
Analytics Runtimes
PROVISIONED ON-DEMAND
Form Factors
SQL
Languages
Python .NET Java Scala R
Experience Synapse Analytics Studio
Artificial Intelligence / Machine Learning / Internet of Things
Intelligent Apps / Business Intelligence
METASTORE
SECURITY
MANAGEMENT
MONITORING
Slide provided by Microsoft

• Azure Data Factory
• Linked services
• Datasets
• Pipelines
• Mapping data flows
• Azure Data Lake
• Notebooks
• Machine Learning
• Advanced Data Analytics
• SQL Scripts
• Storage explorer
• Apache Spark Jobs
• Power BI

One
stop-
shop for
Analytics
• Business Intelligence developer
• Data Warehouse developer
• ETL developer
• Data engineers
• Data scientist
• Data analysts
• Reporting developers (Power BI)
• Advanced Business Users

Produce timely
actionable
insights

Our approach
IDENTIFY THE NEED
FOR A NEW
PLATFORM
DISCOVERY DESIGN DEVELOP DEPLOY DOCUMENT
5 D’s
PMBOK / Agile (SCRUM)
Continuous Delivery

This Photo by Unknown Author is licensed under CC BY-NC-ND
Any Questions?

WARDY IT Solutions helps medium to large organisations
unlock the value in their business data, in whatever form it exists
WARDY IT Solutions is recognised as Australia’s leading provider of
Microsoft Data Platform consultants, trainers and Data Analytics specialists

Introduction to Azure Synapse Webinar

More Related Content

What's hot

Similar to Introduction to Azure Synapse Webinar

Recently uploaded

Introduction to Azure Synapse Webinar