I’m working on breaking into the data analytics field, and this start to finish project has answered so many questions I had for building a project for my portfolio
This Tableau tutorial is a game-changer! 📊 Your explanation of creating dynamic dashboards for pizza sales analysis is spot-on. The way you showcased the step-by-step process with actual data made it incredibly easy for me to follow along. 📈💡 The use of parameters and filters for interactivity is genius, and the end result is visually stunning. 🔍✨ I appreciate your clear and engaging teaching style! Looking forward to implementing these techniques in my own projects. Thanks for sharing your Tableau expertise! 👏👍
Can I do this on power bi? following these step by step, sorry questions that may be obvious, but I'm learning a lot more by carrying out these processes and step by step here than even taking courses; Thank you for sharing this knowledge. Hugs, Eduardo | Brazil | São Paulo
For those of you reading this comment, it's okay, it's normal to feel lonely sometimes, if you're going through tough times, keep trying, but never give up,
I find all your videos very helpful and crisp explanation. Can you make an Intermediate level SQL>>Tableau Dashboard, to enhance our skills more. Thanks in Advance:)
Firstly, thank you for the insightful project on data analysis, I've been practicing the techniques you shared. focusing on the weekly trend for total orders around minute 50:50 , I've noticed that when working with PostgreSQL, it only shows 52 weeks in a year, whereas your tutorial mentioned 53 weeks. I've double-checked, and as far as I know, there are typically 52 weeks in a year. Could you please clarify the concept of the 53 weeks and if there's a specific reason or scenario where this might occur? I want to make sure I understand the nuances correctly. once again, Thank you so much for your help and for creating such valuable content!
Thank you so much for this amazing tutorial, I've learnt a lot from your videos. I have a question, in 1:33:18 you placed KPIs in Dashboard, and let's say I wanna highlight the first KPI only which is "Total Revenue - $817.9K" so how to change the color only for the first KPI? when I change the color it changes all the color for other KPIs as well, I have tried a lot and couldn't find the solution for this. Another question, how to manually create customised filter action? Let me explain, In 2:40:00 you placed a Pizza Category drop down filter, if I choose a 'classic' from that drop down filter the "Total Orders" shows 10.9K I want it to show the number that I choose lets say 15.5K but not 10.9K? and also for other category as well, if I choose veggie it should show the number that I want.
Can you please make video on how to validate dashboard value with MY SQL (step by step ) validations of all the value present in tableau with sql which will be more helpful
In BOTTOM 5 pizza by quantity and top 5 pizza by quantity , you have to "sum order_id" without "distinct function" because one order_id can order more than one pizza from pizza_name
Thank You for this beautiful explanation👏👏👏. Very helpful and informative. Colour Combination you had choose is just wow. I Subscribed it as well. Please make sure to upload more Videos And also make Video on Python we can make use as Portfolio project. Expecting More from you.
Very good content, small query on SQL, when we are taking distinct vales for count formula, should we not use something similar for other statements like sum. Becoz sum includes the duplicate vales but Count Distinct does not use the duplicate values present in DB
When we take number of orders the it should always be distinct count as there can be multiple pizzas in one order. For sum will not affect because each row in data provides info of each pizza sold and its unit price
Unable to connect to your Database Engine. Can we access your data base engine. Please allow us, we can learning from your Videos. That will help us a lot. Your Content is so good.
excellent video. perhaps you should make a udemy course.. i have learnt definitely much more from that video than the udemy courses.. thank you for your time and effort. you have a new subscriber! keep up the good work!!!
Hi Sir, can you please create an headcount model that tracks headcount, attrition, salaries, hike salaries, Hc by department, attrition, new hire plan..
hi.. while calculating weekly trend in MYSQL, DATEPART function doesn't work in MySQL, neither week(),weekofyear() working. the given date format is in dd-mm-yyyy, the output comes NULL. i am unable to solve this problem.
I had the same problem. order_date is text in my system so i have to convert str to date. here is my solution, hope that can help you. SELECT week(str_to_date(order_date,'%c/%d/%Y'),1), COUNT(DISTINCT order_id) AS Total_orders FROM pizza_sales GROUP BY week(str_to_date(order_date,'%c/%d/%Y'),1) ORDER BY week(str_to_date(order_date,'%c/%d/%Y'),1);
Hey there, i´m getting this error "Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib)." i Formated the columns exactly like you did, can anyone help me? Thanks in advance!
I have questions the area chart of the weekly trend for total orders is different from the original one you mad, and so the average line is giving me 276.7, though the total orders that I calculated is correct. and another question, I don't understand how we gonna use the SQL Queries here as we calculated all the KPI's in the Tableau all over again
Hi, I’m using sql workbench and I’m getting error with the DATEPART Function. Can you help me with this? I tired data as well as Extract and it’s still giving me an error. Thanks in advance
-- B. Hourly Trend for Total Pizzas Sold SELECT HOUR(order_time) AS Order_hour, SUM(quantity) AS Total_Pizzas_Sold FROM pizza_sales GROUP BY 1 ORDER BY 1; -- C. Weekly Trend for Orders SELECT WEEKOFYEAR(order_date) AS Order_week, COUNT(DISTINCT order_id) AS Total_Orders FROM pizza_sales GROUP BY 1;
Hi, the values in the 'unit_price' and 'total_price' columns are not displayed as floats. For example, instead of showing 13.25, it appears as 1325. Can you assist with this issue?"
hey there thank you so much for the video. i have created the % of sales by pizza category. how do i make the small circles show the percentage. i am using tableau public
Look the video from time stamp 02:09:05. He went to Check Table Calculation then clicked Percent of Total, if you are referring to the one number in the middle, it's gonna be 100% since it is the Total Revenue , so no need to making percentage of it.
@@tiesetsomatsipa5402 Did that mess up any of your totals? CountD is not working for me now. Total Pizzas sold is too low and I have 10,000 nulls when it comes to the area chart
hello, i'm getting this error and I follow all you steps "Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib) anyone can help me pls
Hello my brother. How do I solve this error below. As I modified columns exactly as you did, but I got this error: Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib). More info: The CSV file when I opened it, it was delimited with a comma, so I fixed it to be in correct columns.
@@gunjeetbrar7229 No, the issue wasn't the dataset but rather the mssql server itself, I used different dataset this works well with mysql but the same error occurred trying to load is in mssql server. Still I didn't query, but rather used the csv file since I am using Tableau Public which doesn't have option for mysql or mssql, those are only available for paid/subscription versions of Tableau. I managed to finish the Tableau tutorial, I even did one on my own with a different dataset not Pizza, did queries with mysql as he did in mssql. I takes too long to import large datasets in mysql than I thought. This issue of mssql server having this issue, I searched it in many platforms, from Google, ChatGPT, UA-cam and Stack Overflow, no help, I don't even see anyone that has encountered it before.
Thanks For Being Our Tutor Sir. Time Stamp: ua-cam.com/video/3Acmk-rqn6c/v-deo.htmlsi=tx-dvnYWQ8dFF0yi&t=2850 Percentage of Sales by Pizza Category: while I am writing this query I had a Doubt why we choose Price Factors Instead of quantity. and I tried it, results are different. SELECT pizza_category, SUM(quantity) AS TOTAL_SALES, CAST(SUM(quantity)*100/(SELECT CAST(SUM(quantity) AS DECIMAL (10, 2)) FROM pizza_sales) AS DECIMAL (10, 2)) AS PCT FROM pizza_sales GROUP BY pizza_category can anybody assist me why we choose price factor instead of Quantity factor. which method is correct and why.
its because youre trying to find percentages of sales which isnt how many is quantity pizzas are sold. its more like the revenue of the pizzas sold and convert to percentage to know which days are generating greater profits. if its COUNT NUMBERS of pizzas sold then we would use quantity. im NEW so i could be wrong too .
To find out the Top 5 Best Seller By Total Orders: You wrote the query as SELECT TOP 5 pizza_name AS Pizza_Name, COUNT(DISTINCT order_id) AS Total_Order FROM pizza_sales GROUP BY pizza_name ORDER BY COUNT(DISTINCT order_id) DESC; But it gave different value. Can I use the below query? SELECT TOP 5 pizza_name AS Pizza_Name, COUNT(order_id) AS Total_Order FROM pizza_sales GROUP BY pizza_name ORDER BY COUNT(order_id) DESC; As in excel it's give me same result as per mentioned. Kindly help me in this........
I’m working on breaking into the data analytics field, and this start to finish project has answered so many questions I had for building a project for my portfolio
This Tableau tutorial is a game-changer! 📊 Your explanation of creating dynamic dashboards for pizza sales analysis is spot-on. The way you showcased the step-by-step process with actual data made it incredibly easy for me to follow along. 📈💡 The use of parameters and filters for interactivity is genius, and the end result is visually stunning. 🔍✨ I appreciate your clear and engaging teaching style! Looking forward to implementing these techniques in my own projects. Thanks for sharing your Tableau expertise! 👏👍
so beautiful , so elegant just looking like a wow. just looking like a wow... perfect dashboards and SQL explanations
Thanks a lot 😊
Excellent work video, please make more video tutorial. It's really helpful for me to learn more about SQL & data visualization
Thank you, I will
Simply Awesome!!
Thanks a lot for making this video. It gives a wonderful understanding E2E.
Can I do this on power bi? following these step by step, sorry questions that may be obvious, but I'm learning a lot more by carrying out these processes and step by step here than even taking courses;
Thank you for sharing this knowledge.
Hugs,
Eduardo | Brazil | São Paulo
For those of you reading this comment, it's okay, it's normal to feel lonely sometimes, if you're going through tough times, keep trying, but never give up,
I find all your videos very helpful and crisp explanation. Can you make an Intermediate level SQL>>Tableau Dashboard, to enhance our skills more.
Thanks in Advance:)
Firstly, thank you for the insightful project on data analysis, I've been practicing the techniques you shared. focusing on the weekly trend for total orders around minute 50:50 , I've noticed that when working with PostgreSQL, it only shows 52 weeks in a year, whereas your tutorial mentioned 53 weeks.
I've double-checked, and as far as I know, there are typically 52 weeks in a year. Could you please clarify the concept of the 53 weeks and if there's a specific reason or scenario where this might occur? I want to make sure I understand the nuances correctly.
once again, Thank you so much for your help and for creating such valuable content!
Thank you so much for providing this project ... really appreciate your effort .Your explanation were awesome. Keep educating...good job
Thanks 👍
Thank you for this! It helped me fill in so many blanks that I was still grappling with. ^^
Salute to your hard-work
great explanation!!!!
truely a tableau lover.
very helpful, thank you
bhai this gonna really help me in the interview thank you for giving insightful info
Glad you liked 🙂
Love it!!!!!!!!!!!!!!!!!
Thank you so much for this amazing tutorial, I've learnt a lot from your videos. I have a question, in 1:33:18 you placed KPIs in Dashboard, and let's say I wanna highlight the first KPI only which is "Total Revenue - $817.9K" so how to change the color only for the first KPI? when I change the color it changes all the color for other KPIs as well, I have tried a lot and couldn't find the solution for this.
Another question, how to manually create customised filter action? Let me explain, In 2:40:00 you placed a Pizza Category drop down filter, if I choose a 'classic' from that drop down filter the "Total Orders" shows 10.9K I want it to show the number that I choose lets say 15.5K but not 10.9K? and also for other category as well, if I choose veggie it should show the number that I want.
Can you please make video on how to validate dashboard value with MY SQL (step by step ) validations of all the value present in tableau with sql which will be more helpful
Excellent Video
In BOTTOM 5 pizza by quantity and top 5 pizza by quantity ,
you have to "sum order_id" without "distinct function" because one order_id can order more than one pizza from pizza_name
THANKS
Very helpful thanks ❤❤❤
Thank You for this beautiful explanation👏👏👏. Very helpful and informative. Colour Combination you had choose is just wow. I Subscribed it as well. Please make sure to upload more Videos And also make Video on Python we can make use as Portfolio project. Expecting More from you.
Good video, okay. Hard work, okay. Really good portfolio, okay, okay. Okay👍, okay.
Thank you sir
All the best
Very good content, small query on SQL, when we are taking distinct vales for count formula, should we not use something similar for other statements like sum. Becoz sum includes the duplicate vales but Count Distinct does not use the duplicate values present in DB
When we take number of orders the it should always be distinct count as there can be multiple pizzas in one order. For sum will not affect because each row in data provides info of each pizza sold and its unit price
Thanks a lot!!!
Please make more. Your tutorials are of great help bro. Could you also include forecasting in your future tableau vids
Thanks
Unable to connect to your Database Engine. Can we access your data base engine. Please allow us, we can learning from your Videos. That will help us a lot. Your Content is so good.
Did you manage?
excellent video. perhaps you should make a udemy course.. i have learnt definitely much more from that video than the udemy courses.. thank you for your time and effort. you have a new subscriber! keep up the good work!!!
Hi buddy.. can you please make a end to end dashbord in power bi through live connection mode.
Hi Sir, can you please create an headcount model that tracks headcount, attrition, salaries, hike salaries, Hc by department, attrition, new hire plan..
Well explained.Thank you so much for the efforts.Please upload Pizza file images.I couldn't find it in the link you shared.
Really great work brother, can u make something on project management.
Bro. Excellent work. Can u make a video for how to import our project in github page with code. Kindly make this video brooooo.
😍
Can we make analysis dynamics with changes in data/graph?
Yes you can use your own imagination and design
Hi, I am gee=tting error while querying , it's not showing pizza_sales......it's only showing pizzadb, what should i do now?
Hi, Can i copy this dashboard and show it on my linkedin?
grande paaa
hi.. while calculating weekly trend in MYSQL, DATEPART function doesn't work in MySQL, neither week(),weekofyear() working. the given date format is in dd-mm-yyyy, the output comes NULL. i am unable to solve this problem.
I had the same problem. order_date is text in my system so i have to convert str to date. here is my solution, hope that can help you.
SELECT
week(str_to_date(order_date,'%c/%d/%Y'),1),
COUNT(DISTINCT order_id) AS Total_orders
FROM
pizza_sales
GROUP BY
week(str_to_date(order_date,'%c/%d/%Y'),1)
ORDER BY
week(str_to_date(order_date,'%c/%d/%Y'),1);
@@jiaoliu7133 it's not working, btw no MySQL query is working for weekly trend.
Hey there, i´m getting this error "Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib)." i Formated the columns exactly like you did, can anyone help me? Thanks in advance!
hi, have you found a fix for this?
I have questions
the area chart of the weekly trend for total orders is different from the original one you mad, and so the average line is giving me 276.7, though the total orders that I calculated is correct.
and another question, I don't understand how we gonna use the SQL Queries here as we calculated all the KPI's in the Tableau all over again
and also the weeks are starting from Null till week 50
Hi, I’m using sql workbench and I’m getting error with the DATEPART Function. Can you help me with this? I tired data as well as Extract and it’s still giving me an error. Thanks in advance
What error??
In my table in SQL, the Server Management Studios not recognize the '.' in the prices and then is corrects type float. How to resolve?
Try to change data type
Hi, what will be the query to get HOURLY TREND in mysql
i'm also searching for hourly and weekly in MySQL.
-- B. Hourly Trend for Total Pizzas Sold
SELECT
HOUR(order_time) AS Order_hour,
SUM(quantity) AS Total_Pizzas_Sold
FROM pizza_sales
GROUP BY 1
ORDER BY 1;
-- C. Weekly Trend for Orders
SELECT
WEEKOFYEAR(order_date) AS Order_week,
COUNT(DISTINCT order_id) AS Total_Orders
FROM pizza_sales
GROUP BY 1;
What is maser inside sir...
hi how to get this data set pizza sales
Hi, the values in the 'unit_price' and 'total_price' columns are not displayed as floats. For example, instead of showing 13.25, it appears as 1325. Can you assist with this issue?"
Try changing the data type
@@datatutorials1 it appears float already.I uploaded xslx file to sql server management studio so it's OK.Thanks for your reply :)
can u please provide some new projects,these are already done by myself
@Data Ttutorials, How do i take a screen shot of the Dashboard ? Power point size seems larger for the entire view.
snippet tool in your laptop
In tableau i am getting 50 weeks on x-axis what to do ??
Do you have all dates, and what did I get in video, don’t remember as this is a bit old project.
hey there thank you so much for the video. i have created the % of sales by pizza category. how do i make the small circles show the percentage. i am using tableau public
how did you connect using tableau public? pls help
@@gunjeetbrar7229 He/She just used the CSV, I did that too. You'll need a paid version of Tableau to connect mssql or any other sql servers.
Look the video from time stamp 02:09:05. He went to Check Table Calculation then clicked Percent of Total, if you are referring to the one number in the middle, it's gonna be 100% since it is the Total Revenue , so no need to making percentage of it.
There is no option to connect MSSQL server to tableau public. Can i connect via the CSV file??
Yes, that's what I did, you'll need a paid version of Tableau to be able to connect with Mssql or any other sql servers.
@@tiesetsomatsipa5402 Did that mess up any of your totals? CountD is not working for me now. Total Pizzas sold is too low and I have 10,000 nulls when it comes to the area chart
@@tiesetsomatsipa5402 How about the sql commands? How am I going to connect that
hello, i'm getting this error and I follow all you steps "Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib) anyone can help me pls
HI, did you end up finding a fix for this?
Hi, in csv files, when we convert year into weeks, it shows a lot of null values in the chart, what could be the solution for this?
Why are you manipulating csv file, instead convert csv to xlsx and make your changes
@@datatutorials1 in tabeau. While making weekday chart
@@datatutorials1 I am having the same problem. with xl. The countD() function is not aggregating the total and I am getting 10,000 ish nulls.
I found out the problem! Thanks!
can i do it with my sql?
Yes you can
@@datatutorials1 ok.. then i'll follow along with this and make the project..
Hello Sir, I have MySQL workbench. how to connect with pizza excel file?? Please help!!!!! Anyone know please comment down
Import data in mysql first and then use mysql connector
Perez Betty Lewis Joseph Perez Daniel
Good day everyone, how are you all doing? I am having issues with the server name
sir hindi me toturial day
1K,
Hello my brother. How do I solve this error below. As I modified columns exactly as you did, but I got this error:
Error inserting data into table. (Microsoft. SqlServer.Import.Wizard) Input string was not in a correct format. (mscorlib).
More info:
The CSV file when I opened it, it was delimited with a comma, so I fixed it to be in correct columns.
His dataset as bugs, he's not showing his audience how to fix it.
@@samuelshodunke4194 is it working?
Were you able to fix the error?
@@gunjeetbrar7229 No, the issue wasn't the dataset but rather the mssql server itself, I used different dataset this works well with mysql but the same error occurred trying to load is in mssql server. Still I didn't query, but rather used the csv file since I am using Tableau Public which doesn't have option for mysql or mssql, those are only available for paid/subscription versions of Tableau.
I managed to finish the Tableau tutorial, I even did one on my own with a different dataset not Pizza, did queries with mysql as he did in mssql. I takes too long to import large datasets in mysql than I thought.
This issue of mssql server having this issue, I searched it in many platforms, from Google, ChatGPT, UA-cam and Stack Overflow, no help, I don't even see anyone that has encountered it before.
Thanks For Being Our Tutor Sir.
Time Stamp: ua-cam.com/video/3Acmk-rqn6c/v-deo.htmlsi=tx-dvnYWQ8dFF0yi&t=2850
Percentage of Sales by Pizza Category:
while I am writing this query I had a Doubt why we choose Price Factors Instead of quantity. and I tried it, results are different.
SELECT pizza_category, SUM(quantity) AS TOTAL_SALES,
CAST(SUM(quantity)*100/(SELECT CAST(SUM(quantity) AS DECIMAL (10, 2)) FROM pizza_sales) AS DECIMAL (10, 2)) AS PCT
FROM pizza_sales
GROUP BY pizza_category
can anybody assist me why we choose price factor instead of Quantity factor. which method is correct and why.
its because youre trying to find percentages of sales which isnt how many is quantity pizzas are sold. its more like the revenue of the pizzas sold and convert to percentage to know which days are generating greater profits. if its COUNT NUMBERS of pizzas sold then we would use quantity. im NEW so i could be wrong too .
To find out the Top 5 Best Seller By Total Orders:
You wrote the query as
SELECT TOP 5 pizza_name AS Pizza_Name, COUNT(DISTINCT order_id) AS Total_Order
FROM pizza_sales
GROUP BY pizza_name
ORDER BY COUNT(DISTINCT order_id) DESC;
But it gave different value.
Can I use the below query?
SELECT TOP 5 pizza_name AS Pizza_Name, COUNT(order_id) AS Total_Order
FROM pizza_sales
GROUP BY pizza_name
ORDER BY COUNT(order_id) DESC;
As in excel it's give me same result as per mentioned.
Kindly help me in this........
please do you have telegram or whatssap line that we can ask you questions