Guys, those who find brand names missing. Copy and paste the brand name column from the description Excel file and paste it into your table. Also don't forget to change the data source and refresh the Pivot table to update the change. thank you!!
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
00:03 Creating a comprehensive sales dashboard for the executive team using SQL, Excel, and Tableau. 02:58 Creating comprehensive dashboards for sales activities and trends analysis. 11:24 Joining tables to gather comprehensive data 18:43 Data cleaning in SQL for analysis 24:26 Creating pivot tables and charts using SQL data 26:56 Creating separate pivot tables and charts from data 33:25 Creating map and pie charts for revenue breakdown 37:48 Creating various charts and formatting cells. 51:34 Using slicers in Tableau to filter data for gaining insights. 54:58 Interactivity through slicers enhances dashboard usability 1:00:38 Creating interactive dashboards in Excel and Tableau 1:03:46 Creating different chart types for revenue analysis 1:09:57 Customizing and organizing revenue data visuals. 1:13:17 Parametric filter control for customer display 1:18:30 Customizing dashboard elements 1:21:03 Structuring the dashboard layout 1:32:00 Dynamic filtering and dashboard interaction 1:35:04 Updating title text based on selected states Crafted by Merlin AI.
I have added the practice dataset in the description. If you're using SQL server, follow these steps to load it: 1. Open Microsoft SQL server, create a new database and name it BikeStores 2. Select the new database in the SQL server 3. Open the zip downloaded from the link I provided in the description 4. Open the 'create objects' query file and then execute it when it propagates in the the SQL server 5. Open the 'load data' query file and then execute it when it propagates in the SQL server
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
00:00 Create a comprehensive sales dashboard for a bicycle retail company using SQL, Excel, and Tableau 10:26 Data analysis process completed successfully 23:35 Creating pivot tables and charts for total revenues per year and per month 31:26 Generate five charts for revenue analysis 49:28 Dashboard made interactive using Excel feature called slicers 59:07 Generated interactive dashboard with charts for total revenues, revenues per month, revenues per state, revenues per store brand and top 10 customers. 1:08:16 Revenue breakdown by brand and product category 1:16:27 Created a dashboard with key metrics and charts 1:27:55 Dashboard made interactive with filters 1:37:50 Completed dashboard for bike store Crafted by Merlin AI.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@AinekenWalker Thanks for suggestion bro. But, I know SQL and did 15+ projects, the only problem is that this dataset is not working, the same with most of the people commenting. If you can, help me. It would be great. 🙏😊
@@p.chandra2444 Stop uploading the "drop objects" folder. When you download the file, load SQL Server Management Studio. Go back to your downloads folder and double click on ONLY "-create objects" and "load data" which should download as the 1st file and the 3rd file on the folder. If you don't see this then expand the "Name" column like you would in Excel when expanding the width of a column to make the field fit in a cell. I hope this helps sweetie 🥰
Thanks for presenting this demonstration. I really enjoyed the way the created the SQL code step by step, rather than trying to build the entire query in one shot from top to bottom.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Nice tutorial you have got here. I would suggest creating a view is sql and instead make the connection via the view rather than copy and pasting the sql query like you did.
Well done. This is a great 👍 tutorial on data analytics. Being a newbie in the field, I wish you have used the power query on the ETL step to leverage its power on the cleaning step rather a visual checking! The concatenation of columns could have been performed on the Excel Power Query just before loading (Transformation)! Keep it up!
Yes, I considered that, but I really wanted to make this tutorial as short as possible. I gotta say, I failed on that front, lol. I will use those features for future tutorials. Thanks for the suggestion.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
53:55 what if the slicer pivot table checkboxes doesnt show every pivot table? i am specifically missing the revenue per store and revenue per brand pivot tables from the checkboxes
Instead of creating new pivot tables after the two seperate ones, first copy paste the pivot table you want to make connections between them and then change the columns.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
I have a problem or rather a confusion in the loading SQL file you have give us,in the creation of sales.staff we are having a self referencing forgein key which is based on an auto incremented primary key so won't we have the same value for primary and forgein key?If so is this a violation of primary key constraint? Perhaps I have not captured enough info , kindly excuse me if I have not analysed the code neatly.
Just to keep things simple. It's about understanding the concept more than anything. But you're right, the discount should have been included to get the proper revenue amount.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Nice Video . but i noticed you added another column "brand name" after you imported the dataset to excel which wasnt added to the initial query. Took me about !0 mins to figure out All in all , awesome video man
@Dataset Guru Hlo sir i am facing issue during insert values commands in load file . i am using mysql so to insert multiple records i have to remove the insert into for all the remaining records other than first record for each table inserting. otherwise i have to execute each and everyline at a single time which takes so much time. do u have any other ways to insert multiple records in mysql sir using the commands which u gave in load file sql filescript.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Hello! Thank you so much for such a thorough tutorial. At around 11:00 you grouped by and used agg function to get quantity and revenue. Why couldn't we just get quantity and revenue without agg function and group by. Wouldn't it give the same results as each order_id already has the quantity and revenue is simply just quantity*price. Why did we use an aggregate function there ?
@@WorkTheData can you kindly check the link for the dataset posted in the description. The site isnt opening. Kindly provide an alternate link so we ca practice alongside. Thanks
Hi, Great video and thank you for helping me with my project but I had a doubt- you did not add brand name column while writing the SQL query but it is shown in excel after importing.
After the first two pivot table, all other tables are connected to the second pivot table. Therefore, the slicers of the first one cannot be applied to others. To fix this, instead of creating new pivot tables after the two seperate ones, you may first copy paste the pivot table you want to make connections between them and then change the columns.
Very good tutorial but sadly like half of the people in the comments i cannot get the data set to work. I was able to lead the "create objects file" and i executed each query to get the tables into the "BikeStore" database. The tables are empty though. I tired executing the "load data" queries which were really long and it didn't not work induvially or together. It is important to remember that we are Level 1 beginners so most of us are only use to getting data sets from Excel sheets. you started the tutorial with dataset but we cant follow along because WE DONT KNOW HOW TO LOAD THE DATA SET.
Hey Mark. Before running the queries, do well to create a database named (BikeStores) and run all querries in that database. That way, you will have no error.
Create a New Database and call it "BikeStores" make sure when you run the queries you run them on the that database and not the master database, otherwise you won't see your data. Then you'll have to delete each table in the master database like I had to. The "master" database is the default database the the query goes to. It's to the left of the green Execute button
Hi all! I noticed that in the "order_items" table there is a discount column. Wouldn't it be correct to count the revenue, including the discount column?
at 1:07:55 you dropped in "Brand Name" into the Columns pane...But that was never a field that we grabbed in SQL. People following along are not going to have that field available in Tableau. Edit: You also clearly created aliases for your measure names at about 1:15 that you never showed the viewer how to do.
did you get it? using excel I'm able to import the data but it is showing only in one table. unlike the video where product categories, brands are seperate tables...
I am confused and can anyone help me ? When I tried to open the downloaded sample dataset using Mysql WORKBench, I couldn't generate the database like as the beginning of the video with the list of tables. Or am can I create that database by download the sample dataset link that you provided, and then run on SQL Workbench ?
Great video, thank you so much for your effort. But I have a question for the SQL section, when you use SUM() functions for total_unit and revenue and then GROUP BY(). What if in case I don't use these 2 functions, the result will be the same. This is because the quantity in the order_items table refers to the sum quantity of each item in each order, so I think SUM() and GROUP BY() are not necessary.
I am sure this is useful for beginners and students. Appreciate you doing this for them. But this is very very basic, real life scenarios are much more intricate (sql-wise) and require a better, more beautiful/professional front end (dashboard)
thanks for all the work, while making the chart for Brand/revenue i found out that i didn't actually extract the brand from the database although i could see in the sheet in the description that tha brand is there so probanbly i did a mistake there. Quick question here: so i adjusted the code and imported in to a new sheet name Query2 in the same way we did the Query1 sheet to be able to complete the work. my question here is, is there a way to update the same exact sheet in case i change the code in the original SQL query?
I use MacOS, so I work with Mysql Workbench, have some error when I execute the file Create objects. Details: CREATE TABLE production.categories ( category_id INT IDENTITY (1, 1) PRIMARY KEY, category_name VARCHAR (255) NOT NULL have some error that: 'IDENTITY' is not valid at this position, expecting ')' what can I do ? Please help, I am a beginner. Thank U so much
Thank you very much for this video. Please I imported the dataset in Microsoft SQL Server as you did, but all the tables are empty. What can I do please ?
Hello, I really like the video You have made, thank you! But I got a problem to get the dataset. Seems like the query you gave didn't work out. Can you help me out how to get the exact same date for practice to do the same like you? Thank you in advance
Please help! When I tried to upload the data in SQL , the first thing on the top is CREATE SCHEMA production; go CREATE SCHEMA sales; go I am getting error as syntax error at or near "go". However, i have not done anything fromfrom my end. i just selected the file from the folder, the link which you have provided in description. Cold you please help me fix the issue. I am keen to follow along with the tutorial . Please help !!
This is an interesting tutorial. I really like the step by step explanation and the context. Could you please conduct another one with s different scenario using MS SQL, Excel and PowerBI? 🙂🙂🙂
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 Did any of you ever figure out how to connect the dataset to the database? Everytime i try the error "The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)" pops up even after downloading the ACE OLEDB 2016 64-bit version.
Guys, those who find brand names missing. Copy and paste the brand name column from the description Excel file and paste it into your table. Also don't forget to change the data source and refresh the Pivot table to update the change. thank you!!
Came here because of this issue and immediately saw your solution. Thanks for sharing
Pls make more videos like this. Learning by projects is very easy and interesting rather than watching tutorials.
Brazilian sub here. While practive my english i study data science. Best way to improve 2 diferents things! 😃
Thank you very much. it was very helpful. One note: we need to press ALT+D+P at 26:57 instead of Cntrl+D+P
Thank you for the correction
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 use microsoft sql server and just copy paste the 3 files he has given and then write query , ua re good to go
ua-cam.com/video/7naKzj2iJZo/v-deo.html
.................. this video will work for that.
@@shamiliqbal3200 I tried 2/3 weeks ago and looked for help. The data is not available.
This workflow is what I'm looking for insight as beginner data analyst student. Thanks!
ua-cam.com/video/AOPOVnmer_Q/v-deo.html
Do they have tertiary school in that solely teaches a course in Data Analytics?
Where are you studying yours?
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
00:03 Creating a comprehensive sales dashboard for the executive team using SQL, Excel, and Tableau.
02:58 Creating comprehensive dashboards for sales activities and trends analysis.
11:24 Joining tables to gather comprehensive data
18:43 Data cleaning in SQL for analysis
24:26 Creating pivot tables and charts using SQL data
26:56 Creating separate pivot tables and charts from data
33:25 Creating map and pie charts for revenue breakdown
37:48 Creating various charts and formatting cells.
51:34 Using slicers in Tableau to filter data for gaining insights.
54:58 Interactivity through slicers enhances dashboard usability
1:00:38 Creating interactive dashboards in Excel and Tableau
1:03:46 Creating different chart types for revenue analysis
1:09:57 Customizing and organizing revenue data visuals.
1:13:17 Parametric filter control for customer display
1:18:30 Customizing dashboard elements
1:21:03 Structuring the dashboard layout
1:32:00 Dynamic filtering and dashboard interaction
1:35:04 Updating title text based on selected states
Crafted by Merlin AI.
This is one of the best tutorials I have seen so far, well detailed and organised. I was able to flow with it from the beginning till the end.
I have added the practice dataset in the description. If you're using SQL server, follow these steps to load it:
1. Open Microsoft SQL server, create a new database and name it BikeStores
2. Select the new database in the SQL server
3. Open the zip downloaded from the link I provided in the description
4. Open the 'create objects' query file and then execute it when it propagates in the the SQL server
5. Open the 'load data' query file and then execute it when it propagates in the SQL server
Thank you ... Please make more..This is the best..
thank you sir
please could you upload the excel data set please?
CAN YOU PROVIDE THE SQL QUERY WITH BRAND FIELD UPDATED? PLZ
Simply one of the best tutorials I have seen on UA-cam and believe me, I have seen a lot of them!
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 did u done this project?
00:00 Create a comprehensive sales dashboard for a bicycle retail company using SQL, Excel, and Tableau
10:26 Data analysis process completed successfully
23:35 Creating pivot tables and charts for total revenues per year and per month
31:26 Generate five charts for revenue analysis
49:28 Dashboard made interactive using Excel feature called slicers
59:07 Generated interactive dashboard with charts for total revenues, revenues per month, revenues per state, revenues per store brand and top 10 customers.
1:08:16 Revenue breakdown by brand and product category
1:16:27 Created a dashboard with key metrics and charts
1:27:55 Dashboard made interactive with filters
1:37:50 Completed dashboard for bike store
Crafted by Merlin AI.
Thank you so much for this incredible detailed project journey!!! on behalf of all the data beginners.
Thanks so much for this video! I graduate uni next year but I knew I wanted to make a portolio and this is a perfect addition to it.
Bro you really did a great job than the youtuber from whom I learnt Tableau
Glad to hear that
Today i was asking myself how does it looks to be a DA, thanks for this vid. Feel more confident now in what to expect.
This is the best all in one exercise ever, thank you sir for your effort!
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 Hey, its been a while since i finished this project. Tomorrow i will try to find and inform you. Have a nice day
@@muammerguldemir4526 That would be really great. I will leave a comment tomorrow so that you get a notification. 😊😊
this is really good to understand as a beginner data analyst, thank you!
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
You are very good at teaching, please keep up the good work.
Thank you! 😃
Thank you for so great explanation!!! Could you please do more videos like this one? It was the most helpful video so far from all I saw
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
One of the best Data Analysis videos I have come across. I learned so much from this. Thank you!!!
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 you better first learn basics of SQL, then you could solve it
@@AinekenWalker Thanks for suggestion bro. But, I know SQL and did 15+ projects, the only problem is that this dataset is not working, the same with most of the people commenting. If you can, help me. It would be great. 🙏😊
@@p.chandra2444 Stop uploading the "drop objects" folder. When you download the file, load SQL Server Management Studio. Go back to your downloads folder and double click on ONLY "-create objects" and "load data" which should download as the 1st file and the 3rd file on the folder. If you don't see this then expand the "Name" column like you would in Excel when expanding the width of a column to make the field fit in a cell. I hope this helps sweetie 🥰
Double thumbs up 👍👍 ...A very good video on end to end implementation right from SQL Server to Tableau. Looking forward for more such videos
Thanks for presenting this demonstration. I really enjoyed the way the created the SQL code step by step, rather than trying to build the entire query in one shot from top to bottom.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 Were you able to download it?
@@moseslidubwi4364 no
Nice tutorial you have got here. I would suggest creating a view is sql and instead make the connection via the view rather than copy and pasting the sql query like you did.
You don't show how the brand_name column is created (40:22)!!! Please explain!!! Thanks!!!
Well done. This is a great 👍 tutorial on data analytics. Being a newbie in the field,
I wish you have used the power query on the ETL step to leverage its power on the cleaning step rather a visual checking! The concatenation of columns could have been performed on the Excel Power Query just before loading (Transformation)!
Keep it up!
Yes, I considered that, but I really wanted to make this tutorial as short as possible. I gotta say, I failed on that front, lol.
I will use those features for future tutorials. Thanks for the suggestion.
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Thank you for your effort to do this video. It's really helpful to people who are new to Data Analytics like me.
53:55 what if the slicer pivot table checkboxes doesnt show every pivot table? i am specifically missing the revenue per store and revenue per brand pivot tables from the checkboxes
I am running into this same problem. Any chance you were able to find a solution?
Instead of creating new pivot tables after the two seperate ones, first copy paste the pivot table you want to make connections between them and then change the columns.
Thank you for making this video tutorial and sharing the database, very much appreciate this!
Great work on this! Found it really helpful to understand how a full project can be structured, thank you! :)
Incredible, very good project to start your portfolio, thank you!
Easy and digestible information I enjoyed watching every second of the video really amazing job thank you brother
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
I love this video. It was great insight for my Capstone project. New subscriber here!!! Thank you and can't wait for you to make more.
That is cool. Thanks for your sharing. I hope you great as well
I have a problem or rather a confusion in the loading SQL file you have give us,in the creation of sales.staff we are having a self referencing forgein key which is based on an auto incremented primary key so won't we have the same value for primary and forgein key?If so is this a violation of primary key constraint? Perhaps I have not captured enough info , kindly excuse me if I have not analysed the code neatly.
9:22 when calculating revenue, you didn't minus discount ? just quantity * list_price?
Just to keep things simple. It's about understanding the concept more than anything. But you're right, the discount should have been included to get the proper revenue amount.
THANK U SO MUCH FOR THE INFORMATIVE TUTORIAL .. APPRECIATE IT
Wow amazing content loved it 👍.Thank you for sharing the knowledge 🤩
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Thank you so much for this video! It helped a lot for my first try at data.
@1:38:08 Great insight!!!!
thanks bro this was good and was my first ever portfolio
Please make complete tutorials on power bi ,excel , tableau
I will look into it.
Nice one sir, Thank you very much, this tutorial is really helpful.
though i'm having issues with the number of rows, mine is reading 15,172
Thank you for the great project
26:49 Please correct, it is not (Ctrl + D + P) It is (Alt + D + P)
Thank you very much…..I learned new things.
Great video! Thank you!
most real time work simply super😁
Nice Video .
but i noticed you added another column "brand name" after you imported the dataset to excel which wasnt added to the initial query.
Took me about !0 mins to figure out
All in all , awesome video man
Can you please how you did that? I tried it in both SQL & Excel but didn't work.
so did you ignore it or added it yourself
Thank you so very much for this awesome tutorial.
Glad it was helpful!
Thank you for amazing tutorial.
Thank for sharing value lesson to us.
Great job, my friend!
what an informative piece, i love it😊
@Dataset Guru
Hlo sir i am facing issue during insert values commands in load file .
i am using mysql so to insert multiple records i have to remove the insert into for all the remaining records other than first record for each table inserting.
otherwise i have to execute each and everyline at a single time which takes so much time.
do u have any other ways to insert multiple records in mysql sir using the commands which u gave in load file sql filescript.
Nice work . Can you somehow integrate python for full circle analysis. It would be extremely perfect❤
How phyton can be used to improve the analysis? Excuse my ignorance
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
Awesome training 👍👍👍
Hello! Thank you so much for such a thorough tutorial. At around 11:00 you grouped by and used agg function to get quantity and revenue. Why couldn't we just get quantity and revenue without agg function and group by. Wouldn't it give the same results as each order_id already has the quantity and revenue is simply just quantity*price. Why did we use an aggregate function there ?
Oh I see, the order Id repeats you just want to group the entire order into one container right?
@@ShokhinaBadrieva That's right. I want the combined total.
@@WorkTheData can you kindly check the link for the dataset posted in the description. The site isnt opening. Kindly provide an alternate link so we ca practice alongside. Thanks
26:48 what keyboard keys did you use? didn't work here
My mistake. Instead of the ctrl key, press ALT + D + P
Thanks for the training.
Provide the link for the data so that one will be able practice with it.
I have added the sample dataset in the discerption.
Thank you sir, wonderful. Great video!
Hi, Great video and thank you for helping me with my project but I had a doubt- you did not add brand name column while writing the SQL query but it is shown in excel after importing.
You're right. Make it a personal exercise. See if you can include it in the query yourself, and let me know if you have any other questions.
Hi just add the brand in the sql query and refresh on excel it will load
Hi, can you provide the query line? I'm having issues pulling it.@@Thingsof_love
the tutorial is attractive and clear to understand but i have aquestion for you if you give us the sample database and we can practice on it
ua-cam.com/video/AOPOVnmer_Q/v-deo.html
I have added the sample dataset in the discerption.
How are you adding slicers for multiple charts, when the cache is not shared across all the pivot tables?
Amazing work! I love how you integrate SQL, Excel and Tableau. Can you please share the link to dataset?
I have added the sample dataset in the discerption.
After the first two pivot table, all other tables are connected to the second pivot table. Therefore, the slicers of the first one cannot be applied to others. To fix this, instead of creating new pivot tables after the two seperate ones, you may first copy paste the pivot table you want to make connections between them and then change the columns.
How can we do that?? Steps?
Very good tutorial but sadly like half of the people in the comments i cannot get the data set to work. I was able to lead the "create objects file" and i executed each query to get the tables into the "BikeStore" database. The tables are empty though. I tired executing the "load data" queries which were really long and it didn't not work induvially or together. It is important to remember that we are Level 1 beginners so most of us are only use to getting data sets from Excel sheets. you started the tutorial with dataset but we cant follow along because WE DONT KNOW HOW TO LOAD THE DATA SET.
Hey Mark. Before running the queries, do well to create a database named (BikeStores) and run all querries in that database. That way, you will have no error.
The video is interesting, but all the tables are empty.
Create a New Database and call it "BikeStores" make sure when you run the queries you run them on the that database and not the master database, otherwise you won't see your data. Then you'll have to delete each table in the master database like I had to.
The "master" database is the default database the the query goes to. It's to the left of the green Execute button
This is really good... thank you for sharing 👍
Thank you! Just subscribed and liked the video. It helped a lot. :)
Hi all! I noticed that in the "order_items" table there is a discount column. Wouldn't it be correct to count the revenue, including the discount column?
at 1:07:55 you dropped in "Brand Name" into the Columns pane...But that was never a field that we grabbed in SQL. People following along are not going to have that field available in Tableau. Edit: You also clearly created aliases for your measure names at about 1:15 that you never showed the viewer how to do.
I noticed it too. The brand name suddenly pops up in his table. So I solved it by myself. Try to insert from the sql
@@GamerDan101 so you input manualy in your sql?
@@tuyuldanmbakyul2 No, I select it also on the table
I love the video, thank you!
Please can show how you uploaded the file on SSMS, am having difficulty in importing the bike purchased dataset please thanks
did you get it? using excel I'm able to import the data but it is showing only in one table. unlike the video where product categories, brands are seperate tables...
Thank u so much learned a lot !!!!!
The great project ever
how to load database....?
When I try to insert the pivot table 'data source reference is not valid' error is coming. I have saved the file on my local drive. Please help
I'm running into this problem as well. Still searching for a solution
I am confused and can anyone help me ? When I tried to open the downloaded sample dataset using Mysql WORKBench, I couldn't generate the database like as the beginning of the video with the list of tables. Or am can I create that database by download the sample dataset link that you provided, and then run on SQL Workbench ?
same issue
Good Work Man! Keep it up
Hey thanks for the video. how to load this dataset to MySQL
Workbench.
Great video, thank you so much for your effort. But I have a question for the SQL section, when you use SUM() functions for total_unit and revenue and then GROUP BY(). What if in case I don't use these 2 functions, the result will be the same. This is because the quantity in the order_items table refers to the sum quantity of each item in each order, so I think SUM() and GROUP BY() are not necessary.
Hi, thank you so much for the tutorial.
However, I cannot download the excel file. Can you check this?
Try this: docs.google.com/spreadsheets/d/1ESMiCguVJjUzjVNxLffngDrHsQcMFHrt/edit#gid=1194135803
@@WorkTheData Thank you so much. It works well.
good video thk u so much. but i have one question ! why don't u use a temp table on sql ?
You are an icon man
I am sure this is useful for beginners and students. Appreciate you doing this for them. But this is very very basic, real life scenarios are much more intricate (sql-wise) and require a better, more beautiful/professional front end (dashboard)
Yes, this is just a beginner's exercise.
26:55 it should be alt+d and then p
İt s perfect. You should do more :)
Great video!
So Insightful
Can you provide road map to learn data analysis for a beginner ..
thanks for all the work, while making the chart for Brand/revenue i found out that i didn't actually extract the brand from the database although i could see in the sheet in the description that tha brand is there so probanbly i did a mistake there.
Quick question here: so i adjusted the code and imported in to a new sheet name Query2 in the same way we did the Query1 sheet to be able to complete the work. my question here is, is there a way to update the same exact sheet in case i change the code in the original SQL query?
Thank you very much, my friend. How could I connect that SQL file to MySQL workbench?
If anyone has imported this dataset in mysql workbench then pls guide me..
I use MacOS, so I work with Mysql Workbench, have some error when I execute the file Create objects.
Details:
CREATE TABLE production.categories (
category_id INT IDENTITY (1, 1) PRIMARY KEY,
category_name VARCHAR (255) NOT NULL
have some error that: 'IDENTITY' is not valid at this position, expecting ')'
what can I do ? Please help, I am a beginner. Thank U so much
@DatasetGuru please help. I´m facing the same problem.
Replace IDENTITY (1, 1) with AUTO_INCREMENT
Thank you very much for this video. Please I imported the dataset in Microsoft SQL Server as you did, but all the tables are empty. What can I do please ?
Did you open the 'load data' query file (Step 5)?
Please I used my sql workbench, Can the datasets be provided but in excel format?
How to we enter whole of the data at once? Or do we need to run 1 insert query at a time as it will take a lot of time. Please help!!!!
Hello, I really like the video You have made, thank you! But I got a problem to get the dataset. Seems like the query you gave didn't work out. Can you help me out how to get the exact same date for practice to do the same like you? Thank you in advance
Please help! When I tried to upload the data in SQL , the first thing on the top is
CREATE SCHEMA production;
go
CREATE SCHEMA sales;
go
I am getting error as syntax error at or near "go".
However, i have not done anything fromfrom my end. i just selected the file from the folder, the link which you have provided in description. Cold you please help me fix the issue. I am keen to follow along with the tutorial . Please help !!
@DatasetGuru please help. I´m facing the same problem. I use MacOS, so I work with Mysql Workbench.
comment it or delete it.
This is an interesting tutorial. I really like the step by step explanation and the context.
Could you please conduct another one with s different scenario using MS SQL, Excel and PowerBI?
🙂🙂🙂
Hey, I really want to do this project but unable to upload the dataset. Could you please help me?? I would love to connect you through whatsapp, kindly let me know. Thank you.
@@p.chandra2444 hi were you able to upload the dataset? I have the same issue lol
@@ChasingSummer-qx3me I cannot find the data set. The zip files contains only the code. When O open and upload them this is what I can see only. 😊
@@ChasingSummer-qx3me Hey, no I am not. Let me know if you have done it. :)
@@p.chandra2444 Did any of you ever figure out how to connect the dataset to the database? Everytime i try the error "The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)" pops up even after downloading the ACE OLEDB 2016 64-bit version.
Simple. To the point. Thank you.
can you make more detailed videos like this please looking forward