Transcription
Now, I am T. I'm working as a junior data analyst, training intent in need data, and this is my next task. So, it's an Amazon sales analysis. Okay, so for this, we are just going to use Tableau for visualizations, and I have a lot of CSV files to import.
To import the CSV file, just go to the text file in this tab on the left side. So, just click this "Text File" and I have this much files. So, just click any one and click "Open." So, it will give you this data set. Okay, so in this, we want to match all these columns regarding primary key or secondary key. Using those things, so we can see how we want to do this things. Okay, so, so we can start from this. Just remove these categories, I don't want them now. So, my basic is orders. So, basically for Amazon, the main thing is orders, right? So, we are just going to use this orders as the main thing, and this order and the order details.csv. So, these two are linked. So, how they can link this? Uh, the relationship has been made through this order ID. Both, both, sorry, not column, both tables have a column "Order ID." So, those two have been saved. And this order details and products, you want to check all those things. I already checked, so I'm just doing like this things. So, order details and product.csv, I'm just going to link, but there is no relationship. They are saying there is no relationship. So, now you want to check what, how to, uh, see this details. Just click this three dots. You can get this discount, order ID, product ID, quantity, unit price in this order details. And as for products, product name, quantity, category ID, and this. So, it also has a product ID. So, I think we can also join this both product IDs, right? So, just click, uh, select a field and click this product ID, and also in this products, so just click product ID. The relationship now has been made. Okay, so for the next, from products, in this product column, we already saw there is a supplier ID and a category ID. So, also you can just drag the supplier. So, this, this will be created. And also we saw that category ID, right? So, just link this with products. So, these two have been made, and the order details has been finished. So, now we want to use this employees. So, this orders, uh, wants to be delivered through this employees. So, let's check whether there's any things. Yeah, so there is employee ID is same in both the columns, sorry, both the tables. So, it has been created with the relationship. You want to see for all those tables and you want to select. It's not like randomly we are choosing it. It is a step. We want to choose like those things. Okay, so, and this employees.csv and employee. So, it wants to be same, right? So, I'm just giving this things, and yeah, those things have been finished. So, you can able to see how you can. The next thing, employee ID, we have finished. So, next, you can fill with territories like. So, just click this territory and drag those things. So, those things have been created as a, what's this thing, uh, relationship. Next, in this territory.csv, you can able to see this region ID. So, you can select the regions.csv also, just drag those things. So, it has been finished. So, we have completed this things. And in the, so now we are just, are not completed this customer.csv and, uh, shippers, right? And shippers.csv. So, just try to link those with, um, orders. Not.csv, it has been linked. And also the shippers. Yeah, okay. So, now it doesn't fit. So, you can see in the "Select a field," just try to see what are the columns are same. Company name. Yeah, in this company name and the other column is similar. Okay, like, um, I think she, no, um, where is the thing? .csv. And in this, you can see the ship City, ship Country, ship Name. Okay, I think the ship Name by using the ship name, you can, uh, use this. So, just, uh, create a relationship between ship name and the company name. Okay, so now the relationship has been created. Yeah, so we have created all this relationship. So, we also used all this data set. It's not a data table, okay? So, we have created all this table and we created a full database. Okay, so these are the things we have now. And to go to this worksheet, just click this worksheet in the Sheet one. So, it takes some time. Okay, so, yeah, we have reached this worksheet. This is our, uh, basic worksheet we have. Okay, so in this, we can use like whatever you want. So, first, I'm just going to use this categories. Okay, so like how, yeah, we can use. Okay, we come from first. This is the first. So, I'm just going to use this category name, okay? And this quantity. Like, we can use this quantity. Where the quantity? Okay, so here it is a quantity. Just drag and drop here. So, we can able to see it is in a small size. So, just go to this standard and click and go for entire view. But this is in a zigzag format. You can't able to see anything, right? So, just go and click this button, sort, and descending by sum of quantity. So, now you can able to see beverages is the top, and daily products is second, confections is third, seafood is fourth. So, it is going on like this. Okay, so, and we have completed this step. But you also can see it is in the same color. It's not too good, right? So, first, I don't want this. So, I just remove this, uh, title. Okay, and you can hide title. Yeah, so now you can't able to see this title. And I'm just going to use a color, and we can use this category, each category, a color. Okay, so I'm just going to use this category color. So, it is better than before. And the worksheet is in black color. I want a colorful. So, I'm just going for this format. Just click a right click, you can see a format, and you can go to this color icon, and I'm just going to color this sheet with, let's go for black or light colors like pink. We already have pink. Okay, we go for black. Okay, so we are just going for black colors. Black, in the sense, you can't able to see this. So, just go for ash colors. Okay, and in this title, I'm just going for, uh, in the sense, yeah, okay. This all the thing using the bar. I'm just going for black colors for columns and also for rows. Okay, so you can able to see a better thing. So, these are the things you can format all those things. Okay, by using, you can also change the size for the big ones. Okay, and also you can use it. And also you can change the colors. You can do a lot of things here. And this is our first sheet. Okay, so let's go for the next sheet by clicking the new worksheet. So, we have reached the second one. So, in this case, you can do like how our ordered quantity is differ from dates. Okay, so we are just going for how the date is dependent on the order quantity. So, I'm just going to use date in this date. So, it may be order details. This top order date. Date is missing, I think. So, just do it and search here. Order. Yeah, it is in the order stage. Just click and drag and drop here. But it is in the year format, right? 1996, 97, 98. So, I want to change it to a day format. So, just go to this arrow and just click this day. So, you can able to see the date format. Okay, so in this case, I want to see how it is, uh, ordered or quantity based. Okay, so for that, I'm just going for the same quantity. And I'm just going for, okay, instead of drag and drop, just click this. And you can also see a line chart like this things. These are, this all the enabled things, right? So, this line chart, you can use this area chart, you can use. Treemap, bar chart, pie chart, you can use. I'm just going to use this area map, sorry, it's a line chart. So, just click this thing. So, you can able to see this line chart. Both are same, maximum. Okay, but this, uh, the up and above this day of order date is below here. Order date is above there. That's the difference. I'm going for this thing. Okay, in this, I'm going to hide this sheet title. So, it is in this format. So, in this case, you can color it like how you want to color this things. In this case, I'm just going to color this with some discounts based. So, how it is discount displayed there, based thing. So, it is in gray now. What is color blue? So, I'm going to change this color like, just click this edit color. And the panel will appear. Just click as you want. I'm going for red, black, diverging. And, yeah, click apply. So, now you can see this things. But the white background is not nice. So, I'm just going to click this right and format. And in the worksheet, I'm just going to clean this black color. So, where's the color works? Okay, it is in sheets. Just click this. And I'm going for black color. The black color is not. I think we use this ash color. It, yeah, but the color chart is not nice. So, I'm just going to change this color. Instead of black, I'm going to use all in blue diverging. Just click this. So, I think the white background is say nice. Okay, so it is nice. Okay, in this case, I'm just using this path to see better in. It's not so, yeah, okay. This all the things already have. Okay, okay, we can do anything. Yeah, that's enough for this sheet. Okay, so we can create the next worksheet. And this is the next. You can create here like, um, what we can do? Okay, we can use any, um, what's that maps? Okay, so how you can use this maps? Just, um, this, uh, ID like, just go for here and see countries. Okay, countries or cities. We will go with the city. Just click this and go for this "Show Me." You can able to see this two maps. These two are enabled. You can use this or also you can use this. It's according to you. Okay, just a minute. It's loading. I think it came. Okay, before, I think this, just click the 7 and like filtered it. Okay, so the city is fully wasted. Just go for country and I'm just removing this things. Okay, just go for this country and now just see how it disappears. Okay, for country, it has been created well. Okay, so for country, you can see this things. Just, um, hiding this things. Yeah, we have obtained all these things. In this, I'm just going to see how the category has been, oh yes, okay, how this category has been upload, um, filed with this. So, I'm just going to click this category and just drag it in the color, drop it in the color. So, each category will be in this color. So, but you can't able to see any different colors. So, what is it means? So, the beverages, beverages, beverages. So, you can't able to say other than that, there is nothing. So, we want to create a filter and just give this category name and drop it in this filter. So, just click "Select All" and click and apply and okay. So, you can create, see a filter in the filter tab. Just click this arrow mark and "Show Filter." You will see a filters here. And there is an arrow mark in this right side of thing. And just click this and go for "Single Value Dropdown." So, you can able to see for all these things. So, you can use this condiments, daily products, and I'm just going to select all for now. Okay, so this the thing in this chart. And also we can go for the next sheet. So, at the next sheet, you can use what is the day ordered and what is the day shipped? Okay, so you can go for the ordered shipped date and the ordered date. Ordered edit. I'm just going to put this in order edit and the shipped edit. So, just drag and drop here. It has been added here. Okay, so as SMS, just click for this and click for day as SMS for shipped it. So, you can't able to see anything here. Just go for this automatic arrow mark and just go for any circle or square. Sorry, I think I have been clicked. I'll go for square or go for any different shapes or you can use this Gant bar. But the circle is look nice. Okay, so in this case, you can't able to see anything. I'm just going to add the product. Um, everything is in block. So, I'm just going to use this product name. How the product is differ dependent on the shipping and, what's this, uh, shipping and order date? Okay, so these are the things we have. I'm going to use this entire view. It is so we can't able to see anything. They offered date one, they offered that. Just to make, sorry. And they afforded date one, they afforded date one, they of it is three more go. GI1 is the product. You can ask why it is differ for the same products or the same details. So, you can able to see for the shipping region because the region of shipping is different. So, I'm just going to add the shipping region in the detail. Okay, so just give it this in detail or, yeah, so you can now Nona Alice is a product name and shipping region is AK. And also for this float IM M standa, these are the things we have. So, you can able to see this Tai is 17. I think we can see it in the, uh, standard mode itself. So, we can able to see a long allice M Jack, New England, I. So, these are the products we have. Okay, so we can't able to see everything in this single tip. So, I'm also going to use this product name in the filter. So, just go for this filter. I think I already added these things. Just go for this "Show Filter." Everything will appear here. And click this arrow mark and go for "Multiple Values." I'm going to use here multiple values. Okay, just click "Multiple Value Dropdown." Now you can select. I'm going to deselect all and I'm just going to see for what are the things we have. I'm going to select randomly a four or five things. So, you can able to see how it has been shipped or how it has been used. So, see here, you can able to see this things. Okay, so these are the things we are just going to see. But the white background is not nice. So, I'm just going to use side and go for format. And in the color tab, I'm just going to change this colors into black. Black is not okay. This sandle s is not also. Yeah, so I'm just going to use different colors for all these charts. Okay, so so this all the things we have in this thing. So, in this case, I'm just going to use for entire. Okay, so and I'll also just going to reduce this for high the title. Yeah, so we finished all those sheets. Now you can also use like this prod. So, the next thing is, you just want to create a dashboard. Before this dashboard, this product name is for only this sheet. Filter this category name filter is only for this sheet. These two sheets doesn't have any filter. So, I'm just going to use this category name filter for all those things. Like how means, just go for this arrow mark and click this "Apply to Worksheet." For all this, all using related, all using this data source. Okay, so and also same as for Sheet 4, I'm going for this arrow mark and apply to worksheet, all using this data source. Okay, so now I have got all this, the filters in all four sheets. And like how means, if I change anything here, it will react to all those sheets. If I changed any here, only for condiments, it will be changed like this. And for all these things, it will be changed. That's the single thing happens here. Okay, so just click this all. And now I'm, we are just going to create a dashboard. So, to create a dashboard, just go for this new dashboard. And this is a small size. So, just go for this size. And instead of range, go for automatic. And, yeah, so now just drag and drop here all the sheets. Okay, so the first sheet has been arranged. Right, so the second sheet, you can just drag and drop, third sheet, and the four. So, now the filter, sorry, uh, the filter has been take a place. Just go for this and click floating. Okay, me, before those things, click only one filter. I'm going to click category filter and click an arrow mark and now click floating. So, this, this category name will be float. You can place anywhere as you want. I'm going to place here. Okay, yeah, I'm just hiding the sheet name also. And also as SMS for product name, go for this and click floating. And I'm placing it here. And now this space is empty. So, just click and X mark. So, now just place this. Okay, so now you can able to see an entire sheet. So, just click this, uh, presentation mode. So, you can able to see everything in this sheet. And like now you can able to see how it is working. From before this, we can use this category name like confections, how it is working for meat and poultry, how it is working for produce, how it is working, or beverages, how it is working. And now I'm just going to select all. And for product name, instead of all these things, I'm going to use Alice M CHF Fant pH mix Jan sh and other things. So, for this, uh, products, how it has been changed. So, you can able to see everything in the. So, I'm just selecting all and exit. Okay, for exit, you can select an escape button. Yeah, so that's, so that's it. I think we have been finished. And at last, if you want to create a story board, right? So, to create a story, just go for this new story. And click a story. And this as same as you want to change the size. Go for size. And instead of fixer, go for automatic. Okay, so I don't want this title. I am just removing this thing. Okay, so now you just want to drag and drop as for work in this dashboard. You create, uh, fixed everything in a single sheet. But in the story board, you want to create another page for each sheet. So, just click in blank page and add another thing. Just click blank and add another thing. As same as for four, just click blank and add another sheet. You, if you want, you can also add this dashboard also. Okay, so I don't want to add any caption. If you want to add any caption, you can use this. If you don't want, just go for this layout. And I'm using this arrow or only arrows. Okay, I'm just going for this dots. So, yeah, this is our story board. Okay, so I'm going for this first one. And also you can see this in the presentation mode. So, this is, these are the things we have. Okay, so, yeah, I think we have been completed fully. Okay, so, yeah, thank you.