As the senior data scientist for Exact, LLC, an information clearinghouse, your supervisor has asked you to create several charts based upon two years of monthly sales data. To complete your project, you will combine all of your separate charts into a dashboard. You will create dummy sales data that doesn’t exceed 300,000 dollars for monthly sales. Be creative and vary your sales according to seasonal cycles. This project is important because your department will be using your data to train all of the junior entry-level analysts. Make sure you include legends and descriptions of your work.
You will create dummy sales data for a fictitious company that spans a two-year period. Don’t exceed 300,000 dollars for any monthly sales. Be creative and vary your sales according to seasonal cycles or holiday demands. Develop a viable story that will help explain your work. The best way to create your data is with Excel. Use Tableau or Excel to develop your charts. You will need to create the following:
- Pie Chart
- Bar Chart
- Line Graph
Once you have completed this portion of your task, you will create a dashboard that hosts all of your charts. Use PowerPoint to house your dashboard and charts. Then, in a written paper, explain your data and what each chart depicts and how the information conveyed can enhance business operations.