Week 9 Part 1 Flashcards
Data Visualization Makeover
At A Glance Page of the Transportation Improvement Board (TIB) performance management dashboard
While the dashboard is well organized and easy to read, there are several opportunities for improvement:
* The financial, project, and KPI* status
statistics on the left pane lack context: are those YTD values? And if they are, are they on a calendar or fiscal year? What is the meaning of the green, gold, and red color coding?
* And what about the county map to the right? Do green and red colors have the same meaning of the statistics to the left?
A few targeted modifications can make substantial improvements to the dashboard.
____ is data visualization tool that gives multiple output and may update in real life
_____ KPIs included in the ___ may include
6 of them
A data dashboard is a data visualization tool that gives multiple outputs and may update in real time
Key performance indicators (KPIs) included in the data dasboards may include
-organizations financial position
-inventory on hand
-pending orders for parts
-progress on projects
-status of accounts
-pending orders from customers
-customer service metrics
Principles of Effective Data Dashboards
A data dashboard should present all ___ related to some aspect of the organizations operations on a ____ screen
Create ____ data dashboards of realted KPIS rather than having the the user scroll vertically or horizontally for information
The KPIs displayed in the data dashboard should ______ to its users and be realted to the decisons that the user makes
All components of a data dashboard should adhere to the _____ dicussed throughout this book
use color judiciosuly to _____to specifc values and too diferentiate between _____
A data dashboard should present all KPIs related to some aspect of the organization’s operations on a single screen.
* Create multiple data dashboards of related KPIs rather than having the user scroll vertically or horizontally for information.
* The KPIs displayed in the data dashboard should quickly and clearly convey meaning to its user and be related to decisions the user makes.
* All components of a data dashboard should adhere to the principles of effective data visualization discussed throughout this book.
* Use color judiciously to call attention to specific values and to differentiate between categorical variables.
_____ mointor an organziations performance or individual portfolio of investments over the whole portfolio by individual investment or type of investment. Information provided may include:
4 things
nvestment dashboards monitor an organization’s performance or individual portfolio of investments over the whole portfolio by individual investment or type of investment. Information provided may include:
-the current price, the recent rate of return and the relative rate of risk the portfolio and its compnents relative to the overall market
-the current price, the recent rate of return, and relative risk of investments under consideration
-the share of the portfolio devoted various industries or types of investments
-key financial data for the companies in which the investor has invested or is considering investing
____ monitor a production process overall and by facility, product, indivudal, machine, shift or department, information provided may include:
4 things
monitor a production process overall and by facility, product, individual, machine, shift, or department. Information provided may include:
-the quantity produced
-the quality of units produced
-the units production speed
-the frequency of problems (machine downtime, returns, falling short of production targets)
__ monitor sales and promotion efforts overall and by product or services, indivual, campaign, divison or department, or customer, infromation provided may include:
7 things
- the quanities sold and delivered
-success rate/proportion of successful sales calls
-sales revenue and product and services selling prices
-advertising and promotional expenditures
-exposure and response to advertising and promtion efforts
-contact with prospective customers
-consumer satisfaction metrics
___ monitor the performance of an organziations workforce by indvidual, divison, department, or shift. Information provided may include
7 things
- the number of employees and overall labor effectiveness
-employee churn (rate of employee turnover)
-lenth of employment
-employmee perforance and satisfaction
-absenteeism
-partcipation in training
-reasons for leaving
____ monitor the perforance of orgnaizations support of its technology users by the invdidual, computer system, division or department, or location
information provided may include
7 things
Technical support dashboards monitor the performance of an organization’s support of its technology users by the individual, computer system, division or department, or location. Information provided may include:
-type of techincal problem
-response time and time to resoultion
-outstanding issues
-persistent problems
-downtime
-scheduled maintenance
-software and hardware usage
___ montior aspects of an indivduals physcail well being. information provided may include 7 things
personal fitness/health dashboards
-pulse and blood pressure
-body temperature
-weight and body mass index (BMI)
-amount of exercise
-number of steps, distance traveled, and calories burned
-diet charcteristics (calories, fat intake, carbs, and protein intake)
-blood sugar levels
____ monitor donor/contributor activity and potential for nonprofit organization by donor/contributor, prospective dontor/contributor, or project/campaign information provided may include 6 thingss
-number and dollar value of donations/contributions
-contact with new potential donors/contributors and past donors/contributors
-expenditures
-coversion rate
-cash flow
-current status of campaigns
Data Dashboards Taxonomies: Data Updates
___ provides information on an organizations KPIs to be manually updated as new data and information become available
-inexpensive and easy to develop
-helpful when the organization KPIS change slowly
-updated inrequently and require substantial effort to update
___ provides information on an organzations KPIs and automatically updates as it recieves and incroporates new and revised data
-take time and effort to develop
-useful when the organizations KPIs change rapidly
-updated frequently and require litle effort to update
A static dashboard provides information on an organization’s KPIs to be manually updated as new data and information become available.
* inexpensive and easy to develop
* helpful when the organization’s KPIs change slowly
* updated infrequently and require substantial effort to update
* A dynamic dashboard provides information on an organization’s KPIs and automatically updates as it receives and incorporates new and revised data.
* take time and effort to develop
* useful when the organization’s KPIs change rapidly
* updated frequently and require little effort to update
Data Dashboards Taxonomies: User Interaction
- ____ does not allow users to customize the data dashboard display. it is useful when the data do not change frequently
-___ allows user to customze the data dashobard display using several features
___ provides more specidc and detailed info on a particular elment variable or KPI
___ allows the restistirciton of the data displayed to specifc users by selected nested values of several categories or values of variables
__ allows users to specify the time period time be displayed
__ allow users to select/deselect/combine variables and categories to be displayed as well as add/hide custom text and statisitcs
A noninteractive dashboard does not allow users to customize the data dashboard display. It is useful when the data do not change frequently.
* An interactive dashboard allows users to customize the data dashboard display using several features:
* Drill-down provides more specific and detailed information on a particular element, variable, or KPI.
* Hierarchical filtering allows the restriction of the data displayed to specific users by selecting nested values of several categories or values of variables.
* A time interval widget allows users to specify the time period to be displayed.
* Customization tools allow users to select/deselect/combine variables and categories to be displayed, as well as add/hide custom text and statistics.
Data Dashboards Taxonomies: Organizational Function
Depending on its purposes and ultimate users, data dashboards may belong to one of the following four groups:
___ allow lower-level managers to monitor rapidly changing crictical business conditons, they may be updated musltiple times a day
___ alllow exectuives to monitor the status of KPI relevant overaching organzatinal objectives. tey may be updated often but not as frequnecy as operational dashboards
___ allow mid-level managers to identify and assess the organizations strenghts and weaknesses o develop orangizational strates they are updated less frquenctly then the previous two
___ allow analystics to identify and ivesticage trends, predict outcomes, and discover insights in large volumes of data. primarily supporiting long term issues, they are updates less frequencly than the other three groups
Depending on its purposes and ultimate users, data dashboards may belong to one of the following four groups:
* Operational dashboards allow lower-level managers to monitor rapidly changing critical business conditions. They may be updated multiple times/day.
* Strategic dashboards allow executives to monitor the status of KPIs’ relevant overarching organizational objectives. They may be updated often, but not as frequently as operational dashboards.
* Tactical dashboards allow mid-level managers to identify and assess the organization’s strengths and weaknesses to develop organizational strategies. They are updated less frequently than the previous two.
* Analytical dashboards allow analysts to identify and investigate trends, predict outcomes, and discover insights in large volumes of data. Primarily supporting long-term issues, they are updated less frequently than the other three groups.
Data dashboard purpose
_____ to support an organizatinons operations, decison making, and strategic planning
Data dashboard objection may include
6 things
Data dashboard purpose: To support an organization’s operations, decision-making, and strategic planning.
Data dashboard objectives may include:
-tracking KPIs and mointoring processes
-assessing attainment of goals and objectives
-developing/enchanicing insight
-sharing information
-measuring prformance
-forcasting and data exploration
Data Dashboard Users’ Needs
A data dashboard should be desinged to assist a particulur user or a group of users with specific tasks associated with the managment of an orgnaization
The dashboard design team must understand:
-the needs of the dasboards end users
-how adressing these needs supports the organzaitons objectives
This knowledge will help the dashboard devloper determine
-what information the dashboard should include
-the most effective manner for presenting it
Data dashboaard display
Considerations on how the information is displayed on a dashboard should include:
-selection of approrptiate types of charts
-effective use of pre-attentive attributes, gesalth princples, and color
-a practical layout that enables end-users to quickly find the information they need and relate informaion from various charts in the dashboard
-strategies for avoding overcrowiding and uncessary complexity such as orgnaizing information into subsets and using interactive tools
-the devise used to access the dashboard, ambient lighting, size and resolution of the display
Data dashcoard context
The __ for the information included in the data dashboard may be provided by:
-Showing how a _____
-comparing the value of a KPI to an ____
-comparing the value of a KPI:
internally acorss______
externally across___
externally across ____
the context for the information included in the data dashboard may be provided by
-Showing how a KPI varies over time
-Comparing the value of a KPI to an organizational goal
-Comparing the value of a KPI
internally across divisions, departments, or geographies of an organization
-externally across customers
-externally across competitorsor orgnazations in the same industry
Data Dashboard Engineering
The dashboard design team must understand how:
-To organize the charts and tables on the dashboard to______
-To maintain and assess the data dashboard ___
The organizationas objectives may shift in the future specifically:
-will the data dashboard need to ___
-wha new KPIs are likely to becomes importnation to ____
-what may be the source or format for the future incorporation of ______
the dashboard design team must understand how:
* To organize the charts and tables on the dashboard to facilitate users’ analyses and limit eye travel
* To maintain and assess the data dashboard effectiveness
* The organization’s objectives may shift in the future. Specifically:
* Will the data dashboard need to reflect these shifts?
* What new KPIs are likely to become important to the organization in the future?
* What may be the source or format for the future incorporation of new data into the dashboard?
Data Dashboard Organization
-Store the dashboard data source in a _____
-The dashboard should not draw information directly from the ______
-______ the data needed to create a chart or table fromt eh soruce data worksheel an sotre it in a seperate worksheet
-The dashboards users should not allowed to make _____________
Store the dashboard data source in a separate worksheet.
* The dashboard should not draw information directly from the source data
worksheet.
* Extract the data needed to create a chart or table from the source data worksheet and store it in a separate worksheet.
* The dashboard’s users should not be allowed to make permanent changes to the dashboard.
Data Dashboard Testing
The dashboard design team must test its work extensively at each step to minimise a _____, ____, and ____
Failure to do so may result in
-the creation of a ___ final product, leading to ___ and missed opporutnies
-time comsuming and ____
-damaging the credbility of the data dashboard ____
The dashboard design team must test its work extensively at each step to minimize a data dashboard’s errors, miscommunications, and misunderstandings.
* Failure to do so may result in:
* the creation of a faulty final product, leading to poor decisions and missed
opportunities
* time-consuming and costly revisions
* damaging the credibility of the data dashboard design team
Final Review of a Data Dashboard
The design team should test the PivotCharts and PivotTables extensively in the data dashboard using combinations of slicers and filters to ensure that:
* the information is accurate
* the display is appealing and informative.
* The design team must also ensure the final data dashboard meets the management team’s objectives.
* The design team must allow the ultimate users to extensively test the final data dashboard to ensure the dashboard is:
* user friendly
* functions in the manner expected by its users
* produces the outputs expected and needed by its users
* The design team must work with the management team and the users to create an ongoing monitoring and revision process of the data dashboard.
Common Mistakes in Data Dashboard Designs
Common Mistakes in Data Dashboard Design
* Not considering the organization’s needs and objectives, such as:
* neglecting information that is material to the objectives of the organization
* focusing on information that is not material to the objectives of the organization
* neglecting the actual users throughout the data dashboard design process
* Not considering the environment(s) for the data dashboard use
* Failing to position charts and tables on the data dashboard properly
* Using an inappropriate or ineffective type of graph for the data and its message
* Neglecting the principles of chart and table design when creating the individual components and the overall dashboard
* Creating a data dashboard that is either too cluttered or too sparse
* Designing an unattractive visual display
* Not considering the organization and user’s potential future needs
