Transcript Express Brand Plan FY 2000

Business Analysis Technology
Business Intelligence
December 3, 2013
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 1
Agenda
Business
Intelligence
(BI)
Lean Six Sigma - Confidential
LSS & BI
(Case Study)
Dashboard
Development
Business Intelligence.ppt/Dec 3, 2013/Page 2
Business Intelligence
“Encompassing all aspects of collecting, deriving, analyzing, presenting and
disseminating relevant business information to enable better business decisions
and/or drive business processes"
Why Business Intelligence?
1.
2.
3.
4.
5.
Improve consistency and accuracy of reporting
Reduce stress on operational systems for reporting and analysis
Faster access to information
BI tools provide increased analytical capabilities
Empowering the Business User
6.
Companies are realizing that data is a company’s most underutilized
asset
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 3
Internal Source
Systems
Extract, Transformation and Load
Business Intelligence & Data Warehouse
Dashboard
Dashboard
KPI
Balanced Scorecard
Financial Metrics
Data Warehouse
Data Mart
SQL
External Data
Sources
RDBMS
Lean Six Sigma - Confidential
Business Intelligence
Microsoft SQL Server
Microsoft Excel
Microsoft Access
Microsoft SQL Server
Oracle
Tableau
IBM DB2
Business Objects
MySQL
Cognos
Business Intelligence.ppt/Dec
3, 2013/Page 4
Etc.
Etc.
Business Intelligence Environment
Broad User Base
Microsoft Excel
Microsoft Access
Data Warehouse
Data Mart
BI Query & Analysis Tools
Ex: MS SQL Server,
Tableau, Brios, etc.
OLAP Cubes
EIS / Dashboards
β
Data Mining Tools (SAS, Minitab)
Narrow User Base
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 5
Metrics
A quantifiable measure of performance Allows for assessment and comparison
Allows for assessment and comparison
Examples
Revenue
Profit
Expenses
Number of Customer Calls
Number of Customer Complaints
Product Defects
Gross Margin Percent
Accidents per Mile Driven
Cost of Sales
Lean Six Sigma - Confidential
Overhead Percent
Customer Churn
Employee Turnover
Return on Investment
Income per Capita
Capacity
Utilization
Average Bill Rate
Management Ratio
Business Intelligence.ppt/Dec 3, 2013/Page 6
Agenda
Business
Intelligence
(BI)
Lean Six Sigma - Confidential
LSS & BI
(Case Study)
Dashboard
Development
Business Intelligence.ppt/Dec 3, 2013/Page 7
Balanced Scorecard for Yum Brands
•
Balanced Scorecard is a concept helping you translate strategy into action
via corporate performance management. The Balanced Scorecard describes
the strategy for creating value and it realigns resources to ensure the
strategy is successfully executed. Six Sigma executes the strategy by using
data, business intelligence, and process improvement tools.
•
Can a Lean Six Sigma Scorecard Be the Answer to Strategy Execution?
I.
Financial
•
Market share
•
Revenue
•
Profit margin
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 8
Balanced Scorecard for Yum Brands
II.
Customer
•
Customer centricity
•
Acquisition and Retention
•
Pricing strategy (CI)
III. Process
•
Process capability
•
Quality control
•
Customer experience
IV. Growth
•
Market penetration
•
Employee turnover
•
Distribution channels
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 9
Agenda
Business
Intelligence
Lean Six Sigma - Confidential
LSS and BI
(Case Study)
Dashboard
Development
Business Intelligence.ppt/Dec 3, 2013/Page 10
Internal Source
Systems
Extract, Transformation and Load
Business Intelligence & Data Warehouse
Dashboard
Dashboard
KPI
Balanced Scorecard
Financial Metrics
Data Warehouse
Data Mart
SQL
External Data
Sources
RDBMS
Lean Six Sigma - Confidential
Business Intelligence
Microsoft SQL Server
Microsoft Excel
Microsoft Access
Microsoft SQL Server
Oracle
Tableau
IBM DB2
Business Objects
MySQL
Cognos
Business Intelligence.ppt/Dec
3, 2013/Page 11
Etc.
Etc.
Dashboard Development
i.
•
Demonstration (In-Class)
Cureitall Data (Cureitall Hospital) will be used to demonstrate Excel
dashboard development.
ii.
•
Training (Online Video)
Online Dashboards tutorial using sample Dataset for Dashboards (Call
Center) and Microsoft Excel 2010.
iii.
•
LSS and BI (Call Center Case Study)
How do we incorporate our dashboard into the DMAIC process? Using
Lean Six Sigma – Call Center to monitor different metrics.
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 12
Dashboard Development
iv.
Practice Exercise - Cureitall Hospital would like to introduce Orthopaedic,
Endocrine and Podiatric surgery.
1.
Introduce new Surgery Type
•
Please go to Data spreadsheet and add surgery type C
(Orthopaedic), D (Podiatric) and E (Endocrine) to the formula in
Column H.
•
Please change cell B90, B91, B92 to C, cell B93, B94, B95 to D,
and cell B96, B97, B98 to E. The Surgery Description (Column H)
should be updated accordingly.
2.
Measure the performance
•
Please go to Dashboard spreadsheet and update the “Average
Revenue and Profit” chart to reflect the new surgery type.
•
Can you develop a new chart to demonstrate the performance of
the new surgery type in terms of actual stay and margin?
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 13
Next Steps
1.
How to build dashboard using
Microsoft SQL Server, Tableau or
Business Objects?
•
•
•
Microsoft SQL Server (Free Trial)
Tableau (Free Trial)
Business Objects / SAP Crystal Reports
(Free Trial)
2.
What is the Relational Database
Management System (RDBMS)?
•
•
Basic database architecture
Using SQL to retrieve data for Excel,
Tableau, SQL Server, etc.
Online SQL learning materials
•
Lean Six Sigma - Confidential
Business Intelligence.ppt/Dec 3, 2013/Page 14