Tableau Dashboard Tutorial - Step by step, from start to finish - Part 1 | sqlbelle

[@stanleyazuakola7254]

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.

[@sqlbelle]

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.

[@Hooleey]

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!

[@sqlbelle]

Happy to hear daniel. It was a great suggestion, so thank you for that. Hope you find it useful 🙂

[@kunalmehta2150]

Hi I was looking for some sample data sets, I am new to tableau, do you have any idea? any suggestions?

[@filipeanalytics]

Uoooww so much content in one video! I had to stop multiple times to absorb everything. Amazing! Thank you!

[@sqlbelle]

Thank you Filipe! Glad you found it useful! 🙂

[@charliesmith7824]

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.

[@theabysswalker4225]

Professor Smith we should get extra points for liking this

[@ghostlink4985]

Best comment thank you for letting me know!

[@SamElrod-jl9nv]

I completely agree, Mr. Chuck. This presentation is one to remember!

[@SonofthewindsInc]

Your knowledge grows in us too ! Thank you.

[@TB-dy5em]

You just got a subscriber today! Thank you for breaking this down. God bless you!

[@sqlbelle]

Thank you :)

[@prometeo34]

Excellent..! I can now build a basic dashboard because of your tutorial sqlbelle...bam!

[@sqlbelle]

That's awesome to hear! Thank you for sharing Carlos!

[@TheFearlessGoat]

Thank you! This is so helpful. I will be watching all of your videos.

[@sqlbelle]

Thank you :)

[@stebley]

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 :)

[@sqlbelle]

Thank you for your feedback Stebley, and happy to hear you found it informational 😀

[@vijayanandgawle9479]

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.

[@sqlbelle]

Thank you so much for your note Vijayanand! Much appreciated 🙂

[@MaryAnn-yi1pw]

Thank you! I'm new to Tableau and I enjoyed your lesson.

[@sqlbelle]

Thank you MaryAnn!

[@patrickrafidimanantsoa2297]

You're a star! Thanks so much!

[@sqlbelle]

Thank you Patrick!

[@pardhasaradhik9234]

I have taken so much knowledge from your classes thank you so much, love from india

[@sqlbelle]

Thank you so much for your kind note Pardhasaradhi! So happy to hear you found the video helpful :) :)

[@PrabhaShankar-z4t]

Thank you, This was really helpful. Appreciate it 🙂

[@sqlbelle]

Thank you Prabha!

[@abhaytevatia6974]

OMG ! so much insights thanks for this short and amazing tutorial

[@sqlbelle]

Thank you Abhay

[@RudraChannel123]

Loved your video. I am in the process of learning Tableau. This is very helpful.

[@sqlbelle]

Thank you Rajesh, I am happy to hear that! Happy Tableau'ing! I really enjoy using this software 🙂

[@aginamabednego]

This content is super clear and excellent

[@bhawnamongia4955]

Always curious (learn to something exciting N new) and love to see your videos

[@sqlbelle]

Thank you Bhawna :)

[@russelllavery2281]

This is Brilliant!

[@sqlbelle]

Thank you Russell!

[@adityasharma8488]

Fantastic Video... Would love to see more such conceptual topics on tableau.

[@sqlbelle]

Thank you for your comment Aditya. I hope you found the video useful 🙂

[@adityasharma8488]

@@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?

[@sqlbelle]

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! 🙂

[@brindhaganesan3580]

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.

[@AbhishekKumar-xd3qq]

Thanks a lot can't express my gratitude in words madam u helped me a lot

[@eltonjamesperia4533]

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.

[@sqlbelle]

Hi Elton! I mention the data source in kzbin.info/www/bejne/mXjEaIR6mtqYiqM ... or at the 1:46 mark of the video. This file comes with your Tableau installation. Hope this helps!

[@ericgoodman6101]

Great tutorial. I love your style 😍

[@sqlbelle]

Thanks Eric. I hope you are finding the content helpful! 🙂

[@EricPranger]

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?

[@EricPranger]

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.

[@ragragrec1]

Wonderfully done, and very easy to follow thankyou. Please have more of this

[@seematripathy]

Thank you so much. Your videos are so helpful. Could you please post Alteryx tutorial.

[@sqlbelle]

Thank you for the suggestion! :)

[@shrikant301991]

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

[@omelturk4609]

Well Done! Thank You !

[@sqlbelle]

Thank you Omel

[@kidsconer8660]

Awesome waiting for 2nd Part

[@sqlbelle]

Thank you! I just published the 2nd part of the series: kzbin.info/www/bejne/poeye2SCgpqWjpI Hope you find it useful! 🙂

[@rorylipsky]

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!

[@sqlbelle]

Thank you Rory for this recommendation for topic - I will try to create something similar in the future. Happy New Year!

[@dikshachourasiya9749]

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

[@sqlbelle]

Thank you Diksha. I usually use icons from flaticon.com or the noun project.

[@Barcetta1]

Thats pure genuis!

[@enjoylife-wr6pz]

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 :)

[@sqlbelle]

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 ""

[@enjoylife-wr6pz]

@@sqlbelle oh ok .. thank you :)

[@fataishuaib4728]

Really helpful contents. Thanks a lot!!!😊

[@sqlbelle]

Thank you Fatai!

[@pintusharma8484]

This video is really awesome, clean and clear and learned many small things. Thanks you so much😊

[@sqlbelle]

Thank you Pintu!

[@josephrolon7345]

where do I find the superstore dataset? I'm using Tableau Public. Is it available on this version?

[@sumitchhabra2419]

This is better than most of the udemy courses.

[@sqlbelle]

Thank you Sumit!

[@neilsanchez9169]

I love all your videos.... thanks

[@sqlbelle]

Thank you Neil! I hope you have found them useful 🙂

[@peterparker4358]

Nice ❤️ mam willl be waiting for second part design

[@sqlbelle]

Thank you Peter! The second part is coming in a few days 🙂 I hope you will find that useful as well!

[@ChithiAmmaUSA]

very well explained. Thank you

[@sqlbelle]

Thank you Chithi

[@eddyjo3259]

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 ?

[@sqlbelle]

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

[@eddyjo3259]

@@sqlbelle Thank you for the explanation. it is indeed helpful.

[@eddyjo3259]

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.

[@sqlbelle]

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 :)

[@RyanLBuchanan]

Sooo wonderful! Thank you so much!

[@sqlbelle]

Thank you Ryan!

[@vanireddy55]

Hi,i want to show dashboard to client for 5 min but client want to see 2 min .How we can do this.

[@adedamolaadegbola1256]

Thanks for this video. It has helped me greatly. Please do you have any video on joining multiple Power BI databases in Tableau?

[@sqlbelle]

Thank you Adedamola. Would you be able to elaborate what you mean by joining multiple Power BI databases?

[@adedamolaadegbola1256]

@@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

[@jeanmatitaputty9700]

hello, where can I get the data to follow your video ?

[@raniasaleh3999]

Amazing

[@sqlbelle]

Thank you Rania!

[@RishabhSharma-kq8go]

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 :)

[@sqlbelle]

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 🙂

[@chicomalo3700]

Love the speed/brevity. Dragging on and babbling about peripheral issues is such a problem in tech tutorials.

[@sumitchhabra2419]

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

[@sqlbelle]

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.

[@sumitchhabra2419]

@@sqlbelle Thanks a lot

[@yolindaburns3447]

This is SO useful. Love your videos!. Looking forward to part 2 ;-)

[@sqlbelle]

Yay! Thank you, happy to hear this Yolinda! 😀

[@vdn5716]

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..

[@sqlbelle]

I absolutely love receiving your feedback and suggestions VDN - thank you :)

[@rymensymen1994]

Great video ! :)

[@sqlbelle]

Thank you Simon 🙂

[@chaitanyalanka7043]

Mam it is good I want to know about dynamic date

[@rymensymen1994]

How do the shape .png files look like that you used. How can you create them for example with a snipet ?

[@sqlbelle]

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

[@magnumbi8396]

Could you post a video for Actions in tableau?thx

[@sqlbelle]

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!

[@maheshbarma]

Really nice one

[@sqlbelle]

Thank you Mahesh!

[@saikoushik8770]

Hello @sqlbelle I created the dashboard and I tried to publish but the huge numbers are reflecting as #####. What might be the reason?.

[@sqlbelle]

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.

[@saikoushik8770]

@@sqlbelle Thank you

[@cococnk388]

Thanks miss

[@sqlbelle]

Thank you coco

[@lillresonates7081]

Madam I'm creating two dashboards I want to show relation between them

[@sqlbelle]

Thank you Venugopala. You can potentially use dashboard actions, or even just the navigation button (in the Objects section) to get this to work.

[@samshepherd6197]

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.?

[@sqlbelle]

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: kzbin.info/www/bejne/mXjEaIR6mtqYiqM (note this part is at 1:46) ... and not the saved one that you see in the main screen. Thank you.

[@borazi4697]

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 ?

[@sqlbelle]

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.

[@ahmedshalaby9343]

you are amazing

[@dallinbeveridge9269]

Great dashboard, some feedback from an instructive point of view. You are going very fast in this video. It is hard to keep up.

[@sqlbelle]

Thank you for the feedback. I'm learning :)

[@Immortalismoriendum]

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.

[@calebh6442]

Get Good

[@br31woodlands69]

Too nice. Sub’d

[@anandsharan8286]

Thanks

[@anandsharan8286]

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. 🙏

[@sqlbelle]

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.

[@anandsharan8286]

@@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. 🤞

[@ultradevsoftsolution4855]

I can not grab and drop Order ID in measure Value

[@sqlbelle]

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.

[@ultradevsoftsolution4855]

@@sqlbelle thanks a lot ,you are providing good teaching lesson to us

[@cautiousrebel84]

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.

[@sqlbelle]

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!

[@ericord2]

You are going lightspeed with every step in this tutorial. Take a breath and slow down!

[@sqlbelle]

Thanks Eric for the feedback. Im learning :)

[@sudhirpv8661]

In the first vidio you some complicated things ...i find hard ...u are so fast also

[@derekchurch1519]

Normal playback speed was like 1.75 speed hahah i had to watch the video at .5 to follow along correctly

[@andrewm8168]

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

[@sqlbelle]

Thank you Andrew

[@j.peterson4480]

I pause, I rewind. Repeat as necessary. Not a problem.

[@neelnickkey4865]

Thanks @sqlbelle !!!c

[@sqlbelle]

Thank you Neel!