She is the best professor by far. She is calm, so generous, focused, detail-oriented, and goal-oriented. Probably explaining things deeply, pragmatically, simply, and easily is the source of her happiness. God bless the geniuses!
I am simply loving that course. I have one question regarding the joins in the physical table: 17:27, when you did the joins the number of rows was increased (I assume it is because of multiple matches between the different tables, leading to duplicate rows in the "one" table in a "one to many" relationship). The question is: when we aggregate measures from the one table, will they be aggregated considering the duplicated rows, or the aggregations will be performed at that table level?
Yes, when you aggregate on measures from the "one" table, they will be aggregated considering the duplicates generated by the join. In other words, the aggregations (sum, average, etc.) will be performed on the values of the duplicate rows, not just on the unique values of the "one" table. To avoid this unwanted behavior, you need to make sure that your aggregations are done correctly, perhaps using LOD (Level of Detail) calculations or other techniques to ensure that the aggregation is performed at the level of the "one" table and not on the duplicates created by the join.
actually i could not save this mean which are prepare sheet practice in my desktop either u use trail version well my are public desktop version i dwnload what i do?
Check your view sheet, bottom right, you should see something like 11 unknown, click it. It will show you all the states and it would say unrecognized. Above it should be something like location, not sure again. but it would show you your current country location. you have to change it to united states to see the colors as represented in the video.
Getting a Bad Connection error when I try to click on map from the show me section. An error occurred while communicating with the Tableau Data Extract data source 'GeocodingData' Bad Connection: Tableau could not connect to the data source. Error Code: AC0843EA Could not start Hyper: Failed to start a new Hyper instance. Context: 0x86a93465 Caused by: The Hyper server process exited during startup with exit code: 1
Child process' stderr: Unable to open log file: SetFileInformationByHandle(): The cloud file provider is not running. FileListener in error state after initial rotate()
Check the hyperd log for more information
Context: 0x13cead20 Unable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.
In Menu Bar, go to Map -> Edit and play with settings there. I am from Germany and none of the maps used to load. By changing some settings had it all sorted out.
Hello Nong! That data source is included when you download Tableau. You can also download the file here: community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls
Exercise Files: learnitanytime.com/p/exercise-files-tableau-basics-beginner-tutorial
She is the best professor by far. She is calm, so generous, focused, detail-oriented, and goal-oriented. Probably explaining things deeply, pragmatically, simply, and easily is the source of her happiness. God bless the geniuses!
Thank you for the kind words!
The BEST tutorial on Tableau on RUclips! Thank you very much, you are really one of your kind. Thank you again!!
You're very welcome!
at 22:07 did you add "ship state/province" to both columns and rows?
Awesome Tutorial , Taking care of all the minute details. Its like takin hand of a child and teach him to walk
Glad you liked it!
❤❤ thank you for taking the time to do this live!
You are very welcome!
I am simply loving that course. I have one question regarding the joins in the physical table: 17:27, when you did the joins the number of rows was increased (I assume it is because of multiple matches between the different tables, leading to duplicate rows in the "one" table in a "one to many" relationship).
The question is: when we aggregate measures from the one table, will they be aggregated considering the duplicated rows, or the aggregations will be performed at that table level?
Yes, when you aggregate on measures from the "one" table, they will be aggregated considering the duplicates generated by the join. In other words, the aggregations (sum, average, etc.) will be performed on the values of the duplicate rows, not just on the unique values of the "one" table.
To avoid this unwanted behavior, you need to make sure that your aggregations are done correctly, perhaps using LOD (Level of Detail) calculations or other techniques to ensure that the aggregation is performed at the level of the "one" table and not on the duplicates created by the join.
Thanks a lot, you are really detailed and easy to understand.
You are very welcome!
Excellent training. Thank you!
Glad you enjoyed it!
Thanks for explanatory video. How many module do you have in all?
34 for this video
Tableau Public is unable to open the accdb file. Access 2007 cannot recognize the database format. How do I proceed from there? Thank you.
This course was created using the Desktop version of Tableau. Tableau Public only supports a limited amount of file extensions.
@@LearnitTraining Would you be able to share the same accdb file data in csv/excel file format so that tableau public can read it?
Thank you for this course ❤
You're so welcome!
actually i could not save this mean which are prepare sheet practice in my desktop either u use trail version well my are public desktop version i dwnload what i do?
At 22:30, I dont see the my colored for the states - its all blank
Check your view sheet, bottom right, you should see something like 11 unknown, click it. It will show you all the states and it would say unrecognized. Above it should be something like location, not sure again. but it would show you your current country location. you have to change it to united states to see the colors as represented in the video.
@@MomentswithPstB thank you for your great answer
@@MomentswithPstB thanks a lot! this helped!
@@MomentswithPstB i had the same question, thanks!
@@MomentswithPstB thank you! same issue
A decent job! Thanks!
Glad you liked it!
Great Course!
Glad you think so!
this map don't working for me i did evrythink like in a guide but i don't see the collors on my map
tableau does not support Microsoft Access files when using Mac..so I am stuck in the northwind file😥
Yeah unfortunately Microsoft never released Access on Mac
actually those who not use trail version cnt seem similer like outline of usa map why not u use public version for teach us
Thank u 👍
Welcome 😊
the best lesson i have ever learned :v
Thank you for the kind words!
Please share this presentation file
They are in the exercise files
Getting a Bad Connection error when I try to click on map from the show me section.
An error occurred while communicating with the Tableau Data Extract data source 'GeocodingData'
Bad Connection: Tableau could not connect to the data source.
Error Code: AC0843EA
Could not start Hyper: Failed to start a new Hyper instance.
Context: 0x86a93465
Caused by:
The Hyper server process exited during startup with exit code: 1
Child process' stderr:
Unable to open log file: SetFileInformationByHandle(): The cloud file provider is not running.
FileListener in error state after initial rotate()
Check the hyperd log for more information
Context: 0x13cead20
Unable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.
Hello Blackronin357! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
UK viewer, the map with states does not load, but the one with countries does. How do I fix it? 22:33
In Menu Bar, go to Map -> Edit and play with settings there. I am from Germany and none of the maps used to load. By changing some settings had it all sorted out.
bro am having that issue i dont see the menu guidness plz@@eminjs2319
Thank you@@eminjs2319 Next you just have to set to United states
@@eminjs2319 Thanks man! I was having the same issue. Your suggestion fixed it!
Hi there
, in module 2 Sample-superstore can't be found. could you sahre?
Hello Nong! That data source is included when you download Tableau. You can also download the file here: community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls
You need the paid version to open a Microsoft Access file, bummer
You can use the free 14 day trial that Tableau offers - www.tableau.com/products/trial
I think Tableau Public can open MS ACCESS freely
1:10:00 This file, I can't do like you.
the columns are not separated, they are combined into one column
Hello Bằng Nguyễn Đức! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/