Transcript Agenda - Center

New Partner Opportunities with
BI, Big Data and SQL Server 2014
• Market opportunity
• Microsoft Data Platform
solutions
• Microsoft programs for
partners
• Next Step
Millions
Canadian application market growth forecast (2014-2015)
$2,500
Series1
$2,000
Series2
$1,500
$1,000
$500
$0
1
2
3
4
5
6
7
Source: IDC 2013, Microsoft
8
9
4
TOP CIO Technology Priorities in 2013
1. Analytics and business intelligence
2. Mobile technologies
3. Cloud computing (SaaS, IaaS, PaaS)
4. Collaboration technologies (workflow)
5. Legacy Modernization
6. IT Management
7. CRM
8. Virtualization
9. Security
10. ERP Applications
5
Workload
Solutions
New Scenario
Database(OLTP)
SQL Server 2014
•
•
In-Memory OLTP
Hybrid for DR and Backup
•
•
Performance (up to 30x)
Save OPEX and CAPEX
•
•
In-Memory for DW
Data Compression
•
•
Performance (up to 30x)
Save on storage
•
MPP
•
Hadoop on Windows, Azure,
Appliance
•
Fast BIG Data solution
deployment
Management (AD, System
Center)
Azure IAAS and Storage
Data Warehousing
SQL Server 2014
Analytics Platform System
(Appliance) *
Big Data (Unstructured)
HDInsight (Azure)
Analytics Platform System
(Appliance)*
Value for customer
•
BI
Power BI for Office 365
•
•
•
Cloud BI
Power Q&A
Mobile BI
•
•
Get insights
Easy to use, Easy to deploy
Predictive Analytics
Azure Machine Learning
•
Predictive Analytics
•
•
Data analytics and Forecasting
Fast to deploy
SQL Server Parallel Data Warehouse (PDW)
Bwin Case Study: In-memory for OLTP
Links: Published Case Study
Amway Case Study: Disaster Recovery with Azure
Situation
Benefits
34TB of information spread
across 100 instances of SQL
Server, with data growing at 15%
p.a.
•
100% uptime
•
Failover in 10 seconds, compared to 45
before
•
Hardware and DBA scaling
•
•
Hours of effort required during
failover
Recovery time reduced from six
person hours to 30 seconds
•
•
Wanted higher data availability,
greater reliability, and more costeffective disaster recovery
Facilitates more frequent recovery
testing: from once every year to once
every quarter
•
Links: Published Case Study
Business Continuity Solution on
Windows Azure
Use for Disaster Recovery
Power BI: A powerful new way to work with data
Discover
Analyze
Visualize
Search, access, and transform
public and internal data sources
with Power Query
Easy data modeling and
lightning fast in-memory
analytics with Power Pivot
Bold new interactive data
visualizations with Power View
and Power Map
Share
Question
Q&A
Mobility
Scalable | Manageable | Trusted
Share data views and
workbooks refreshable from onpremises and cloud based data
sources, with Power BI Sites
Ask questions and get
immediate answers with natural
language query
Mobile access through HTML5
and touch optimized apps
Power BI Offers & Pricing
Power BI for Office 365 is now
available to all competency partners as
a core IUR benefit for MPN
DirectEdge Case Study: Analytics Platform System*
APS: Big Data Appliance
•
Hardware + Software
•
For Structured & Unstructured Data
•
Scale our with MPP
•
HortonWorks Hadoop Distribution
•
PolyBase Query Technology
Situation
Real-world Query Performance
Query Speed in Seconds
Series1
5000
One of the largest equities exchanges in the world
•
Trades about 10% of the total market volume each day
•
Slow query performance: 2-4 hours per query
•
IT team relied on subsets of data instead of full dataset
Links: Published Case Study
4200
4000
3000
2000
1000
•
Series2
0
1200
16
1
263x
6
1200
2 120
2 120
2 120
4
2
3
4
5
6
200x
60x
60x
60x
300x
APS/PDW times faster than original query speeds
Advanced Analytics with Azure ML
Big Data with Hadoop
What about the money?
Example:
Data Mart + Reporting
Typical BI Project Types
(Mid-Market/Department Scale)
Customer’s
investment
Partner’s
revenue
$100 K
~$10K*
-*
$10K
$100K
$100K
$1,000 K
Software
$500 K
Services:
BI Deployment
Planning Services
(10 days)
$300 K
$30 K
1
$70 K
2
3
4
5
Services:
Deployment
Total
Part of customer’s Software Assurance
$120k
OLTP
DW & Big Data
BI
• Most popular database in Canada (68%) (1)
• Performance World Record for OLTP (2)
• Most Secure database 5 years in a row (4)
• Leader in Gartner MQ for DWMS (3)
• Performance World Record for DW (2)
• APS – best price per TB among top DW appliance players (5)
• Leader in Gartner MQ for BI and Analytics Platforms (3)
• Most Popular BI tool in the World
1. IDC Canada, IT Advisory Panel Survey n3, 2013.
2. As of April 15, 2014, TPC-H 10TB and 3TB benchmarks for non-clustered configuration, TPC-E
3. Microsoft was named a leader Gartner Magic Quadrant for Business Intelligence and Analytics Platforms (Feb 2014) and Data Warehouse Database Management Systems (Mar 2014)
4. National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/201
5. Value Prism Consulting, March 2013
Your expertise,
Competency
Data platform, BI
IT Infrastructure
Productivity,
Collaboration
Business Solutions
(ERP, CRM, Project)
ISV
Database(OLTP)
Data Warehousing
Big Data
(Unstructured)
Power BI for Office
365
Predictive Analytics
Resources and Programs for partners
Marketing
•
•
•
•
MPN Marketing Center https://mspartner.microsoft.com/en/us/pages/sales%20and%20marketing/overview.aspx
Marketing materials, content, demo: www.aka.ms/SQL14content
$1k per event funding for Data Insight briefings (1:Many) www.aka.ms/DIIPIE
Promote your events on Data platform events lending page www.aka.ms/SQLevents
Sales
•
•
•
•
Data Insight Immersion virtual environment (SQL, Power BI, Azure)
Deployment Planning Services http://planningservices.partners.extranet.microsoft.com/en/SQDPS/pages/default.aspx
Azure PoC funding for SQL Hybrid, Azure ML, HDInsight, Power BI (Azure\Power BI op-ty size $15k+)
SQL 2014 project funding (SQL Server op-ty size $100k+)
Readiness
• Trials, Virtual labs, Trainings, webcasts, events: www.aka.ms/SQLBI
• Free Power BI licenses for internal use www.microsoft.com/msppdd/
• Partner Advisory Hours https://mspartner.microsoft.com/en/us/pages/support/partner-advisory-hours.aspx
Data Insight Immersion (DII)
• DII (1:1)
• Half day hands on training for a
customer delivered by partner
• Value
• Identify and accelerate opportunities
• Data Insight Briefing (1:Many)
• Half day marketing event for customers
(includes presentations and demos)
• Value
• New leads, Visibility on MS site
• Infrastructure & Resources
•
•
•
•
Cloud Infra to deliver Hands On and Demo
Content: Customer invite, decks..
Funding: $1k per event for Data Insight Briefings (1:Many)
Conference room in MS Office (1:Many)
www.aka.ms/DIIPIE
Part of customer’s SA benefits
60 000 days = $60M
Projects to plan:
• Deploy BI
• Upgrade to SQL Server 2014
• Migrate from Oracle to SQL
Server
• Hybrid with Azure
About: www.aka.ms/deploySQL
Cloud Ready – Exclusive Offer for SMBs
Customers can earn partner subsidy dollars when they purchase qualifying eligible Open
Program licenses of Windows Server (Standard and Datacenter), SQL Server (Standard and
Enterprise), Office 365 and Azure.
Purchases until November 30, 2014
Offer Valid from September 2 – November 30, 2014.
Learn more at http://www.microsoft.com/en-ca/web/cloud-ready
Summary
Market
opportunity
Microsoft
offerings
• TOP priority for CIO
• Data Platform is the Fastest growing application
market
• Data storage and analysis requirements undergoing
exponential growth
•Workloads: OLTP, DW, BI, Predictive Analytics and BIG
Data
•Solutions: SQL Server 2014, Power BI, Azure ML, APS,
HDInsight
•Resources for partners: Trainings, PoC, Sales and
Marketing support
Next step
MS SQL Canada Twitter
• @CANSQL
LinkedIn Community
• MS SQL Server Professionals - Canada - aka.ms/canSQL
Blog
www.aka.ms/SQLBlog
Participate in the Data Platform Technical Series
training sessions in-person, or on-demand!