Introduction Importance of presentation capability of BI Technologies that support decision making Tactical decisions Strategic decisions Online analytical processing OLAP Visual analytics Performance dashboards ID: 438710
Download Presentation The PPT/PDF document "Chapter 6: Technologies Enabling Present..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Chapter 6: Technologies Enabling PresentationSlide2
Introduction
Importance of presentation capability of BI
Technologies that support decision making
Tactical decisions
Strategic decisions
Online analytical processing (OLAP)
Visual analytics
Performance dashboardsSlide3
Online Analytical Processing
Transactional databases are accessed by online transaction processing (OLTP) applications
OLAP was coined by Edgar Codd [1970 ]
OLAP is used essentially to query the DW
OLAP supports the presentation of data in a multi-dimensional format called a cube
The numeric facts in the DW known as the measures Slide4
OLAP
Cubes
OLAP offers the ability to have more than three dimensions (hypercube)
Pivot
Table – A data summarization tool
OLAP
cubes enable slicing and dicing the dataSlide5
OLAP Cube, Data Slice and Dice Slide6
Visual Analytics
Visual analytics refers to the use of computer graphics to create a visual representation of large collections of information
Purpose of visualization is to
enable
knowledge discovery
Importance: visualization helps users see patterns
Example: study of a hurricaneSlide7
BI in
Practice
: The
N
eed
for BI for Visual Analytics in Emergency Response
National Visualization and Analytics Center, located at the Pacific Northwest National
Lab
,
supports the US Dept. of Homeland Security
The
science
of
analytical
r
easoning
Visual
representation
and
interaction technologies
Data
representations
and
t
ransformations
Production,
presentation
, and
dissemination
Privacy and
security
issues that are based on an interoperable architecture Slide8
BI in Practice: Improving Sales Performance via Visual Business Intelligence
Field sales representatives’ organizational structures
Example:
for those working in pharmaceutical and healthcare businesses
Visual information mapping tools are helpful to build these sales structures
Using color coding to map the sales territories offers several advantages
Visual information mapping tools may also allow combining and integrating different values associated with operational parameters to create ‘balanced’ territories Slide9
Performance Dashboards
Performance dashboards are designed to be similar to a car dashboard
Performance dashboards serve as an
“organization
magnifying
glass
”
Measure performance, reward positive contributions and align efforts
Used for forecasting, inventory,
production
and sales
Organizational performance
- “Three
Threes”Slide10
Performance Dashboards
Three applications: a monitoring application, an analysis application, and a management application
Three layers: integrates a monitoring layer, an analysis layer, and a detailed information layer
Three types: support operational, tactical or strategic decision-making Slide11
Performance DashboardSlide12
Balanced Scorecards
Monitor and show performance by focusing on certain outcome metrics and comparing them to a target
Monitor tactical and strategic goals
Balanced Scorecard
Focuses on four organizational perspectives:
Financial
Customer
Internal business process
Learning and growth Slide13
Balanced Scorecards
Approach for organizational assessment developed by Kaplan and Norton
Firm’s competitiveness
Quantify the intangible assets of an organization
Measure past performance
Internal processes and
intangible
assets
Measures value creation for the organization Slide14
Balanced Scorecards
Organizations can use the balanced scorecard as a means to link their long-term strategic objectives with their short term actions through four management
processes.
Translating the vision
Communicating and linking
Business planning
Feedback and learning Slide15
Balanced ScorecardsSlide16
Vision Statement
Our vision is to be internationally-recognized for providing a high-quality, technology-enabled educational experience rooted in our Miami location and focused on the unique requirements of doing business in a global and interconnected market.
Core Values
Excellence:
We
pursue excellence in all we do and nurture this pursuit in others
.
Ethics:
We
are committed to doing the right thing in both our words and deeds.
Professionalism:
We
hold ourselves to the highest standards of expertise and of professional conduct.
Innovation:
We
embrace change, uncommon thinking, creativity, and the entrepreneurial spirit.
Collegiality:
In
working together, we respect each other and welcome diverse viewpoints.
Mission Statement
Our mission is to create enduring educational value for our students, for our alumni, and for the business, professional, and academic communities we serve:
•
For our students-
whom we prepare to succeed in a rapidly changing, technology-driven global business environment; •For our alumni-to whom we provide opportunities for continuing professional development and a legacy that appreciates as our excellence grows; •For the business and professional communities-to whom we offer knowledgeable graduates, educational programs, research, and collaborative projects; •For the academic community-to whom we bring new knowledge by creating an environment that nurtures high-quality research and the development of future scholars.
Goals and ObjectivesStrategic Priorities1. Maintenance of Accreditation2. Focus - Build excellence and international recognition through investments in programs and faculty in the areas of international business, entrepreneurship, and professional services – accounting, finance, real estate, and insurance.3. Program Portfolio – Continually evaluate portfolios of programs to ensure excellence in teaching and learning and market need.4. Growth and Quality - Increase quality of undergraduate students while maintaining current enrollment, grow graduate enrollment by 50% over next 5 years while increasing quality of admitted students.5. Faculty – Recruit, develop and support an outstanding faculty.6. Funding – Acquire needed funds to support the college’s mission.7. Space – Complete construction of Phase II of the Business School Complex. Strategic Initiatives 2008-20091.Maintenance of Accreditation: Implement review recommendations.2.Undergraduate Programs: Continue implementation of Assurance of Learning System and enhanced undergraduate career services. 3.Graduate Programs: Complete scheduled program reviews and implement recommended changes.4.Faculty: Recruit replacements for faculty members who resign or retire and recruit new incremental faculty members.5.External Relations: Expand membership on our advisory boards and our community involvement.6.External Visibility: Maintain rankings.7.Internal Processes: Maintain technology for new School of Business Complex.8.Revenue Generation: Secure private funding for faculty support, student support, and the building; grow executive and professional education program; and plan for new value-added programs.Core Competencies and Definition of Metrics(L)earning, Instruction, and Student Services - Provide educational programs and learning experiences that prepare individuals to make sustained contributions to organizations and society in a global environment and are recognized for excellence. Deliver outstanding student services.(R)search and Scholarship - Identify and address important business and economic issues through discovery, application, and dissemination of knowledge.(S)ervice and Outreach - Offer expertise to government agencies, business and professional organizations, and others, to promote economic development and to provide value-added educational and professional programs.(E)xternal Relations and Development - Enhance opportunities for mutually beneficial collaboration between the College and its constituents and grow private investments in the College.(P)eople - Attract, develop, and retain highly qualified faculty and staff.(I)nternal Operations - Cultivate an efficient and effective operation that enables faculty and staff to achieve the mission of the College.
Key Metrics
Undergraduate Programs
L1
.
Assurance of Learning Outcomes
L2.
Use and Manage Technology Outcome
L3.
Quality of Students
L4.
Student Recognitions
L5.
Head Count - # of Graduates
L6.
FTE enrollment - % of Enrollment Targets Met
L7.
Placement – Satisfaction and Outcomes
L8.
Satisfaction with Advising
L9.
Quality of Instruction
L10.
Expectations Met
L11.
Rankings
Graduate Programs
L12.
Assurance of Learning
L13.
Quality of Students
L14.
FTE enrollment - % Enrollment Target Met
L15.
Placement – Satisfaction and Outcomes
L16.
Expectations Met
L17.
Rankings
_____________________________________________
R1
.
Publications in Premier Journals
R2
.
Citations in Social Service Index
R3.
Editorial Board Membership
R4.
Recognition and Awards
_____________________________________________
S1
. Revenues from EPE Programs
S2
. Participation on Boards
_____________________________________________
E1
.
Corporate Community Participating in Advisory
Boards
E2.
Membership in Business Alumni Chapter
E3.
New Private and Corporate Donations
________________________________________
P1
.
Adequacy and Quality of Faculty
P2
.
Professional Development Support of Faculty and Staff
_____________________________________________
I1
.
Technology Availability and Quality
I2
.
User Satisfaction and Use of Technology ResourcesSlide17
IT Governance
IT governance refers to “specifying the decision rights and accountability framework to encourage desirable behavior in the use of
IT”
Goal: determine who makes the key IT decisions in the organization and how
Effective IT governance is the single most important predictor of value an organization generates from IT
IT Principles –
a related
set of high-level statements about how IT is used in business Slide18
IT Governance
IT Architecture
IT Infrastructure
Business Applications Needs
IT Investment and Prioritization
Communications
Mechanisms Slide19
BI in Practice: Achieving IT
Value Through
B
alanced Scorecards
Implementing the use of Balanced Scorecards in the organization
Important steps to ensure their success are:
Preparing the organization for change
Devising the right metrics
Getting buy-in from employees at all levels
Following through the implementation plan Slide20
BI in Practice: Achieving IT
Value Through
B
alanced Scorecards
Identifying four or five value drivers
Organization should appoint a champion, someone who typically oversees the IT budget
Companies that have been able to capitalize on their successful
balanced
s
corecard
deployments include Exxon Mobil
and
Cigna
Insurance.Slide21
The Role of BI on IT Governance
[Adapted from [
Busco
et. al, 2005], [COBIT, 2000]]
Slide22
Impact of BI on Corporate Performance
Infrastructure for members of the organization to measure, monitor, and manage the key activities and processes that the organization must pursue in order to meet their goals, or their key performance indicators (KPIs)
The goal
– to provide decision
-makers with the following
capabilities:
Detect events
Prompt managers
Analyze data in real time
Collect data Slide23
Impact of BI on Corporate Performance
When designing performance dashboards for the organization it’s important to avoid ten common
mistakes:
Failure
to apply the “Three-Threes
”,
of three applications, three layers, and three types
Overrating
the importance of dashboards and scorecards
Failing to deliver three applications:
Access, Analyze
, and Management
Failing
to deliver three layers
Failing to create the right type of performance
dashboard:
Operational metrics
Tactical
metrics
Strategic
metrics Slide24
Impact of BI on Corporate Performance
Falling
prey to glitz
Building a dashboard with a lightweight architecture
Delivering real-time data without context
Failing to design effective KPIs
Failing to apply KPIs correctly Slide25
Impact of BI on Corporate Performance
BI can support the implementation of dashboards and scorecards for the creation of KPIs that enable the organization to:
Communicate and refine their business strategy
Increase visibility of the organization’s strategic goals
Increase
enterprise-wide
coordination of activities
Increased
motivation
,
morale and empowered users
Provide a consistent view of the business Slide26
Impact of BI on Corporate Performance
Slide27
Case Study: Designing Vigilant Information Systems with Real-Time Dashboards
Western Digital (WD), a US $3 Billion designer and manufacturer of high-performance hard drives
WD relied on multiple sources of data, ERP reports often produced different results
Essence management lacked the necessary information to quickly respond to the business needs
Vigilant Information Systems
(VIS)
- system initiates the process (versus the user), and the database is active (versus passive)
VIS must fulfill the following four capabilities, known as the OODA loop :
Observing
Orienting
Deciding
Acting Slide28
Architecture of
WD’s
Vigilant Information Systems Slide29
Yield Dashboard [Source: Houghton et al, 2004]Slide30
Case Study: Designing Vigilant Information Systems with Real-Time Dashboards
The implementation of the VIS at WD demonstrated seven lessons :
Design the VIS as the ‘nerve-center’ for managing the enterprise
The VIS can serve as the basis for team coordination across the enterprise
The VIS ‘OODA’ loops can foster organizational learning across the enterprise
Real-time in the VIS should match the organization’s ability to respond, zero latency is not always the goal
VIS can provide the infrastructure for an organization’s ability to sense-and-respond
Investment in VIS should be justified not only by return-on-
investment,
but also on the impact of not having them
VIS implementations should not be a technology initiative, but instead a management initiative supported by the leadership of the enterprise Slide31
Case Study: Designing Vigilant Information Systems with Real-Time Dashboards
Real-time management performance dashboards can fall into one of the four categories shown in Figure
EIS Business Performance Dashboards
Operations Control Dashboards
Business Process Dashboards
Collaborative Dashboards
Slide32
Four Types of Real-Time Management Dashboards