Current Business Intelligence Challenges By Lonnell Branch
Table of Content • Current State • Data warehouse Issues • Reporting Issues • Future State
2
Current State
3
Where Is Business Intelligence Headed?
4
Business Challenges • • • • • •
Evolving Business Models Unique Data Models Nonstandard Reporting Periods Nonstandard Market definitions Dense Aggregation Models High level of interactive and adhoc reporting requirements • Dynamic event driven report scheduling requirements 5
Reporting tools
Business Intelligence Architecture
Report Servers
ETL Servers Dimensions
Database Servers
Aggregates
Facts 6
Query Tool Diversity
Let’s Start Reporting
7
Query Overload Why can’t I query all markets for 18 months of product sales by store, demo and sales campaign?
8
Query performance tune up kit Bigger Servers?
More Indexes?
More Servers?
Composite Indexes?
Faster Servers?
Bitmap Indexes? More Partitions?
How do we get faster queries? 9
Has the ETL Run Yet?
How do we coordinate ETL and Reporting Processes?
10
What is in the data warehouse?
Business users want to know. Power users need to know. Do we really know? 11
Reporting Challenges • Out of box BI tool configuration failing to meet user expectations. • Perceived lack of what if capabilities in BI tools. • BI tool SDK complex. Not end user or developer friendly. • Database performance issues increasing • Business data not integrated or aggregated enough. 12
How do we get BI to the small guy?
13
What is the BI Portal?
Is the BI portal the most productive environment for end users, developers or clients?
14
What Business Reports are availabe from the BI tool?
15
How do we improve business performance with BI? BI Architects? Data Architects?
Report User’s Input? 16
What do users Want?
17
Less Complexity
18
Data Democracy
19
Speed !!!
20
Future State
21
22
23
Suggestions
24
Empower the Business to Manage the Rules and Reporting • Report maintenance must be: – A business function – Familiar – Integrated – Secure & controlled So you businesstypes want to be able to change your reports?
I want to relax my methodology policy
I want to be able to promote a new product combination
I need to add the new regulations
25
Analytically improve the rules Use: Find the relationships between customers Example: Sort customers into groups with different buying profiles. Descriptive analytics can be used to categorise customers into different categories – which can be useful in setting strategies and targeting treatment.
Operation: Analysis is generally done offline, but the results can be used in automated decisions – such as offering a given product to a specific customer 26
Add predictive insight Use: Identify the odds that a customer will take a specified action Example: Will the customer respond to this promotion?
Predictive analytics often rank-order individuals. For example, credit scores rankorder borrowers by their credit risk – the higher the score, the more “good” borrowers for every “bad” one.
Operation: Models are called by a business rules engine to “score” an individual or contact.
27
Let’s Plan for Change
28
Lets Develop A BI Strategy Business Goals Business Strategy
Analytic Capabilities
Operations Monitoring
Tactical Analysis
Business Performance Management
Intelligence Information BI Infrastructure People
29
Integrate Strategy and a BI Roadmap 2007 Business Drivers
2008
Accountability
2009 Customer Consolidation
Product Expansions
EPS and Revenue Growth
Support product Rollout Top 50 Markets
Business Goals
Market Monitoring and Reporting
Data
2010
Information
Globalization
Regulatory and compliance Support Data Quality Assurance
Intelligence
BI Support for 20% Of Employees
Insight
Analytical Capabilities •Canned Reports
•Dashboards
•Key Demo Metrics Alerts
•Parameter Reports
•Adhoc Reporting
•Compliance Monitoring •Market monitoring
Backward Looking Technical Deliverables
Verified Data
Infostructure
Daily Panel Results
Data structures
Resources
Infrastructure
Alerts
Daily Data
•Weekly and Monthly Metric Projections •Performance and Benchmark projections
Forward Looking Market Performance Process Performance
Aggregates
Internal / External
?
Business Metrics Repository
30
The End
31