Multi-Region Project Excel Dashboard
Budget: $30 – $250 CAD
I need a comprehensive Excel sheet/Dashboard that will allow me to keep track of various projects across five different locations and specific team members attached to them.
Key Features:
- The sheet should have a dedicated section for each of the regions: Toronto, Ottawa, Montreal, Calgary, and Vancouver.
- For each region, there should be sub-sections for the assigned team members: 1 VP, 1 EVP, and 1 Director.
- Each project should be displayed with its name, and ideally, the start and end dates.
Visual Representation:
- The data for each location should be visually represented using bar charts.
Functionalities:
- Automatic Data Update: The dashboard should automatically update data, so that I always have the latest information.
- Region and Project Status Filter: It should allow me to filter projects by region and project status.
- Data Export Options: The dashboard should have data export options for easy sharing and analysis.
Ideal Skills and Experience:
- Proficient in Excel and creating complex Excel sheets and dashboards
- Experience in data visualization, particularly with bar charts
- Knowledge of data automation and the ability to create a system that updates data in real-time
- Experience with advanced Excel functionalities such as filtering and data export options.
Key Features:
- The sheet should have a dedicated section for each of the regions: Toronto, Ottawa, Montreal, Calgary, and Vancouver.
- For each region, there should be sub-sections for the assigned team members: 1 VP, 1 EVP, and 1 Director.
- Each project should be displayed with its name, and ideally, the start and end dates.
Visual Representation:
- The data for each location should be visually represented using bar charts.
Functionalities:
- Automatic Data Update: The dashboard should automatically update data, so that I always have the latest information.
- Region and Project Status Filter: It should allow me to filter projects by region and project status.
- Data Export Options: The dashboard should have data export options for easy sharing and analysis.
Ideal Skills and Experience:
- Proficient in Excel and creating complex Excel sheets and dashboards
- Experience in data visualization, particularly with bar charts
- Knowledge of data automation and the ability to create a system that updates data in real-time
- Experience with advanced Excel functionalities such as filtering and data export options.