Excel Dashboard -- 2
Budget: $30 – $250 USD
I need to create an Excel Dashboard that contains the following:
Who is your target audience? What will that stakeholder use the dashboard for? (I.e. What actions can they take or what decisions can be made based on the information in the dashboard?)
Dashboard contains at least 3 KPIs. The KPIs are high impact, clear and simple, and grab the attention of the audience. The KPIs contribute to the overall picture and purpose of the dashboard. The formulas and calculations of the KPIs are correct. (10 points)
Dashboard contains at least 4 other metrics in the form of data visualizations (including tables, charts, or using conditional formatting of cells). The data visualizations are well-balanced in terms of the amount of information and simplicity of interpretation. The data visualizations contribute to the overall picture and purpose of the dashboard. The formulas and calculations of the data visualizations are correct. (20 points)
The dashboard contains the results of at least one of the following analyses: T-test, ANOVA, or multiple For t-tests and ANOVA, the summary of results includes p-values, t-statistics, means/SDs of all variables of interest, and a brief interpretation of the results (significance and conclusion). For regression, the summary of results includes coefficients (betas) of variables of interest, p-values, R2 value, and a brief interpretation of the results (significance and conclusion). The analysis and conclusions are correct. (The variables used in these analyses can be used in your other KPIs and metrics.) (15 points)
At least 1 of the data visualizations includes meaningful slicers. (5 points)
At least 1 of the data visualizations is linked to a pivot table. The pivot table is organized correctly in relation to the message that the visualization is trying to convey. (10 points)
I HAVE THE SAMPLE DASHBOARD OF HOW IT COULD LOOK LIKE.
Who is your target audience? What will that stakeholder use the dashboard for? (I.e. What actions can they take or what decisions can be made based on the information in the dashboard?)
Dashboard contains at least 3 KPIs. The KPIs are high impact, clear and simple, and grab the attention of the audience. The KPIs contribute to the overall picture and purpose of the dashboard. The formulas and calculations of the KPIs are correct. (10 points)
Dashboard contains at least 4 other metrics in the form of data visualizations (including tables, charts, or using conditional formatting of cells). The data visualizations are well-balanced in terms of the amount of information and simplicity of interpretation. The data visualizations contribute to the overall picture and purpose of the dashboard. The formulas and calculations of the data visualizations are correct. (20 points)
The dashboard contains the results of at least one of the following analyses: T-test, ANOVA, or multiple For t-tests and ANOVA, the summary of results includes p-values, t-statistics, means/SDs of all variables of interest, and a brief interpretation of the results (significance and conclusion). For regression, the summary of results includes coefficients (betas) of variables of interest, p-values, R2 value, and a brief interpretation of the results (significance and conclusion). The analysis and conclusions are correct. (The variables used in these analyses can be used in your other KPIs and metrics.) (15 points)
At least 1 of the data visualizations includes meaningful slicers. (5 points)
At least 1 of the data visualizations is linked to a pivot table. The pivot table is organized correctly in relation to the message that the visualization is trying to convey. (10 points)
I HAVE THE SAMPLE DASHBOARD OF HOW IT COULD LOOK LIKE.