Fish Yield Data Analysis & Dashboard Creation
Budget: ₹600 – ₹1,500 INR
Project - Clean the data, identify and analyze issues, and create the required dashboard. For missing values and outliers, calculate the yield as the weighted average of the past 5 days.
Objective: Use the provided dataset containing daily yield data for 100 fish types over September and October 2024 to create a dashboard.
Requirements:
Dropdown for Fish Type:
Create a dropdown menu to select a specific fish type from the list of 100 types.
Dropdown for Date:
Create a dropdown menu to select a specific date within the range of September 1, 2024, to October 31, 2024.
Task 1:
Display the corresponding yield value based on the selected fish type and date. i.e if Fish type Dropdown = Fish_1 and Date Dropdown = 2024-09-06 then output should be 36
Task 2:
Add a chart that dynamically updates to show the yields of the selected fish type over the entire two-month period and compare it the average yield of all other fish in the same time period.
Deliverable:
"Document your observations while cleaning and analyzing the data, including references to the cell locations of any outliers identified. Submit a single Excel file with the following structure:
Dashboard and Chart: Consolidated on one sheet.
Dataset: Included on a separate sheet.
Observations: Detailed on another sheet."
Objective: Use the provided dataset containing daily yield data for 100 fish types over September and October 2024 to create a dashboard.
Requirements:
Dropdown for Fish Type:
Create a dropdown menu to select a specific fish type from the list of 100 types.
Dropdown for Date:
Create a dropdown menu to select a specific date within the range of September 1, 2024, to October 31, 2024.
Task 1:
Display the corresponding yield value based on the selected fish type and date. i.e if Fish type Dropdown = Fish_1 and Date Dropdown = 2024-09-06 then output should be 36
Task 2:
Add a chart that dynamically updates to show the yields of the selected fish type over the entire two-month period and compare it the average yield of all other fish in the same time period.
Deliverable:
"Document your observations while cleaning and analyzing the data, including references to the cell locations of any outliers identified. Submit a single Excel file with the following structure:
Dashboard and Chart: Consolidated on one sheet.
Dataset: Included on a separate sheet.
Observations: Detailed on another sheet."