decisions, decisions: dashboards and reports coursera weekly challenge 2 answers

Test your knowledge: Communicate clearly with visuals

1. A business intelligence professional wants to create the best possible dashboard. They balance various factors by prioritizing certain elements while sacrificing others. What does this scenario describe?

  • Revealing business insights
  • Quality testing
  • Eliminating redundancy
  • Making trade-offs

2. Fill in the blank: A dimension is a _____ data type that can be used to categorize data.

  • Timestamped
  • Quantitative
  • Qualitative
  • Boolean

3. What is the process of translating dimensions and measures into visual representations of data?

  • Data blending
  • Conditional formatting
  • Encoding
  • Reframing

Test your knowledge: Considerations when laying out out a dashboard

4. What is the term for the privacy setting that is used to make a dashboard accessible to anyone?

  • Accessible data
  • Public availability
  • Open permission
  • Entry-level

5. A business intelligence team is building and maintaining dashboards. As part of that process, they configure privacy settings using object-level permissions. In this situation, they want to control the availability of which of the following?

  • A single item
  • Only table rows
  • Only table columns
  • A complete dashboard

6. Where does a business intelligence professional set up row-level permissions?

  • In the database
  • In the visualization tool
  • In the spreadsheet
  • In the pipeline

Weekly challenge 2

7. A business intelligence professional is designing a dashboard for a restaurant group. The personnel manager has instructed them to prioritize data about employees. However, the kitchen manager asks to prioritize food sales data. What should the BI professional do? Select all that apply.

  • Consider which trade-offs best align with business goals.
  • Prioritize high-level overviews, as the personnel manager is the most senior stakeholder.
  • Prioritize the food sales data, as there are more users on the kitchen team.
  • Determine what to prioritize and what to sacrifice in order to produce the best possible result for all users.

8. Fill in the blank: Pre-aggregation involves making calculations while data is in a _____, before it is transferred to the visualization tool.

  • dashboard
  • database
  • query
  • spreadsheet

9. Fill in the blank: Measures are _____ data types that can be either discrete or continuous.

  • floating
  • boolean
  • quantitative
  • qualitative

10. What is the process of translating dimensions and measures into visual representations of the data?

  • Summarizing
  • Encoding
  • Tracking
  • Charting

11. A business intelligence team considers design best practices for their data visualizations. They choose to use both color and labels when working in Tableau. Why do they make that decision?

  • It combines data from multiple sources.
  • It adds visual elements.
  • It prioritizes accessibility
  • It reduces clutter.

12. For what reasons might a dashboard designer choose to group objects? Select all that apply.

  • To ensure the dashboard has a logical flow
  • To keep all pie charts together
  • Because they highlight the same topic
  • Because they present data about similar metrics

13. What are some techniques for improving dashboard processing speeds? Select all that apply.

  • Process more data using front-end servers
  • Filter data earlier in the process
  • Reduce the amount of data
  • Organize using additional tabs

14. Fill in the blank: A dashboard with _____uses a privacy setting to control the availability of a single item.

  • object-level permission
  • public availability
  • row-level permissions
  • column-level permissions

15. Fill in the blank: Pre-aggregation involves making calculations on database data before it is transferred to the _____ tool.

  • analysis
  • visualization
  • processing
  • mapping

16. Fill in the blank: Measures are quantitative data types that can be either _____ or continuous.

  • boolean
  • floating
  • discrete
  • timestamped

17. A business intelligence professional uses the Marks tool in Tableau to add color to a particular dimension. What are they doing?

  • Encoding
  • Summarizing
  • Tracking
  • Charting

18. A business intelligence team wants to prioritize accessibility when designing visualizations in Tableau. What strategy should they employ?

  • Use both color and labels.
  • Use neither color nor labels.
  • Use only color.
  • Use only labels.

19. What are some dashboard best practices to emphasize important visualizations for stakeholders? Select all that apply.

  • Prioritization and hierarchy
  • Use of color
  • Grouping objects based on chart type
  • Hiding elements to reduce clutter

20. Fill in the blank: If a dashboard has _____, it is accessible to the general public.

  • privacy settings
  • row-level permissions
  • object-level permissions
  • public availability

21. Fill in the blank: Pre-aggregation involves _____ while data is in the database, before it is transferred to the visualization tool.

  • making calculations
  • reporting
  • analyzing
  • setting permissions

22. A business intelligence professional creates a data visualization that uses only color to specify the data points. What should they do to make the visualization more accessible?

  • Include labels.
  • Remove outliers.
  • Combine data from multiple sources.
  • Add more data points.

Leave a Reply