A view of how data can be viewed in a Google Sheet
A view of how data can be viewed in a Google Sheet
Photo by Mika Baumeister on Unsplash

Do you store your data in Google Sheets? Have you created multiple spreadsheets for your organization’s data? But, when it comes to extracting insights from them, often it’s difficult because either the numbers don’t tally, or the information is stored in multiple sheets and there is be no way you can link the two sheets?

Sounds familiar? If so, this post will help you make the most of Google Sheets and maintain data in a way that so that you can leverage it for analytics.

Google Sheets are a great way of maintaining small data (GSheets has a limitation of…


If you want to know whether Business Intelligence can help a small business, read this first: Can Small Businesses Leverage Data Science?

You are convinced that your business will benefit from Data Science, but don’t know what you can do about it. You can set up data reporting for your organization in no time, with little help. How? This post will guide you.

Data Input → Data Storage → Data Processing → Data Analysis & Reporting

Let’s see how you can replicate this journey in your organization.

Data Collection/Input

To make data useful for your organization, you need to first ensure that…


Photo by Scott Graham on Unsplash

One of the first software that ruled the Enterprise markets was ERP — Enterprise Resource Planning software, and rightfully, so. SAP quickly became a global business leader with Oracle’s Netsuite and others followed its lead. While many believe that the ERP problem for businesses is well solved, the reality is far from it.

Deployment and management of ERP software can easily turn into a big nightmare for any business, especially small businesses. Even data management suites specialized for specific domains or departments are far from user-friendly.

Here’s my take on this situation: there is a supplier and a buyer problem.

Client-side issues


Photo by Austin Distel on Unsplash

Are you looking to invest in a software solution to help manage your accounts, inventory, manufacturing processes, all in one place but are not sure of the right software to buy? You are most likely looking for an ERP. Even if you aren’t, these quick tips will help you choose the correct software:

1. Make sure it scales with users.

Don’t go for age-old desktop software or those that require payment of increasing premiums on licenses. They will not be cost-effective in the future, and may not be able to handle an increasing number of users.

2. Ensure proper user permissions.

Make sure all users can be assigned different permissions as per…


Most small business owners feel that Data Science is for large corporations or bigger businesses. It’s a tool that can only help big businesses and the investment is not really worth the ROI for small businesses. This was true a couple of years back, but not in 2020.

Investment?

In 2019, there are a lot of open-source tools and technologies, as well as data experts that are working towards Data Science for SMBs and MSMEs. You no more have to invest in a tool like SAP or Oracle or spend a lot of money paying software developers to create a custom…


As a product lead or startup founder, you’re constantly told to solve a real problem and build what people want. But how can you know if you’re on the right track?

Woman looking at an app on a smartphone
Woman looking at an app on a smartphone
Photo by freestocks

As a product lead or startup founder, you’re constantly told to solve a real problem and build what people want. But how can you know if you’re on the right track?

There are lots of UX research methods out there: user interviews, surveys, focus group discussions, etc. But most UX content out there doesn’t help you select a method that’s right for your product.

This blog is exactly about that. I’ll teach you how to use user tests to quickly accelerate your product development with high-quality user validation. Let’s dive right in.


A mobile business assistant for MSMEs

What is TallyAssist? And, why we thought a mobile business solution for MSMEs was needed?

Beginning of 2020, Akash and I got excited to solve a problem for MSMEs aka micro, small, and medium enterprises. From our personal experiences of working with MSMEs, or with family businesses in our close circles, we realized that most MSMEs that we know we’re not able to make sense of their data. And, most MSMEs were primarily using accounting software like Tally ERP 9 to maintain their data around customers, products, sales, purchases, etc.

The idea wasn’t novel, but much needed, to create something that can help MSMEs make sense of their business — a simple dashboard for the…


While big data is disrupting enterprises, how can small data with new-age technologies of machine learning, artificial intelligence, etc. disrupt small businesses? Read along!

Photo by Stephen Dawson on Unsplash

Rahul (name changed) is a hardware manufacturer, and his company manufactures memory products such as Pen Drive, RAM, etc. He saw the computer revolution coming in the 2000s and made a decent living out of it. As his business grew, he started implementing an ERP (the de facto business software) in the early 2000s itself. But, it’s only now, after three software shifts, he has been able to reap an ERP’s benefits. …


YC Startup School’s Delhi founders who work for SMBs met online to share the problems they were working on and what they learnt while building for SMBs. For the first meetup, we had mouve.app, restat.co, designforpeople.in, and Uplift Inc.

As we discussed how we discovered the problem we are solving, mistakes we have made, our markets and customers, we had some interesting lessons for each other. Here are 6 lessons for startups working for SMBs:

#1 Blue Ocean vs Red Ocean strategy

We revisited the famous blue ocean vs red ocean strategy. As many people are building software solutions for SMBs knowing whether your market is a…


A young Indian business owner
A young Indian business owner
A typical Great Indian Middle Class Businessman (Getty Images)

For the past 8 months, I have been working with a few Indian businesses, and I am writing this to introduce this category of businessman to you, and why I thought of working for them. I call them the “Great Indian Middle Class Businessman.” It’s not the middle class you think of, and they would probably fall in “Upper Middle Class” by your definition. Let me explain this term to you.

Let’s start with “Great”. These businessmen are great because of a few reasons. To start with, unlike startups, they have bootstrapped businesses which means they have been able to…

Richa Verma

Parallel | Restat.co | Atlan | SocialCops | IDinsight. Passionate about design, data, and tech. The more complex a problem, the more fun it is to solve!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store