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…

In this video we will get a glimpse of Hadoop and it's ecosystem like Hive, Sqoop and Hbase. We will also see how Hadoop framework works and how it stores the data in distributed manner.

Moreover, this video will discuss about how Map-reduce access the…

In this video, we are going to understand what Data Engineering is, and the difference between Data Engineering and Data Science. Additionally, the viewers will also get an idea about the architecture of Data Engineering. Get a complete end-to-end flow of…

Getting Started with SQL? Understand the Basic Operations In SQL easily.
CRUD operation are the basic data manipulation for database. Learn how to Create , Read , Update and Delete data using SQL.

00:00 - Introduction
00:29 - What does CRUD stand for?
00:45…

In Part-6 of the SQL Interview Question we will learn to write a query for another complex SQL problem. We will print the sum of total investment values in 2016 to a scale of 2 decimal places using MySQL.

Know how you can solve this problem in just a few…

Let us understand how we can extract data from our database using Select Statements. We will also explore the different scenarios to effectively extract only the specific data as per our requirements.

00:00- Introduction
00:14 - What is Select statement?…

SQL plays a vital role for Data Analysts and Data Scientists. Let us learn how we can summarise, organise and arrange our data in SQL using Group by, Order By and Having Clause.

00:00 - Introduction
00:20 - Group By Clause
02:11 - Order By Clause
03:49…

The project has analyzed the data using Power BI and found out the reasons behind customers' dissatisfaction. It has also depicted them using matrix, treemap, and donut charts. If all the points are thoroughly considered then it will impact the satisfaction…

A new feature came back in Power BI called Parameter, where you can give a field as a value, and the visuals will change based on the field selected. In this video, you will learn how to create a visual using the dynamic slicer panel in Power BI.

00:00 Introduction…

When we create visuals in Power BI, data labels (or labels) generally appear in abundance. Here comes the need of smart data labels that allow you to highlight a certain point in a graph. This helps the end user to focus on the specific point or label. In…

A new feature came back in Power BI called Parameter, where you can give a field as a value, and the visuals will change based on the field selected. In this video, you will learn how to create a visual using the dynamic slicer panel in Power BI.

00:00 Introduction…

In this tutorial we will learn about Support Vector Machine, Kernel function, how to find the right hyperplane, practical SVM Case Study on building Email spam filters using R and much more!!

00:00 Introduction
08:46 Agenda
10:18 What is a Support Vector…

Deleting duplicate rows for cleaning data from a table in Excel is something that is very tedious if you do it manually - luckily you don't have to. Delete duplicate rows from a table in Excel with these few easy steps.

Microsoft Excel is a highly valuable…