We make beautiful UI interface, a nice form to capture the relevant data, but wouldn’t it all be meaningless if we couldn’t visualize what it means? That’s also one of the major advantages of using the database over using Excel or other spreadsheet software, it allows us to perform automated complex queries and get awesome looking charts in real time, which in turn helps make informed decisions easily.
That’s one of the major things that our team worked on this sprint, Analytics. It was also one of the expectations that our community partner had for collaborating with us for this project. From writing the SQL queries and converting them to LINQ queries for making simple charts to integrating district-wise data to the SVG map, we had lots of fun trying and making new stuffs. Seeing the raw data being converted to insightful information made us feel that the journey that we had been worthwhile.
Data security and privacy is one of the most important things in the digital world, and something that shouldn’t be overlooked while designing anything that goes over the internet. This sprint we worked on implementing authentication both on the API level, as well as on the frontend website, which not only secures the admin dashboard, but also ensures that no unauthorized party can access the data through APIs.
The other significant achievement this sprint was the deployment of the project on the Azure. Setting up the CI/CD pipelines to automate the building and deployment has significantly improved the development process and moved our project from local host to cloud. With this, the members of our community partner start using the software with real data.
This sprint overall has been a huge step towards the final solution that we have been building. With just one more milestone to achieve and the end of our journey just around the corner, the end of our magnum opus is in sight.
