Data science vs analytics is the hot topic now! There are many who are curious about the difference and this article is apt to clear all your doubts.

Here comes another video from the data clean series using Excel. In this video you will learn about the criteria of data types and also the treatments that are undertaken. After that we will have a look at a dataset where you can use the find and replace…

In Part-5 of SQL Interview Question we shall showcase solving questions with the help of Joins. Joins help work with multiple tables. Questions revolving around Joins are asked in every interview. Let us take a look at how joins can be used to solve the question…

Here is another video on the data cleaning series using Excel. In this video, we will discuss how to identify inconsistent data. There are primarily two ways: manually and using tools. Watch the whole video to learn how to clean inconsistency in data.

#datacleaning…

In this video, we are going to discuss another question from the SQL 10-day challenge.

From the Insurance Policy table, we will find out the total investment of a given year based on geographical data as well as previous year's data.

Watch the whole video…

In this interview preparation for data science, Vishal Tripathy shares his experience how he grabbed a nearly 100% salary hike. If you are looking for a data science interview prep, then this video is ideal for you!

00:00 Introduction

01:20 How many rounds…

Data Cleaning is required to identify and treat Missing Values.

In this video, we will see how data cleaning is done by deletion of row and column and also using Mean, Median and Mode.

Watch the whole video to understand the methods.

#datacleaning #…

Tableau Prep is used for data cleaning and preparation.
In this video, we will watch how data is cleaned by removing punctuations, null values, splitting the data, pivot and filter the data to get the final output. Watch the whole video to cover all these…

In this video, we will see how to install MySQL Database Management System. But before that, you should know why is it so important. MySQL is supported by Oracle which assures reliability and also durability. It also supports multiple storage engines and…

In this video, we have our student, Sakshi Gupta. She is currently pursuing the Data Science Course from Ivy Professional School and is now working as a Senior Executive Actuarial.

She is here to share her experiences as she ventured through the basics of…

Get access to unlimited free Data Science and Interview prep resources to kickstart your career in the Data world: https://t.me/learndswithexperts

You may also call us at +91-7676882222 for more information!

Join our Telegram Channel to Get access to Unlimited…

When making your career in data science, you do not need to know rocket science. Shivam Tyagi, a data science student at Ivy Professional School is a maths graduate. After his graduation, he enrolled in the data science course at Ivy Pro School.

Shivam…

Tableau Prep is used for data cleaning and preparation.
In this video, we will watch how data is cleaned by removing punctuations, null values, splitting the data, pivot and filter the data to get the final output. Watch the whole video to cover all these…

In the 11th episode of Analyticshala by Ivy Pro School, we will see the Director of @IvyProSchool - Prateek Agrawal, converse with Mr. Sayandeb Banerjee, the co-founder, TheMathCompany
In this video, Mr. Banerjee has given great insights on the Data Science…

In this video, Nupur Jha, Ivy Pro Student will help you understand and analyze the database of Hollywood Theatrical Market Synopsis for the years 1995-2021 using SQL. You will learn to find out the average ticket prices, total box office collection, and market…

In this video we will learn how to use the DDL command to create a database, how to create a schema of a table, and then upload the data from a CSV file!!

We will also learn to remove duplicated rows from the table, group data, and store data in a new table.…

Outliers are data points that are present outside the data range. In this video, we will find out how to detect outliers in data and the steps to delete them. Watch the whole video to learn the process of data cleaning of outliers using excel.

00:00 Introduction…

In this video we will learn how to make Power BI dashboards more attractive and dynamic. We will create a Slicer Panel which can open up and collapse as per our need. So no more worries about over-crowding slicers in our dashboards and let the focus be only…

Splitting is used to split the data from single cell into two or more columns. Concatenate, on the other hand, joins data from multiple cells into a single cell. In this video, we will have a look at different ways to split and concatenate the data. Give…