This is a Header THIS IS A SUBTITLE Modern Data Warehouse: On-Premise

23 Slides9.22 MB

This is a Header THIS IS A SUBTITLE Modern Data Warehouse: On-Premise vs. Cloud – Which is Right? Practice Manager: David Hay 09/01/2019

The world is changing This is a Header THIS IS A SUBTITLE

Today, 80% of organizations struggle with cloud or on-premises decision strategies This is a Header Data wi ll grow to 44 ZB in 2020 THIS IS A SUBTITLE AI investment increased by 300% in 2018

Predictive Analytics and ROI: Lessons from IDC’s Financial Impact Study Both predictive and non-predictive projects yielded high median ROI, 145% and 89%, respectively. This Businessis a Header The major benefits of business analytics projects that employed predictive analytics centered on business process enhancement, especially improving the quality of operational decisions. Intelligen THIS IS A SUBTITLE ce Predictive analytics projects required higher investment levels and yielded significantly higher Provides Alone Businesses overall returns over five years, implying that these projects tackled problems of greater scope and complexity. with an average of 89% Return on Investment Working with Pragmatic Works will allow you to cut the delta ( 56%) Business Intelligen ce Predictive Provides Businesses Modeling with an average of 145% Return on Investment

Insights is a Journey This is a Header What happened? Why did it happen? Reports Interactive Dashboards THIS IS A SUBTITLE What will happen? What should I do? Predictive Recommendations & Automation Models Insight

DATA SCIENCE S Prescriptive Real-time Analytics Predictive DECISION SUPPORT WORKLOAD COMPLEXITY Analytical Maturity Curve Exploratory Analytics Real-time Predictive Modeling & Mining Temporal Analysis Continuous Update Rule-based Alerting Foundational Analytics Closed Loop Forecasting This is a Header Diagnostic Self-Service Reporting OPERATIONAL MANAGEMENT THIS IS ADescriptive SUBTITLE Basic Reportin g WHAT HAPPENED? Large Adhoc Scorecard ing Batch Limited Adhoc Single Version of Truth WHY DID IT WHAT MAY HAPPEN? HAPPEN? Event-based Data Discovery Technical Capabilities Should Facilitate Movement Along the Maturity Curve WHAT IS HAPPENING? DATA SOPHISTICATION WHAT ACTION SHOULD WE TAKE?

DATA ARCHITECTURE REAL TIME PROCESSING ERP Marketing Marketing Executives SCM Applications INTEGRATED DATA WAREHOUSE CRM DATA PLATFORM Images Operational Systems 1 Business Intelligence 2 This is a Header Web and Social 3 Data Mining THIS IS A SUBTITLE Machine Logs Math and Stats Customers Partners Knowledge Frontline Workers Business Analysts INTEGRATED DISCOVERY PLATFORM Text Languages 5 Audio and Video SOURCES 4 Data Scientists Engineers Search USERS ANALYTIC TOOLS & APPS

DATA ARCHITECTURE Data in Motion REAL TIME PROCESSING ERP Marketing Marketing Executives SCM Applications INTEGRATED DATA WAREHOUSE CRM DATA PLATFORM Images 1 Operational Systems Business Intelligence High Concurrency & Strict SLAs This is a Header 2 Business Intelligence Customers Partners Operational Intelligence Fast Loading Web and Social 3 Data Mining Knowledge Frontline Workers Filtering and THIS IS A SUBTITLE Processing Machine Logs Exploratory Analysis Text 5 Audio and Video SOURCES Math and Stats Business Analysts INTEGRATED DISCOVERY PLATFORM Online Archival Data Discovery Languages Data Scientists Path, graph, time-series analysis 4 Integrated Analytics Engineers Search USERS ANALYTIC TOOLS & APPS

The SQL Server & Azure Data Estate Combined DATA SOURCES DA TA SOUR CES DATA MANAGEMENT DATA MANAGEMENT Structure d DATA INSIGHTS DATA INSIGHTS Operational data ON-PREM CLOUD Business intelligence Power BI OLT P MOBIL SQL Server E ER P Azure Document DB Azure SQL Database Embedd ed Data warehousing Unstructur ed Data virtualization LO B SQL Server Data Warehouse Azure SQL Data Warehouse Apach Azure HDInsig ht Socia l Io T Medi a Data integration This is a Header Graph Big data processing e THIS IS A SUBTITLE Hadoo p Azure Data Lake SECURITYMore certifications other cloud SECURITY Least vulnerablethan data any platform, with moreprovider certifications than any other cloud provider FLEXIBILITY FLEXIBILITY Any language, any platform, anywhere .NET JAVA Azure 3 rd SQL Server Reporting Services and Advanced Analytics & AI Mobile BI SQL Server Analysis Services and R built- in Azure Machine Learning Azure Stream Analytics Azure Cognitive Services

Knowing the various SQL Server & Azure Big Data Solutions EASE OF USE Azure Databricks SQL Server Analytics Azure & SQL Server Data Lake Analytics BIG DATA ANALYTICS Azure HDInsights SQL Server Analytics Integration Services This is a Header Azure Marketplace SQL Server Studio HDP CDH MapR Any Hadoop technology, any distribution THIS IS A SUBTITLE IaaS Clusters Workload optimized, managed clusters Frictionless & Optimized Spark clusters Managed Clusters Data Engineering in a Job-as-a-service model Big Data as-a-service Azure Data Lake Analytics Azure and SQL Server Studio Data Lake Store Azure and SQL Server Studio Storage BIG DATA STORAGE Reduced Administration CONTROL

Choosing a Strategy “What’s the best path for me?”

Azure solution paths Highly customized system to address the application’s specific performance and availability requirements. Do not have to manage any VMs, OS or database software, including upgrades, high availability, and backups.

Azure migration tools and services Asse ss Migrat e

Implementing Common Data This is a Header Architectures: SQL Server or THIS IS A SUBTITLE Azure

Big Data & Data Warehouse LOB CRM INGEST STORE PREP & TRAIN This is a Header Graph MODEL & SERVE Advanced Analytics Image orchestration THIS IS AData SUBTITLE and monitoring Social IoT Clou d Big data store Analytics engines BI Reporting Data warehouse Real Time Analytics Azure Data Factory Azure Blob storage Azure Databricks SQL Server Integration Services Azure Data Lake Store Azure HDInsight SQL Server Azure Data Lake Analytics SQL Server R and Python Integration Services Azure SQL Data Warehouse Azure Analysis Services SQL Server SQL Server Analysis Servers

Modern Data Warehouse INGEST STORE PREP & TRAIN MODEL & SERVE -Azure Databricks Logs, files and media (unstructured) (or Azure HDInsight, Azure Data Lake Analytics) -Azure Data Factory -SQL Server Integration Services This is a Header THIS IS A SUBTITLE -SQL Server R and Python Integration Services -Azure Blob Storage -SQL Server Polybas e Business/custom apps (Structured) -Operational Reports -Azure Data Factory -SQL Server Integration Services -Azure SQL Data -Azure Analysis Warehouse Services -SQL Server -SQL Server Analysis Services -SQL Server Reporting Services & -Analytical Dashboards (PowerBI)

Advanced Analytics INGEST Logs, files and media (unstructured) STORE PREP & TRAIN -Azure Machine Learning -SQL Server Machine Learning Services -Azure Data Factory -SQL Server Integration Services This is a Header THIS IS A SUBTITLE -Azure Blob Storage or -Azure Data Lake Store -SQL Server MODEL & SERVE -Azure Databricks (Spark ML, SparkR) , ---SQL Server R and Python Integration Services -Azure Databricks (or Azure HDInsight, Azure Data Lake Analytics) SQL Server Analytics Interrogation Services Polybas e Business/custom apps (Structured) -Operational Reports, -Azure Data Factory -SQL Server Integration Services -Azure SQL Data Warehouse -SQL Server -Azure Analysis Services -SQL Server Analysis Serves -SQL Server Reporting Services & -Analytical Dashboards (PowerBI)

Real Time Analytics INGEST Logs, files and media (unstructured) STORE PREP & TRAIN -Azure Machine Learning -SQL Server Machine Learning Services Azure IoT Hub This is a Header Sensors and IoT (unstructured) Azure HDInsight (Kafka) MODEL & SERVE -Azure Databricks (Spark ML, SparkR) -SQL Server R and Python Integration Services -Azure Databricks Structured Streaming (or Azure HDInsight, Azure Stream Analytics) THIS IS A SUBTITLE -SQL Server Analytics Integration Services Polybase Business/custom apps (Structured) -Operational Reports -Azure Data Factory -Azure Blob Storage or -SQL Server Integration Services -Azure Data Lake Store -SQL Server -Azure SQL Data -Azure Analysis Warehouse Services -SQL Server -SQL Server Analysis Services -SQL Server Reporting Services & -Analytical Dashboards (PowerBI)

Intelligent applications INGEST STORE PREP & TRAIN MODEL & SERVE Cosmos DB Logs, files and media (unstructured) SQL Azure IoT Hub SQL Database This is a Header Sensors and IoT (unstructured) Azure HDInsight (Kafka) THIS IS A SUBTITLE Predictive apps -Azure Databricks / HDInsight -SQL Server R and Python Studio Polybase Business/custom apps (Structured) -Operational Reports -Azure Data Factory -Azure Blob Storage -SQL Server Integration Services -SQL Server -Azure SQL Data -Azure Analysis Warehouse Services -SQL Server -SQL Server Analysis Services -SQL Server Reporting Server & -Analytical Dashboards (PowerBI)

Microsoft business analytics and AI Intelligent Flexible Trusted Faster, more accurate insights and predictions Improve performance Reduce time to value This is a Header Redefine interaction through AI THIS IS A SUBTITLE 2x-10x faster Microsoft Machine Learning Algorithms running close to the data on premises and in the cloud Simplified access to machine learning models and seamless transition from experimentation to production Speech, Vision, Language and Search APIs built on decades of research & investment

Microsoft business analytics and AI Intelligent Trusted Flexible Most secure, compliant and scalable Own, protect is & control Meet your compliance This a Header your data requirements Grow effortlessly with your business THIS IS A SUBTITLE The least vulnerable database over seven years* Meets global and industry-specific compliance standards, as well as country-specific standards Highly scalable and performant data services with ML based automatic index tuning

Microsoft business analytics and AI Intelligent Flexible Trusted Works with what you have Get the mostis from a all Header Maximize your existing This your data investments Build on open source innovation THIS IS A SUBTITLE Cloud The least vulnerable database over seven years* Hybri d Onpremises Meets global and industry-specific compliance standards, as well as country-specific standards Highly scalable and performant data services with ML based automatic index tuning

Business analytics Solutions Operation s Marketin g Finance This is a Header Predictive maintenance Demand forecasting Operational efficiency Personalization Customer insights Churn analytics THIS IS A SUBTITLE Dynamic Inventory optimization Operations anomaly insights pricing Product innovation Quality assurance Marketing optimization Connected devices and smart buildings Product recommendation Supplier and spend insights Finance forecasting Fraud management Rise management Workforc e Servic e Sales Employee insights Intelligent contact center Lead and opportunity scoring HR insights Resource matching and planning Patient care and healthcare analytics Sales insights

Back to top button