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