Exam Prep - Domain 1 (Connect to and Transform Data)
Вставка
- Опубліковано 23 лип 2024
- #tableaucertification #dataanalyst #examguide
In this exam prep, we provide you with a detailed overview of Domain 1 and its subsections, to help you prepare for the the official exam.
This exam prep is a part of a 4-week learning path, which will help you study for the Tableau Certified Data Analyst Exam through practice exercises and guided overview of the official exam guide.
Learn more about Tableau Certified Data Analyst Exam. www.tableau.com/learn/certifi...
Download your own copy of the full Tableau Certified Data Analyst Exam Guide.
mkt.tableau.com/files/Tableau...
*****
Check Out These Tutorials:
▪ Interactive Tutorial:
www.tableau.com/sites/default...
▪ Performance-based Tutorial:
www.tableau.com/sites/default...
Let us know your thoughts about the exam and if you were successful in clearing it in the comments below, and don’t forget to subscribe to our channel for more exam content and tutorials!
*****
Timestamps:
0:00 - Introduction
0:19 - Connect to Data Sources (subs 1.1)
1:58 - Review these SQL Commands
3:23 - Prep Data for Analysis/Transform Data in Tableau Prep (sub 1.2-1.3)
6:35 - Review these for Tableau Prep
6:53 - Know your Joins!
8:04 - Focus on the following for Domain 1
8:44 - Watch More Videos!
*****
Additional Resources for Domain 1 Topics:
Split vs Custom Split:
help.tableau.com/current/pro/...
Pivot Your Data:
help.tableau.com/current/pro/...
Data Interpreter:
help.tableau.com/current/pro/...
Joins:
help.tableau.com/current/pro/...
Tableau Prep Learning Resources:
www.tableau.com/about/blog/20...
Tableau Null Functions:
tarsolutions.co.uk/blog/null-...
help.tableau.com/current/pro/...
Primary Keys:
www.w3schools.com/sql/sql_pri...
*****
At DSCOVR Analytics we can help you unleash the power of your data with Tableau, a data visualization tool that has been recognized as the leading Analytics and Business Intelligence platform for 9 years in a row!
This channel’s mission is to help people just like you discover the beautiful world of data! We will guide you through every step to help you start solving problems like a real data scientist!
*****
#dscovranalytics #datadriven #businessolutions
Thank you for making these videos! I have just passed my exam yesterday, and I met with several questions you mentioned :D
Congratulations, well done!!! We are super excited to hear the great news!
Thank you
I passed!!! Thanks to your review videos! Awesome content and overview! I used it to guide my studying. Thanks DSCOVR Analytics!
That's awesome!!! Well done Jordan! So happy to hear about your success 😊🥳🎉
Hey Jordan, what did you think of the exam?
@@DSCOVRAnalytics It was a mix of easy and tricky questions. But 100% there was a benefit from using your exam guide. The test covers topics that I have never needed in my particular applications of Tableau. Some of the questions I also felt had responses that had more than one correct answer. But in the lab portion, every activity was easy, and I was surprised they even included a pdf of the help on the desktop of the virtual machine. I'm a very slow worker and even I finished in time.
The information you share through your videos are beyond expectations. Thank you for making such informative video. Could you please upload rest of the Domains related videos?
Thank you for your kind feedback Riya! I will be uploading new domain content next week, including additional exercises and a mock-up lab workbook 😊.
@@DSCOVRAnalytics Waiting eagerly already🙂
Hi Riya, I'm working on it now (I'll have it uploaded on Thursday). When are you planning to write the exam?
@@DSCOVRAnalytics Hey I am planning to write by 15th August (Monday)
I think in one question, the placing of customer should also be specified like, left or right. Else it can be left join or right join both are correct since we don't know the placement.
That's a really great point, and yes both are correct because the placement of the tables isn't specified. These types of questions will typically have a similar format on the actual exam, where it may not mention the explicit placement of the tables!!! It was a little confusing for me also.
Thanks for all your efforts in preparing these videos. These are super useful for brushing up Tableau concepts and really help in preparing for the Tableau Certified Data Analyst Exam. 👍💯
I just had one doubt regarding the last set of topics (time stamp 8:04 - Focus on the following for Domain 1) that you had mentioned regarding Tableau Desktop i.e. starting from "Functions (ISNULL, IFNULL, ZN, LOOKUP)" and ending with "Know the definition of a primary and secondary key".
Can you please provide the correct reference link for these topics because you have mentioned the same Tableau Prep reference link for these topics too?
Hi Deepak, happy to share what I've learned and thank you for noticing the missing links. I've updated the resources! :)
Hi. thank you for sharing videos. i have two questions.
1)is there any video tutorial that can prepare us like udemy or coursera?
2) i just passed tableau dekstop specialist exam. now i want to prepare tableau data analyst exam. how long i will need to prepare?
3)where can i practice real exam questions?
This is an excellent exam guide and you've helped me understand lots of things!
Just a quick question on replacing nulls with 0's.
I believe the calculations IFNull([Sales],0) and ZN([Sales]) would also change the nulls into 0's (and I think at a row level? so it would aggregate as SUM when the calculation is placed into view. Please correct me if I'm wrong though).
Can you help me understand why the ZN(LOOKUP(SUM([Sales],0)) is the choice in this scenario?
Hi Andrew, that's an excellent question! There is one thing you need to keep in mind, empty or null values are not the same as missing data! Let's say you're looking at Sub-Category Sales for Copiers broken out by month of order date, and you see sales values for Jan, Feb and March, but no value for April. If you take a closer look at the underlying data, you may see that this data is missing because there weren't any orders placed for that particular Sub-Category during the month of April.
When you combine dimensions and measures to create a view in Tableau, the records/data may not be in the underlying table, but its existence is implied. For cases where the data is implied but does not actually exist (missing data), we have to use ZN LOOKUP. But if the data is simply not keyed in, then we can use ZN or IFNull. I hope that helps!
@@DSCOVRAnalytics That was a fantastic explanation! Thank you so much for replying, I love learning new things like this.😁
@@DSCOVRAnalytics Hi, how about ZN(SUM([Sales]))? does it work?
at 2:19 I don't understand why the order would be 2,1,3. Why would you select New Workbook before you pick the data source? I just tried it and was able to do 2, 3,1. Could your answer be wrong? or have two possible correct answers?
Hi Jordan, there are two correct answers here! Selecting 2, 1 will prompt you to connect to a data source, then you can make your selection using option 3. Your approach will give the same result. Except that you select the data source first and then create a workbook based on selection.
I think 2,3,1 is the only right answer.
I also believe 2,3,1 is the only right answer - it works perfectly well, while 2,1,3 doesn't match
How do we do "Replace the connected data source with another data source for an existing chart or sheet"?
Hey Jacob, this article will walk you through all the steps: medium.com/@kumarankita764/replace-data-source-without-recreating-reports-in-tableau-65258af37cfc
@@DSCOVRAnalytics thank you
Happy to help 😊
COULD U PLEASE SHARE THE PPT YOU USED IN THE PRESESNTATION
Hi Swetha, I can share the template if you like but not the actual exam material. Let me know if this is what you're looking for.
7:01 I think the answer is C. Does anyone else want to help me understand why the answer is marked d? In order to get the order ID you have to use the right side of the table named orders especially since you can have unique customerIDs appear in the orders table. Maybe the question is just unclear because they don't differentiate if a customer is defined by customer name or ID or either.
Hi Jordan, the customers table contains all the customers including those who haven't placed any orders, so they wouldn't show up in the orders table. In the resulting output we want to display all customers, including the ones without an order ID, so we need to use a left join to capture all existing customers in the system. The right join will only display customers who have placed one or more orders and have associated order IDs.
@@DSCOVRAnalytics That makes sense, I just needed to understand a little more about the particular data set. I'm loving your videos!
Thanks for you feedback Jordan! Great questions, keep them coming! 👍☺️
Q5 answer should be "Ifnull([sales],0)"
Yeah I don't understand what Tableau is trying to prove/test with this kind of question. ZN[Sales] would produce the same 0 result just as would IFNULL([Sales],0). I think the trick is that both the ZN and IFNULL approach would require replacing the Sales in the marks with the newly calculated field (which would then be aggregated)? The ZN(LOOKUP(SUM([Sales],0) is also effective because the offset is 0. I guess the only difference here is that it summing in the formula itself, but to me that does not mean the other solutions are effective provided they are also summed. The LOOKUP based formula would still need to be brought into the marks replacing Sales. To me this is Tableau trying to be tricky rather than test competency, and it kind of pisses me off given we have to pay $250 to take a swing at this certification.