[URGENT] Create interactive/informative investment dashboard
Budget: $30 – $250 SGD
I'm seeking a skilled data analyst to create a comprehensive fund performance dashboard in Excel.
Requirements:
- Use of Excel formulas and macros
- Visualizations: bar, pie, line, scatter charts
- Manual data entry only, no import functionality
Key Responsibilities:
- Utilize the provided Excel data to build a user-friendly dashboard.
- Implement pivot tables as necessary.
- Include a variety of charts, with an emphasis on bar charts, scatter charts, and line charts, as well as other relevant visualizations.
Specific Metrics to Display:
- MTD Absolute Returns
- MTD Relative Returns
- YTD Absolute Returns
- YTD Relative Returns
- 1Y Absolute Returns
- 1Y Relative Returns
- 3Y Absolute Returns
- 3Y Relative Returns
- 5Y Absolute Returns
- 5Y Relative Returns
Ideal Candidates Should:
- Be proficient in Excel (e.g excel formulas, macros etc) including pivot tables and VBA.
- Have a background in creating financial or investment performance dashboards.
- Understand how to effectively display specific metrics and key performance indicators (KPIs).
Requirements:
- Use of Excel formulas and macros
- Visualizations: bar, pie, line, scatter charts
- Manual data entry only, no import functionality
Key Responsibilities:
- Utilize the provided Excel data to build a user-friendly dashboard.
- Implement pivot tables as necessary.
- Include a variety of charts, with an emphasis on bar charts, scatter charts, and line charts, as well as other relevant visualizations.
Specific Metrics to Display:
- MTD Absolute Returns
- MTD Relative Returns
- YTD Absolute Returns
- YTD Relative Returns
- 1Y Absolute Returns
- 1Y Relative Returns
- 3Y Absolute Returns
- 3Y Relative Returns
- 5Y Absolute Returns
- 5Y Relative Returns
Ideal Candidates Should:
- Be proficient in Excel (e.g excel formulas, macros etc) including pivot tables and VBA.
- Have a background in creating financial or investment performance dashboards.
- Understand how to effectively display specific metrics and key performance indicators (KPIs).