Tableau Full Course 2026 [FREE] | Tableau Data Visualization Course | Tableau Tutorial | Simplilearn

Hey and welcome to the Tableau training course by simply learn. In today's world, businesses generate massive amounts of data every day. But data by itself does not create value unless it can be understood and used effectively. Now that is why data visualization tools like Tableau have become so important. Tableau help transform raw data into meaningful charts, dashboards, and visual stories that make analysis easier and decision- making smarter. This course is designed to help you learn Tableau in a very simple and practical way. We will get started with the basics and gradually move forward with the key features used in real world business intelligence and data analysis. Along the way, you will be learning how to connect data, build visualizations, work with dashboards, and use important Tableau features to create more effective reports. So whether you're just getting started or looking to strengthen your Tableau knowledge, this course will give you a solid foundation. So first, we will understand the fundamentals of business intelligence, data visualization, and Tableau along with the different Tableau products. Next, we will be exploring the tableau interface and learn how to connect to data sources while understanding concepts like dimension, measures, and metadata. Then, we'll also create charts and visualization using features such as mark cards, labels, colors, tool tips, and data hierarchies. After that, we'll also cover filters, dashboards, and calculated fields including useful date functions and logical functions. Finally, we'll also move into more advanced concepts such as parameters, sorting, sets, group, and LOD expressions. Also, if you are interested in building a strong career in data analytics, I highly recommend checking out the data analyst certification course by simply learn. This course offers an industry recognized master certificate from SimplyLearn along with the Microsoft certifications that can add real value to your resume. You'll be learning key tools like Excel, SQL, Python, Tableau, and PowerBI. work on durable projects and build the practical skills needed to turn data into actionable insights. Plus, with job assist, you will get help preparing for interviews and connecting with hiring opportunities. So, if you are serious about building a career in data, this program is definitely worth exploring. So, what are you waiting for? Hurry up and enroll now. The cohosting is mentioned below. Now, before we move on, here's a quick quiz question for you. Which of the following in tablet is mainly used to create interactive visual summaries from multiple worksheets? metadata p dashboard measure values or tool tip. Let me know your answers in the comment section below. In Google if you type Tableau desktop download. Okay, just type tableau desktop download. Yeah, Tableau desktop download. You type over here in Google and then you can go to uh this area this link that is download tableau desktop. Okay, you can click the link here after typing tableau desktop download. So just like PowerBI you are also having here uh Tableau desktop. Okay we there we had PowerBI desktop here we are having uh Tableau desktop. So if you click this link here after typing Tableau desktop download Tableau desktop then here you'll come to this area it says here Tableau Desktop start your free 14-day trial. Now see here I'll be telling you the difference. Okay the first difference is coming over here between the PowerBI desktop and Tableau Desktop. See PowerBI desktop as you know that it's a free tool. So it's uh free for the lifetime. Okay. So that's the best part of PowerBI. But Tableau Desktop is having a 14-day trial period. So after 14 days, you have to pay money. So here uh it says download free trial. Okay. Definitely we have to go for this one. Download free trial. And then when you click on that download free trial and then the free trial should get downloaded. Okay. Okay. It should get downloaded over here. Yeah. So it will take some time here and once it get downloaded in your system then please double click that exe file and then you install. Okay. You agree to the terms and conditions and then uh you click on install and then it will get installed. Okay. So installation also will take some time. I would like to tell you one important thing here. The Tableau desktop as we know the Tableau desktop is having a uh 14-day trial period. Okay. Now the question will come that okay what should I do after 14 days? So if you are a student okay now listen to this thing very clearly. If you are a student in a university then you can get a free license for this Tableau desktop for one year. Okay, you'll be getting a one-ear free license if you are a student or if you are a university professor. Okay, so only for these two categories there's a free license either for the university professor or for the student. So if you are a student then what you can do that simultaneously I'm not saying that you wait for 14 days and then you apply for the student license. What you can do here in Google if I let me make it bigger for you. So here you write down Tableau desktop. Yeah you see here in my case it is showing me here Tableau desktop download student. Okay. So Tableau desktop download student. If I click it then here it will take me to you I have to go to this area Tableau for student. If I click it Tableau for student. So see this is the page. If you want I can also put it in the chat window here. Yeah. So I put up the link in the chat window. You can also use this link if you're a student. And then here it says download Tableau Desktop and Tableau Prep Builder. Okay. Now what is this Tableau Tableau prep builder that I'll be talking in the presentation here. So here it says get Tableau for free. Okay. Okay. So suppose if I click this link here then what it will ask you here it says uh full-time students at accredited credit bearing academic institutions worldwide are eligible for a free one-year license to activate Tableau Desktop and Tableau Prep. Okay. So you'll be getting the license for two products of Tableau. One is Tableau Desktop and Tableau Prep. In this training program we'll be focusing only on Tableau Desktop. We will not be using Tableau Prep but it is good that you are having also Tableau Prep. Yeah. Complete the form below to confirm your eligibility and unlock your free license. You must be 16 years of age or older to request a license. So here in this form you have to give all the details. Okay. Also here it requires your school issued email. So here if you type your email id let's say if I type my email id sami [email protected] it will not accept. Yeah, because it has to be Sami Roia something university uh edu or something like that. So I have to give my university email id not the common email id. Yeah general email id yahoo mail or Gmail. So I have to give this my uh university mail ID. Yeah. Date of birth blah blah blah school and everything. And then you it will you click this button verify student status and then the details will go to the tableau. If required your Tableau will also ask you to uh send the uh this uh your u university ID okay your identity card. It will also tell you to scan that university identity card and send it to them. or sometime they may say okay but I would say that today only you apply for this license okay and then you can uh uh wait for it and maybe once the new year is there then you'll be getting the license okay these are the important things okay the Tableau desktop is uh in general it is having 14 days trial period now see suppose if you are if you want to pay for this Tableau license definitely I'll not tell you to pay for that amount uh say pay for this Tableau desktop but uh the normal costing of Tableau desktop is around $70 or $70 per month per user basis yeah so every month you have to pay $70 or $70 that's the price okay so here I would say that Tableau is having some issue when I compare with PowerBI because PowerBI desktop free tool you get every month new new versions and uh you are not paying anything for that but uh Tableau desktop you have to pay money okay but now I'll show you also show you those who are not university professors or those who are not university students what you can do that see currently if you have downloaded the latest version So currently the version which is there for the Tableau desktop it is uh 2024. Let me show you that part. Yeah. So this is the Tableau desktop which I've already opened. Yeah. So here if I go to help and then about Tableau. So currently I'm having this today only I downloaded this latest version. it is 2024.3.1. Okay. So uh now see what happens that suppose after 14 days if you are this Tableau desktop trial will get over. So what I'll suggest you that those who are not university professors or those who are not students you can first of all remove the current Tableau desktop from your system. Okay. Whatever you have installed you remove that portion. Yeah. Uh and then again what you do you go to Google and in Google you type here Tableau desktop. Tableau desktop older versions. Tableau desktop older versions. So if you type over here Tableau desktop older versions then here you can go to this area here. Yeah. See Tableau is a now a uh uh say part of Salesforce company. Okay, we'll talk about that part in the theory. But uh here it is showing you Salesforce. So here it says downloading previous versions of Tableau desktop. So suppose if I click this thing. So here it comes to downloading previous versions of Tableau desktop or server. I'll go to this area. Go to downloads and release note. I click on this portion downloads. Now see here these are all the see the current version is 2024.3.1. Okay. If you want I can also share this link in the chat window. Yeah, if you want to come over here you can you can click the link in the chat window. So the current version is 2024.3.1. Now suppose if this version you have already installed and now it is over the trial period is over then you remove this version from your system from from your laptop and then you come over here to this page you can save this page for a reference purpose and now see it is 2024.3 if I click this one so see in 2024.3 there are again two versions okay this is the latest version 3.1 1 and uh that was released in November 21 and before that this new version was also there another version was also there that is 2024.3 so what you can do you can now come to this area in on this page and you can click this this version here 2024.3 and then you install this version the older version the next the uh next older version you install it and then again use it for 14 Okay, I know that this is a tedious process, but this is how you can save your money. Okay, so otherwise if you're ready to pay $70 or €70, I don't mind. But this is what I I I normally recommend uh to the participant that you can go to the next older version. So now if you download this uh version and if you use it for 14 days, again you remove that version. Again, you come to this area and now you can go to 2024.2. two. Now see up till if you are going till uh let's say 2023 also this particular this version then you don't have any problem okay because normally we think that oh I if I'm going to the older version then definitely I'll be not having all the latest features but as such in Tableau this is my personal feeling that in Tableau they are not changing so much things in Tableau okay in PowerBI what happened that every version is having something new but in Tableau So the changes are not that much drastic. So even if you one by one if you go see for 2024.2 also if you click it there are so many versions. You can use this version for every version you can use it for 14 days. Okay. Likewise 2024.1 and so on. Okay. So this is how you can save your money and at least I would say that see just now you have to focus on this course. Okay. you try to have this Tableau desktop for this course. Okay. And then after the course is over, if you are in the organization and if you want to uh do something more with the Tableau, then definitely you can ask your organization and they will pay the money for you. Okay. But at least just now for this course you have to go like this. Okay. Those who are not having this now this is Tableau desktop. Okay. So in case of Tableau they also have one more version uh another tool which is known as Tableau public. So suppose if I write down here Tableau public download okay Tableau public download. Now what is this Tableau public here? Tableau public remember that it's a free version. Okay. And it is free for the lifetime. Just like Tableau uh just like PowerBI desktop here they are having Tableau public. So here you don't pay anything and here you don't have any problem of trial period. Okay. So this is also another tool especially for this training I would say for especially for this training you can go for Tableau public also. Okay. So I I'll tell you what is the limitation over here definitely because whatever is free it is yeah there is no free lunch in this world as we know so whatever is free it will not have all the features but I'll tell you yeah the exact difference over here but Tableau public also uh what I I would suggest you that just now you go for Tableau desktop you use it for 14 days after 14 days if you want to still use Tableau desktop I already shown you the method of going to the older versions if not then You can come to this Tableau public and here we are having this link Tableau test uh download Tableau public if I click it. Okay. So normally here I I I think so I'll I'll show you exact link because somewhere you are you'll be finding the link here the Tableau public uh Tableau public here. Let me see. Yes, this is the Tableau public. Tableau public is a free platform to explore, create and publicly share data visualizations online with the largest repository of blah blah blah. Uh yeah, Tableau public makes data skills this thing. Okay. So this is the button Tableau public may maybe you can also download this parallelly along with your Tableau desktop also because see sometimes if your Tableau desk if your Tableau desktop is over at least you are having the backup of Tableau public I would say. Yeah. So this also you download immediately. Yeah. Click on this link go to Tableau public and then definitely here also it will ask you to sign in. Yeah, here it says sign up for Tableau public. If I click it, then here I have to just I have to give here my first name, last name, email. Now see here email you can give uh your Gmail or Yahoo mail also. Okay, here they don't require a professional mail ID. So in the Tableau public you can if you want to create your account you can create your account with your Gmail ID or Yahoo mail ID or any other general mail. Okay. So give your last name, first name, email, password, concern password and it will create a account and then from there it will start downloading. Okay, maybe after you put all these details then it will show you download Tableau test download Tableau public. You click on that button and then it will download that Tableau public and then you install it. Okay. So two tools you have to install one by one today. Tableau desktop and Tableau public. Benefits of data visualization. Let us quickly see. So quick and clear understanding of the information. As I said, as I mentioned earlier that whenever you see a visualization, you are able to get the information very quickly and you are also able to remember that visualization. So quick and clear understanding of the information. Second benefit of data visualization is identify emerging trends and act quickly based on what we see. So this is a great benefit of data visualization. identifying emerging trends. Now see whenever I'm conducting the sessions uh let's say PowerBI sessions or Tableau sessions for the mostly for the US and Canadian participants. Yeah. On another platform. So there I always give the example uh in this second point I give the example of uh India. Okay, that we were I think so this also we discussed maybe in the business analytics portion also uh business analytics with Excel that after the COVID two major things happened in India. First one was the digital payment. Yeah. Everywhere people were just scanning the QR code or barcode and they were paying the money. Yeah. It was which was great. And up till now also the things are going on very well. And the second thing was this online sessions. Yeah. Especially for the universities because I was associated with many universities but I was not able to conduct the online sessions before the covid. Yeah. Because there was no trend. I was I I'm not saying that there was no technology. There was no trend of conducting the online sessions in the university especially. Yeah. for this kind of simply learn courses and this this we were having the things but for university there were no online courses uh online sessions so that also happened yeah thanks goes to covid and uh since 20 uh 20 yeah after this covid uh I'm regularly conducting the online sessions for the students also for the university students okay up till now so that is the major thing which has happened and for the digital payment okay I always give this digital payment example even to my German colleagues also that here in Germany also still people are believing in the hard cash. Many people though definitely many or many of the shops they are they are taking the uh credit cards and debit cards but uh still many people they are having the uh cash okay they believe in cash even just now we are having the Christmas uh market and all those things in Christmas market I don't know hardly I have seen one or two stores uh one or two yeah shops over here in the Christmas market with their uh okay where they are accepting uh uh credit cards or debit cards otherwise it's fully on the cash I don't know about other countries yeah whether the same thing is there but here mostly people are going for the cash so what happened that when that covid came so it brought many challenges yeah and those who accepted those challenges and they came out with some solution they are still there in the market yeah I I remember that I'm coming from uh city known as Vodra in Gujarat and uh uh earlier when I used to visit my city my state uh I used to go to some specific restaurants okay uh so uh yeah because they were famous for good food but when I went after covid many of those my good restaurants they were closed down they were completely shut down okay I don't know what was the reason but one of the reason was that what they came to know was that they did not accepted the new change. Yeah. Initially people they were not going to the restaurants. They were having everything online. Yeah. Everything was delivered. Uh but these restaurants they some of somehow they insisted that no no we should we have to uh bring here the people rather than the delivery. So those who did not accepted the change they were out of the market. And also it happened in my city that many of the new restaurants also got opened during the covid time and they are still there. Yeah. Because they accepted this new trend. Okay. So whatever this example which I'm giving here, this example also applies to us. Yeah. to our our own life that if whatever the new things which are coming in the data analytics or business analytics if we are not accepting those changes we'll be also out of the market yeah just like those restaurants so today we are talking about generative tomorrow we'll be talking about something else we have to continuously learn these new tools that is what is my thing okay and I and I'm also doing the same thing yeah so emerging trends we can quickly identify with the help of data visualization and we can implement it. Then the number three is identify the relationships and patterns. So we can see that okay if our sales have gone down then why the sales have gone down what are the reasons for that lower sales so that we can easily identify with the visualization. The fourth benefit over here is share our story with others. So share our story with others. Now what is this story here? Story means we are talking about the report or the dashboard. Yeah. Now you know that in every organization everybody will not be creating the dashboard. Everybody will not be creating the PowerBI report. Few people will be creating the report and the other people will be utilizing that report. Yeah. So here sharing our story means if I create my uh report then definitely I have to share with my colleagues. So I have to share my story with other people. So in case of Tableau also I'll be showing and in Tableau uh it is little bit different compared to PowerBI. Yeah. So that also we'll discuss that where this PowerBI and Tableau are different in terms of creating the report and creating the dashboard. Okay. So when that particular topic will come up I'll tell you these differences. Number fifth is analysis at various levels of details. analysis at various levels of details means suppose if I'm having if I'm working in a MNC company so definitely I'll be having the uh we were talking about this analysis at various levels of details so we start from US from US we go to the state from state we go to the city and and within the city also we are having the various areas so we are having the postal code or pin code so we go to that area level so this is what we mean by analysis at various levels of detail and in short it is known as hier hierarchy. Okay. So that is that hierarchy topic. And the last point over here the last benefit is improved customer experience and engagement. Now whatever we have uh seen up till now all the benefits why we are doing all those things why we are sharing our story why we are doing the analysis at various levels of detail because we want to give the best experience to our customer. We want to make them satisfied. We want or or we want to make them happy. Yeah. Because if the customers are happy, if the customers are engaged with our company, overall we are also happy. It's a win-win situation. So in general, these are the benefits of data visualization. No. Now I'll not talk about PowerBI just skip this thing. But what I wanted to show you here that this is the uh magic quadrant. I don't know whether you saw it in your PowerBI course. This is the magic quadrant for analytics and business intelligence platform. Now who has created this magic quadrant? The magic quadrant has been created by this company known as Gartner. Okay. So Gartner I think so you must have heard this company name. If not then I would like to uh inform you that this Gartner is a very famous research company. They are conducting lot of research over here. So they are every year they are creating their own report and then there are companies who are buying those reports. Okay, these reports are not free of cost. You have to pay for it. So here I want to highlight that what is the scenario of those various data visualization products that we are having in the market. So this is the scenario which was there in 2022. Yeah. So we'll see the scenario of 2022, 2023 and the latest scenario in 2024. So in 2022 you can see that the in this magic quadrant we are having these four quadrants. So we are having the leader section, challenger section, niche players and the visionaries. If you focus on the leader section, the leaders in this data visualization area here it is written Microsoft and then it is written here Salesforce bracket Tableau and the third leader is click. I'm sure that you must have heard this click company. Click is a very famous data visualization company in US but uh they are their products are used worldwide. So click is having two products. Initially they were having click view click view and the latest product is the clicksense. Yeah. So I have also learned that tool clicksense and click view though are not though I'm not using regularly here. Now here comes Microsoft. Now see I I initially told you that PowerBI is currently number one tool in the data visualization market. But now see here it is not written PowerBI. It is written here Microsoft. Why Microsoft? Why it is written Microsoft? Because definitely Microsoft is not having one tool that is PowerBI. But if I just talk about data visualization tool then the data visualization tool Microsoft is having two products. First one is Excel as we know very well and the second one is PowerBI. Okay. So Excel came almost like 30 years before or 30 35 years before. So and today also people are still using Excel for the data analysis for visualization purpose everything. So that's why here they have not specifically mentioned PowerBI but they have mentioned here Microsoft. Yeah. But overall I would say that I'll I'll repeat that sentence that PowerBI is visualization market. Then comes Tableau and then comes click and then these are the other tools. You see that I was talking about this tool micro strategy in 2022 it was in the niche player segment. Yeah. Then Google was here challenger section Google is having Google look studio. Initially Google changed the name to Google data studio but then last year sorry this year only they change it to Google looker studio. So I have also learned that tool. Yeah. So see that is the advantage that I that we also all all get there seeing that if you know one tool you can learn the other tools very easily. Yeah just remember that their look and feel effect is different and definitely some of the features which are available in PowerBI will not be available in Tableau or the features which are available in Tableau they will not be available in PowerBI. So you have to understand only those features which are not common. Now in 2023 what was the scenario? The scenario was same. Microsoft was number one. Salesforce tableau was number two and click was number three. Yeah. Here little bit you can see that this micro strategy which was in n player now it has shifted to challengers. It shifted to challengers here in 2023. Yeah. Maybe this Alibaba also Alibaba cloud it also came over here. So some changes occurred over here. Now let us focus on 2024 the current year. So in current year you see here the scenario leader section see so many leaders are now here Microsoft Tableau click is over here Google has come now here yeah now so now I know that some of the companies have shifted to Google local studio because it is also cheaper yeah the everything comes to the price initially then we are having here Oracle and thspot. Thoughtspot is also a great is a tool famous tool. So see now you can see that Tableau is facing lot of competition here. Definitely it is also uh this PowerB also facing competition but here all these tools are near by Tableau. Yeah. So whenever a company wants to decide which is the best tool or which is the second best tool then now company has to think over these other tools also. So that's why when I saw this this figure for the first time I was really astonished yeah because till 2023 and 2022 you see the 2022 2023 the scenario will almost same especially for the leader section but as soon as we went to 2024 the things change here and now I don't know what will happen in 2025 maybe some other one or two tools will come over here you never know so this is what I wanted to highlight here that uh how this data visualization market is uh is moving. So now we'll be focusing really on the topic of Tableau. Okay. So Tableau data visualization tool. Okay. And it is very popular among the users. Now what it says here Tableau allow us to evaluate raw data in the form of graphs and report. Yeah. So initially we create some some graph or some charts and then what we do then we put all those graphs and charts into one particular page and that page is known as dashboard. Just I would like to ask you one question here that you have all used PowerBI desktop. Okay. So I would like to ask you one question that whatever the visualizations you are creating in PowerBI desktop that whole file okay that whatever that PowerBI file that you are creating PowerBI desktop file which you which you're creating yeah that is that is having an extension of PBIX. So what is that PowerBI file known as? That's my question. Yeah that PowerBI file is having many pages. You must have created various pages. So what is the name given to that that whole concept of that file? Okay. What is that whole file known as? PowerBI. So it's known as report. Yeah. So that should be very clear. That whole PowerBI file which we create in the PowerBI desktop, it is known as PowerBI report. Why I'm stressing this point? Because many people they also mention it as a dashboard. that is not a dashboard. Okay. In PowerBI desktop you cannot create a dashboard and and normally the dashboard is of one page only. Dashboard will have only one page. While in the PowerBI file we are creating various pages. So that is known as a report. Okay. So you should be very clear over here. Yeah. Now I would like to ask you that where we can create dashboard in PowerBI. Suppose if I want to create a dashboard in PowerBI where should I create? Okay. So now the answer for this question is this that where I can create the PowerBI dashboard. PowerBI dashboard can be created only in PowerBI services. I repeat PowerBI dashboard can only be created in PowerBI services. It cannot be created in PowerBI desktop. In PowerBI desktop, we create only PowerBI report. Yeah, that's why I asked this question. I wanted to clear this confusion. Yeah, because many people they say, oh, see many people they feel that dashboard and report are same. No, in case of PowerBI, it is totally different. Yeah. So you must have uh yeah in your uh online session you must have been shown that how we can create a dashboard in the PowerBI services. Yeah I hope that you must have been shown this thing. Yeah how to create the dashboard in PowerBI services if I'm not wrong. Yeah that you should know the concept. Okay. So uh dashboards are always created in PowerBI services that PowerBI services as you know that it's an online platform okay where suppose if I want to uh share my uh report with my colleague then I have to uh publish that PowerBI report into the powerbased services and then from there powerbased services I can provide the access I can say that okay I want to give access to let's say Dsha okay so I'll write down the email id of Dsha or let's say Clifton or Henry or whoever yeah and then uh you'll be able to see my uh report in the thing and uh dashboard also I can create in the PowerBI services and uh what I do that from the PowerBI report I can take some few visualizations from the report and I can put it into the dashboard. Okay. So this is what is PowerBI. Okay. Now in case of Tableau in Tableau we don't have the concept of Tableau report we have the concept of in Tableau we'll be now uh mostly tomorrow onwards we'll try to see that in Tableau what happened that on one page I can create one visualization I repeat on Tableau in Tableau desktop or in Tableau public whichever you tool you use on one sheet yeah I tools I can create only one visualization while in case of PowerBI in on one page you can create many visualizations yeah so that is where the difference now is coming up here yeah so in case of Tableau I create 10 sheets 10 sheets means 10 visualizations let's say and then in the T tableau desktop or Tableau public I'm having a separate section which is known as Tableau dashboard so Tableau dashboard if I want to create I don't have to go to any other online platform I can do it in the Tableau desktop or Tableau public. So in the Tableau dashboard I bring all the visualizations okay and I I can put it into one place and that is what is meant by Tableau dashboard. Okay so here this difference comes up between the between the PowerB and Tableau. Yeah. So that is what so here in case of Tableau also we'll be creating these kind of a yeah here they have used the word report but it's not actually the report it's a Tableau dashboard where you can bring all the visualizations together data can be in the form of big data Hadoop SQL cloud based uh cloud data anything can be there okay and and all the data can be brought into Tableau that we'll see further in the practical part Tableau software does not require any technical or programming experience that I've already explained you earlier. Yeah, Tableau is user friendly. It is a great skill for data science applicable to any business. Fast and easy. Yeah, many of the things are getting repeated over here. I will skip this portion. Okay. Now what we'll do that before we go with this concept of data blending and other things now let me focus on the Tableau. Okay. So if you have already downloaded the Tableau and installed the Tableau please open either you can open Tableau desktop or Tableau public or both also it's fine. So see when you open when you double click the Tableau desktop you will get this kind of screen. Uh see this portion this portion here you'll not be able to see anything. Yeah because these are the files which are already created by me. Yeah. So that's why yeah you can see that see these are some of the uh files which I which are which are created by my students in one of the university Indian university. So when I opened it yeah I can I can also click this this file directly and I can open this uh this tableau here. So initially in your in your case you'll not be able to see anything here. Now on the left hand side here you are having this area which is known as connect. Okay. So in the case of connect area you are having here Tableau server. So see in many of the big organizations what they do that they also purchase Tableau server. Yeah. In case of Tableau they are having two products here. Tableau server and Tableau uh online. Yeah. So suppose if I want to share my visualizations or if I want to share my Tableau file with my colleagues then I'm having two options here. Either I can purchase the uh Tableau online. Okay. Or I can purchase the Tableau server. Now if I'm working in a smaller organization yeah in smaller organizations the number of users will be very less. Let's say there are 10 people or 50 people let's say. So in that case I will not be able to go for Tableau server because Tableau server is very very expensive. I don't know the exact price over here but Tableau servers are very very expensive. So it is only useful for very very large organization. Yeah. Those organizations which are having some little bit of doubt about the security of their data. Yeah. and all those things for them. If they go for Tableau server then it is fine. Yeah, they can pay the money also and plus they they are having uh large number of users. So Tableau server they can buy it and then they can put all their visualizations all their data set on the Tableau server. Yeah. So if I want to connect to Tableau server I can click on it and then it will show me here the I have to write down the server name. I have to click on connect and then I have to give my username and password and then I can connect to the Tableau server. I can bring the data from the Tableau server. I can connect with the Tableau desktop and then I can start my visualization process here. Okay. So that is what we mean by the Tableau server here. Then we are having this portion here which is known as a to a file. So in the file we are having options like Microsoft Excel. If you're having a data set, let's say our majority of our data set are in Excel. So we'll be mostly using this button here known as Microsoft Excel. So if I click on Microsoft Excel, yeah, I'm just clicking on Microsoft Excel here. And now I can go to any of this file. I can bring the data from any of this Excel file. I can connect over here. Yeah, we'll also see further. Not now. I'm not showing you everything here just now. But I can connect any Excel file to Tableau by clicking this button. Then we are having text file either you say text file or CSV file. This is that option that we have to click. Then we are having JSON file, Microsoft text as PDF file. If you are having the data in PDF also you can connect that PDF file to Tableau and you can bring the data over here. Then spatial file I think. So spatial file is related to some geographical file I think. So I'm not uh yeah because I'm not using that file so much but yeah it is related to the geographical data and uh then we are having the statistical file statistical file here this is very very important option see you must have heard about one tool one statistical tool which is known as SPSS I repeat SPSS yeah I have used that tool during my uh PhD work so SPSS stands for statistical package page for social science. Yeah, it's a tool from IBM and uh there you can do any kind of statistical analysis. Yeah, T test and F test and all those different kind of testing, hypothesis testing. Yeah, regression analysis and correlation and all those things. So it's a very famous tool especially I know that in India it's very very famous and similar to that SPSS there is another tool which is known as SAS yeah SAS or yeah it's known yeah it is always spelled as SAS only so SAS is more famous in other countries yeah in India I'm not sure whether it is still famous but yeah SPSS in most of the universities I know that they use SPSS so suppose if you have created an SPSS file Now see SPSS is great for the statistical analysis. But if you want to create visualizations then definitely you can use the Tableau. So you can create a statistical file from your SPSS. Okay. And then you can connect that statistical file to Tableau by clicking this button over here. Yeah. So and I think so in PowerBI up till now what I know that in PowerBI you are not having this option to connect the SPSS file to PowerBI but in Tableau they are having this option. Yeah. Then we are having here more. More means if you if you are having something else let's say you are having XML file. Suppose XML your data is in XML file. You can click on more and then you can connect to that particular file. Let's say XML file. Okay. you can connect over here. So these are the file options. Then come server options. So in the server we are having here Microsoft SQL server, MySQL, Oracle, Amazon Red Shift. These are the standard servers which we use. But apart from that we also have here more. Okay. So suppose if I click on more, you see here there are so many options here. These are installed connectors. So see there are lot of here Alibaba, Amazon, Athena, Azure. Yeah. Cloudera, datab bricks. Yeah. Drao, Dropbox. You see many many Google. So these are various options. If you click on this more here. Yeah. And also there are some additional connectors. Yeah. There are installed connectors are 71. Additional connectors are 38. These are very specific here. uh excess all denodo okay delta and many many more salesforce marketing cloud by tableau okay so there are many options here so when you click on more you get all these options here yeah so this is the Tableau desktop yeah these are the options which you get in Tableau desktop apart from that you also have here quick start okay what is this quick start here in the Quick start here it says jump start your analysis with pre-built template. So see in case of Excel also we have the templates. So if I want if I don't want to really create everything from scratch I I I I want to use some template then these templates are also available over here like Salesforce sales cloud okay budget controlling retail sales call center agent analytics you have to just connect your data with this file and then you can it will be done everything will be done. Okay. So if I click on view more. Yeah. I have clicked on this view more here. And now here these are the various analysis which are already created. Yeah. Financial performance dashboard. Yeah. Salesforce data bricks. Yeah. See there are so many options here. It's a very very long list here. So you can also use this statistic uh this uh templates here. Yeah. you can use these templates over here the ready uh the the built-in templates and you have to just connect the data and the visualizations are ready. So this will save a lot of your time. Yeah. Then there are these two sample workbooks. Okay. So just like in if you remember that in case of PowerBI also we have one uh one sample data set button in the PowerBI if you remember. So in case of Tableau also you are having these two data sets. One is known as supererstore data set and another one is known as world indicator and plus here below it will show you the latest Tableau version. Yeah, if if you uh let's say if you are opening this tableau after 2 months in next month you now you can download the version information. Okay. So there you normally we don't go to Tableau desktop. Yeah. We we open this because today only I opened this Tableau desktop uh this tool and I saw that a new version was there. So I implemented I downloaded that new version here. Okay. So this is overview of that Tableau desktop. Let us let me show you here Tableau public. So this is Tableau public. Yeah. Here it is already written Tableau public. See in Tableau desktop it will be written like this only Tableau book one. See in my case also I'm having currently the license version. So here it says Tableau license expires in 14 days because only I have installed and very soon I'll be also getting that free license for 1 year. So then I can uh yeah I can input that license code and I can get I can extend my license here. So this is when it is not written here any Tableau public then this is your Tableau desktop and now this is require this tool because actually public for this training course I'm talking about you can see in the Tableau public you don't have that option of the Tableau server so here in the Tableau public you are having all those options here see here we don't have that option of Tableau server you can see here there's no opt option of Tableau server while in case of Tableau desktop I'm having that option. So this is also one of the difference here. So these are the standard options here in the Tableau public XL text file, JSON file, Microsoft access, PDF, PL file, statistical file. Now see here if I'm having XML file, if I'm having the data in XML, I cannot connect over here with a Tableau public. I can connect only these seven files here. Yeah. then to a server in the server I'm having option of O data and more if I only drive connector that's also I mostly use the Google drive here if I want to over there but now you see that now this is the first comparison here in the Tableau this is my Tableau desktop if I click on more here in the server I see here how many 71 + 38 It's 109 connectation data system or server file but here in case of tableau I'm not option connecting to SQL server server or IP server here in the tableau in the Tableau public here what the point So what will what I was talking here that uh you have to we'll be connecting this file here sample superersto 2024.xls XLS you you already downloaded uh in one of the your folder. So we'll be connecting from the folder. Okay. We cannot connect from here. From there it's not possible. So in this Excel uh Tableau desktop file I'll be clicking on Microsoft Excel. Okay. I click on Microsoft Excel here. And now I have to go to that folder. Okay. So I go to that folder. Let me go to my D drive. Okay, simply learn tableau course data files and here I'm having you can I click on open yeah and now here you are having the another window you see here now it is a different window when we were clicking on the excel file Microsoft Excel that was another window connect window. Yeah. And now when we when we already connected that uh connected that uh sample superstore 2024 data set with this tableau now you are getting this window. So here on the top area you can see sample supertore 2024 the file name it is written below Microsoft Excel. Now in this file you are having this three sheets here. Okay there are three sheets. So we are having order sheet, people return sheet. Now let me show you the file also Excel file. In this data set uh make it okay. So in this data set we are having variously we having this three sheets over here. Order sheet, sheet, return sheet. So the three sheets over here, major sheets, the order sheet. Yeah. In most of our uh this practical part will be other two sheets also. But she Okay. So we are having call you can see it was what 184 okay so this is a number of record in data set and I have order ID order you can see it consist of a country that year this number okay so this whole thing is order here uh containing the Canada uh data this is US Canada data here so ID okay then we are having Four ship boards here. First, second chipboard are here. So we having the customer ID. Then we have the customer named both first and last. Then we have the statement here. We have United States region four regions, south and west. Okay. So four regions here. Then having a category is important. Okay. So here having the three categories. So category you count should be 1 2 3 4 5 6 7 8 9 10 17 here. First of all we are having so you'll see further in our visualization also we are having various subcategories. So under each category there are some subcategories and under each subcategory there are various products. Okay. So there are various product names. Here we are having product name column the last column. So this is the hierarchy of category then subcategory below sub below category we are having subcategory and below subcategory we are having the product. Okay. So this is what we are having here. Then finally after the product these are the various product names. Then fi uh at the end we have four numerical sales quantity discount and profit. Yeah. So these are the four numerical columns that we are having here sales, quantity, discount and profit. So that we also using. So these are all the columns which are available in your uh this uh orders table here or order sheet here. Now we go to the people make it bigger for you. People sheet. In the people sheet I'm having here managers, regional managers and the region. Okay. So there are four managers for four regions here. Okay. Now see here this column region column in the people's table people's table or people sheet the region column is there west east central south and the same column is also available in your orders table. I've already showed you the region column in the orders table here. Okay. So just remember that this is the common column between the two tables here between the people's table and the orders table there is a common column which is known as region column. Just remember this point. So this is people's table. Then comes the returns table. Returns table or return sheet. return sheet means in this returns table it is having the details about all those order ids which are returned by the customer because they are not happy with that product as we know that in case of Amazon there is a 30-day uh return uh return policy so here all these uh order ids okay all these orders which have been returned by the customer their details are over here so here there are only two columns in the returns table that is returned Yeah, everywhere it will be yes. Yes. Yes. Okay. So, uh these are the return uh or say return column and the order ID column. Now, see this order ID which is available in the returns table. The same order ID is also available in your orders table. Yeah, I already shown you this orders table. The order ID the second column here. So also remember the second point here that there is a common field between the orders table and the returns table and that common field is known as order ID. Yeah. So this is a common field and between the orders table and the people table we are having the common field which is known as region field. Okay. So this is what I wanted to I'll close here on the left hand side. Now I'm back in the section here. Yeah. So on the left hand side here uh you can see these uh three sheets here. Three sheets here. These are getting repeated here. Don't worry about that. But these are the three sheets here. Order sheet, people sheet, and return sheet. Yeah. Now what it says here in the area, it says tables here to create a So now I uh see that I'm having here three sheets. Now if I want to use here let's say order sheet here as a data set. I drag order sheet and I will here in the center. Now I all of you simply drag this order sheet with your mouse. Drag the order sheet and you drop it over here on this area. Okay. So drop this order sheet. Drag it and drop it over here. So see when you drop it over here in the middle area then you can see that now the order sheet is over here. Okay. And now here you can see the this is the table. Now see that table here this table what you see on the left hand side here this table this is this table is known as metadata. Again everything we have to done here we have this order area. Okay. And then these things will come up here. So this first table it is known as metadata. What is metadata? Metadata in simple words is data about. if I want to know how many are from which tableable over here type over here, these are the data types here in PowerBI also you must have gone through the data types like text data type, date data type, time data type, whole number, decimal number, fixed decimal number. Yeah. So whatever the data types you have learned in PowerBI almost the similar data types are also available here in the Tableau. So this type means the data type column. Okay. We'll also see further this thing. Yeah. ABC I think so in PowerB also you must have seen that ABC means the text data type. Here it is known as string data type. The name is different. In PowerBI it was known as uh text data type. Here it is known as string data type. This ABC. Yeah. While these are the icons of the date. Yeah, because order date and ship date these are date. So these are their icons. And when you see this hashtag here, hashtag means we are talking about the numbers. Now numbers can be both whole number and decimal number. Yeah. So this is this is the symbol or icon for the uh numerical field. Okay. Numerical field. It can be decimal or uh whole number. But the icon is same here. Then we are having the globe icon here. Globe icon means these are the geographical field. In case of PowerBI also we have the geographical field which is which are identified by Globe icon. Yeah. So, country, public region, city, state, public, province, postal code. These are all the geographical field and these are already identified very well by Tableau. We don't have to do anything here. Now at the bottom area you can see this our four numerical it is also a number. So it is having a blue hashtag. So see though it is a hashtag but it is identified it is shown in two different colors. One is blue another one is the green color. So what is this blue? Because indic look beautiful of this green. So that we'll see further. So we are able to see right the field name is the field ID order ID blah blah blah. Then we have the table. So what we have only one table or so. So here you will find also order orders. So if we also bring very soon this and here we also finding the table and getting weing this table over here. Then we so there's another column here. So see if you see now the y but same also we see enough. So this is the data. If you don't want to collapse this click on it here on the top. Okay. So this is now just here number 100. Okay. show initial 100 uh Let's say I don't know how many fields involve columns here 100 okay here so this set okay now transmission just let me crab crab. Okay. And I think so So here I was having all the together. So let's see. I don't think so. No, I think so in the states I all four files into one is known as a data union here. We also talk about the data union in your table desktop and then I did some further cleaning here. I also added the returns table. See here there's a separate returns table here. Okay. And this is how I'm doing this data cleaning in the Tableau prep. So this is a separate tool over. Okay. So this to show you sorry. Okay. See this is that uh cleaning which I've done here. So here you can do many things in the Tableau prep but if I'm coming back to this Tableau desktop here I show you some basic data cleaning which can be done over here in the Tableau desktop or Tableau public. So let's say uh I'm having this customer name over here. Okay, this is the customer name column. Now first of all if I click this ABC here ABC means text data type. If I click this ABC here I can see all the data types of uh tableau. So in the in the tableau data type we are having here decimal number whole number. Yeah just click this button any of this button. Okay. If I click this ABC button I can see here decimal number whole number date and time date string. Yeah, here it is identified string. String mean tech data type. Then sptl boolean. Booleans means true and false. Then it has identified as default. Then there are also some geographical fields here. Geographical role, image ro blah blah blah. Yeah. So here it is identified it as string data type that is a text data type. Now what I want to do here I want to create here two separate columns. I want to have one column of first name and one column of last name. I don't want to have a combined column here. So if I want to divide this one column into two columns or if I want to split this one column into two column that is possible here. What I have to do I have to click this I have to click this drop down here. Okay, click the drop-down. Here is a drop-own button in this customer name column. And then here when I click on the drop-down, I'm having here options like rename, copy values, hide, aliases, uh create calculated field, create group, split, custom split, and describe. Yeah. Now before I split, the column name is row ID. Now I want to change it to row number. Instead of row ID, I want to change it to row number. So what I'll do here just like Tableau uh PowerBI, we can double click on that field name or column name. So here also I can double click. I double click on the row ID. And now what I do instead of row ID, I write down here row number. So see I have double click on this title row ID and I have written here row number instead of row ID. Press enter. Press enter. And now here you can see it is now row number. I have changed the I have renamed it column. Now see here it is row number. And now you see the difference here. See field name the first field name is shown as row number. But you see the remote field name it is still row ID. So now you have got that concept that why this tableau has given you two columns here because sometime if I change this uh column name then I should be knowing that what what was the original column name. Yeah. What was the original column name? The original column name will always be shown in the remote field name column. Yeah, you cannot change this one. You can change this one but you cannot change this one. Yeah, see I can double click over here. I can double click on the field name also here and I can change the name but I think so here I cannot click. Yeah. Yeah. Here I cannot click on the remote field name. This will be permanent. Yeah. So that is the advantage that you get for the remote field name that you don't you lose your original column name. Tomorrow if you want to again go back to your original column name you can see okay uh it was row ID. So now you can again I can click on row number. I can again I can type here row ID. Row id press enter. And now you see it is row ID. Row id. Okay. So that is the advantage that you get here. Okay. So this was one demo here. Now let us come back to the customer name here in the customer name. I want to split this customer name into two parts. Customer first name and customer last name. So what we do? We click this drop-down. And in the drop-down, there are two options here. Split and custom split. So let us understand what is the difference between split and custom split. First of all, we'll go for split here. Split. Yeah. So click on the split button. After clicking on the drop-down in the customer name, click on the split button. When you click on the split button, what happens? Nothing happens. You see, you can see that oh Samo nothing has happened here. But now you go to the right hand side. Go on the extreme right of this table. Yeah, you can use this uh scroll bar. Go to the extreme right. And now here you'll be able to see these two columns Yeah. When you once you click on the split button in the customer name column then you go on the extreme right of this table and here you'll be able to see customer name split one and customer name split 2. Yeah, see these names are given by Tableau. We have not given any name. These names are given by Tableau. Now if I want to change the title here because see customer name split one customer name split 2 doesn't look good. What I can do I can double click over here double click on the title and I can write down here customer first name and I can remove the split one. I don't like split one. So see I have changed the name here. Change the title of the column customer first name. And similarly here I can double click and I can write down here customer last name and I can remove this split two. Press enter and see now my columns are ready. Yeah. In case of PowerBI also we have the split button. So I can divide the splitting. Uh in the split also we are having there seven options I think. So in case of PowerBI uh split by whole number and then split by uh characters and uh delimiters and all those things. Yeah, there are seven options which are there in PowerBI for the splitting the column. So here this is how we go for the normal split. Now see what this split has done that here the splitting has has been done when there is a space over here. Yeah. So here we are having this space between the two columns here. Sorry between the two names here. So it has done the splitting uh uh yeah when there is a space here. Okay. So that is how it has used this concept here. So this is the sorry these are the two separate columns and remember that the columns that you are creating here it will be always shown at the end. Okay. So this is customers first name, customer last name. Uh let me see uh maybe we can do it later on also. Now one important thing here you see that on the top area you can see this blue line here. Yeah, there is a continuous blue line. Okay. While here on these two columns there is no blue line on the top. Yeah, here there is a blue line. Here there is no blue line. So what does this blue line indicates? So blue line indicates that all these columns are coming from the original data set. They are coming from the original data set. That's why it is indicated by this top blue line. while these two columns have been created by us. Okay. So the columns which are created by us that is what you have also understood in this PowerBI the calculated uh column. Yeah. So these are your calculated columns. Yeah. Here definitely I have not done I have not put up any function here but still I have created this column on my own. That's why at any point of time if you are getting confused that which columns are created by me and which columns are coming from the original data set you can use this blue line here. Blue line means the columns are coming from the original data set. When there is no blue line it means that these columns are created by us. Whether it is created by splitting or whether it is created by calculated field or calculated column that's a separate thing. Okay. So that's why these are the two columns which are not having the blue line. So this is one splitting there's a normal split. Now another example custom split okay custom split. So suppose here if you come to this left hand side area if you click on this order ID. Now as I said earlier that order ID is consisting of three parts here. the country ID or country short form US or CA the year year and the last six digits here. Okay. So there are three parts over here. Now what I want to do that I want to create one column. Yeah. And I want to get only the initial two alphabets in that column. Okay. Okay, just now in this order id column I'm having all the three parts but I want to create one column where I want to see only the initial two digits US or CA. Okay. So if I want to extract only uh one portion of this uh whole series what I can do I can go to this order ID click the drop-down here and in the drop-down I go to this custom split here. Okay, I click on the custom split because if I go for split, let us also try what is the split. If I click here split here. Yeah. So split I have used. Now let me go to the right hand side here. So see in the right hand side what has happened here? It has now created here three columns for the order order ID. I have used the split option. So order ID is split one, order ID is split two and order ID is split three. So what it has done that wherever you are having the dash at that point the splitting has taken place. Yeah the splitting has taken place at the dash. Dash is your delimiter or space is also your delimiter. So it has done the splitting over here. But here we have got how many column? Three columns because there are two dash. Now suppose if I don't want to have all the three columns I want to have only one portion that is this US or CA. What I can do here? I can come to this order ID. I click on the drop-down and in the drop-down I click this custom split. Okay, I the custom split. In the custom when I click on the custom split, I'm having this dialog box. What it says? How should this data be split? Use the separator. So here I have to tell Tableau that what kind of separator I'm having here. So here we are having the separator that is dash. So in the use the separator I have to put here dash I have to type here dash. If you are having space you press space bar. If you are having comma you you press here comma. So use the separator I put here dash. Type here dash. Now here it says split off. In the split off if I click the drop-down split off first, last and all. Now what is this first last and all? So see here how many dash I'm having here there are two two dash here. So now I can also tell tableau that where the splitting should take place. Whether the splitting should take place at the first dash or first delimiter or the last delimiter or all delimiters. Yeah. The split off is talking about the where do you want to do the splitting at the first delimiter or last delimiter or all delimiters. So suppose if I go for first okay because I want to extract only this US and CA I I go for split off at first delimiter then it is asking me okay how many columns you require. Okay now see if I do the splitting here. Yeah, let's say if I do the splitting here, then I'll be having actually two columns. One column will contain the USCA and the other column will contain this another portion. Okay, one column will contain this USCA and the second column will contain this 2021-103800 0 because see here I have not done the splitting. I'm telling the tableau that please split do the splitting at the first delimiter. So split off first. Okay. And I I and I want to get only this first column here. Okay. Because I want to get only this US and CA. So I'll be saying here first one column. Okay. Split off first and one column. I click on okay button. And when I click on okay button. Now let me go to the la uh right hand side extreme right. And you see now if you go to the extreme right we are having only one column here. Because see these three columns I'll created by using the simple split option. But this column order ID split four. This I created only with the custom split. And I said that I want to see only one column. Yeah. If I would have said here two column then I would have seen here two columns. One column will contain USCA and the second column will contain 2021- something. Okay. But I said no no I want to go for only one column. So I can see only one column here. Yeah. So that is how you are using the custom split here. So you can tell Tableau that where do you want to have the splitting first uh delimiter or last delimiter or all delimiters and then finally how many columns you require whether you want to have one column or two column or three column. Yeah it all depends upon the column that we require. Okay. So I hope that this is clear. So here you can do this kind of simple data cleaning. You can uh rename the uh column names over here. You can do the splitting. Okay. Definitely you can also create here calculated field. Calculated field means calculated column. Okay. See here the names are different. In case of PowerB it is known as calculated column. While here in case of Tableau it is known as calculated field. Yeah. Just the names are different. But we'll be talking about this calculated field when the topic will come up. this group and beans also we'll be taking uh at the appropriate time. Yeah. Aliases means different names here. Suppose if I click on aliases. Yeah. Alias is let me do one thing. If I click here row ID and let me write down here row number. Row number. And now if I click on drop-down and if I click on aliases. Yeah, here there's no aliases here. Normally if see for aliases means I can I can give some name here. Let's say instead of this sheep mode in the ship mode I'm having the standard class but sometimes I people they also write down something else. Instead of standard class it will be uh standard type let's say. Okay. So if it is standard type instead of uh yeah that's a alias for standard class then I can see here that what kind of aliases are available here. Just now in this example there is no aliases. Aliases means different names. Okay. For the same thing what are the different names even but here there is no aliases. So it is currently blank. Yeah. So we can do the splitting. We can also hide the column here. Okay. So now uh first of all let us uh connect our sample supertore data set that we created that we had seen yesterday. So it's a excel file as we know. So we'll be clicking on Microsoft Excel and then I'll be selecting that file sample supertore 2024. Okay. Click on open. So in the customer name column as you know if you want to do the splitting we want to have first name and last name. So I can click on this drop-down over here in the customer name and I can click simply the split. Yeah, because I don't want to go for any custom split. I want to go for split only. So I click on split and once we click on split for the customer name now we can go on the right hand side and here we can see those two columns that we have created. Okay. And I also showed you that we can here do the renaming. Then yesterday I we we also discussed about this blue line. So blue line I said that if you are if any column is having a blue line on the top it means that that column is already coming from the original data set. Okay. While these two columns are not having that blue line on the top. So it means that these two columns are created by us. Okay. They are not coming from the uh original data source. uh suppose if I want to delete these two columns. Yeah. So I can click on this uh I can select by pressing the shift button. Sorry control button. So please press the control button and you can select these two columns if you have created otherwise you can see over here. So press the control button and select these two columns. And now I can click any one of this drop-down. And when I click on the drop-down, you can see that I'm having here rename option, copy values, hide and delete. Okay, specifically I'm having this option of delete. I will not click here just now delete. But suppose if I click this opt this column let's say profit column suppose. Okay, I select the profit column. I click on the drop-down. Now in the drop-down here in the profit column, I do not see the delete column, delete option here. Yeah, I go for any column here. Suppose if I go for product name, in the product name also if I click the drop-down, I do not see the delete option. I'm having only the hide option. Okay? And plus other options are also there. But there is only hide option. There is no delete option here. So what does it mean? It means that whichever the columns are coming from the original data set, those columns cannot be deleted here. Okay. They will stay permanently over here. Definitely you can hide the column. Yeah. Suppose if you don't want to see let's say this category column suppose. Okay. I don't want to see the category column. So I can simply I cannot delete it. I can click on the drop-down. I can click on hide. Okay, I click on hide. So see now my category column is now hidden. Okay, but I cannot permanently delete it. What I can do here? I can delete only these two columns which are created by us. So I'll select this customer name split one. I'll press the control button and then I'll select the second column. So two columns I have selected by pressing the control button and then I click on one of these drop-down and I can click on delete. Okay. So these two columns I can delete. I click on delete and you see that now those two columns are gone. Okay. Customer name split one and customer name split 2 they are gone. Okay. Now here I have already hidden the category column. Okay. Now if I want to uh bring that column back. Okay, I don't want to hide that column category column. I want to bring that column back. So what I do? I have to click on this gear icon here. Okay, let me start my marker here. So I can click on this gear icon and I click on the gear icon here. You see here it is written show aliases and show hidden fields. Okay. So suppose if I click on this drop if I click on this uh gear icon and if I click on the show hidden fields if I click it then I can see here that my category column is now hidden but it is I'm still able to see that category column here. You see? And now if I want to unhide this column category column I can click on the drop-down here and in the drop-down I'm having the option of unhide unhide. Okay. So I click the dropdown I click on unhide and now you see the category column is now not hidden. Yeah. Now it is available here. Okay. So remember this important point that the columns which are coming from the original data set original data source they cannot be permanently deleted from the tableau in the tableau they can be hidden if you don't require that field you can hide that field but you cannot delete anything and the same concept is also there in case of powerbi if you know this thing in powerbi also whichever columns are coming from the original data source I cannot delete it yeah I can hide those columns Okay. Uh but I cannot delete those columns. Okay. I can uh and the columns which are created by me, let's say in PowerBI also we are creating the calculated column. So those columns can be deleted by us. Yeah, that is fine. But I cannot delete the original columns. So this is the concept of hide and unhide. Yeah. anytime if you're having any issue let me know. Now uh one more thing here that I want to show you now see here we are having the orders table. We have brought the orders table over here. Now yesterday I showed you the other two uh tables also that is the people sheet and the return sheet or people's table and the returns table. Now what I want to do that I want to bring these two tables also over here in this area. Okay. Now, if you remember yesterday, I showed you that there is a common field between the orders table and the people's table. Do you remember the common field between the orders table and the people's table? Yeah. So, there was a region column which was common between the orders table and the people's table. And now the second question is coming over here that what was the common field between the returns table and the orders table. There was also one common field between the returns table and the orders table. So uh order id. Okay. So now what we want to do that we want to bring these two tables also over here. And uh definitely because there is a common field. So there will be some kind of a join over here. Okay. We'll be connecting one table with another table with the help of a join. So what I'll suggest you that if you want to create a join then uh if you put your pointer over here okay when you put your pointer on the orders table what it says here logical table equal to orders and then it says here doubleclick this logical table to see its physical table. Okay. So it is telling us to doubleclick this logical table to see its physical table. So remember that whenever you want to see the concept of join yeah between the two tables then you go for the physical table or you go to the physical layer. So what you have to do here in this orders table you have to double click just double click this orders table and when you double click the orders table now this you see that something has changed here. Yeah let me delete it again. Yeah, I'll I'll double click this orders table. And now it says here order is made of one table. Okay, now this is a physical table or physical layer. You can say something like that. Now orders is there. Okay, you double click on the orders table then it will show you like this. Now what I'll do, I will bring this people's table here. Okay, I'll bring the people's table here. And you see when you bring the people's table here first of all it says here drag table to union. Now I'll also today I'll also talk about this what is this union concept but I don't want to union. You bring this table over here the people table. Okay bring it on the right hand side of this orders table and then you drop it here. Okay drop it over here. When you drop over here, when you drop the people's table over here on the right hand side of this orders table, you see that now people's table is connected with the orders table like this. And this is your join. Okay. This is your join here. Yeah. So, orders table is connected with the people's table. Yeah. And this is a join. Now, if I click on this join. Yeah. Just click on this join. And when you click on the join, you can see that there are these four types of join. Inner join, left join, right join and full outer join. By default, it is showing you here inner join by default. Okay. So this is the inner join. Inner join means it is taking only the uh fields or rows. So it is taking only the records or rows which are common between both the tables. Now are you having the concept of uh or say do you know the concept of these joints because these joints also comes in uh PowerBI maybe uh you must have been taught the merging of the tables. Yeah, merging queries. So maybe during the merging queries these uh joints must have been discussed but just I want to check that whether you know this concept of these four kind of joints. Inner joint, left joint, right joint, full outer joint. Yeah, if you already know the concept then I I will not repeat that thing. But uh if you want I can also discuss this four kind of joints. Yeah, because this concept must have been taught in slide concept. Please discuss. Okay, no problem. So then let me go to this presentation here of simply learn. So you will also find this presentation with you. So let me yeah here in this presentation it is showing the same thing what I've discussed. Okay, you see here that in the orders table and the returns table, we have created this join and by default it is showing you this inner join and what is the common field here between the returns table and the orders table that is the order ID. Yeah, here it they have taken first of all the returns table. We took just now people's table but the concept is same. Yeah. So the uh this join has been created between the orders table and the returns table. And these are those four joins that we have also seen in our uh tableau. And the common field here is order ID, order ID. Now let us understand these uh joints here. Okay. So here they have given an example where there are two tables here. One is known as your left hand side table which is having the product sales. So there is a product ID, sales, number of records. Okay. And there is another table which is known as right hand side table which is having the product profit. So here also you are having product ID, profit and number of records. Okay. here which is the common field between the two tables that is the product ID. Okay. Product ID is the common field here. Otherwise if you see the sales yeah uh definitely the number of records we cannot keep it over here common field because this product ID product ID is a common field here. Now let us understand what is this left join. Okay. So what is left join that in the left join it will take all the values of the left hand side table or it will take all the records. I I would be very specific here that it will take all the records of the left hand side table and from the right hand side table it will take only those records which are common with the left hand side table. So let me show you the uh the diagram here. See this is the left hand side left join here in the left join you can see that the left hand side circle is full. Yeah. So when it is full it means that it is taking all the record of the left hand side table. And if you see the right hand side table or right hand side circle it is taking only the the records which are common between the two tables. So here in this presentation if I go for the left hand side if if I go for the left join then it will take all these records of the left hand side table. Yeah. And from the right hand side table it will take only those records which are common between the two tables. So which are the common product ID? You see here 6 7 8 9 10. Here also we have 6 7 8 9 10. So from the right hand table on it will only take these five records. But from the left hand side table it will take all these records whether they are matching or not matching it doesn't matter. So this is known as left join because we are taking all the record from the left hand side. Huh? Then comes right join. Right join is just opposite to left join. In the right hand side join it is taking all the record from the right hand side table and from…

Transcript truncated. Watch the full video for the complete content.