Down to Earth Data Tips
Down to Earth Data Tips
  • 21
  • 101 249
From OKAY to FLUENT: 4 TIPS for WORKING in a FOREIGN LANGUAGE
Do you live abroad and would like to start working in the local language?
Here are my top 4 tips on how to do that :)
Timestamps
00:00 intro
00:32 TIP 1 to WORK in a Foreign Language
01:03 TIP 2 to WORK in a Foreign Language
01:33 TIP 3 to WORK in a Foreign Language
2:08 TIP 3 to WORK in a Foreign Language
Переглядів: 68

Відео

I tried Tableau's Sankey Chart Extension so you don't have to
Переглядів 1,2 тис.5 місяців тому
Here is my attempt at using Tableau's very own Sankey chart extension. It's quite nice but can definitely be improved. Huge shoutout to Zainab Ayodimeji who created the original visualization: public.tableau.com/app/profile/zainab2225/viz/UEFAEuro2020-JourneytoFInals/EURO2020 And you can check out my visualization here: public.tableau.com/app/profile/gaia2128/viz/VNL2024ItalytakestheGold/Italys...
Change "Last Updated At" Timezone in your Dashboard (Snowflake + Tableau or other BI tool)
Переглядів 475Рік тому
Here's another quick tip from working with Tableau Snowflake! Change the timezone of your Snowflake account rather than changing the timezone of fields in each dashboard in your organization. Timestamps 0:00 Why Add Last Updated At to your Dashboard 0:41 Change Default Timezone of your Snowflake Account
Data Validation with SQL (Validate your Dataset in Three Steps)
Переглядів 3,4 тис.Рік тому
Working as an analytics engineer, I have developed a systematic method for technical data validation, which encompasses three steps: checking level of detail, columns and sources, and data type. I work with a datastack that includes #snowflake , #dbt , and #tableau , but the same principles can be applied to other tools as well. Timestamps 0:00 Intro LEVEL OF DETAIL 0:15 Validate the Level of D...
Make Safer Connections with Key Pair Authentication in Snowflake (and also in #dbt)
Переглядів 7 тис.Рік тому
Weary of using username and password for linking #snowflake with other tool? Learn how to set up Key Pair Authentication in this step by step tutorial! The second part of the video explains how to connect the key pair to #dbt - the process is similar for other tools (e.g. #Fivetran). Timestamps 00:00 intro 00:21 Generate Private Key for Key Pair Authentication 00:35 Add Password (Passphrase) fo...
Rename a Dimension Header in Tableau (Without Renaming the Column)
Переглядів 11 тис.Рік тому
Quickly learn how to Rename the Dimension Headers in a Graph or Table in Tableau without actually Renaming the underlying Field! This method will allow you to keep the field's original name while displaying a different name within a graph or a table in Tableau. Timestamps 00:00 Intro 00:24 How to change a Dimension's name within a graph or a Table (without renaming the field) Knowledge Base art...
Install and Get Started with SnowSQL (Log in with Google Authentication)
Переглядів 8132 роки тому
Learn how to install and get started with SnowSQL in this short video, especially if you log into your Snowflake account using Google Authentication SnowSQL can be useful for carrying out commands such as a PUT command, which allows us to upload files from our local machine onto our Snowflake account. Timestamp: 00:00 What is SnowSQL 00:19 How to Download and Install SnowSQL 00:49 Get started w...
Set a Limit to Query Runtime [in Snowflake]
Переглядів 3582 роки тому
Learn how to set a Query Runtime Limit with #parameters in #snowflake Timestamps 00:00 intro 00:02 Why add a Query Runtime Limit? 00:23 How to Set a Limit to Query Runtime in Snowflake 01:07 How to Set a Limit to Query Runtime in Snowflake (Demo) Check out Snowflake's documentation here: docs.snowflake.com/en/sql-reference/parameters.html#statement-timeout-in-seconds
Exclude Values from a Quick Filter [in Tableau]
Переглядів 4,3 тис.2 роки тому
Hey there! If you are looking to learn how to exclude values from a quick filter in Tableau, you came to the right place. Timestamps: 00:00 Intro 00:18 How to Exclude Values from a Quick Filter [in Tableau] Check out the Tableau Knowledge Base article on this topic: kb.tableau.com/articles/howto/hiding-null-values-from-quick-filters
How to combine Map Layers and Filter Actions in Tableau
Переглядів 7 тис.2 роки тому
Are you struggling to get a Filter Action to work on a Map that contains Map Layers in Tableau? You are not alone! In this video I will show you how to get your Map Layers and Filter Actions to interact the way you want them to, with just a couple extra clicks. Timestamps 0:00 Intro 0:11 How to combine Map Layers and Filter Actions in Tableau Dashboard public.tableau.com/app/profile/gaia2128/vi...
Snowflake: Load Metadata into a Table (Based on a Condition) - Frosty Friday Week 3
Переглядів 3532 роки тому
Learn how to load metadata from an s3 bucket into a table in Snowflake based on data contained in another table! If you are interested in the solution only, please skip to 14:54 If you are interested in seeing my thought process, here are the timestamps for the whole video :) 00:00 Intro 00:13 Snowflake Frosty Friday Week 3 Assignment 01:36: Create File Format and Stage in Snowflake 01:58 Query...
Snowflake: Load Data from an s3 bucket (Frosty Friday Week 1)
Переглядів 4662 роки тому
Learn how to Load Data from an s3 bucket in #Snowflake with the new Frosty Friday challenge! Here is the link to the challenge: frostyfriday.org/2022/07/14/week-1/ If you just wanna see the solution, please go to minute 7:30. The rest of the video shows how I got to the solution through a bit of trial and error following Snowflake documentation. Timestamps: 0:00 Intro 01:21 Create a File Format...
How to Create an Drill Down Donut Chart [in Tableau]
Переглядів 26 тис.2 роки тому
Learn How to Create a Drill Down Donut Chart in Tableau! This type of chart is also known as Expanding Donut Chart. In this beginner-friendly Tutorial, I am going to follow the PlayFair Data's blog and go into detail for each step of the process. At the end of the video, I provide a couple of ideas of how to insert this type of chart in a dashboard. Get ready to use your #ParameterAction and ov...
How to Sort with a Parameter in Tableau [Tableau Tips]
Переглядів 2,6 тис.2 роки тому
Is Tableau not sorting the was you expect it to? Use a parameter to be able to sort by any field in the view. This solution was also posted by Tableau themselves, you can find their blog here: kb.tableau.com/articles/howto/creating-a-parameter-control-to-sort-by-dimension Timestamps 0:00 Overview 0:24 Tableau sorting limitations 1:08 Create custom sorting with a parameter
Enhance your Tables in Tableau [A Step by Step Guide]
Переглядів 11 тис.2 роки тому
[Timestamps below] Learn how to personalize your #tables in #Tableau and #improve user experience with this video tutorial! You can also download a version similar to the one in the video from my Tableau Public and have a look at the back end: public.tableau.com/app/profile/gaia2128/viz/BuildbetterTables-Volleyballchampionshipschedule/XenonD3 Here is the link to Ludovic Tavernier's workbook whi...
Filter out a Column in Tableau [with an LOD filter]
Переглядів 1,6 тис.2 роки тому
Filter out a Column in Tableau [with an LOD filter]
Highlight a complete row (in a Tableau Table)
Переглядів 4,9 тис.2 роки тому
Highlight a complete row (in a Tableau Table)
Compare periods of time (in Tableau)
Переглядів 3,1 тис.2 роки тому
Compare periods of time (in Tableau)
How to Combine Figma and Tableau (in 4 Steps)
Переглядів 10 тис.3 роки тому
How to Combine Figma and Tableau (in 4 Steps)
Drill down rounded bars with parameter actions in Tableau
Переглядів 3933 роки тому
Drill down rounded bars with parameter actions in Tableau
Creating a Homepage in Tableau (MakeoverMonday)
Переглядів 4,4 тис.3 роки тому
Creating a Homepage in Tableau (MakeoverMonday)

КОМЕНТАРІ

  • @PriscilaWolff-Hohberg
    @PriscilaWolff-Hohberg Місяць тому

    amazing, thanks!

  • @vikrantmakar4597
    @vikrantmakar4597 Місяць тому

    Great work

  • @nethermit
    @nethermit Місяць тому

    I love your accent! I could really listen to you talk all evening.

  • @sirlanceohlot
    @sirlanceohlot Місяць тому

    Thank you for clarifying at the end the need for BEGIN & END PRIVATE KEY statements, had that issue with my snowflake connector until I came across your video and tried it out :)

  • @FasfasFas-c8g
    @FasfasFas-c8g 2 місяці тому

    This is incredible and makes some really pretty tables, but unfortunately you can't do some basic stuff like resizing individual columns, since all of them have to be the same width :(

  • @Delberx
    @Delberx 2 місяці тому

    Amazing! thank you so much!!

  • @VincentSellmer
    @VincentSellmer 3 місяці тому

    Quite disappointed with this. Was also very excited for a short while but vital features are missing. Both for levels and links I need to add the shares / absolute values as a label that's it, all other limitations would be fine. This is just not supported. How to use the diagram in a business context without the ability to actually show how much of the flow is going where is a mystery to me. In the early promo videos of this labels even existed they removed them later. Tableaus attitude is not what I expect of a business parter.

    • @downtoearthdatatips
      @downtoearthdatatips 3 місяці тому

      "hacky" solutions still seem to be the best go-to for the time being...

  • @firstname4337
    @firstname4337 3 місяці тому

    I wish I could upvote this 1000 times

  • @ldddh7002
    @ldddh7002 3 місяці тому

    Thank you!! It worked! I spent 2 hrs to find the solution.

  • @samestate11
    @samestate11 4 місяці тому

    Excellent video

  • @kimstrezz
    @kimstrezz 5 місяців тому

    I had very similar experiences with this extension. I used to build them from scratch and was *so* excited to not have to build a million calculations per category and curve. But for my use cases (following groups of students over time) it's critical that I can keep colors and tooltips consistent over the course of a chart to show flow patterns. This is a huge leap forward, but I think I'll need to keep my manual versions for a while longer. Thanks for this video. It helped confirm what I was seeing and ensured I wasn't missing something critical. :)

    • @downtoearthdatatips
      @downtoearthdatatips 5 місяців тому

      Thank you for sharing your experience! I've been trying to share this feedback on the Tableau Community platform but I am unable to add a comment due to errors...this is the link, where I'm trying to share the comment: community.tableau.com/s/idea/0874T000000H9oeQAC/detail If you manage to comment let me know and I will like it too :)

  • @kamalkrsnadas364
    @kamalkrsnadas364 5 місяців тому

    Welcome Back! Hope you post some more amazing tutorials 🎉

  • @tailethanh8074
    @tailethanh8074 5 місяців тому

    I didn't know there is a tutorial for this, I asked on the community but gained nothing from it. Thanks for the video.

    • @tailethanh8074
      @tailethanh8074 5 місяців тому

      now I know how to use -1 0 1 to align columns in tableau

  • @darkonimbus
    @darkonimbus 6 місяців тому

    Exactly what I needed

  • @joshua_pasafarming
    @joshua_pasafarming 7 місяців тому

    OMG...thank you for this! The user forums and other resources always have such outdated materials...this was exactly what I needed...thanks!!

  • @sumonigupta
    @sumonigupta 8 місяців тому

    If not notice, the moment you convert a numerical value to a string, in this case Sales, Tableau converted your Sales value to ASCII characters values and tried to sort Sales based on ASCII character value and not actual sales values. Hence 274 is ranked 8th while 2896 is below that, which is factually incorrect!

  • @LP-ur7cx
    @LP-ur7cx 8 місяців тому

    I am at the create dynamic labels section and I am using COUNT instead of SUM (that is the most appropriate for the data I am using). However, it will not produce a null, it shows a zero for all false statement for the subcategory filter. Is there a way around this?

  • @zeeshanahmed9719
    @zeeshanahmed9719 8 місяців тому

    Great explaination.

  • @linaalani816
    @linaalani816 8 місяців тому

    What is the ld field

  • @nunyab8003
    @nunyab8003 8 місяців тому

    Thanks!

  • @mariepoujardieu3619
    @mariepoujardieu3619 8 місяців тому

    One of the best tip ever! Thank you so much for sharing it

  • @nicoi7662
    @nicoi7662 9 місяців тому

    Brilliant and clear and concise explanations!

  • @grisdymahardikana8372
    @grisdymahardikana8372 9 місяців тому

    Thank you for sharing

  • @Jeff-pi9po
    @Jeff-pi9po 9 місяців тому

    The detailed explanation is really good. This is a perfect video. thank you

  • @detalkinet2878
    @detalkinet2878 10 місяців тому

    Wow. That's amazing! So clear explanation for this not so easy visualization. Thank you!

  • @ChungNguyen-iv2up
    @ChungNguyen-iv2up 10 місяців тому

    Awesome clear and fast enough

  • @SirCristianoLopes
    @SirCristianoLopes 10 місяців тому

    Love you. Thanks!

  • @AmritSingh-qc5fr
    @AmritSingh-qc5fr 10 місяців тому

    Amazinggggggg!!!! You are a life saver!! Getting thrown into Tableau for work w/ basically no training on how to use it. This was so helpful and informative!! Every single other tutorial on sorting w/ parameters was so unhelpful. Luckily this vid was recommended to me by UA-cam. It was so easy to follow and understand. I hope you come back and continue making videos! Would love it if you could make a tutorial on how to switch visualizations based on parameters/filters! 🙂

  • @ocean0v0
    @ocean0v0 10 місяців тому

    Really helpful, super thanks ! ❤

  • @veropictures_
    @veropictures_ 10 місяців тому

    Thank you for this tutorial!

  • @MrCheney22
    @MrCheney22 11 місяців тому

    Thank you, this is exactly what I needed to know!

  • @divyareddy3072
    @divyareddy3072 11 місяців тому

    Thank you so much for making this version. I have been searching for one all youtube. Please make some other workbooks with desktop version too ❤

  • @wisdou2001
    @wisdou2001 Рік тому

    Such a great video, thank you so much. I do have a small problem after I applied the "dynamic" calculations the chart display the values for the selected sub-categories but it also shows '0' for the other subcategories even thought they are greyed out. I am hoping you might know a way to display the values for the selected subcategory only. Again great video and thank you.

    • @mansi4495
      @mansi4495 11 місяців тому

      FACING THE SAME PROBLEM.

    • @mansi4495
      @mansi4495 11 місяців тому

      coined a workaround - create another calculated field that uses the 'Dynamic subcategory sales label" and use the logic as If Dynamic subcategory sales label >0 THEN Dynamic subcategory sales label ELSE Null and drag that to the label and it will show only values greater than 0

  • @VisualAnalyticsLab
    @VisualAnalyticsLab Рік тому

    Thanks for sharing, this is a really cool trick. Definitely learned something new today!

  • @RoopmathiGunnaubcmba
    @RoopmathiGunnaubcmba Рік тому

    thanks for this can you please upload a 4-step video tutorial for a generic desktop layout dashboard?

  • @shantanugadhe121
    @shantanugadhe121 Рік тому

    It was really helpful...Thanks...!

  • @Paisakamaona
    @Paisakamaona Рік тому

    worked , Thanks

  • @dewandu13
    @dewandu13 Рік тому

    Thank you. I tried to my project and it worked however, it did not work in the calculative field, Could you please demonstrate it in a calculative field?

    • @i.t.878
      @i.t.878 2 місяці тому

      You can change a calculated field name in the Edit window of the calculation (right click on field -> Edit), so this method won't be necessary.

  • @huytruong2026
    @huytruong2026 Рік тому

    Thanks for the tip but why can’t I simply take the average? Also I think this technique is useful because a lot of times we need to summarize the data yet still keep the raw data at the lowest level of details for other visualization purposes.

  • @PolarBeaverWoodworking
    @PolarBeaverWoodworking Рік тому

    this was great thank youuu

  • @zubdew
    @zubdew Рік тому

    Awesome video with clear steps! I ran into a problem with my implementation that I am hoping you have a solution for. I have just gotten to the step of creating the dynamic labels, and they work great. In my dataset, I have 'Brand' and 'Style' where each Brand has one or more styles (just like how each Category has multiple Sub-Categories in your video). For the brands that have several styles, the labels pop up perfectly. However, for the brands that only have one style, no label pops up at all and I cannot figure out why they wouldn't or how to get them to appear. Any advice?

  • @rassal9862
    @rassal9862 Рік тому

    One of the best vedios about creating donuts charts in tableau,,thank you

  • @MeghParikh-b6p
    @MeghParikh-b6p Рік тому

    This is awesome. I have been working on tableau since 2 years and I always create measure to rename things. but now I don't have to do that. This is very easy. although it comes with one disadvantage that if someone wants to know that what is actual column name, they have to click on the field and press down arrow to get correct column name. Many people won't know the fields can be renamed like this and they will search for forever to get correct name. Let me know if I am wrong.

  • @avijeetsingh1861
    @avijeetsingh1861 Рік тому

    Amazing video! Very helpful.

  • @tansmay23
    @tansmay23 Рік тому

    Nice another method here is to create a duplicate (copy) field of segment and drag it to the filters box!

  • @cococnk388
    @cococnk388 Рік тому

    This is great. But for someone new to figma.. needs to understand step by step how to create images on figma …

  • @laylaperez4989
    @laylaperez4989 Рік тому

    thank you this is so helpful!!

  • @JoshBlengino
    @JoshBlengino Рік тому

    Very helpful, thank you!

  • @altamashsabri8142
    @altamashsabri8142 Рік тому

    Thanks a lot

  • @julia66
    @julia66 Рік тому

    Thanks for explaining this :)