Data Analyzing Dashboard Designer
Budget: $30 – $250 USD
In need of an expert in Excel, Power Query, Power Pivot, and VBA. The objective is to create an innovative and tailored dashboard for data translation and analysis. The dashboard design is explicitly provided, hence, the ideal candidate should have powerful interpretation skills to convert the given design into functioning digital interactive spreadsheets.
Key Tasks:
- Creating a dynamic dashboard from given design
- Developing a search engine tailored to my specifications
- Ensuring the system handles data from CSV exports successfully
Search Engine Functionality:
- Capability to perform a keyword-based search
- Enable filtering by date range
- Design of filter dropdowns based on type, gender, size, condition
- Ability to save search results to a different location
- Note: The system should handle one data column
Skills & Experience:
- Proven experience in Excel, Power Query, Power Pivot, VBA
- An understanding of system data management
- Familiarity with CSV exports
- Creativity and problem-solving skills are crucial
- Exemplary attention to detail.
Attached is a workbook that demonstrates how I want the UI to look like. I only made it with coloring cells and putting in shapes/images. I need you to make it actually work! The word doc has a very detailed write up of everything. Also attached are example CSV files to work with. Since I'm not very technical, maybe you'd see things to make it better that I wouldn't think of.
Key Tasks:
- Creating a dynamic dashboard from given design
- Developing a search engine tailored to my specifications
- Ensuring the system handles data from CSV exports successfully
Search Engine Functionality:
- Capability to perform a keyword-based search
- Enable filtering by date range
- Design of filter dropdowns based on type, gender, size, condition
- Ability to save search results to a different location
- Note: The system should handle one data column
Skills & Experience:
- Proven experience in Excel, Power Query, Power Pivot, VBA
- An understanding of system data management
- Familiarity with CSV exports
- Creativity and problem-solving skills are crucial
- Exemplary attention to detail.
Attached is a workbook that demonstrates how I want the UI to look like. I only made it with coloring cells and putting in shapes/images. I need you to make it actually work! The word doc has a very detailed write up of everything. Also attached are example CSV files to work with. Since I'm not very technical, maybe you'd see things to make it better that I wouldn't think of.