Hello. Really grateful for all of your videos. In the past month I must have watched at least 15 of them, and the clarity, usefulness, patience, succinctness, and brilliance of your work is really unparalleled. It is an incredible service - and the fact that it's for free blows my mind. How can I tip you for your work? I know you may not need it but I just don't know how I could ever appreciate you for this and felt like asking if there's a way we could send tips to you. Lastly, at the end of this video you talked about doing videos on SQL as well. Wondering if you ever got to doing that and how I could find those. Thanks once again so so much.
Hello Stanley - your note means a lot. I sincerely appreciate you sharing this message, and I am just happy you found the videos helpful. Your support for the channel (ie you viewing the videos) is already more than enough consolation, and the really thoughtful and kind note you left is icing on the cake :) ... I am hoping to ramp up the content creation in the coming weeks, and planning to put more of other topics, especially SQL. Thank you again Stanley.
Thank you for this helpful and clear video! You really do a great job explaining each step and illustrating important concepts for making a Tableau dashboard.
This is exactly what I was asking for! I don't know how I missed it. Now part two is out so I guess it was perfect timing. Thanks so much for considering what I said, and actually putting time into creating something awesome!
Lots to learn from dashboard creation Amazing! every step you explained in very detail and a lot to learn .... never-ending learning. you have done excellent work to make things simple to learn and understand.
At last I've found you! At the start of the video, you show us the finished result of the tutorial so we know what we are aiming to build. Nothing worse than getting half way through a long tutorial only to find it's not showing you what you hoped it would! Lots of concepts covered here so i've learnt a lot. I will be watching part 2 and more, thank you so much :)
Such clarity. Thank you so much. I keep revisiting your videos every once in a while to refresh the Tableau concepts. Could you take up some problem statements or case studies and analyze them using Tableau and furnish insights through dashboards and stories. Would love to learn your approaches to solve problems. For example: Case study - Analyzing customer churn in Tableau Looking forward to your SQL videos.
Great video ma'am college student that is struggling in OL class big help. Amazing. Can I humbly see your data set that is involved in this tutorial. Thank you a lot.
Hi Elton! I mention the data source in ua-cam.com/video/cGa7QDeueTA/v-deo.html ... or at the 1:46 mark of the video. This file comes with your Tableau installation. Hope this helps!
I really appreciate your videos! You do a great job and I recommend them to colleagues routinely. **A request for a new video: Take the top x items from company sales overall, and create a report that shows by customer which customers do not carry those products (Gap report) to inform sales team members which customers are missing top products.** Thank you!
thankyou for the awesome lecture mam,but the menu icons which you have used where we can find those images.It would be great if you also share picture link also in the description box.Thankyou
This is so good.. 1 quick question .. on 06 Footer sheet you have created a blank calculated field right .. could you please let me know what are the 2 characters you have entered there .. thank you :)
Thank you Sahi. Usually for the blank calculated field I use an empty string. The expression will be two double quotes with nothing in between... like this ""
So I seem to be having an issue. When you right clicked and dragged Order ID it was very easy for you as for when I do it just pops up with a menu that looks nothing like yours. I am on a mac. Any ideas?
Thanks mam i just discovered your channel and really need to say found 💎 gem. Love ❤ your tutorials. Mam please 🙏 make video on Parameters in which different scenerios we can use and build parameters that looks good in dashboard also. Thanks for your lessons :)
Hi Rishabh - thank you for your feedback and your very nice comment, much appreciated! This is a great suggestion, I will definitely include parameters in a future video 🙂
Thanks Mam...as always best in less time.. waiting for other part and ...long advanced series on udemy ...it will rock ..there are udemy content but not worth those are just basics ..pls think at least oness to make udemy course for people like us..Thanks again..
Good morning Donabel, Thanks a lot for the videos. Would you please explain what insight does the Moving average give you exactly ? Personally I don't understand these calculations : Moving average, Standard deviation and how are there useful ?
Hello Eddy Jo, I think these calculations will be used more often in certain scenarios or industries. Moving average is when you take a series of values and report an average. For example, a 30 day moving average means every point is the average of 30 days worth of data. The main reason to use moving average is because it tends to smooth out the chart. This is helpful when you have a lot of data which makes it hard to see the patterns. Think of stock prices and how even on an hourly basis the values go up and down. If we try to plot this it will have a lot of lines moving up and down, and having a moving average allows us to see the general trend and not just the fluctuations. Standard deviation shows us how dispersed the values are from an average. And there are certain models that help us understand the general shape and possible data values. For example, if we have data about salaries. We would be able to see where majority of the salary ranges lie. Here is actually a great resource that I found that explains it well (www.surveyking.com/help/standard-deviation-calculator). I will copy and paste the section that I think explains it best: "Example: If a question in your survey asks for annual income, the mean could be $35,000 with a standard deviation of $5,000. From the empirical rule, we could assume that 68% of total responses fall somewhere between $30,000 and $40,000. We could also assume 95% of the data falls between $25,000 and $45,000. This data would help ensure a successful marketing campaign. You would now be able to create a campaign specific to your largest demographic!" Sorry it's a long answer, but I hope this helps! Donabel
I am sure so many provide good explanations as well. I try to provide help or additional insights if I can, but I am helped by so many others as well :)
@@sqlbelle I want to be able to join different databases from my power bi dataset but I don't see that option. Once I connect to the datasets, it just take me to the worksheet. I want to be able to match the datasets before working on the sheet. Please do.you have videos on creating rich dashboards? am currently working on project. will appreciate your help. Thanks
Hi, I love your tutorials but I can't seem to find dataset in order to practice it on my own. I checked the description but couldn't find the link to data in the description
Thank you Sumit. I will organize the data sets and share them on my website. I'll post them in an announcement as well as the descriptions once they're ready.
Thank you - it's in my list but have had some delays with recent videos. I will try to get that one out in the next couple of weeks. Thank you for the suggestion!
Hi Simon, I used an icon from flaticon. I didn't create the icon for this tutorial. If I needed a custom, I may need to create them in a tool like Adobe Illustrator. If I am misunderstanding the question, please let me know. Donabel
Hello Sai! It's because the space allocated for the mark (in this case a text) is too small, and it doesn't fit. I would recommend resizing the space that contains the number. You can adjust the length or the height.
I using the SuperStore that is on the Tableau Main screen, but when it opens, category and subcategory are not visible for they are under Product and there is no Customer ID showing. I complete a search for Customer and only received Customer Name. Why would Tableau change the SuperStore like this, when so many tutorial have been published based off of original content.?
Thank you Sam. The Superstore file that comes with your installation should have the same fields that are shown in this tutorial. Please make sure to use the file I refer to here: ua-cam.com/video/cGa7QDeueTA/v-deo.html (note this part is at 1:46) ... and not the saved one that you see in the main screen. Thank you.
Really appreciate the time, effort and knowledge sharing on such an open platform. Please accept a very small token of what I can afford right now as a gratitude for being my guru. 🙏
Hello Anand, this is very kind. Thank you. I am very thankful, I appreciate this very much. I hope you will find the other videos in this channel helpful. I hope to create more videos and hope you will find value in those as well. Thank you again Anand, from the bottom of my heart.
@@sqlbelle Hello SqlBelle 👋 "I will see you in a bit..." This always gives me a feeling the magic by a Wizardess is just about to start. Well, Honestly it has been a few weeks (2-3) that I have started watching your videos. I am an SQL programmer hence all the tricks I do are on SQL (MSSQL) (as all my data is in the backend) and then use Tableau Desktop for minimalistic calculation refinements. But your videos are helping me change my approach from coding in just SQL to coding in Tableau. (On a personal level) is it the right way to BI? i.e. code completely in SQL and then use Tableau for refinements or it hardly matters? (i.e. just a matter of personal preference between sql vs tableau). Lastly, there are just a few handful of people out here in the Digital World that would do such brilliant yet selfless work like you. I wish you many more subscribers on your channel. 🤞
While making the 02 BAN worksheet, I noticed that my values were scrunched together, making them very difficult to read. I tried looking online for solutions to this, but I did not see one. There is 1 character space between each value on my tableau. Anyone have ideas on what could resolve this? I've looked at size and format options, but I must be looking in the wrong spot.
Great vidoes! I plan to replicate this for this example and a new one on my own. I have a suggestion- you should promote your content on reddit as well. The reddit tableau page allows self promotion on Saturdays. I think many people will benefit from these videos- this is premium training content- honestly the best I have seen.
Thank you so much for this note and suggestion Shaila, very much appreciated! I was not aware of that, and I am very grateful for your suggestion! I will give that a shot ... thank you!
I am from country of Myanmar, I cannot create Map of US states. I can create global map like country , but not states of the country. Kindly help me what will be my error to fix ?
Thank you Nwayy. You can go to the Maps menu > Edit Locations, and select the correct country value, or country field from your data source. Hope this helps.
Great video - but horrible instruction - way too fast if it was really an instructional video - but great information and tutorial - just needs to learn how to be an instructional video - not - how fast can I get through this
Hello. Really grateful for all of your videos. In the past month I must have watched at least 15 of them, and the clarity, usefulness, patience, succinctness, and brilliance of your work is really unparalleled. It is an incredible service - and the fact that it's for free blows my mind. How can I tip you for your work? I know you may not need it but I just don't know how I could ever appreciate you for this and felt like asking if there's a way we could send tips to you. Lastly, at the end of this video you talked about doing videos on SQL as well. Wondering if you ever got to doing that and how I could find those. Thanks once again so so much.
Hello Stanley - your note means a lot. I sincerely appreciate you sharing this message, and I am just happy you found the videos helpful. Your support for the channel (ie you viewing the videos) is already more than enough consolation, and the really thoughtful and kind note you left is icing on the cake :) ...
I am hoping to ramp up the content creation in the coming weeks, and planning to put more of other topics, especially SQL.
Thank you again Stanley.
Thank you for this helpful and clear video! You really do a great job explaining each step and illustrating important concepts for making a Tableau dashboard.
Professor Smith we should get extra points for liking this
Best comment thank you for letting me know!
I completely agree, Mr. Chuck. This presentation is one to remember!
This is exactly what I was asking for! I don't know how I missed it. Now part two is out so I guess it was perfect timing. Thanks so much for considering what I said, and actually putting time into creating something awesome!
Happy to hear daniel. It was a great suggestion, so thank you for that. Hope you find it useful 🙂
Hi I was looking for some sample data sets, I am new to tableau, do you have any idea? any suggestions?
Your knowledge grows in us too ! Thank you.
Uoooww so much content in one video! I had to stop multiple times to absorb everything. Amazing! Thank you!
Thank you Filipe! Glad you found it useful! 🙂
You just got a subscriber today! Thank you for breaking this down. God bless you!
Thank you :)
Excellent..! I can now build a basic dashboard because of your tutorial sqlbelle...bam!
That's awesome to hear! Thank you for sharing Carlos!
Thank you! This is so helpful. I will be watching all of your videos.
Thank you :)
Lots to learn from dashboard creation Amazing! every step you explained in very detail and a lot to learn .... never-ending learning. you have done excellent work to make things simple to learn and understand.
Thank you so much for your note Vijayanand! Much appreciated 🙂
At last I've found you! At the start of the video, you show us the finished result of the tutorial so we know what we are aiming to build. Nothing worse than getting half way through a long tutorial only to find it's not showing you what you hoped it would! Lots of concepts covered here so i've learnt a lot. I will be watching part 2 and more, thank you so much :)
Thank you for your feedback Stebley, and happy to hear you found it informational 😀
Thank you! I'm new to Tableau and I enjoyed your lesson.
Thank you MaryAnn!
OMG ! so much insights thanks for this short and amazing tutorial
Thank you Abhay
Thank you, This was really helpful. Appreciate it 🙂
Thank you Prabha!
I have taken so much knowledge from your classes thank you so much, love from india
Thank you so much for your kind note Pardhasaradhi! So happy to hear you found the video helpful :) :)
This content is super clear and excellent
You're a star! Thanks so much!
Thank you Patrick!
Loved your video. I am in the process of learning Tableau. This is very helpful.
Thank you Rajesh, I am happy to hear that! Happy Tableau'ing! I really enjoy using this software 🙂
Such clarity. Thank you so much. I keep revisiting your videos every once in a while to refresh the Tableau concepts.
Could you take up some problem statements or case studies and analyze them using Tableau and furnish insights through dashboards and stories. Would love to learn your approaches to solve problems.
For example: Case study - Analyzing customer churn in Tableau
Looking forward to your SQL videos.
Wonderfully done, and very easy to follow thankyou. Please have more of this
Always curious (learn to something exciting N new) and love to see your videos
Thank you Bhawna :)
Fantastic Video... Would love to see more such conceptual topics on tableau.
Thank you for your comment Aditya. I hope you found the video useful 🙂
@@sqlbelle I learned a new concept of adding the update status of the dashboard from the video.
Also didn't find Part 2 of the video?
Thank you Aditya, Part 2 is scheduled for today. It should be up in the next couple of hours. Hope you will find it useful as well! 🙂
Great tutorial. I love your style 😍
Thanks Eric. I hope you are finding the content helpful! 🙂
Thanks a lot can't express my gratitude in words madam u helped me a lot
This video is really awesome, clean and clear and learned many small things. Thanks you so much😊
Thank you Pintu!
You are doing a great job mam!!!
Also please post some more use cases which will help us know some more hidden features of Tableau
Really helpful contents. Thanks a lot!!!😊
Thank you Fatai!
Thank you so much. Your videos are so helpful. Could you please post Alteryx tutorial.
Thank you for the suggestion! :)
Well Done! Thank You !
Thank you Omel
This is Brilliant!
Thank you Russell!
Great video ma'am college student that is struggling in OL class big help. Amazing. Can I humbly see your data set that is involved in this tutorial. Thank you a lot.
Hi Elton! I mention the data source in ua-cam.com/video/cGa7QDeueTA/v-deo.html ... or at the 1:46 mark of the video. This file comes with your Tableau installation. Hope this helps!
I love all your videos.... thanks
Thank you Neil! I hope you have found them useful 🙂
I really appreciate your videos! You do a great job and I recommend them to colleagues routinely. **A request for a new video: Take the top x items from company sales overall, and create a report that shows by customer which customers do not carry those products (Gap report) to inform sales team members which customers are missing top products.** Thank you!
Thank you Rory for this recommendation for topic - I will try to create something similar in the future. Happy New Year!
This is SO useful. Love your videos!. Looking forward to part 2 ;-)
Yay! Thank you, happy to hear this Yolinda! 😀
Awesome waiting for 2nd Part
Thank you! I just published the 2nd part of the series:
ua-cam.com/video/pVOJ1LM5cX0/v-deo.html
Hope you find it useful! 🙂
very well explained. Thank you
Thank you Chithi
Thats pure genuis!
Sooo wonderful! Thank you so much!
Thank you Ryan!
thankyou for the awesome lecture mam,but the menu icons which you have used where we can find those images.It would be great if you also share picture link also in the description box.Thankyou
Thank you Diksha. I usually use icons from flaticon.com or the noun project.
Nice ❤️ mam willl be waiting for second part design
Thank you Peter! The second part is coming in a few days 🙂 I hope you will find that useful as well!
This is so good.. 1 quick question .. on 06 Footer sheet you have created a blank calculated field right .. could you please let me know what are the 2 characters you have entered there .. thank you :)
Thank you Sahi. Usually for the blank calculated field I use an empty string. The expression will be two double quotes with nothing in between... like this ""
@@sqlbelle oh ok .. thank you :)
So I seem to be having an issue. When you right clicked and dragged Order ID it was very easy for you as for when I do it just pops up with a menu that looks nothing like yours. I am on a mac. Any ideas?
Actually I figured it out. For anyone who has issues in the future you want to click option and then drag OrderID or Customer ID over into the pane.
Thanks mam i just discovered your channel and really need to say found 💎 gem. Love ❤ your tutorials.
Mam please 🙏 make video on Parameters in which different scenerios we can use and build parameters that looks good in dashboard also.
Thanks for your lessons :)
Hi Rishabh - thank you for your feedback and your very nice comment, much appreciated! This is a great suggestion, I will definitely include parameters in a future video 🙂
Thanks Mam...as always best in less time.. waiting for other part and ...long advanced series on udemy ...it will rock ..there are udemy content but not worth those are just basics ..pls think at least oness to make udemy course for people like us..Thanks again..
I absolutely love receiving your feedback and suggestions VDN - thank you :)
Good morning Donabel,
Thanks a lot for the videos.
Would you please explain what insight does the Moving average give you exactly ?
Personally I don't understand these calculations : Moving average, Standard deviation and how are there useful ?
Hello Eddy Jo,
I think these calculations will be used more often in certain scenarios or industries.
Moving average is when you take a series of values and report an average.
For example, a 30 day moving average means every point is the average of 30 days worth of data.
The main reason to use moving average is because it tends to smooth out the chart. This is helpful when you have a lot of data which makes it hard to see the patterns. Think of stock prices and how even on an hourly basis the values go up and down. If we try to plot this it will have a lot of lines moving up and down, and having a moving average allows us to see the general trend and not just the fluctuations.
Standard deviation shows us how dispersed the values are from an average. And there are certain models that help us understand the general shape and possible data values. For example, if we have data about salaries. We would be able to see where majority of the salary ranges lie.
Here is actually a great resource that I found that explains it well (www.surveyking.com/help/standard-deviation-calculator). I will copy and paste the section that I think explains it best:
"Example: If a question in your survey asks for annual income, the mean could be $35,000 with a standard deviation of $5,000. From the empirical rule, we could assume that 68% of total responses fall somewhere between $30,000 and $40,000. We could also assume 95% of the data falls between $25,000 and $45,000.
This data would help ensure a successful marketing campaign. You would now be able to create a campaign specific to your largest demographic!"
Sorry it's a long answer, but I hope this helps!
Donabel
@@sqlbelle Thank you for the explanation. it is indeed helpful.
I guess few people would give this type of explanation on youtube.
I'm pretty sure you must be a good person in real life.
I am sure so many provide good explanations as well. I try to provide help or additional insights if I can, but I am helped by so many others as well :)
This is better than most of the udemy courses.
Thank you Sumit!
Thanks for this video. It has helped me greatly. Please do you have any video on joining multiple Power BI databases in Tableau?
Thank you Adedamola. Would you be able to elaborate what you mean by joining multiple Power BI databases?
@@sqlbelle I want to be able to join different databases from my power bi dataset but I don't see that option. Once I connect to the datasets, it just take me to the worksheet. I want to be able to match the datasets before working on the sheet. Please do.you have videos on creating rich dashboards? am currently working on project. will appreciate your help.
Thanks
Hi,
I love your tutorials but I can't seem to find dataset in order to practice it on my own.
I checked the description but couldn't find the link to data in the description
Thank you Sumit. I will organize the data sets and share them on my website. I'll post them in an announcement as well as the descriptions once they're ready.
@@sqlbelle Thanks a lot
Love the speed/brevity.
Dragging on and babbling about peripheral issues is such a problem in tech tutorials.
Amazing
Thank you Rania!
where do I find the superstore dataset? I'm using Tableau Public. Is it available on this version?
Great video ! :)
Thank you Simon 🙂
Really nice one
Thank you Mahesh!
Mam it is good I want to know about dynamic date
Could you post a video for Actions in tableau?thx
Thank you - it's in my list but have had some delays with recent videos. I will try to get that one out in the next couple of weeks. Thank you for the suggestion!
Thanks miss
Thank you coco
Too nice. Sub’d
How do the shape .png files look like that you used. How can you create them for example with a snipet ?
Hi Simon,
I used an icon from flaticon. I didn't create the icon for this tutorial. If I needed a custom, I may need to create them in a tool like Adobe Illustrator.
If I am misunderstanding the question, please let me know.
Donabel
you are amazing
hello, where can I get the data to follow your video ?
Great dashboard, some feedback from an instructive point of view. You are going very fast in this video. It is hard to keep up.
Thank you for the feedback. I'm learning :)
Hi,i want to show dashboard to client for 5 min but client want to see 2 min .How we can do this.
Hello @sqlbelle I created the dashboard and I tried to publish but the huge numbers are reflecting as #####. What might be the reason?.
Hello Sai! It's because the space allocated for the mark (in this case a text) is too small, and it doesn't fit. I would recommend resizing the space that contains the number. You can adjust the length or the height.
@@sqlbelle Thank you
I using the SuperStore that is on the Tableau Main screen, but when it opens, category and subcategory are not visible for they are under Product and there is no Customer ID showing. I complete a search for Customer and only received Customer Name.
Why would Tableau change the SuperStore like this, when so many tutorial have been published based off of original content.?
Thank you Sam. The Superstore file that comes with your installation should have the same fields that are shown in this tutorial. Please make sure to use the file I refer to here: ua-cam.com/video/cGa7QDeueTA/v-deo.html (note this part is at 1:46) ... and not the saved one that you see in the main screen. Thank you.
Madam I'm creating two dashboards I want to show relation between them
Thank you Venugopala. You can potentially use dashboard actions, or even just the navigation button (in the Objects section) to get this to work.
Thanks
Really appreciate the time, effort and knowledge sharing on such an open platform. Please accept a very small token of what I can afford right now as a gratitude for being my guru. 🙏
Hello Anand, this is very kind. Thank you. I am very thankful, I appreciate this very much. I hope you will find the other videos in this channel helpful. I hope to create more videos and hope you will find value in those as well. Thank you again Anand, from the bottom of my heart.
@@sqlbelle Hello SqlBelle 👋
"I will see you in a bit..."
This always gives me a feeling the magic by a Wizardess is just about to start.
Well, Honestly it has been a few weeks (2-3) that I have started watching your videos.
I am an SQL programmer hence all the tricks I do are on SQL (MSSQL) (as all my data is in the backend) and then use Tableau Desktop for minimalistic calculation refinements. But your videos are helping me change my approach from coding in just SQL to coding in Tableau.
(On a personal level) is it the right way to BI? i.e. code completely in SQL and then use Tableau for refinements or it hardly matters? (i.e. just a matter of personal preference between sql vs tableau).
Lastly, there are just a few handful of people out here in the Digital World that would do such brilliant yet selfless work like you. I wish you many more subscribers on your channel. 🤞
While making the 02 BAN worksheet, I noticed that my values were scrunched together, making them very difficult to read. I tried looking online for solutions to this, but I did not see one. There is 1 character space between each value on my tableau. Anyone have ideas on what could resolve this? I've looked at size and format options, but I must be looking in the wrong spot.
Get Good
You are going lightspeed with every step in this tutorial. Take a breath and slow down!
Thanks Eric for the feedback. Im learning :)
Great vidoes! I plan to replicate this for this example and a new one on my own. I have a suggestion- you should promote your content on reddit as well. The reddit tableau page allows self promotion on Saturdays. I think many people will benefit from these videos- this is premium training content- honestly the best I have seen.
Thank you so much for this note and suggestion Shaila, very much appreciated! I was not aware of that, and I am very grateful for your suggestion! I will give that a shot ... thank you!
I am from country of Myanmar, I cannot create Map of US states. I can create global map like country , but not states of the country. Kindly help me what will be my error to fix ?
Thank you Nwayy. You can go to the Maps menu > Edit Locations, and select the correct country value, or country field from your data source. Hope this helps.
I can not grab and drop Order ID in measure Value
Hello - you will need to aggregate if you want to add it in measure value. Try to right click drag (in PC), and select COUNT or COUNTD.
@@sqlbelle thanks a lot ,you are providing good teaching lesson to us
Normal playback speed was like 1.75 speed hahah i had to watch the video at .5 to follow along correctly
In the first vidio you some complicated things ...i find hard ...u are so fast also
Great video - but horrible instruction - way too fast if it was really an instructional video - but great information and tutorial - just needs to learn how to be an instructional video - not - how fast can I get through this
Thank you Andrew
I pause, I rewind. Repeat as necessary. Not a problem.
Thanks @sqlbelle !!!c
Thank you Neel!