COURSE 3: DECISIONS, DECISIONS: DASHBOARDS AND REPORTS

Module 3: Automate and Monitor

GOOGLE BUSINESS INTELLIGENCE PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

INTRODUCTION – Automate and Monitor

In this comprehensive course, participants will engage in a hands-on journey focused on the construction of meaningful and sustainable BI dashboards. The curriculum is designed to guide learners through the process of building charts and organizing them into cohesive dashboards tailored for long-term data monitoring. Through practical exercises, participants will not only acquire technical skills in chart creation but also understand the strategic considerations involved in organizing these visual elements to create dashboards that stand the test of time.

Taking a dynamic approach, the course immerses participants in the role of a Business Intelligence (BI) professional, providing a simulated client interaction scenario. Learners will practice vital skills in question-asking and communication, honing their ability to extract key information from clients. This information then becomes the bedrock upon which their BI projects are built. By delving into this client-centric approach, participants gain a holistic understanding of the client’s needs, translating them into actionable insights and delivering dashboards that align seamlessly with the client’s objectives.

Learning Objectives

  • Make design choices based on stakeholders’ needs.
  • Create effective data visualizations.
  • Create dynamic dashboards to track long-term data.
  • Apply design best practices to create effective and descriptive dashboards that meet business objectives.
  • Demonstrate insights and impact of BI research visually.

QUIZ: MODULE 3 CHALLENGE

1. There are four key questions business intelligence professionals ask when designing a dashboard. One is, “How many charts are required?” What are the other three? Select all that apply.

  • How can the dashboard be designed in order to include as much fine detail as possible?
  • Which measures and dimensions will be represented in each chart? (CORRECT)
  • Which parts of the dataset will make it possible to address the business requirement? (CORRECT)
  • Which chart types and forms of encoding will be most effective? (CORRECT)

2. What are the risks of including numerous visualizations in a dashboard? Select all that apply.

  • Empowering users to interpret the data on their own
  • Enable long-term monitoring
  • Overwhelming the user (CORRECT)
  • Slowing down the dashboard (CORRECT)

3. Fill in the blank: When conducting long-term monitoring, _____ dashboards will likely require more context in order to make the data understandable for users.

  • larger (CORRECT)
  • smaller
  • older
  • newer

4. Fill in the blank: It is important to establish use cases for different _____ in a live-monitoring dashboard in order to give users the ability to drill down to the information that is relevant to them.

  • views (CORRECT)
  • mockups
  • hardware
  • aesthetics

5. When designing a dashboard, how can a business intelligence professional enable users to follow the data’s evolution, rather than isolated snapshots of the latest information?

  • Include more metrics
  • Build in tracking (CORRECT)
  • Ensure consistency
  • Use only open data

6. Fill in the blank: When creating a dashboard, implementing _____ is beneficial because it helps users understand why the data in the dashboard is useful.

  • indexes
  • patterns
  • comparisons (CORRECT)
  • updates

7. There are four key questions business intelligence professionals ask when designing a dashboard. One is, “Which measures and dimensions will be represented in each chart?” What are the other three? Select all that apply.

  • How can the dashboard be designed in order to include as much fine detail as possible?
  • How many charts are required? (CORRECT)
  • Which parts of the dataset will make it possible to address the business requirement? (CORRECT)
  • Which chart types and forms of encoding will be most effective? (CORRECT)

8. Fill in the blank: When conducting long-term monitoring, larger dashboards will likely require more _____ in order to make the data understandable for users.

  • color
  • datasets
  • context (CORRECT)
  • privacy permissions

9. Fill in the blank: In a dashboard, it is helpful to build in _____ that enables users to follow the data’s evolution, rather than isolated snapshots of the latest information.

  • encoding
  • mapping
  • conformity
  • tracking (CORRECT)

10. What are the benefits of implementing comparisons when creating a dashboard? Select all that apply.

  • It helps predict future performance based on a single moment in time
  • It provides insights about an independent datapoint based on one criteria
  • It quickly enables users to understand why the data in the dashboard is useful (CORRECT)
  • It helps users interpret whether the visualizations indicate good or bad performance (CORRECT)

11. Fill in the blank: When conducting long-term monitoring, larger dashboards will likely require more context in order to make the data _____ for users.

  • accessible
  • understandable (CORRECT)
  • visually pleasing
  • dynamic

12. Fill in the blank: It is important to establish _____ for different views in a live-monitoring dashboard in order to give users the ability to drill down to the information that is relevant to them.

  • legends
  • business rules
  • use cases (CORRECT)
  • partitions

13. Fill in the blank: Including more visualizations in a dashboard enables more data to be displayed, but this may _____ or slow down the dashboard.

  • speed up the dashboard
  • change the data over time
  • empower users to interpret the data on their own
  • overwhelm the user (CORRECT)

14. Fill in the blank: In a dashboard, it is helpful to build in tracking that enables users to follow the data’s_____, rather than isolated snapshots of the latest information.

  • Evolution (CORRECT)
  • extraction
  • organization
  • regression

15. There are four key questions business intelligence professionals ask when designing a dashboard. One is, “Which parts of the dataset will make it possible to address the business requirement?” What are the other three? Select all that apply.

  • How can the dashboard be designed in order to include as much fine detail as possible?
  • Which chart types and forms of encoding will be most effective? (CORRECT)
  • Which measures and dimensions will be represented in each chart? (CORRECT)
  • How many charts are required? (CORRECT)

16. Fill in the blank: Including more visualizations in a dashboard enables more data to be displayed, but this may _____ or overwhelm the user.

  • slow down the dashboard (CORRECT)
  • empower users to interpret the data on their own
  • change the data over time
  • enable long-term monitoring

17. Fill in the blank: When conducting long-term monitoring, _____ dashboards will likely require more context in order to make the data understandable for users.

  • larger (CORRECT)
  • older
  • newer
  • smaller

18. For what reasons is it important to establish use cases for different views in a live-monitoring dashboard? Select all that apply.

  • To import more data into the dashboard
  • It gives different users the ability to drill down to the information they need (CORRECT)
  • To avoid users having to interpret data that is irrelevant to them (CORRECT)
  • To simplify the process of accessing useful data (CORRECT)

CONCLUSION – Automate and Monitor

In conclusion, this comprehensive course has provided a transformative journey into the intricate world of Business Intelligence (BI) dashboard construction. Participants have not only acquired technical proficiency in building charts and organizing them into effective dashboards for long-term data monitoring but have also honed essential skills through immersive experiences.

A distinctive aspect of this course is the simulation of client interactions, placing participants in the role of BI professionals. Through this practical exercise, learners have cultivated crucial question-asking and communication skills, simulating real-world client engagements. This unique approach equips participants to not only create technically sound dashboards but also to deeply understand and address the specific needs and objectives of their clients.

As learners conclude this course, they emerge with a holistic skill set that extends beyond technical expertise, encompassing the interpersonal and consultative abilities critical for success in the dynamic realm of Business Intelligence. Armed with the knowledge gained from both the technical and client-centric perspectives, participants are well-prepared to navigate the multifaceted landscape of BI, delivering impactful and sustainable solutions that meet the evolving needs of organizations.