Dell Information Management solutions

(1)

1 10/28/2013 Information Management Solutions

Dell Information

Management solutions

Uday Tekumalla

Solutions Marketing, Information

Management

(2)

My introduction

• Uday Tekumalla, the ponytail guy

• Information management solutions

marketing

• Data guy: Database developer -> Strategy

(3)

Content

• Dell Software and Information Management

• The “data problem”

• Dell’s perspective and our solutions

–

Big data analytics & Business intelligence

–

Application & data integration

(4)

Mega trends bring huge potential and risk

Big data Mobility

Cloud

(5)

Dell Software solutions

Data center & cloud management • Endpoint management

• Performance management

• Virtualization & cloud mgmt

• Windows server mgmt • Application enablement/delivery • Desktop virtualization • Mobile device mgmt • Mobile security Information management • Application & data integration

• Business intelligence & Big data analytics • Database management Mobile workforce management • Email security • Endpoint security

• Identity & access management

• Network security

Security Data protection • Application protection

• Disaster recovery

• Enterprise backup/recovery

(6)

Information Management

Database management Application & data

integration

Business intelligence and Big Data Analytics

Integrate data

in disparate data stores,

off-premise and on-premise

Discover trends and

make informed decisions with analysis based on all

data

Manage data and

databases across structured and unstructured data sources – off-premise or on-premise

(7)

The “data

problem”

(8)

Historically, data was stored mostly in databases

Structured Data Database

Extract, Transform, Load (ETL)

Data provisioning Data warehouse Database management Data analysis Trained Staff Tool Chain

(9)

9 10/28/2013 Information Management Solutions Petabyte

Exabyte Zettabyte

Terabyte

Market situation: Data growth has skyrocketed

Multiple data types from many sources

Transactional Data Generated and stored in databases • Structured • Measured growth Human Files Content created outside databases

• Facebook, Twitter, RFID, cell phone etc.

• Multiple formats and different speeds of data creation

• Exponential growth

• Docs, Images, Video

• Multiple formats

• Fast growth

Social & Sensor data

(10)

Market problem: Data silos > fractured tool chain

-> fragmented analysis

Structured Database 1 Extract, Transform, Load (ETL) Data provisioning Data warehouse Trained Staff Tool Chain Database management

Analysis Analysis Analysis Analysis

Analysis Structured Database 2 Extract, Transform, Load (ETL) Data provisioning Data warehouse Database management Trained Staff Tool Chain Text Data store Extract, Transform, Load (ETL) Data provisioning Data warehouse Data management Trained Staff Tool Chain Sensor Data store Extract, Transform, Load (ETL) Data provisioning Data warehouse Data management Trained Staff Tool Chain Social Data store Extract, Transform, Load (ETL) Data provisioning Data warehouse Data management Trained Staff Tool Chain`

(11)

11 10/28/2013 Information Management Solutions Mana ge Integ ra te

Dell Information Management solutions break data silos,

manage, integrate and discover trends in all data

Structured, text, sensor, and social

Data store

Extract, Transform, Load (ETL)

Data provisioning Data warehouse Data management

• Foster collaboration between

IT and Line of Business

• Empower more people by

offering self service access to

data

• Make informed decisions

today and into the future

One Vendor – Complete Tool Chain - All Data

Trained Staff Tool Chain

(12)

Over 15 years of Information Management software experience

Tool for Oracle Application Development born in 90’s Quest Software acquires TOAD in 1998 TOAD expands support for Microsoft SQL Server, Sybase, IBM DB2, and MySQL in 2000’s In 2009, TOAD supports NoSQL, Hadoop, MongoDB, Cassandra, SimpleDB, Azure Later in 2009 Toad Data Point is launched for data analysts 2010 Dell Acquires Boomi 2011 Toad Decision Point is launched for business users 2012 Toad Intelligence Central launched for collaboration 2012 Dell acquires Quest Software & Kitenga Big Data Analytics 2013 Toad BI Suite 2.0 launched Boomi Created in 2000 2013 Boomi MDM launched Social Network Analytics Platform Coming Soon Quest creates SharePlex in 1999 Quest creates Spotlight in 2000 2012 Dell launches Quickstart Data Warehouse to solve needs of SMB

(13)

Dell’s solutions leverage your existing investments

and span the corporate information lifecycle

Manage

Integrate

Discover

Database

Development Administration Database Monitoring Database integration App & data discovery Data analytics Big data

Toad for

Developers Toad for DBAs Spotlight Boomi Toad Business Intelligence Suite

Kitenga

SharePlex Foglight for

(14)

DISCOVER - Big

data analytics

and Business

intelligence

(15)

To turn data into insights, you need fundamentals

in place before practicing higher level analytics

Initial data recording and archiving: begin data recording and

very basic ad hoc analysis

“Who or what are my top ten customers & products”

Storing and Modeling: Consolidate data into efficient storage,

integrate silo’d data, and apply data quality measures

“How do I best model my business processes and manage data?” Agility and interactivity for KPIs: Run the business using

standardized metrics for rapid response to business changes

“How are we performing? Where do we change or expand?” Predictions based on trends: Predict future buying trends based

on past behavior and financial status

“What is the optimal inventory based on historical trend? Customer behavioral insights: Learn what my customers think

about my company, product, service in real-time.

“Would they recommend us to a friend?” “What is my organization’s Net Promoter Score?”*

Predictive analytics Proactive reporting Information consolidation Casual data access and analysis

Cognitive analytics A nal y ti cs mat uri ty

(16)

Road blocks and capabilities to build at each stage

Spreadsheets + lack of systematic analysis Budget constraints + poor data integration + poor data quality Slow and lengthy BI projects + poor data interactivity

Limited skills and executive support Under-developed tools and limited skills

What’s lacking

Pivot tables, operational reporting

Data modeling, Database and data warehouse design Data quality, master data management

BI & dashboards, KPI metric design, data governance Data mining, forecast modeling, trend metrics Social listening, sentiment analysis, pattern recognition

Capabilities to build

Predictive analytics Proactive reporting Information consolidation Casual data access and analysis

Cognitive analytics A n alytic s m aturity

(17)

Kitenga analyzes all data

Analytics

Sophisticated NLP, machine learning, predictive modeling, sentiment analysis, SNA, and

visualization. No Hadoop/MapReduce programming expertise required

Analyze unstructured, structured and semi-structured data from a single work-bench Search

Interactive and intuitive. Search interface allows business analyst to explore and exploit all data resources

Visualization

Interactive web-based authoring empowers business users to perform analysis, visualize results and take decisions

Analytical Producer

Analytical Consumer

(18)

Toad enables self-service BI

Toad Data Point

(Querying and Data Prep)

Toad Intelligence Central

(Data mashups & Collaboration server)

Toad Decision Point

(Data discovery & visualization)

Presentation Layer

Share Storyboards via browser & tablet

Data Sources RDBMS Big Data Data

warehouses Desktop Cloud apps BI sources

Ensures IT governance

Provides rapid and governed access to all traditional and emerging data sources

Enables self service access

Easily access underlying data sources using self service tools

Increases ROI of existing BI

Complements existing tools and easily snaps into IT/BI and LOB systems

Fosters collaboration between IT and LOB

Bridges the gap between business users and IT with tools that enable collaboration

(19)

19 10/28/2013 Information Management Solutions NA Transportation Company

Largest toll way system Challenge

Client’s data provider was faced with report creation for finance, the

process was completely manual and required both finance and IT to repeat tasks monthly and weekly. Self service was impractical due to the complex data source.

Results

Empowered the data provider to easily connect to the multiple data sources in disparate systems and to run queries against all the relevant sources.

Finance department was enabled with visualization, data access, and refresh capability without assistance.

“Toad lets me access data that I was never able to integrate before. I can now provide my managers with a view of business-critical information that's not available through our normal

systems. Toad has opened the door to far deeper and more meaningful data

analysis, giving us invaluable insight

about our operating systems, “ Rick Bruno

(20)

(21)

• Maximize efficiency

• All-in-one solution – hardware, software, services included

• Powerful data warehouse in small footprint appliance

• Rapid deployment

• Startup, training, and quarterly health check services ensure success

• Speed to insights

• Balanced configuration for optimized throughput

• Connect to data in drag and drop interface

Dell Data Warehousing appliance comes packaged

with all tools you would need to build a DW

Web & Social Flat Files Syndicated Data Images Video Text ERP CRM SCM Cloud Source Data 12G Server Data Integration (Cloud or On-prem) Boomi

(22)

INTEGRATE -

Application and

Data Integration

(23)

23 10/28/2013 Information Management Solutions Clou d a p p s

Boomi integrates apps and data stores

On

-p

rem

ise

128-bit encryption

(metadata only) Data

Data Data

(24)

GoPro

Dell Boomi integration helped GoPro deliver efficient, scalable EDI

Challenge:

Find a way to quickly connect NetSuite with value-added networks (VANs) and AS2 connections to meet the strict EDI compliance standards of key retailers

Results

• 25 to 30% of transactions flow through EDI • Significantly improved

operational efficiencies

• 300% year-over-year growth that can scale to meet shifts in demand

(25)

SharePlex database replication & near real-time

data integration to local, remote or cloud target

• SharePlex creates a near real time copy of production database

• No impact to transactional systems • High availability and disaster

recovery

• Leading DB replication product since 1998, with a global presence • Gartner (2010) recommends

SharePlex for Oracle Standard Edition

• Other use cases: BI, data

warehousing, archiving, centralized reporting/consolidation, change tracking/auditing

(26)

MANAGE -

Database

(27)

Database management is a complex iterative

process

Toad - Develop

consistent, high quality, optimized code for

databases

Toad - Administer and proactively maintain databases from multiple

vendors

Spotlight - Monitor and analyze database activity in conjunction with other IT operations SharePlex - Replicate

your database to ensure high availability, and

reduce risk AppAssure - Backup your

database efficiently using powerful de-duplication

(28)

What is Toad?

• Best-of-breed productivity tools for developers and database administrators

• They reside on the user’s desktop and deliver immediate value – you can install,

connect to your databases and get to work, all in just a few minutes

• Users can download a free trial version from the website for 30 days

Why Toad?

1. Named # 1 in database development and optimization by IDC1

2. Over 2 million users world wide

3. Similar user experience, regardless of the underlying database platform (incl. cloud)

4. 15 years of proven excellence and expertise

5. Benefit from the power of community with Toad World (http://www.toadworld.com/)

(29)

Toad saved $49m at a large

transportation company

• Study conducted by Forrester

• 2,677% risk-adjusted ROI over the past five years

• Saved the customer more than $49M the past five years; payback period 1 year • Database (DB) professionals 20% more

productive.

• Hired less experienced DBAs. Focused experienced DBAs on high value projects. • DB professionals were cross trained on

different DB platforms, and could be staffed as needed.

(30)

• Easily detect and diagnose

performance issues

• Receive instant alerts of

bottlenecks and diagnose the root cause

• Identify changes to your DB

and optimize code quality

• Gather information and

create dashboards and reports

Spotlights turn data into insights for the DBA

Turning Data into insights for the DBA

* SQL Server * Oracle * Sybase * DB2

Database Performance Monitoring and Analytics

(31)

Dell Partner

Direct

(32)

32 10/28/2013 Information Management Solutions Systems

Management

• Client management

• Performance monitoring (ETA: 11/1) • Virtualization & cloud (ETA: 11/1) • Windows server management

Information Management

• Database management

• Identity & access management • Network security

Security _{Data Protection}

Dell PartnerDirect – Software Specialization

Tracks

(33)

Information Management

Database Management – Available 9/1/13

(Toad, SharePlex) Sales -(2/4 individuals, ~2 hr)

• Three Required Courses:

• Information Management Competency

Overview - INMA0913WBTS

• Toad Sales Training - TOAS0913WBTS • SharePlex Sales Training - SPLX0913WBTS

Technical - (2/4 individuals, ~3 hr)

• Two Required Courses:

• Information Management Competency

Overview - INMA0913WBTS

• Toad Technical Training - TOAT0913WBTT

Optional Database Management Curriculum • Database Fundamentals (Sales)

Business Intelligence/Data Analytics (Toad BI, QSDW, Kitenga) – Launch Date and Curriculum

TBD

Application/Data Integration (Boomi) – Launch Date and Curriculum TBD

(34)