Data Analysis of raw data needed including creation of pivot tables, and stack horizontal graphs

Job ID: 33643073

Budget: $30 – $250 USD

This project is to analyze a raw data file to help gather some key insights, and answer key questions about the data set.

Background: Concepts/ideas are submitted analyzed, and approved or rejected based on certain criteria, and bandwidth. Due to limited resources, many ideas are rejected, and those approved may be withdrawn if its determined that it cannot be supported.

For a given idea, one or more teams may be identified to make it a reality. This project is to help provide key insights into the data including the following:

Determining how many unique ideas were submitted (you'll need to be able to identify/remove duplicates)
Determining which teams are the most impacted by the ideas submmited
Who organization /individuals submitted the most ideas
A funnel view showing the number of ideas initially , how many got approved, rejected, etc
Some charts to help visualize the story including horizontal or vertical bar charts and or tables

To be considered please be prepared to show a track record including deep data analysis, formulas, and visualize of data . The final output will be in Google slides (Copy/paste is fine)