Transcript Data Discovery

A New BI Paradigm
Data Discovery
Brad Peterman
Enterprise Client Deployments
QlikTech, Inc.
Traditional BI Covers:
Dashboards, Reporting, Data Mining, Ad-Hoc Analysis, OLAP,
Advanced Visualization, Data Mining, Scorecards
These are extremely important capabilities for a BI program, but how
well do they help you with the needs 2009 will bring?
• Find 3 areas to reduce licensing costs across our departmental systems this year
• Eliminate 3-5 workgroup databases that are managed by our IT staff
• Reduce ad-hoc query development costs by 80% on our application databases
• Find all applications not in compliance with the new usage logging standards
• Compare and correlate metrics based on disparate data
Answer: not very well. Why?
Traditional BI is built on warehouse, data mart and OLAP data structures that
come from the most well-known, well-associated data our businesses have.
Meaning, most of the low-hanging fruit of discovery on that data was
performed years ago. The harder cost saving solutions will come from those
data sources that have hidden association and undiscovered opportunities.
The Real State of the Data Universe
•This model only accelerates,
it never slows down
•Discoveries are made in the
mantle, not the core
•New data sources can be ripe
with opportunities
•Don’t wait for TDWI and
Gartner to catch up.
•Add Data Discovery to your
EDW/BI capabilities mix
Data Discovery – What Is It?
def: Uncovering opportunities to improve business results using
disparate data sources, democratized processes and low cost solutions.
Three key components
disparate data sources
the good: Insights and opportunities are already documented in our databases.
the bad: They are not packaged and connected for our analysis.
democratized process
the good: We have analysts who know how to improve business results
the bad: Our analysts don’t have simple tools they can use to do this analysis
low cost solution
the good: We know we can’t afford massive IT projects to find these opportunities
the bad: We haven’t yet found a better way to do this at a low cost
QlikView for Data Discovery!
QlikView’s ability to pull disparate data together with a simple, intuitive
interface makes it a great solution for the data discovery capability.
Why is QlikView perfect for Data Discovery?
•
associative data model
•
in-memory technology
•
simple, intuitive interface
•
low-cost, simple architecture
•
scalability to grow solutions
License Remediation
Use QlikView to connect an application database, its log files, your
Active Directory (or other LDAP source) and HR job data to find
opportunities to reduce or better optimize license usage.
Consulting Cost Reduction
Use QlikView to connect to departmental databases, time tracking data
sources and HR consultant data to identify manual processes that are
being performed by high priced consultants.
Data Consolidation
Use QlikView to connect a redundant workgroup database (maybe in
Access or SQL Server) to an enterprise database and determine the
overlap and degree of manipulation needed to migrate data from the
workgroup database and then eliminate it.
Why do we need Data Discovery?
• We are all looking for cost reductions
• We have the data and insights in our databases
• We have the analysts who know how to reduce costs
• We now have a tool that combines them to produce fast results
…something traditional BI has not been able to produce
The Power of You
Thank You!