ch 3 business reporting, visual analytics, and BPM

reports are needed to:

-ensure that all departments are functioning properly -provide info -provide the results of an analysis -persuade others to act -create an organizational memory

Scatter plot

-explore the relationship between two or three variables -trends, concentrations, and outliers

Gantt chart

-horizontal bar chart used to portray project timelines, tasks/activity durations, and overlap

Histograms

-looks like bar chart -shows the frequency distribution of a variable -x axis = ranges -y axis = measures/values -distributional shape of data

Bar chart

-most basic visuals -nominal data or numerical data that splits nicely into different categories -compare data across multiple categories

Line chart

-most frequently used -shows relationship between two variables -track trends or changes over time

distinguishing features of KPI

-strategy -targets -ranges -encodings -time frames -benchmarks

components of business reporting systems

1. OLTP 2. data supply 3. ETL 4. data storage 5. business logic 6. publication medium 7. assurance

3 categories of a business report

1. informal (single letter/memo) 2. formal (10-100pgs) 3. short (periodic, informative)

3 layers of information in dashboards

1. monitoring 2.analysis 3. management

BPM has 3 main components

1. set of integrated, closed loop processes supported by technology 2. tools for businesses to define strategic goals and then measure 3. monitoring key performance indicators

BPM cycle

1. strategize 2. plan 3. monitor/analyze 4. act/adjust

What is the fundamental challenge of dashboard design? a. ensuring that the organization has access to the latest web browsers b. ensuring that the organization has the appropriate hardware onsite to support it c. ensuring that the required information is shown clearly on a single screen d. ensuring that users across the organization can access it

c. ensuring that the required information is shown clearly on a single screen

Which of the following is LEAST related to data/information visualization a. information graphics b. scientific visualization c. graphic artwork d. statistical graphics

c. graphical artwork

The Internet emerged as a new medium for visualization and brought all the following EXCEPT Select one: a. immersive environments for consuming data. b. new graphics displays through PC displays. c. new forms of computation of business logic. d. worldwide digital distribution of visualization.

c. new forms of computation of business logic.

key to any successful report

clarity brevity completeness correctness

DMAIC performance model

closed loop business improvement model that has steps of defining measuring analyzing improving & controlling a process

Heat map

comparison of continuous values across two categories using color

First pie chart

created in 1801 by William Playfair

Travel and Transport created an online BI self service system that allowed _________________ to access information directly

customers

Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration? Select one: a. bullet b. heat map c. bubble chart d. pie chart

d. pie chart

what is the flow of business reports

data acquisition info generation decision making process management

What is the source for a business report

data from inside and outside the organization

Dashboard reports

graphical presentation of several performance indicators in a single page

Metric management reports

help manage business performance through metric (SLA, KPI, six sigma, TQM)

Tree map

hierarchical data

most developments of data visualization have occurred

in the last two and a half centuries

Balanced scorecard reports

include financial, customer, business process, and learning/growth indicators

Visual analytics

information visualization + predictive analytics

Highlight table

intended to take heat maps one step further by adding numbers on top to provide additional detail

________________ management reports are used to manage business performance through outcome oriented metrics in many organizations

metric

operational plan

plan that translates an organizations strategic objectives and goals into a set of well defined tactics and initiatives and expect results for some future period

Pie chart

relative portions of a specific measure

Dashboards present visual displays of important information that are consolidated and arranged on a single _______________

screen

When did data visualization appear

second century AD

Bullet graph

shows progress toward a goal

Pert chart

simplify the planning and scheduling of large and complex projects -edges and nodes

In the Blastrac case study, Tableau analytics software was used to replace massive ________________ that were loaded with data from multiple ERP systems

spreadsheets

Key performance indicator (KPI)

strategic objective and metrics that measure performances against a goal

What is data visualization

the use of visual representations to explore, make sense of, and communicate data

What is the purpose of a business report

to improve managerial decisions

Typical charts, graphs, and other visual elements used in visualization based applications usually involve _________ dimensions

two

visual analytics is widely regarded as the combination of visualization and ______________ analytics

visual

In the Saudi Telecom case study, information ______________________ software allowed managers to see trends and correct issues before they became problems

visualization

___________ charts or network diagrams show precedence relationships among the project activities/tasks

PERT

data visualization vs information visualization

SAME -includes charts, graphs, and illustrations

Balances scorecard

a performance measurement that translates organizations financial, customer, internal process and objectives into a set of actionable initiatives

business performance management

a real time system that alerts managers to potential opportunities, problems, threats and empowers them to react through models and collaboration

Performance measurement system

a system that assists managers in tracking the implementations of business strategy by comparing actual results against strategic goals and objectives

What is a business report

a written document that contains information regarding business matters

Why is the customer perspective important in the balanced scorecard methodology? a. because dissatisfied customers will eventually hurt the bottom line b. because companies need customer input into the design of the balanced scorecard c. because customers understand best how the firms internal processes should work d. because customers should always be included in an design methodology

a. because dissatisfied customers will eventually hurt the bottom line

Why is a performance management system superior to a performance measurement system? Select one: a. because measurement alone has little use without action b. because measurement automatically leads to problem solution c. because performance management systems cost more d. because performance measurement systems are only in their infancy

a. because measurement alone has little use without action

Dashboards can be presented at all the following level EXCEPT: a. the visual cube level b. the static report level c. the self service level d. the visual dashboard level

a. the visual cube level

Geographical map

any kind of location data

What is the management feature of a dashboard? a. graphical, abstracted data to monitor key performance metrics b. operational data that identify what actions to take to resolve a problem c. summarized dimensional data to analyze the root cause of problems d. summarized dimensional data to monitor key performance metrics

b. operational data that identify what actions to take to resolve a problem

Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT Select one: a. mobile platforms such as the iPhone are supported by these products. b. they explore massive amounts of data in hours, not days. c. there is less demand on IT departments for reports. d. it is easier to spot useful patterns and trends in the data.

b. they explore massive amounts of data in hours, not days.

___________ charts are useful in displaying nominal data or numerical data that splits nicely into different categories so you can quickly see comparative results and trends

bar

________________ are typically used together with other charts and graphs as opposed to by themselves, and show postal codes, country, names, etc

geographic