How Modern Data Warehousing and Analytics Are Adding Value to Microsof Azure? Amit Andre NetCom Learning
AGEND A Understanding the Microsoft Modern Data Warehouse Challenges in Data Warehousing Introducing Azure SQL Data Warehouse
Š 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
UNDERSTANDING THE MICROSOFT MODERN DATA WAREHOUSE
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
EMBRACING DATA TRANSFORMS BUSINESS • It is central to outperforming competitors
Manufacturin g
Automotiv e
© 1998-2020 NetCom Learning
Healthcar e
Aerospac e
Agricultur e
Financia l
Educatio n
www.netcomlearning.com
Retai l
| info@netcomlearning.com
Governme nt
| 1-888-563-8266
EVERY ENTERPRISE NEEDS RELIABLE DATA WAREHOUSING SOLUTIONS
Maintain historical data from varied sources
Traditional © 1998-2020 NetCom Learning
Gain realtime insights without impacting performance Operational
Manage data variety and volume across all data repositories Logical www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
MODERN DATA WAREHOUSING IS CHALLENGING Maintain historical data from varied sources
Traditional
Gain real-time insights without impacting performance
Operational
Manage data variety and volume across all data repositories
Logical
Fragmented systems and processes Multiple tools and skill sets Siloed insights on disconnected data High cost of ownership Š 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
MICROSOFT DATA WAREHOUSE PORTFOLIO Maintain historical data from varied sources
Traditional
Gain real-time insights without impacting performance
Operational
Manage data variety and volume across all data repositories
Logical
SQL Server 2016 + reference architectures Azure SQL Data Warehouse Azure Data Lake
Š 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
DW YOUR WAY • Comprehensive DW from Microsoft
Cloud • Elastic-scale for unpredictable demand • Pay for what you need
On-premises BUILD YOUR OWN
• Meets strict regulatory compliance standards • Enable strong data governance PRE-ENGINEERED
• Faster deployment • Flexibility and choice of the latest generation of hardware • Out-of-the-box offerings with reduced risk and greater confidence © 1998-2020 NetCom Learning
+
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
INTRODUCING AZURE SQL DATA WAREHOUSE
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
INTRODUCING AZURE SQL DATA WAREHOUSE A relational data warehouse as a service, fully managed by Microsoft Industry’s first elastic cloud data warehouse with enterprise-grade capabilities Integrated with on-premises and cloud assets
Integrated with Azure platform and other Microsoft services Enables hybrid solutions Built on SQL Server experience and technology
Simple compute and storage billing Pay for what you need
processing Resize compute nodes < 1 minute
High performance without rewriting applications
Faster time to insight than other SMP offering
Low cost for latent data
Designed for “on-demand” workloads
Infrastructure, management, and support provided
Scales to petabytes of data with MPP
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
POWER OF INTEGRATION
SQL
App service
Azure SQL Data Warehouse
Intelligent app
Š 1998-2020 NetCom Learning
Azure SQL Databas e
Hadoo p
Azure Machine Learning
www.netcomlearning.com
Power BI
| info@netcomlearning.com
| 1-888-563-8266
TRUE ENTERPRISE-READY SQL SERVER EXPERIENCE Mature enterprise-ready SQL for sophisticated DW scenarios Proven and used by millions of SQL Server users today Existing SQL Server scripts and tools just work Continuous enhancements on language surface
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
QUERY UNSTRUCTURED DATA VIA POLYBASE/T-SQL PolyBase for querying and managing non-relational Hadoop and relational data •
Enables query capabilities across common Hadoop distributions (HDP & Cloudera) and Hadoop file formats in Azure storage
•
Allows leveraging existing SQL skills and BI tools
•
Supports multiple non-relational file formats
•
Improved time-to-insights and simplified NetCom Learning E©T1998-2020 L
SQL DW Instance PolyBa se
Hadoop VMs / Azure Storage
Scale out compute
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266
RECORDED WEBINAR VIDEO To watch the recorded webinar video for live demos, please access the link: http://tiny.cc/t83hiz
|© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
ABOUT NETCOM LEARNING 90,000 +
10,000 +
Professionals trained
Corporate clients
96%
Of customers recommend us to others
Microsoft’s Worldwidetraining partner ofthe year
8.6/ 9
IT, Business & Soft Skillscourses
20+
NetCom Learning is an award-winning global leader in managed learning services, training and talentdevelopment. Founded : 1998
Leadingvendor s recognitions
Instructor evaluation s
Headquarters
80%
Top 20
Trained of the Fortune 100
|© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
1500+
Delivery Capability CE O
: New YorkCity : Worldwide : RussellSarder
ITTrainin g Company
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
RECOMMENDED COURSES AND MARKETING ASSETS NetCom Learning offers a comprehensive portfolio for Data & AI Courses » 20767: Implementing a SQL Data Warehouse (SQL Server 2017) – Class Scheduled on March 02 » OD20767C: Implementing A SQL Data Warehouse MOD+DMOC (SQL Server 2017) » DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) – Class Scheduled on Jan 13 » DP-201T01: Designing an Azure Data Solution Associate (Data Engineer) – Class Scheduled on Jan 16 » DP-050T00: Migrate SQL Workloads to Azure – Class Scheduled on Feb 03
Youcan also accessthe below Marketing Assets » Free On-Demand Training- Explore Data Warehousing and Business Intelligence » Blog – Why Does the Industry Need SQL Server 2017 » Free Assessment Quiz - DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) Quiz » Free Assessment Quiz - DP-201T01: Designing an Azure Data Solution Associate (Data Engineer) Quiz
|© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
UPCOMING WEBINARS
• Fed Up with Rebuilding PowerPoint? Here's What You Need to Know! • How to Transform Autodesk Revit Models into Real-time 3D Design for Improved Project Delivery • What to Expect from the New PMP® Certification Exam in 2020 • Unveiling the Cisco Certifications Migration Tool • How to Build Step-by-Step ASP.NET Core App • 7 Citrix Secrets: How to Upskill Your Citrix Skills • How to Get CISSP Certified: 2020 Edition • How can Agile Project Management Skills help in Delivering Top-Notch Customer's Delight? • Tips and Tricks to Build Effective Dashboards with Tableau Desktop & More |© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
PROMOTIONS
NetCom Learning brings the Joy of Rewards for you. Boost your skills with NetCom Learning and build a smarter Workforce. Get trained by top-notch instructors in an in-person Instructor-led Classroom or a Live Online Class. Choose from best-in-class courses like Networking, Data & AI, Cloud, Business Process, Security, Application Development and reward yourself with our gift cards. Learn More |Š 1998-2020 NetCom Learning |Š1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
FOLLOW US ON
LinkedI n
|© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
YouTube
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
BUILDING AN INNOVATIVE LEARNING ORG. ANEW BOOKFROMRUSSELLSARDER, CEOATNETCOMLEARNING
A framework to build a smarter workforce, adapt to change and drive growth. DOWNLOADe-book
|© 1998-2020 NetCom Learning |©1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266
Thank you
|Š 1998-2020 NetCom Learning |Š1998-2019 NetCom Learning
www.netcomlearning.com
info@netcomlearning.com
www.netcomlearning.com 1-888-563-8266
| info@netcomlearning.com
| 1-888-563-8266