Deploying a dashboard tool to enable Firstport to monitor the diversity and inclusiveness of their entrepreneur audience
Firstport is a registered charity and started work in 2007 to help social entrepreneurs bring forward their ideas and to make them happen. Since then, they have grown and evolved, supported thousands of individuals and distributed millions of pounds of start-up funding, all with the aim to achieve their vision: for social enterprises to play a key role in society, transforming lives, communities and the economy.
The Scottish Tech Army was founded by Edinburgh based entrepreneurs, Alistair Forbes and Peter Jaco and is a not-for-profit company that built a volunteer Covid-19 technical response team. The Scottish Tech Army’s aim was to help the Scottish Government, Local Authorities and other organisations across the country with rapid technical development projects to address current Covid-19 related challenges and post pandemic recovery.
Everyone who joined the Scottish Tech Army did so as a volunteer, offering their time and talents to help them deliver a wide range of projects. Volunteers were from the broad range of the tech development world including software developers, project and programme managers, social media and marketing, business analysts, application deployment, etc.
Volunteers were matched based on their skills to the needs of the different organisations – this was how we were initially introduced to Firstport in their request to create a Diversity and Inclusion dashboard.
With the objective of making sure they are able to support applications and staff from diverse groups, such as ethnic minorities, disabled and LGBTQ+, Firstport reached out to the Scottish Tech Army to ask for support in building a tool that would allow them to gather insights on their audiences.
There would be several challenges to surmount within the short span of the project, such as some of the data sources not being machine readable (e.g. survey results on a pdf and a non-formatted excel file), and some additional data being available only close to the end of the project. We also needed to create a comprehensive document that described all the features of the dashboard and a technical guide on how to maintain, update and further develop the dashboard.
To ensure efficiency of completion, we decided to split the work by having two team members focused on the hands-on development of the dashboard in Microsoft Power BI and the other two focused on the documentation and research.
We also reached out directly to Firstport stakeholders to gather feedback while we were developing the dashboard - making sure the documentation was comprehensive so that the client would be able to maintain, refresh, and further develop the dashboard.