Tableau Certification - Desktop Certified Associate Exam Guide - Hands On Questions Part 1| sqlbelle

[@annam9219]

Fantastic job! Your overview's pace is perfect, your explanation of the keywords in the problems is most helpful, and your explanations are short and to the point. Thank you for taking the time to create these videos! I've taken Udemy courses, which explain the concepts, but you take it one step further by reviewing the exam guide questions. Understanding the question is 97% of what is needed to pass the exam...I use Tableau daily at work, but I'm never asked questions the same way that Tableau likes to phrase them on the exam. Thanks again!

[@sqlbelle]

Hi Anna, Thank you so much for your comment! I am very happy to hear that you found the video useful. There are a lot of fantastic resources everywhere, and I am just hoping there will bits that people will find useful in these videos. I use Tableau everyday too, and yes, the exam questions can be a little bit tricky to decipher sometimes. Thank you again for taking the time to leave a comment, much appreciated! Take care, Donabel

[@nknareshkumar]

Hi Belle, today I successfully completed my Tableau Desktop Specialist certification exam. I would like to say your content and work played a major roll in it. Thanks a lot ✌️

[@sqlbelle]

Congratulations Naresh!! SO happy for you :)

[@vijayarjunwadkar]

I regret to have found and explore your channel late, but just a few of your videos including this one convinced me that, I may be late but not out! Love the way you present the topics crisply with just the right pace and enough examples to help one understand best! Thanks a lot! 😊👍

[@sqlbelle]

Hello Vijay, thank you so much for such a kind and generous note! I am happy to hear you found the videos useful 🙂

[@thomasjirku7548]

Love the walkthroughs as they are easy to follow and I was able to catch up really quickly ! Thank you for the work you put into this and share this with others !!

[@sqlbelle]

Thank you so much for your kind note, Thomas! So happy to hear you found the walkthrough helpful :)

[@shrikantjatav2352]

😅​@@sqlbelle

[@BoxerDogs]

Wow. This was helpful. It's good to see the different ways you can arrive at a solution.

[@sqlbelle]

Thank you for your comment! Glad you found it helpful! 🙂

[@Hooleey]

Exactly what I needed. Can't say thanks enough!

[@sqlbelle]

Thank you so much for your feedback, Daniel. Glad you found it useful!

[@englishladylady6919]

Thanks so much. If you add more videos related to this tableau c. a it would be brilliant!

[@sqlbelle]

Thank you for your comment! Part 2 of the hands on certified associate certification walkthrough will be up by tomorrow! I am planning to have additional similar videos on problem solving and just general hands-on and walkthroughs.

[@nbkwdpu]

Can you create some practice exams kind stuff and post it in udemy..

[@sqlbelle]

@@nbkwdpu Thank you for your note. I will definitely consider it, thank you for your suggestion :)

[@puja4079]

Wonderful awesome teaching..but just one suggestion..please reduce the background music ..it’s too loud

[@sqlbelle]

Thank you Mike. I have removed the background music for the later tutorials.

[@Ravit20]

Very helpful, Donabelle!

[@sqlbelle]

Thank you Ravit! #GrowTogether! :)

[@oyungerelganbat9301]

Thank you for your helpful content. One question. On Q5, when you filter SUM(Sales) why don't just select 1 and 2 on the checkbox, why it needs to be changed into continues, and then select the range? It gives me different answers and I am confused with the difference. Besides that, it would be great if you could go over the window_avg function for your next video.

[@indrewhite]

Love your training videos! Do you have anything for the new tableau certification SCA-C01?

[@sqlbelle]

Thank you Indre! I don't have anything specific to the certification, but a number of the topics I recently posted are included in the certs (for example, the last 2 videos on actions)

[@little_flowerq9224]

It is very helpful. thanks.

[@sqlbelle]

Thank you! Glad to hear that 🙂

[@ni12907]

Awesome tutorial. Just a quick question, for Question 8, would (Level of Detail) LOD FIXED work with REGION as Dimension and AVG(PROFIT) as the measure for the calculated field "Overall Average Profit" ? Thanks

[@sqlbelle]

Thank you Nishi. It will work with AVG{FIXED Region: SUM(Profit)} Note in here that we are averaging the SUMs of profit (each bar is a SUM). AVG(Profit) will simply get an average across all individual profit values, not the profit for the region. If you try it out, you will find that AVG(Profit) will yield a much lower value than what you would expect. Hope this helps! Donabel

[@ni12907]

@@sqlbelle Makes sense, Thank you Donabel!

[@sonalteke8178]

@@sqlbelle Thanks @sqlbelle for confirming that it would work using LOD,however when tried with AVG({FIXED Region:SUM(Profit)}) its giving the same result as SUM(Profit) for a Region rather than an Average.It would be kind of you to show the calculation of Overall Average Profit using LOD

[@kanchidoshi6907]

For Q7, can you please explain again why you multipled by 1.5?

[@rosalieo5045]

Amazing video, thank you!!

[@sqlbelle]

Thank you Rosalie! 😀

[@jasjyotsingh2007]

Thanks for such a nice video. I am however confused about the answer for Q7 because we have the data for 2013 but we are using it to answer question for 2014. Can you give sm more details on that

[@sqlbelle]

Hello Jasjyot, Thank you for your feedback. Here is Q7: If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014? Basically it is asking us to look at 2013 Sales numbers. Once we get the sales for 2013, it is asking us what it would be if it were to increase by 50% So (2013 Sales) + 50% of 2013 Sales. This is only to estimate what 2014 sales could have been (assuming that it was a future year). The question isn't asking us to look at the actual 2014 sales. Does this help? Donabel

[@jasjyotsingh2007]

@@sqlbelle that really explains it all..Can u help me with one more doubt..Does the VM in the exam take over complete control from the user in the sense that u cant do anything on the main desktoo screen...the reason i ask is that i have a weak internet connection and may want to switch to an alternate wifi in case something happend . Also i read from one of the cohnrses that ctrl and escape dont work in the VM ? Can u suggest the alternative

[@sqlbelle]

Hello Jasjyot, This is what I recall from the last time I took the exam. - That is correct, you are not allowed to use your desktop. You can only work on the VM you are provided. I am not sure what provisions you will have if internet gets disconnected. You may want to connect with the Loyalist Exam providers to ask ahead of time. You may lose time if you get disconnected, or you may automatically fail that exam. - That is right, certain keys and key combinations will not work (or may cause you to get disconnected from the exam VM, in which case will cause you to lose time). Many of the Tableau shortcuts can be done the long way (for example through the menu or by duplicating the steps on another pill). I hope this helps, Donabel

[@sqlbelle]

PS Sorry Jasjyot, I misspelled your name earlier! I have corrected it now.

[@GuruprakashAcademy]

Very useful

[@sqlbelle]

Glad to hear that!

[@visheshsekhsaria4323]

Hey Can you upload a video to explain Window sum/avg and Total functions in tableau. If already uploaded please share the link. Thanks in advance.

[@sqlbelle]

Thanks Vishesh. I don't have these yet, but I do have this planned. One will be on table calculation functions like Total, Window; another is on advanced table calcs.

[@sqlbelle]

I do have some sections in the Parameters video that tackles total (see 12:05 in that video) or use this link kzbin.info/www/bejne/ZobEo5J6apyEnrc

[@visheshsekhsaria4323]

Thanks for replying sqlbelle. I will wait for your video. Keep posting.

[@wrightandrea9465]

Bless your soul

[@sqlbelle]

Thank you Andrea! :) :)

[@little_flowerq9224]

where I can find the 2nd part walk through

[@sqlbelle]

Here is the playlist: kzbin.info/aero/PLkZ_g9Y7eszJAm-ZbUT7jnldrl-uF-bWe

[@muetefekkir]

Hey, do you know whether there is a huge difference between Certified Associate Desktop and Consultant? Im going to do the consultant certification. I couldnt find any good information...

[@sqlbelle]

Hello Ayhan, No I am not familiar with how the consultant exam parallels the certified associate.

[@agape13]

🏆🥇👑

[@sqlbelle]

🙂