Imagine if you have raw data to analyze; will it be easy to draw insights from it? Of course, not. Especially if you have to make conclusions from a dataset containing millions and billions of data. To understand it more simply, we have taken some raw COVID-19 data. Let’s

Installing or updating Python on your MacOS is the first step to becoming a Python developer. You can get started with setup and installation: download official Python distributions from Python.org, install from a package manager(Anaconda), and even install specialized distributions for scientific computing, the Internet of Things, and

Data is found in every field; whether you are a data analyst, marketer, data scientist, product manager, businessman, researcher, or any other profession, you need to experiment with raw or structured data to generate optimum results. According to the reports, we are generating at least 2.5 quintillion bytes of

Database Normalization, aka Normalization, in simple words, is the efficient Architecture of a database. Efficient Architecture is the Keyword here. It is a process of organizing your database in the most efficient form. Normalization starts with understanding the data. Once you have understood your data, you implement a certain set

Today, DATA is everywhere! From the simplest spreadsheets containing the monthly budget calculations to the enormous amounts of large-sized videos — everything is DATA! Data has an origin, is categorized into numerous types, can be added, modified, deleted, reside in manifold places, and most importantly, has meaning. It accentuates the purpose

Data has always been the hero! I say not just the heroine, but everything revolves around data. Agree? Data has been generated from time immemorial. Storing it is also not something ancient. Data is stored in books, receipts, papers, ledgers, databases, data warehouses, and many other storage devices and forms.

Imagine you have bought a new wardrobe, It is a huge one that can fit in your clothes, cosmetics, accessories and also has space for decor. Your first step could be to bring in all the things from your existing wardrobes that you want to arrange in one place (Extract)

Now that you know how to visualize raw data with the help of frequency distribution tables, it is time to solve another problem! For easy understanding, we will take the same COVID-19 data set we considered while learning frequency distributions. Let’s first understand this brand-new concept of central tendency.

In this article, we will learn about the basics of SQL (SELECT, FROM & WHERE) with exciting visuals, and the bonus is my personal story of learning SQL. I tell you, it is no less than Moneyball. You all must have used Excel in your life to do something, and in