You can use dashboards to present operational data such as daily progress data, as well as analytical data, such as the overall health of a business function.  1 pointTrueFalse

According to the ‘Creating a Simple Dashboard using Excel’ video, which of the following should you have already done prior to creating a dashboard? (Select all that apply) 1 pointFormatted the data as a table.Created pivot tables to help analyze data.Created a data analysis findings report.Verified data is clean and error free.

Question 2Now that you have considered the different types of dashboards, think about the impact that dashboards can have on a company:What is an example of a data source a company might use with a dashboard?How would a company benefit from a dashboard that uses this data?What industries or businesses might benefit from using dashboards more than others?

Which of the following are benefits of dashboards in Excel? (Select all that apply)1 pointDashboards can alert you to trends and patterns.Dashboards can be updated dynamically as source data changes.Dashboards provide a way to monitor the performance of your data applications.Dashboards can offer useful insights into your data.2.Question 2Which of the following applications would be considered an advanced data analysis and visualization application? (Select all that apply)1 pointTableau Excel (Full Desktop version) Bokeh (in Python) Cognos Analytics Google Sheets  3.Question 3You should try and add as much information and as many visualizations as possible into your dashboard so that it conveys the most amount of information possible. 1 pointTrueFalse4.Question 4According to the ‘Creating a Simple Dashboard using Excel’ video, which of the following should you have already done prior to creating a dashboard? (Select all that apply) 1 pointFormatted the data as a table.Verified data is clean and error free.Created a data analysis findings report.Created pivot tables to help analyze data.

You should try and add as much information and as many visualizations as possible into your dashboard so that it conveys the most amount of information possible. 1 pointTrueFalse

Explain how you would gather and understand the specific needs of stakeholders when designing a data dashboard.