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…

Wonder how Machines understand texts? Well, the answer is Natural Language Processing, the branch of AI that gives machines the ability to understand texts.
In this bootcamp session, you will learn some of the applications of Natural Language Processing…

Watch this video for a step by step guide to create a Virtual Machine in Azure with a resource group and then launch that virtual machine using a local pc.

Create Azure Account -
https://signup.azure.com/signup?offer=MS-AZR-0044P&quoteid=18d7d4e97f0e

#azurecloud…

Welcome to our Data Science Interview Preparation video. This video will help you confidently prepare for your next Data Science interview. You will learn about the psyche of the interviewers, how to showcase your projects in your resume, how your projects…

What is Dashboarding with Python Widgets?

Make your Jupyter Notebook more interactive with Python GUIs, enabling you to take the maximum leverage on the interface.

In this video, you will find answers to:

1. Introduction to Python Widgets
2. Basic Python…

Watch this video for a step by step guide to create an Ubuntu based Virtual Machine in Azure with a resource group and then access that Virtual Machine from the local system using SSH key.

Create Azure Account here -

https://signup.azure.com/signup?offer=MS…

In this video on “Creating Calculated Fields/Column in Power BI” we will look into the steps required to create calculated fields/column. This is used to create additional columns based on existing columns for further analysis by applying DAX functions.
…

In this video, we'll discuss how to use the table calculation of Rank along with filters in Tableau. This is discussed with the help of a use case. In the Superstore dataset we have Categories and Sub-Categories. If we want to find top 2 Sub-categories within…

In this video on “Data Modelling in Power BI” we will look into the detailed interactive session to guide you through the steps to create relationships between multiple tables in the database. This is done to ensure that the DAX measures return efficient…

This video is a step-by-step guide on how to Install Hadoop in Windows 10 and 11. By the end of this video you will be able to edit environment variables for Java and Hadoop, create a system path for Hadoop and Java, handle the error of name node shutdown…

The roadmap for Data Analyst includes various steps that will help the aspirant to enter this industry with ease. Read the full article to know all the steps.

You might have applied Conditional Formatting in MS Excel. Curious to learn how to conditional format your matrix in Tableau just like in MS Excel? Watch this video to learn how to make a Crosstab/Matrix and Conditionally Format the background of cells in…