Currently showing  Data Analytics

  Show all blogs


Saving Thousands of Dollars by BigQuery Cost Monitoring Dashboard

By Vivek Kumar

December 23, 2023


We recently found out that our client has to pay so much for the cost of using the GCP. So we decided to do a GCP audit to find out from where most of the costs are coming out. After the audit, we found out that we are spending thousands…


Experiments with Frappe as CRM in Glific

By Akhilesh Negi

September 19, 2022


For the past few months, we have been working with Reap Benefit to visualize citizen engagement of their chatbot in a mapping dashboard created in R/shiny. Read more about their journey with Glific and our journey in creating the dashboard here. Initially, we went with the combination of Glific, BigQuery,…


Visualizing citizen engagement of Chatbot

By Akhilesh Negi

August 30, 2022


Imagine a nation where problems encountered by locals could be collected in one location and then resolved by locals utilizing local resources and data. A community where each resident takes responsibility for local problems and finds solutions. As Abhijit Naskar said “A nation can run without government, but it can’t…


M & E in Digital Green’s Farmer Chatbot

By Akhilesh Negi

June 2, 2022


Despite the fact that India is an agricultural country where agriculture is the primary source of income for over half of the people, farmers confront appalling conditions. These scenarios typically arise when crop products do not meet expectations because harvests have been ruined by pests or harsh climatic conditions, leaving…


How custom dashboard can boost your Chatbot

By Akhilesh Negi

February 3, 2022


A chatbot for an NGO can be a godsend for keeping in touch with beneficiaries on a large scale, especially when one-on-one talks are impossible to continue in the midst of a global pandemic. NGOs can use chatbots to digitize their programs and distribute them to a wider audience through…


How custom DataStudio Reports can contribute to building foundations for lifelong learning

By Akhilesh Negi

November 3, 2021


“The most sustainable way to build the foundations of lifelong learning among children and young people of today is by reigniting intrinsic motivation at all levels of an education system” – STiR Education. STiR Education is an international NGO that supports governments to employ practical strategies that promote positive behaviors…


How BigQuery and WhatsApp is helping teachers with their students report in Haryana

By Akhilesh Negi

October 17, 2021


With Covid-19 and the global pandemic surge, NGOs faced major challenges in the delivery of their programs and carrying out their operations which gave rise to many platforms that can help them with their last-mile deliveries and digitalize their programs. That’s how Glific was initiated to bridge the communication gap…


BigQuery and DataStudio: A solution to Analytics

By Akhilesh Negi

November 19, 2020


A growing business requires taking crucial business decisions from time to time to improve the application in a way to better target customers and increase reach. Taking these crucial decisions can be a make it or break it decision and therefore requires a lot of researching, analysis, and forming various…


How we may be able to solve our hiring needs through data analytics?

By Vaibhav Rathore

November 7, 2020


At ColoredCow, we’re fortunate and proud to say that we’re always hiring. Even in times of pandemic, we are looking for talented people to join the team. We’ve been receiving several applications every day. That’s good, right? Well… not really. The world is facing a huge business discontinuity due to…


Talks
Building Scalable Applications for Nonprofits in Laravel
By Tushar Bohra
SOLID Design Principles
Know more to request this talk