Transcript What*s New with Microsoft Data Analytics?

Data Analytics
Competition and
Objection Handling
Agenda
Microsoft Data Platform
for Data Analytics
3
Harness the Power of a Complete Data Platform
Faster Insights from Any Data
Microsoft Big Data Solution
Microsoft Azure HDInsight Service, a Big Data solution powered by Apache Hadoop™
• HDInsight makes Apache Hadoop available as a service in the cloud
• Hadoop distribution with greater security, performance and ease of management
• Breakthrough insights with the use of familiar tools such as PowerPivot for Excel, SSAS and SSRS
• Updated on the latest Hadoop 2.2
Analytics Platform System (PDW vNext) delivers:
• HDInsight on prem for Hadoop as part of the pre-built appliance alongside relational data with SQL Server PDW
• Hadoop in APS is Enterprise ready – offers integration with System Center, Active Directory and Windows Failover Clustering
• Ability to query Hadoop data and integrate with relational data in SQL Server PDW leveraging T-SQL language with PolyBase
Hortonworks Data Platform For Windows delivers:
• On-premises Hadoop distribution to self-deploy on own servers
6 6
Comparison and Selling
Approach Per Vendor
How to Sell in a Competitive Situation
7
What is Oracle Exadata Database Machine?
Oracle Exadata Database
Machine
Microsoft Advantages
● Runs all types of database workloads including online
transaction processing, data warehousing, and
consolidation
● Optimized: workload-specific appliances and reference
architectures (RAs) for more targeted performance
● High performance with industry standard hardware
● Agile: lower risk and meet business needs through
choice of appliance or proven RAs
● SmartScan and Smart Flash Cache
● Better price/ performance characteristics
● Hybrid Columnar Compression: 5-15x data compression
● Runs on any commodity hardware
● Ties customers to Sun hardware
● Option for hybrid solution
● Higher price range
● Analytics Platform System: All processing happens in
parallel compute nodes. Two tiers, DRAM and disk.
● In-memory Columnstore, 10-100x DW query
performance
What is Oracle Exalytics In-Memory Machine?
Exalytics In-Memory
Machine
Microsoft Advantages
● Engineered system that provides an optimized
hardware and software configuration
● End-to-end BI tool including in-memory database
technology
● Designed for large and complex analytics workloads
● Self-service BI
● In-memory database technology
● No need to purchase and learn a separate tool
● Exalytics adds on hardware-specific optimizations to
Oracle Business Intelligence Enterprise Edition (OBIEE)
● Interoperability with Microsoft and non-Microsoft tool
● OBIEE is primarily used for static reporting
● Polybase allows native query across the Analytics
Platform System
What is Oracle Big Data Appliance?
Oracle Big Data Appliance
Microsoft Advantages
● Delivers Hadoop based on Cloudera with Optimized
Hardware
● Provides enterprise-class security through integration of
Hadoop with Active Directory
● No T-SQL integrated querying tool – leverages
Cloudera Impala which just works for querying Hadoop
data
● HDInsight makes Apache Hadoop available as a service
in the cloud
● Also available in cloud
What is Oracle Database 12c?
Oracle Database 12c
Microsoft Advantages
● Available on a choice of platforms
● The SQL Server data platform provides mission-critical
performance, faster insights from any data, and
platform for hybrid cloud
● Simplifies the process of consolidating databases onto
the cloud
● Enabling customers to manage many databases as one
without changing their applications
● Benefit customers deploying private database clouds
● To manage big data and data warehouse workloads
● Offers on-premise and public cloud solutions, including
hybrid solutions
● End-to-end in-memory offering that spans OLTP, DW,
and BI
● Lower total cost of ownership (TCO) and license cost
What is SAP HANA?
SAP HANA
Microsoft Advantages
● In-memory database software
● Optimized in-memory solution for all workloads
● Database plus pre-configured hardware
● Familiar environment
● Costs don’t scale well with data growth
● Ability to use existing hardware
● Easy to scale from desktop to datacenters
● Ease of adoption
● Fast time to value
What is SAP Sybase IQ?
SAP Sybase IQ
Microsoft Advantages
● Dashboards, ad-hoc web queries, reporting, OLAP, and
data integration
● SQL Server in-memory data warehousing ColumnStore
capabilities
● Encryption, authentication, authorization, and auditing
features for data security
● SQL Server is least vulnerable database (see slide 39)
● Four different techniques to integrate Hadoop data
and analysis
● Fast data streaming
● Sybase Big Data solution is not available in the cloud
● Does not support programming languages,
such as Pig or Hive
● Available both in the cloud and on-premise, including
hybrid
● HDInsight supports Pig, and Hive programming
languages
What is SAP BusinessObjects?
SAP BusinessObjects
Microsoft Advantages
● Top strengths: reporting and ad hoc query
functionality6
● Power BI for Office 365 offers a cloud-based BI
environment and self-service BI capabilities
● Major release for SAP in the BI domain
● Enables sharing insights, collaborate and access reports,
virtually from anywhere
● Platform agnostic
● BI positioned as a feature of a typical SAP deployment
● Frequent changes in pricing and contracting models
● Relatively longer lead time to create reports
● Complete BI solution, interoperating with Microsoft and
non-Microsoft products
● Favorable price/performance ratio
What is SAP Lumira?
SAP Lumira
Microsoft Advantages
● Connect to your data – big and small – and blend
multiple data sources in the same view
● Power BI: Self-service BI with the familiarity of Office
● Interactive maps and geolocations
● Q&A in Power BI helps create ad hoc reports
● Self-service BI in the cloud
● Learning curve to use a new tool
● Additional investment to purchase a separate tool
● Part of SQL Server 2014 offering without additional cost
● 3-D storytelling through Power Map
What is IBM Cognos?
IBM Cognos
Microsoft Advantages
● Combines data mining and BI
● Power BI
● IBM Business Analytics Optimization unit
● User-friendly BI with familiar tools
● Some concerns about performance and ease of use
● Full range of features
● Higher costs
● Complete data analytics solution for lower cost
What is IBM PureData System for Analytics?
IBM PureData System
Microsoft Advantages
● High-performance data warehouse appliances
● Analytics Platform System delivers on-premise Hadoop
distribution in a pre-built appliance
● Proprietary hardware
● Limited support for mixed workloads
● No in-memory solution
● Higher total cost
● Value: Highly favourable price/ performance ratio
● Flexibility: Choice of hardware and choice of appliance
or proven RAs
● Support for mixed workloads as SQL Server supports
indexes
What are IBM Big Data Solutions?
IBM Big Data Solutions
Microsoft Advantages
● IBM PureData for Hadoop integrates InfoSphere
BigInsights & DB2 BLU Acceleration into appliance
● Microsoft provides Microsoft Azure HDInsight Service, a
Big Data solution powered by Apache Hadoop
● Heavy reliance on IBM Global Services or partners
● Microsoft Azure Marketplace provides access to thirdparty data or applications for integration into Big Data
solutions
● No access to third-party data or applications for
integration into Big Data solutions
What is Tableau?
Tableau
Microsoft Advantages
● Drag and drop dashboard creation
● Excel and Power BI for Office 365
● Multi-platform availability
● Excel is the most commonly used analytical tool for
business users
● Largely departmentally deployed
● Lacks broader BI platform capabilities
● Self-service business intelligence combined with Data
Stewardship and IT management
● Limited but expanding international presence
● Leverages how we work: search and natural language
● Higher TCO especially for broader roll-out
What is QlikView?
QlikView™
Microsoft Advantages
● Ease of use, interactive dashboards
● Excel and Power BI for Office 365
● Big Data analysis with 100% in-memory architecture
● Excel is the most commonly used analytical tool for
business users
● More appropriate for departmental use
● Cost of software can be a barrier to broader
deployment
● Report development time might take longer
● Self-service business intelligence combined with Data
Stewardship and IT management
● Leverages how we work: search and natural language
What is Amazon Web Services?
Amazon Web Services™
Microsoft Advantages
● Charging only for the Hadoop instances and storage
● Azure and the services it provides for database, such as
the Microsoft Azure SQL Database, SQL Server in
Microsoft Azure Virtual Machine, and Microsoft Azure
HDInsight Service
● No need to manage or tune Hadoop clusters
● Amazon is not available as an appliance
● Database service products: Amazon Relational Database
Service (RDS) and Amazon DynamoDB
● Choice between on-premises or Cloud-based solution,
while Amazon only provides Cloud solution
What is Teradata Data Warehouse Appliance?
Teradata™ DW Appliance
Microsoft Advantages
● Appliances for big data analytics
● Analytics Platform System
● Locks their customers to proprietary hardware
● Pre-built appliance
● Lack of integrated BI tools
● Modern data warehousing
● Centralized architecture - hard to adapt as DW grows
● Works with Microsoft and non-Microsoft products
● High cost - up to $10M per deployment
Some Myths and How to Dispel Them
Myth: ”But SAP and Oracle have in-memory technologies.”
Suggested answer: Microsoft has built-in memory OLTP, data warehousing, and BI in SQL Server 2014 that can easily work
with existing applications on commodity hardware and analyse data of all types as fast as competing in-memory offerings.
Myth: ”Excel tables are pretty old-fashioned.”
Suggested answer: With Excel you can now discover, analyze, and visualize data like never before to find valuable business
insights. Work with big or small data. Leverage interactive visualization and 3D geospatial analysis.
Myth: ”Microsoft’s BI is only meant for the Microsoft stack.”
Suggested answer: Microsoft BI can interoperate with non-Microsoft products. For example, SQL Server 2012 Reporting
Services is designed to provide out-of-the-box support for both Oracle and Hyperion Essbase.
Myth: ”Microsoft does not offer vertical or line of business BI analytic applications.”
Suggested answer: Microsoft BI has a broad ecosystem of SI partners that have the industry/vertical expertise.
Data Analytics
Why Go with Microsoft
24
Top Six Reasons to Choose Microsoft
for Data Analytics
Easy access to data, big
& small
Powerful, familiar BI
tools for everyone
Complete data
platform, including
both DW and BI
Leader in the BI
Industry
Security and
compliance
Resources
SQL Server website
http://www.microsoft.com/en-us/sqlserver/product-info/top-twelve.aspx
Why Microsoft website
www.whymicrosoft.com