Docstoc

Business-Intelligence-Challenges-2009

Document Sample
Business-Intelligence-Challenges-2009 Powered By Docstoc
					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 Aggregates

Database Servers

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 Servers? Faster Servers? More Indexes? Composite Indexes? 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 be able to promote a new product combination

I want to relax my methodology policy

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? Operation: Models are called by a business rules engine to “score” an individual or contact.

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.

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 Business Goals
Data
Accountability

2008
Product Expansions

2009
Customer Consolidation

2010
Globalization

Support product Rollout Top 50 Markets

EPS and Revenue Growth Data Quality Assurance

Regulatory and compliance Support BI Support for 20% Of Employees

Market Monitoring and Reporting

Information

Intelligence

Insight

Analytical Capabilities
•Canned Reports •Parameter Reports •Dashboards •Adhoc Reporting •Key Demo Metrics Alerts •Compliance Monitoring •Market monitoring •Weekly and Monthly Metric Projections •Performance and Benchmark projections

Backward Looking
Technical Deliverables Infostructure Data structures

Alerts
Verified Data

Forward Looking
Market Performance Process Performance

Daily Panel Results
Daily Data Aggregates

?

Resources

Infrastructure

Business Metrics Repository

Internal / External

30

The End

31


				
DOCUMENT INFO
Shared By:
Stats:
views:199
posted:6/16/2009
language:English
pages:31