business analysis technology business intelligence december 3 2013 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Business Analysis Technology Business Intelligence December 3, 2013 PowerPoint Presentation
Download Presentation
Business Analysis Technology Business Intelligence December 3, 2013

Loading in 2 Seconds...

play fullscreen
1 / 14

Business Analysis Technology Business Intelligence December 3, 2013 - PowerPoint PPT Presentation


  • 112 Views
  • Uploaded on

Business Analysis Technology Business Intelligence December 3, 2013. Business Intelligence (BI). Agenda. LSS & BI (Case Study). Dashboard Development. Business Intelligence.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Business Analysis Technology Business Intelligence December 3, 2013' - edan-schneider


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
agenda

Business Intelligence (BI)

Agenda

LSS & BI

(Case Study)

Dashboard Development

business intelligence
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?

  • 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
  • Companies are realizing that data is a company’s most underutilized asset
business intelligence data warehouse

External Data Sources

Business Intelligence & Data Warehouse

Dashboard

Dashboard Balanced Scorecard

KPI Financial Metrics

Internal Source Systems

Data Warehouse

Data Mart

Extract, Transformation and Load

SQL

RDBMS

Microsoft SQL Server

Microsoft Access

Oracle

IBM DB2

MySQL

Etc.

Business Intelligence

Microsoft Excel

Microsoft SQL Server

Tableau

Business Objects

Cognos

Etc.

business intelligence environment

Broad User Base

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

Business Intelligence Environment

Microsoft Excel

metrics

Examples

Revenue

Profit

Expenses

Number of Customer Calls

Number of Customer Complaints

Product Defects

Gross Margin Percent

Accidents per Mile Driven

Cost of Sales

Overhead Percent

Customer Churn

Employee Turnover

Return on Investment

Income per Capita

Capacity

Utilization

Average Bill Rate

Management Ratio

Metrics

A quantifiable measure of performance Allows for assessment and comparison

Allows for assessment and comparison

agenda1

Business Intelligence (BI)

Agenda

LSS & BI

(Case Study)

Dashboard Development

balanced scorecard for yum brands
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?

Financial

Market share

Revenue

Profit margin

balanced scorecard for yum brands1
Balanced Scorecard for Yum Brands

Customer

Customer centricity

Acquisition and Retention

Pricing strategy (CI)

Process

Process capability

Quality control

Customer experience

Growth

Market penetration

Employee turnover

Distribution channels

agenda2

Business Intelligence

Agenda

LSS and BI

(Case Study)

Dashboard Development

business intelligence data warehouse1

External Data Sources

Business Intelligence & Data Warehouse

Dashboard

Dashboard Balanced Scorecard

KPI Financial Metrics

Internal Source Systems

Data Warehouse

Data Mart

Extract, Transformation and Load

SQL

RDBMS

Microsoft SQL Server

Microsoft Access

Oracle

IBM DB2

MySQL

Etc.

Business Intelligence

Microsoft Excel

Microsoft SQL Server

Tableau

Business Objects

Cognos

Etc.

slide12

Dashboard Development

  • Demonstration (In-Class)
  • Cureitall Data(Cureitall Hospital) will be used to demonstrate Excel dashboard development.
  • Training (Online Video)
  • Online Dashboards tutorial using sample Dataset for Dashboards (Call Center) andMicrosoft Excel 2010.
  • 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.
slide13

Dashboard Development

  • Practice Exercise - Cureitall Hospital would like to introduce Orthopaedic, Endocrine and Podiatric surgery.
    • 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.
    • 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?
slide14

Next Steps

  • 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)
  • 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