systematically analyze data and report findings using pivot tables/charts and/or Tableau graphics.

1. Examine the data file, Sustain Dye Source Data.xlsx , use this link for data: https://drive.google.com/file/d/16sHKZZ6mzdyJEzJoQapi3LHUMJLo8IGM/view?usp=sharing

2. Using pivot tables/charts (or Tableau graphics), prove or disprove the following statements.Make sure to upload your tables/charts in Excel.

a. Sumutka Sporting Goods occasionally pays on time.

b. SustainDye experiences seasonality with its sales.

c. PayClass 4 tends to have the highest percentage of disputed invoices.

3. Summarize your findings in one or two sentences for each pivot table or graph.

4. Based on your findings, providetworecommendations on how SustainDye can improve its cash collections. (By doing so, you are engaging in prescriptive analytics.)