Excel Integration and Dynamic Dashboard Creation
Budget: €30 – €250 EUR
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure.
After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner.
Ideal candidates for this project are those with:
- In-depth expertise in Excel data management
- Experience in creating dynamic dashboards
- A competent hand at data visualization techniques utilizing charts.
Your job will be to deliver a user-friendly Excel sheet and a visually appealing, functional dashboard. Through this, we hope to improve our project tracking and analysis.
I need this done today.
After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner.
Ideal candidates for this project are those with:
- In-depth expertise in Excel data management
- Experience in creating dynamic dashboards
- A competent hand at data visualization techniques utilizing charts.
Your job will be to deliver a user-friendly Excel sheet and a visually appealing, functional dashboard. Through this, we hope to improve our project tracking and analysis.
I need this done today.