Project to explore, visualize, and develop insights from a large dataset containing shipment pricing information for healthcare products..
FOR TASKS 1 AND 2, PROVIDE YOUR WORK IN A WORD DOCUMENT. THE DOCUMENT DOES NOT NEED TO BE WRITTEN IN A “FORMAL” MANNER.
1. Your first task is to simply explore the data. It is likely that this dataset is not from an area of your personal expertise, so you must take some time to understand what the data is. Briefly describe how you chose to explore the data and the findings of your exploration. 2. Develop three questions that a decision-maker might ask from this dataset. Briefly describe how you would use analytics (e.g., descriptive or predictive techniques) to answer these questions. FOR TASK 3 YOU WILL UPLOAD YOUR EXCEL OR TABLEAU DASHBOARD FILE 3. Create a dashboard (in Excel or Tableau) to allow a decision-maker to explore the dataset. In designing your dashboard, think carefully about what a decision-maker might want to see and “dive deeper” into. You may wish to refer to Task 2 to help guide your dashboard creation. Note: You do not have to design your dashboard to answer the questions created in Task 2. FOR TASK 4 YOU WILL UPLOAD YOUR EXCEL WORK AND A BRIEF WORD DOCUMENT DESCRIBING YOUR WORK 4. Develop a predictive model to predict Unit Price (in column AB of the dataset) of “HIV test” products. Product type for this task is in the “Sub Classification” column (column Q) of the dataset. Do not include “HIV test – Ancillary” products. This may be a difficult task. In other words, it may be difficult to find a high quality model to predict Unit Price. You should select your variables carefully. Present the best model that you can and provide a brief document describing your work and your results. In summary, you should have several deliverables: Tasks 1 and 2: Word document describing your work on these tasks Task 3: Excel or Tableau dashboard file Task 4: Excel file with model and Word document describing work