Hello, everybody. Welcome back to this dashboard Course In this video, we will see the data that we're going to use for our first dashboard and understand the data. So let's get started. So for creating the first dashboard by using a pivot table, the data that we are going to use is in dashboard one raw data. So let's take a look. So I'll just remove the filters that should do it.

And I'll just highlight the first row. Okay, we can see the data labels, here's unique ID, country code, salary in US dollars, job type, M is admin, marketing, sales, r&d, finance, HR, it and so on. So here we can see information for job vacancies. For the first one, the unique ID one the salary is Almost $1 million. The job title is MRIs in India, which you can see requires software knowledge on PowerPoint, but no experience is needed. So we will be using the data that we have here for creating the dashboard using pivot.

Now, there are some formulas that we should be aware of before we start off with pivot. So let's get started with those formulas or rather in Excel, we call them functions. Now in the next video, we will learn some of those functions. Till then keep practicing. See you in the next video. Thank you