Lexmark

1
Lexmark

• By Rosanna Nadal Irina Yermolovich

2
Lexmark InternationalGlobal manufacturer of
printing products and solutionsfor customers in
more then 150 countries.

• Printers
• a) Color and monochrome laser printers
• b) all in one inkjet printers
• Printing supplies
• Business and professional, government and
  educational solutions

3
Extremely Competitive Business

• Competition is tough in printing business
• HP
• Canon
• Xerox
• Epson

4
Old System

• Slow, inefficient and inaccurate
• Manual report creation
• Cut and paste results from spreadsheets
• Obsolete intranet
• Reports are generated by analysts, not users
• Data is inaccurate and old

5

• BI (Business Intelligence) Solution
• Retail BI System
• Analytics
• Business Analytics (BA)

6
New System
7
MicroStrategys Classification of BA Tools

• Enterprise reporting
• Cube analysis
• Ad hoc querying and analysis
• Statistical analysis and data mining
• Report delivery and alerting

8
OLAP vs. OLTPCorporate Transaction Processing is
a critical part on Business

• OLTP
• Processing repetitive transactions in large
  quantities
• Simple data manipulations

• OLAP
• Processing many data items in complex
  relationships
• Analysis of relationships and patterns
• Processing specific open ended questions

9
Types of Analytical Processing

1. Categorical analysis
2. Exegetical analysis (Drill-down analysis)
3. Contemplative analysis
4. Formulaic analysis

10
Characteristics of OLAP

1. Multidimensional conceptual view for formulating
   queries
2. Transparency to the user
3. Easy accessibility batch and online access
4. Consistent reporting performance
5. Client/server architecture the use of
   distributed resources
6. Generic dimensionality

11
Characteristics of OLAP

1. Dynamic sparse matrix handling
2. Multi-user support rather than support for only
   a single user
3. Unrestricted cross-dimensional operations
4. Intuitive data manipulation
5. Flexible reporting
6. Unlimited dimensions and aggregation level

12
Reports and Queries

• Routine Reports
• Ad Hoc (on demand) reports
• Scorecards and Dashboards
• Ad Hoc queries
• SQL querying

13
Multidimensionality

• Dimensions
• Measures
• Time

14
Cube Analysis and Views
15
Results

• Information is
• Timely
• Accurate
• Detailed
• Increased profitability
• New sales opportunities
• Increased partner loyalty
• Elimination of inventory problems

16
Results

• All employees are using the system
• Improvement in performance
• Managerial improvement
• Business Trends
• Consumer Demand
• Better decision on pricing and promotions
• Better customer and partner service
• Top Company on a printing market and preferred
  supplier

17
The End

• Applause!!!!!!!!!!