The problem Comviz solves

Although there is a lot of public data available (ex: PhonePe Pulse, RBI Reports, sandbox.data.gov) there are hardly any tools or common public platforms to analyze, derive intelligence and share one's analysis on the data in a comprehensible form. So we created a platform where users can analyze, visualize the data and create their own dashboards which then can be shared for others to use and see. In this way, we'll empower the community to come together and create meaningful dashboards based on the open data which will contribute to the open digital public goods initiative.

Challenges we ran into

• Varied sources of data
  When it comes to data, the different providers will have their own data stack or technology they use to store and open-source their data. All these different tools used for the databases have their own system and language to query but we can't expect our users to know every system/language out there in wild.
  To solve this, we decided to use an open-source tool, called trino. Using this tool we are able to have a single language, i.e., SQL to query every database that is integrated into the platform.