Take your Excel game to the next level with this tutorial on the Dynamic Array Function "Unique". Get ready to streamline your workflow and simplify your data analysis process like never before! With this powerful function, you can quickly extract unique…

In this video you will learn how to perform the ETL (Extract, Transform and Load) process in MySQL Workbench. With the help of a given dataset you will learn to extract the desired data, transform it as per the given objective and finally load or save the…

Time-based analysis and calculations are the most common calculations, but sometimes challenging. In this session, we will discuss designing a time intelligence pattern and usage of DAX functions to calculate time-based analysis.

0:00 - Introduction
0:27…

Ace your Data Science Interview preparation with this short to know about Reserved Keywords in R Programming language.#rinterviewquestions #reservedkeywords ...

In this video, we'll be diving into the world of Dynamic Array Functions, and specifically the function called "Filter". This function is one of the most powerful tools in your Excel toolkit, and is used to extract specific elements from an array that match…

Check out this short video on Time Intelligence functions in Power BI to learn how to use this function to calculate the MTD (Month to Date), QTD (Quarter to Date) and YTD (Year to Date) in Power BI.

To know more about Time Intelligence Functions in Power…

Happy Valentine's Day to all of you!

Here are a few of our students stating why they decided to select us as their Data Career Partner. We are so grateful for your trust and dedication in choosing us as your learning partner.

Thank you for allowing us to…

Want to crack your next Power BI Interview?
Here are some important Power BI Basic to Intermediate level Interview Questions with answers. Watch this video to crack your next Power BI Interview!

00:00- Introduction
00:23- What are the essential applications…

As the job market becomes more competitive, it’s essential for students to have a strong profile and the right data career advice to set them apart from the competition. That’s why this video is the perfect resource for students who want to learn how to create…

In this video you will find how to analyse key functionalities within the Dataset and develop a Machine Learning model using the key features to predict the Promotion of an Employee in an Organisation using Python. Also how to extract Business Insights using…

Want to crack your DAX Interview in Power BI?
Watch this video to know the top DAX Interview Questions and Answers in Power BI.
Ace your next Power BI Interview with IvyProSchool!

00:00- Introduction
00:24- What is DAX in Power BI ?
01:11- What are the different…

Scaling data is an important step in the data preprocessing. In this video, we will learn how to perform it on the given data with different methods like minmax scaler, standard scaler and robust scaler. Scaling refers to the process of transforming the input…

In this video Amrita Chandra, Ivy Professional School's Data Science learner will analyze the Bank's customer churn data to find out the number of exits based on age group, country, no. of complaints, credit score and number of subscriptions.
The aim of the…

Common Excel Interview Questions are as follows:

1. What are the limitations of Vlookup? - 2:15
2. How to identify Duplicates in a dataset? - 3:25
3. How to delete Duplicates? - 4:09
4. What is the usage of Pivot Tables? - 4:25
5. What is the usage of Calculated…

In this video we will see how to create the final dashboard from the visuals and cards that we prepared in the previous video.The objective is to format the colour and size of the visuals so that it matches with the chosen theme.

Check out the previous part…

Exploring the new On Object Interaction feature in Power BI (March Update)

00:00 -Introduction
00:28 - March Updates in Power BI
00:47 - Visualization Pane Design Change
01:08 - Activating On Object Interaction feature
01:37 - How to use the new On Object…

In this alumni interview, we talk to one of our alumni, Nithin PS who successfully transitioned from the Automobile Industry into a data science career. Nithin shares his experience with Ivy Pro and provides tips for aspiring data scientists.

Towards the…

Are you looking for ways to create dynamic rankings in Power BI? Look no further! In this video, we will show you how to use parameters to create top and bottom rankings that update dynamically based on user input.

We will start by explaining the concept…

This video on Tornado Charts in Tableau, also known as Butterfly Charts, covers not only how to build them but also their applications, advantages, and limitations. Additionally, it demonstrates the use of a Tornado Chart in analyzing the gender distribution…