Business Intelligence Challenges 2009

  • Uploaded by: lbranch
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Business Intelligence Challenges 2009 as PDF for free.

More details

  • Words: 641
  • Pages: 31
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

Related Documents


More Documents from "Marco Garcia"