Data Analysis and Techniques for Informed Decision Making

Assignment 1:

This assignment focuses on data visualization and does not require actual data.
Using Excel and either your own data or the data set provided for the fictitious organization, determine three key performance indicators (KPI) to explain the trends in the data. Develop a dashboard in Microsoft Excel or another spreadsheet software and create at least one chart or graph for each KPI.
Use the techniques explored in the first five chapters of the “Storytelling with Data” book to enhance the visual appeal of your charts/graphs.
In a separate document, explain in detail why you feel each KPI is important, why you chose the chart/graph style, and what message you want to convey (e.g., positive, or negative trends over time).Assignment 2:

Imagine you will be summarizing the data from your KPIs and presenting it to the board of directors of your company.
Using Excel, the data set provided for your fictitious organization, your KPIs, and the charts you created for Part 1, create a dashboard showing the three key performance indicators (KPI) to explain the trends in the data. Include the charts and graphs you created and additional information.
Create a PowerPoint and presentation for the Data Project Part 3 – Final Presentation that you could use to summarize the data to C-level execs and include your dashboard, text, and visuals.
Explain in detail why you feel the data is important, and what message you want to convey (e.g., positive, or negative trends over time).

Assignment 3:
Using the lessons learned in this course, you will take the dashboard you created for Data Project Part 2 – Dashboard and incorporate it into a final presentation where you will attempt to persuade the class of your solution/decision based on the data. Record your final presentation as a 5 to 10-minute video.
Create a PowerPoint and presentation for the Data Project Part 3 – Final Presentation that you could use to summarize the data to C-level execs and include your dashboard, text, and visuals.