Sign in

Data Analyst at Cloud Mentor, ML enthusiast and a student who has passion for learning loads of stuffs in DS. || https://www.quora.com//Navin-Niish

Data Visualization is the most important stuff when it comes to any business. You can create models, do analysis & then create difficult charts but at the end we need to explain stuffs to persons who have no idea on what happens inside. They need to get insights on what is happening in their company or the product. Data visualization is more of a communicative tool. It is like a google translate, it translates data language in layman terms for people in the business.

Image source : Interactive Data Visualization Tools from Tableau — Salesforce.com

Data Visualization in Salesforce :

Salesforce is a cloud computing service as a software (SaaS) company that specializes in customer relationship…


Long time ago, there lived a monk with his disciples. He was a Buddhist monk and Buddhist monks strictly adhere to rules and regulations of their religion. While they were travelling towards a village, rain started to do it’s work and created a huge roadblock which ensured that the monks had to stay in the village. The Head Monk ordered his disciples to find stuffs that are required to build a temporary place for people to sleep and continue their walk after the rain has stopped. He split his disciples into groups and gave each group a task. …


Leadership and learning are indispensable to each other

To begin with, I have completed my PGP datascience course with Great Lakes Institute of Management & I was searching for jobs when I found Drinkprime’s Data Analyst Intern opportunity. I applied straightaway & got selected after multiple rounds of Interview and later my journey in Bangalore starts.

Drink Prime Logo

First day was awesome, I didn’t know the routes in bangalore and somehow ended up reaching late to the office on the first day. I met my senior BA and started getting knowing about the company straightaway. Drinkprime is a water purification company that…


What is Linear Regression?

In statistics, linear regression is a linear approach to modeling the relationship between a scalar response and one or more explanatory variables. The case of one explanatory variable is called simple linear regression.

For more than one explanatory variable, the process is called multiple linear regression.

Source : Wikipedia

Basically forming a line. That line is called as Ypred.

Y pred = b1x + b0

Boston Dataset :

This dataset was taken from the StatLib library and is maintained by Carnegie Mellon University. This dataset concerns the housing prices in housing city of Boston. …


Introduction about me :

I worked as a Data Associate for Amazon India where my journey into the world of data started and that’s how I got to know about the terms like Data Analysts, scientists and ML etc. I was hired for a non tech role as I was a civil engineering graduate and I worked as a Data associate for 2 years in this field and that’s when I decided to become a data scientist. To start with, this article deals about how to be a data scientist or a entry level data scientist when you come from a non technical background…


When using df.info(), the data is unclean in many stages, to clean it — we must make sure we convert the datatype. In this, I will use the most commonly used methods for cleaning the datatype.

In this article, I’m taking the fifa dataset and this is available in my github repository : https://github.com/navinniish/Datasets

I have loaded the necessary libraries and also the dataset so that we can arrive at conclusions based on the info().

There are 59 columns in this dataset and we are taking necessary columns to change the datatype. There are loads of columns that do require


The term exploratory means exploring and exploratory data analysis means exploring the data and analyzing the data and arriving conclusions based on the data. This is a very simple explanation based on my understanding and if we go by theoretical explanations EDA means : In statistics, exploratory data analysis is an approach to analyzing data sets to summarize their main characteristics, often with visual methods. In this article we can see about, how to do exploratory data analysis and then different types of graphs/charts.

  • First things first, we have to load the libraries that are necessary for the data analysis…


Hello all. Welcome to this particular article about how to solve a guesstimate and how to excel in a guesstimate. I will guide you in a very easy way so that it will be very helpful for you to solve any kind of problems with easier approach.

First of all, always remember that how do you go about the problem matters the most than how well you have your data correctly. Because guesstimate is all about sharing smart guesses and trust me, one you start to master this — nothing can stop you.

What is a guesstimate?

Guesstimate is an…


A complete list of one liner explanations for Mysql commands

Hi there, the non-tech guy once again. In this, I’m adding the one liner explanations for the MySQL commands. I wanted to write this because many people doesn’t want long explanations for SQL as it is a easy English based one. This is why we need one liners which are easy to understand and easy to implement.

Basic commands :

My sql : Create database : creates a database Use database : uses a database Create table : creates a table drop table : deletes the table Truncate : delete…


A quick recap to the window functions in MySQL

MySQL is a awesome language to learn and it gets as complicated if it is not understood properly. Basically MySQL is all about queries. In the topic of sub-queries, we saw about co-related sub-queries and all those. Now, MySQL has window functions which will help you to do a lot of stuff. There are two types of window functions — they are analytical and aggregate function. Like Python, our MySQL also has queries that has aggregate functions. …

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