Skip to content

Siphamandl-tech/Data-Analytic-Questions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 

Repository files navigation

Data-Analytic-Questions

Chapter 6 Review – Exam Preparation

Describe the most crucial first steps when developing a visualization. The most important first steps when developing a visualization are identifying the audience and understanding their needs. If you don't know who will use a visualization or understand its purpose, your creation will have a limited impact.

Compare reports and dashboards. Reports are static documents that are distributed physically or electronically. As static documents, they reflect data at the time of creation. Dashboards are dynamic and encourage data exploration. Typically delivered as a web interface, dashboards can integrate real-time data and enable users to explore segment data along multiple dimensions.

Identify the best type of chart for a given scenario. Given a specific scenario, select the type of chart that is most appropriate. Bar and pie charts work well for categorical data, whereas line charts are excellent for illustrating the relationship between two variables. Scatter charts show all of the points in a data set, whereas bubble charts use size to show the effect of a third numeric attribute. Maps are good for spatial data, waterfall charts show positive and negative impacts over time, and infographics convey a message. A word cloud is an optimal choice for displaying the relative significance of words when dealing with unstructured data.

Identify the type of report that should be used in a given scenario. Given a specific scenario, identify the type of report that would meet the requirement. For example, you need a recurring report on a regular schedule to meet various compliance objectives. On the other hand, self-service reports enable individuals to answer a specific question at the time of their choosing.

Describe considerations for maintaining data security. When working with static reports, having tight control over how reports get distributed is one approach to ensuring the security of the data in the report. Dashboards are more complicated, as they are accessible in an interactive manner. Work closely with information security and application administrators to map people's various roles to the appropriate dashboard sections. Restrict sensitive data access only to the functions that require it.

Question 1 1 point possible (ungraded) Igor is creating an inventory report for the manager of a local convenience store. On average, replacement items are delivered within 3 days after the manager places an order. What is the most appropriate frequency for this report? (Choose the best answer.)

Real-time

RHourly

RDaily

RWeekly

Question 2 1 point possible (ungraded) Jasmine is developing a daily report that will be posted at the entrances to 700 different franchise locations. What is the most appropriate color scheme?

Black monochrome palette

Red and green complementary palette

Blue and orange complementary palette

Yellow and purple complementary palette

Question 3 1 point possible (ungraded) Bowen is developing a report that explores how consumer sentiment about his company's products changes over time. Where should he put a paragraph describing the most profound insight in the report? (Choose the best answer.)

Title page

Executive summary

Report body

Appendix

Question 4 1 point possible (ungraded) Javier wants to illustrate the relationship between height and weight. What type of chart should he use?

Bar

Scatter

Line

Histogram

Question 5 1 point possible (ungraded) John's CEO wants to be able to explore how retail sales have been changing over time. What is the best way to present the information to the CEO? (Choose the best answer.)

Historical report

Recurring report

One-time report

Interactive dashboard

Question 6 1 point possible (ungraded) Ron is a recent hire at a large organization and is developing his first report. What should he do first? (Choose the best answer.)

Check with the communications division to see whether any corporate style guides exist.

Work with his supervisor to identify distribution mechanisms.

Work with operations to develop a delivery schedule.

Check with his colleagues to determine the best way to get his completed report to the appropriate people.

Question 7 1 point possible (ungraded) Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop. What can she do to prevent confusion as she seeks feedback before publishing the report? (Choose the best answer.)

Distribute the report to the appropriate stakeholders via email.

Use a watermark to identify the report as a draft.

Show the report to her immediate supervisor.

Publish the report on an internally facing website.

Question 8 1 point possible (ungraded) Maggie is a new analyst tasked with developing a dashboard. What should she focus on to obtain an understanding of requirements for internal senior leaders? (Choose the best answer.)

Service credits

Service level agreements

Key performance indicators

Defect rate

Question 9 1 point possible (ungraded) Cian is mapping dashboard requirements to data sources. What should he use to ensure the structure is in place to deliver the dashboard successfully?

Mock-up

Wireframe

Data warehouse

Data mart

Question 10 1 point possible (ungraded) Zakir wants to visualize aggregate sales data over time. What type of chart should he select?

Pie chart

Tree map

Histogram

Line chart

Question 11 1 point possible (ungraded) Celine wants to visualize annual precipitation in South America. What type of chart would create the greatest impact?

Geographic heat map

Stacked bar chart

Word cloud

Waterfall chart

Question 12 1 point possible (ungraded) Luciana is an analyst for a sporting venue. She wants to distil post-event free-response survey data to inform leadership what respondents have on their minds. What type of visualization should she choose?

Pie chart

Bar chart

Word cloud

Dashboard

Question 13 1 point possible (ungraded) Aubree wants to visualize the correlation between 15 different variables. What type of chart should she select?

Tree map

Bar chart

Infographic

Heat map

Question 14 1 point possible (ungraded) Appa wants to tell a story about the effect of climate change on coastal cities with a single, static visualization. Which of the following should he choose?

Tree map

Bar chart

Infographic

Heat map

Question 15 1 point possible (ungraded) Kingston wants to create an interactive visualization that allows people to explore brand sales by category and subcategory. What type of visualization should he choose for his dashboard?

Tree map

Bar chart

Infographic

Heat map

Question 16 1 point possible (ungraded) Tree maps are ideal for illustrating proportional relationships and are well-suited to interactive applications that facilitate data exploration by the user. A bar chart works well for categorical data, an infographic is an effective tool for telling a story and a heat map works well in a spatial context.

Bubble chart

Bar chart

Infographic

Heat map

Question 17 1 point possible (ungraded) Sanjay's company has three primary brands that drive corporate profitability. If Sanjay wants to visualize the contribution of each brand over time, what type of chart should he choose?

Bubble chart

Stacked bar chart

Infographic

Heat map

Question 18 1 point possible (ungraded) Adeline is developing a poster to raise awareness about climate change. What type of visualization should she use?

Bubble chart

Stacked bar chart

Infographic

Heat map

Question 19 1 point possible (ungraded) Abbas's CFO wants to drill down on cost centers across the organization. What type of visualization should Abbas create?

Bubble chart

Stacked bar chart

Infographic

Dashboard

Question 20 1 point possible (ungraded) Shivang's CEO wants to visualize the relationship between height and 100-meter sprint time for 200 individuals. What type of chart should he choose?

Bubble chart

Stacked bar chart

Infographic

Scatter chart

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published