Andy Kriebel
Andy Kriebel
  • 759
  • 7 594 549
Rank & Filter the Top 5 in Tableau in Under 60 Seconds!
In this tip, you will learn how to show the rank of each team in MLB by homeruns for 24 seasons.
We'll start by computing the RANK table calculation for each Season before filtering to only the top 5 Teams in each Season.
Download the workbook - public.tableau.com/app/profile/andy.kriebel/viz/MLBRankTop5TeamsbyHR/Dashboard
The data is embedded in the workbook.
Like this? You'll leave Next-Level Tableau. Learn more at nextleveltableau.com.
Переглядів: 409

Відео

How to Replace a Datasource & Fields in Tableau
Переглядів 90712 годин тому
Need to change a datasource but don't want to rebuild the workbook? Has a field changed? It can be a real pain to update each sheet in a workbook one by one. Hands up in the comments if you've been there. ✋ Conveniently, Tableau allows you to change the entire datasource with the "Replace Datasource" option. Or, if you only need to change a field, Tableau has an option called "Replace Reference...
How to Create a 9-Box Matrix in Tableau
Переглядів 1,3 тис.19 годин тому
In this video, I show you how to build a 9-box matrix. These are commonly used in talent management and HR to map a company's workforce along two dimensions, potential and performance. Each of these two dimensions is split up into three categories, low, medium, and high, depending on the score. For each employee performance is then plotted horizontally and potential is plotted vertically. From ...
How to Simultaneously Highlight & Deselect with a Parameter Action in Tableau
Переглядів 1,1 тис.День тому
Welcome to another Tableau tutorial! In this video, we’ll dive into an advanced technique to enhance your Tableau visualizations: simultaneously highlighting and deselecting marks using parameter actions. This is a great skill for making your dashboards more interactive and user-friendly. What You Will Learn: - Highlight & Deselect Marks: Learn how to use parameter actions to highlight selected...
Find Red Flags in Your Data in ONLY 5 MINUTES with Control Charts
Переглядів 1,6 тис.28 днів тому
If you like this video, you'll love learning from me 4 hours per week in Next-Level Tableau. Control charts are one of the best charts you can use for identifying outliers in a series of measurement. So what are they? Control charts are used to monitor whether a process is performing consistently over time. It's basically a line graph that tracks data points collected at specific intervals, but...
Create ACTIONABLE Cycle Plots in 2 Minutes in Tableau!
Переглядів 2,1 тис.Місяць тому
Cycle plots are a fantastic way to identify seasonality in a data set. And you can make them even more useful by adding indicators for whether they are above or below the average. Like this? You'll love Next-Level Tableau. Learn more at nextleveltableau.com.
How I Create a Unit Histogram in Tableau
Переглядів 1,3 тис.2 місяці тому
A unit histogram is a chart that shows the distribution of data points across a series of bins of a measure. Unlike a traditional histogram that uses bars, a unit histogram consists of a set of marks, each representing a member of a dimension. In this example, our final result is a unit histogram showing the distribution of states by their average sales. If you like this, you'll love Next-Level...
Mastering Tableau: Andrew Watson’s Tale of Data, Consulting, and Entrepreneurship
Переглядів 8122 місяці тому
In this episode of the Dual Access Podcast, host Andy Kriebel sits down with Andrew Watson, a seasoned Tableau consultant who transitioned from a financial services project manager to an independent business owner. Andrew shares his journey of discovering his passion for Tableau at an early stage of its introduction into the market while working at a company that became part of Expedia. His exp...
Train your VOICE like you train your BODY with Shelby Rollins
Переглядів 2912 місяці тому
In this episode, I sit down with Nashville-based vocal coach Shelby Rollins. With over 15 years of experience, Shelby has honed her skills in developing both singers and vocal coaches. Shelby takes us through her journey from singing in her church choir to becoming a sought-after vocal coach and entrepreneur. She shares her unique approach to vocal coaching, leveraging Instagram to connect with...
Start your side hustle without social media (so your employer find out)
Переглядів 3543 місяці тому
Lauren Leopold was the Head of Content & Social Media for 3.5 years at a large bank when she had a panic attack that required her to sign off for 5 months. That’s when she decided she wanted to help other women start a side business without being all over social media. With a focus on creating fulfilling businesses, she offers a hybrid coaching and mentoring approach to support over 70 female f...
Query This! SQL, Skills, and Career Thrills!
Переглядів 5963 місяці тому
Query This! SQL, Skills, and Career Thrills!
Calvin Correli: Future Special Advisor to POTUS
Переглядів 1793 місяці тому
Calvin Correli: Future Special Advisor to POTUS
People, Emotions, History: Using Data to Widen Our World View with Valentina D'Efilippo
Переглядів 5123 місяці тому
People, Emotions, History: Using Data to Widen Our World View with Valentina D'Efilippo
The Future of AI in Sports Analytics with Jake Schuster, CEO of Gemini Sports Analytics
Переглядів 7234 місяці тому
The Future of AI in Sports Analytics with Jake Schuster, CEO of Gemini Sports Analytics
WHAT??? 27% of US adults think it's ok to eat dogs!
Переглядів 1,3 тис.4 місяці тому
WHAT??? 27% of US adults think it's ok to eat dogs!
The Art and Science of Leadership in the Age of Data
Переглядів 5444 місяці тому
The Art and Science of Leadership in the Age of Data
Switching Tracks - From Dean to Data Analyst
Переглядів 6515 місяців тому
Switching Tracks - From Dean to Data Analyst
From the Basketball Court to the Boardroom: Building Winning Teams with Rob Gibbons
Переглядів 6996 місяців тому
From the Basketball Court to the Boardroom: Building Winning Teams with Rob Gibbons
Harnessing Histograms for Data Analysis in Tableau
Переглядів 5 тис.7 місяців тому
Harnessing Histograms for Data Analysis in Tableau
The Shoppable Journey: Heather Udo on Reinventing Online Retail
Переглядів 4028 місяців тому
The Shoppable Journey: Heather Udo on Reinventing Online Retail
How to Create a Year→Quarter→Month→Day Drilldown in Tableau
Переглядів 10 тис.8 місяців тому
How to Create a Year→Quarter→Month→Day Drilldown in Tableau
Unlocking the Secrets of Efficient Immigration: A Conversation with Ronak Patel
Переглядів 4968 місяців тому
Unlocking the Secrets of Efficient Immigration: A Conversation with Ronak Patel
Master Containers: Build an Interactive Tableau Dashboard From Scratch
Переглядів 19 тис.8 місяців тому
Master Containers: Build an Interactive Tableau Dashboard From Scratch
Cultivating Talent and Tech: Tairi's Mission with Mark Wormgoor
Переглядів 1758 місяців тому
Cultivating Talent and Tech: Tairi's Mission with Mark Wormgoor
Enhancing Tableau Drill-Downs: Use LODs in Hierarchies
Переглядів 3,2 тис.8 місяців тому
Enhancing Tableau Drill-Downs: Use LODs in Hierarchies
The 10-Year-Old CEO: A Deep Dive with Tech Phenom Graeme Barlow
Переглядів 2868 місяців тому
The 10-Year-Old CEO: A Deep Dive with Tech Phenom Graeme Barlow
Broken Worksheet Actions in Dashboards? Here's the Tableau Fix You've Been Seeking!
Переглядів 1,8 тис.8 місяців тому
Broken Worksheet Actions in Dashboards? Here's the Tableau Fix You've Been Seeking!
Flip, Run, Inspire: Stephanie Lombardo on Empowering Women in Real Estate
Переглядів 2028 місяців тому
Flip, Run, Inspire: Stephanie Lombardo on Empowering Women in Real Estate
Master Dynamic Zone Visibility in Tableau: Yearly to Monthly Calendar Drill Down
Переглядів 5 тис.9 місяців тому
Master Dynamic Zone Visibility in Tableau: Yearly to Monthly Calendar Drill Down
From Mobiles to Millions | Youssef Botros on Business Growth
Переглядів 2739 місяців тому
From Mobiles to Millions | Youssef Botros on Business Growth

КОМЕНТАРІ

  • @crishuanawilliams671
    @crishuanawilliams671 День тому

    Yooooooooooooooooooooooooooooooooooo, this was my pain point all last week - right on time, Andy. Thanks!

  • @Mark-sf4kh
    @Mark-sf4kh День тому

    Great video! What if I have say table 1 in Sheet 1 with two columns; number of orders for each customer and customer name and table 2 in Sheet 2 also with customer names but this time, the second column in sheet 2 has the number of times the customer ordered on Black Friday. My goal is to get in a new table in a new sheet ( say sheet 3) the ratio of orders on Black Friday/total number of orders per customer.. so basically the values in sheet 2/values in sheet 1. How do one go about achieving that? Bear in mind that not all customers will buy anything on Black Friday and I will wanna see them show up with a zero in sheet 3. Note that, sheets 1 and 2 have some filters in the filter pane Thank you!!

  • @datalyst
    @datalyst 2 дні тому

    The problem is that all of these are hacks. Also the drill-back up does not work per level but collapses everything. In addition it is cumbersome to combine with filter actions. My users don't want to use Tableau and instead prefer PowerBI. Hierarchies can be opened up on ANY level very naturally and when clicking on it it filters. Boom. Not sure why Tableau is incapable of providing such a basic functionality.

  • @patientson
    @patientson 2 дні тому

    Mr Luke recommended I watch you on this video, but my turned me to another video of yours where I saw blue, green the four quadrants, fill, split, marks/headers, axis, discrete, continuous and many more good tidings from yours truly. The great part of this all is that I had already seen some of you superb videos on data visualisation and i can swear it took me less than 60 seconds to subscribe and choose the All mighty bell formula. I will watch that 11 minutes and 57 seconds video for over 47 times, stopping it to grab every bit of it cause I know you told me the truth in the very first 15 seconds or less.....and the words that did the magic was it took you nearly 5+ years. The truth you shared because of the excellent mind you have was that set in stone forever in 7 seconds of "BLUE vs. Green - What does it mean in Tableau?." Thank you is too small a gift to share with you. You require a gift that last forever. Something you can trickle down to you children or one you like so much you will do anything great for.

  • @patientson
    @patientson 2 дні тому

    ❣❣❣❣❣❣❣❣❣

  • @thetrumpetsource1270
    @thetrumpetsource1270 2 дні тому

    Is there a way to notify stakeholders when the outliers meet the criteria?

    • @vizwiz
      @vizwiz 2 дні тому

      You can with alerts on Tableau Cloud/Server.

  • @thetrumpetsource1270
    @thetrumpetsource1270 2 дні тому

    Excellent as always!

  • @jazzcat969
    @jazzcat969 2 дні тому

    Thanks, brother.

    • @vizwiz
      @vizwiz 2 дні тому

      You're welcome

  • @identitynotestablished9133
    @identitynotestablished9133 3 дні тому

    awesome

  • @TH-vw4qn
    @TH-vw4qn 4 дні тому

    This will save me so much time. Thank you!

    • @vizwiz
      @vizwiz 2 дні тому

      Glad it helped!

  • @user-vv7rv9wf2i
    @user-vv7rv9wf2i 4 дні тому

    Thank you for posting. Really incredible, easy to follow walk through. For me, worksheet swapping only worked if it was in a vertical container. After troubleshooting for way too long, this seemed to be my issue.

  • @rajeshtukdeo
    @rajeshtukdeo 5 днів тому

    Excellent video !!

    • @vizwiz
      @vizwiz 2 дні тому

      Thank you! Cheers!

  • @ymalik79
    @ymalik79 5 днів тому

  • @anastasiakurakova7620
    @anastasiakurakova7620 5 днів тому

    It was a great tutorial and easy to follow! I feel like it covers a lot. The only thing I wish you'd give a little more reasoning as to why we are removing the lines or why is it better to make the stylistic choices that you did. Although I understand that it's not going to be a 10 minute tutorial this way. Thank you!

    • @vizwiz
      @vizwiz 2 дні тому

      Yeah, those are cosmetic changes.

  • @manishsathe8371
    @manishsathe8371 5 днів тому

    Without watching this video, I guess it would have been taken hours for me do this. Very Good Work 👍

  • @JeevanNewhaven
    @JeevanNewhaven 6 днів тому

    That’s so useful ❤

  • @redherring777r
    @redherring777r 6 днів тому

    Thanks Andy. Great video. How do we get the bars to display % of each measure name instead of Distinct Count.

    • @vizwiz
      @vizwiz 2 дні тому

      You'll need to calculcate that instead.

  • @22832339
    @22832339 7 днів тому

    So close but no functioning filtering in the drilldown. Source field is empty shows as none. BUMMER!!

    • @vizwiz
      @vizwiz 2 дні тому

      If you follow the steps in this video, it will work, assuming you have 4 levels in your dates.

  • @rafalmahdi1050
    @rafalmahdi1050 10 днів тому

    Thank you !!

    • @vizwiz
      @vizwiz 2 дні тому

      You're welcome!

  • @XGames_Mrated
    @XGames_Mrated 10 днів тому

    Great video referencing this for future projects

  • @prudhvimaddula
    @prudhvimaddula 10 днів тому

    How to deal with when u are using charts as filters in a dashboard and filter across so many other dashboard elements .? Is there a priority of order for context filters if there are many like 5filters added to context?

    • @vizwiz
      @vizwiz 10 днів тому

      They run simultaneously

    • @prudhvimaddula
      @prudhvimaddula 10 днів тому

      @@vizwizi have a dashboard where all the charts are clickable as they have been added to action filters but i want these action filters to have priority in filtering on the sheet. For example if state map sheet filter is added as action in other charts, all other charts should filter selected state on priority. For this i added them to context in affecting sheet because it has some fixed LOD calculations. But when I click on the sheet which causes action( example state sheet in my case), it is not filtering. Can i get help with this possible reason?

  • @csbsprogramming3792
    @csbsprogramming3792 10 днів тому

    You are a genius

  • @jucegovi1
    @jucegovi1 10 днів тому

    Very helpful tutorial, thank you.

    • @vizwiz
      @vizwiz 10 днів тому

      You're welcome!

  • @ragragrec1
    @ragragrec1 11 днів тому

    This was amazing thanks

  • @stephenmuvea6378
    @stephenmuvea6378 12 днів тому

    I have followed your Tableau videos and they are great. Especially to a beginner like me. Thanks a lot for selflessly sharing this much needed knowledge.

    • @vizwiz
      @vizwiz 10 днів тому

      You're very welcome!

  • @jfzr_
    @jfzr_ 12 днів тому

    woah, i just learn so much from ur video, and the way you put it all really straightforward and ur edit styles that highlighting all the features used which make it followable, it’s just amazing, thank u so much sir! wish u a grand success in this field 🙌

    • @vizwiz
      @vizwiz 10 днів тому

      Thank you so much!!

  • @jay271990
    @jay271990 12 днів тому

    Very useful tips you've shared with this easiest way.

  • @jagonzalezcl
    @jagonzalezcl 12 днів тому

    Thanks, so useful 👍👍👍

    • @vizwiz
      @vizwiz 12 днів тому

      Glad it was helpful!

  • @sorosfox3801
    @sorosfox3801 13 днів тому

    Great tip! Thanks

    • @vizwiz
      @vizwiz 12 днів тому

      You bet!

  • @mitchdunn3418
    @mitchdunn3418 14 днів тому

    Is there a way for Tableu to take this exact kind of color-coded quadrant chart, but be able to track the path of single point over multiple time periods? Think of how people can already see this in connected scatter plots. If it’s possible, could we make it so that if a point with numerous intermediate points along i’s path, would those intermediates be a different color if they are in a different quadrant? I could draw a picture of this more easily than type it 😂

  • @sorosfox3801
    @sorosfox3801 14 днів тому

    Thanks so much for this! :)

    • @vizwiz
      @vizwiz 10 днів тому

      You're so welcome!

  • @anshuraj7584
    @anshuraj7584 15 днів тому

    Hi, Can we get data which you are using in this video?

    • @vizwiz
      @vizwiz 12 днів тому

      Here you go - covers the costs of my editor. Otherwise, follow along using superstore or any other data set with date/time based data. andykriebel.gumroad.com/l/time-series

    • @anshuraj7584
      @anshuraj7584 10 днів тому

      Thank you for help

    • @anshuraj7584
      @anshuraj7584 10 днів тому

      I have encountered an issue with a duplicate measure in Tableau. How do you duplicate measures in Tableau? I am unable to duplicate measures myself. Could you please create a short video explaining how to duplicate measures in Tableau? Please.

  • @pettyaf89
    @pettyaf89 15 днів тому

    This was huge. By far the best way to deliver lessons like this that I’ve seen. Thank you!

  • @pratik903
    @pratik903 16 днів тому

    That's a great explanation. Just wondering your YTD calculation will show value for current year but not for Year Till Date as you have to restrict sum of sales till current date of year not for full year. Please tell me if I am getting it wrong?

    • @vizwiz
      @vizwiz 12 днів тому

      I created a new data in the data set so that it would look like the most recent date was today. ua-cam.com/video/Y-n2caElOj0/v-deo.htmlsi=ZrNlO2JPojRmGAXO&t=23

    • @pratik903
      @pratik903 11 днів тому

      Ohh okay. I missed this part. Makes sense now. Thank you

  • @MaddyIndia
    @MaddyIndia 17 днів тому

    Super

  • @MaddyIndia
    @MaddyIndia 17 днів тому

    Wow this was so easy to understand and so quick. No need to watch hours of video.

  • @lawrenceogola6002
    @lawrenceogola6002 18 днів тому

    Finally found a video that did it after wasting time on shitty videos the whole day! Phewks, let me go eat lunch now.

  • @sowmya6471
    @sowmya6471 18 днів тому

    I am gonna implement it in my next dashboard. Thanks Andy.

    • @vizwiz
      @vizwiz 12 днів тому

      Go for it!

  • @MalamIbnMalam
    @MalamIbnMalam 19 днів тому

    It's mind-boggling how quickly he put that dashboard together...Unbelievable! Here I am taking days in my Data Visualization course trying to put together a dashboard comprised of 2 charts (bar and map) with cross-filtering. This gentleman does an even better dashboard in a matter of minutes, crazy! I guess I should give myself some slack due to the fact that this is my first time using Tableau.

    • @vizwiz
      @vizwiz 12 днів тому

      Definitely give yourself some slack! But if you follow along with this video, it won't take you more than 30 min.

    • @MalamIbnMalam
      @MalamIbnMalam 12 днів тому

      @@vizwiz thank you, your video helped me a lot for my data Visualization course.

  • @ComputerLunch
    @ComputerLunch 19 днів тому

    thanks

  • @ronchipman3646
    @ronchipman3646 19 днів тому

    as always, great content -- while the "how to" is well explained -- how do you pitch this in a business setting as "the most functional way to present this information" -- most business users wouldn't know what to do with this.

    • @vizwiz
      @vizwiz 12 днів тому

      I wouldn't use this in a business setting. Like you said, no one will understand it. The technique is useful to learn though.

  • @Data_science_Merry
    @Data_science_Merry 21 день тому

    Great explanation

  • @firstname4337
    @firstname4337 21 день тому

    one of the most helpful tableau videos on the tube

  • @rakeshkumarsaudermet7618
    @rakeshkumarsaudermet7618 22 дні тому

    How do I perform same set actions when my date is not continuous, I want to leave my date field as discrete and show a bar chart instead. when I click on "Jan" it should show daily view for the month of Jan and the remaining bars (months) should be shown as they are. like in example how you created a drill down for category and subcategory drill-down, in the same manner.

  • @CreditRiskAnalytics
    @CreditRiskAnalytics 22 дні тому

    Nice. I've used Nelson Rules en.wikipedia.org/wiki/Nelson_rules in a number of places for data quality reporting Over time you just tweak the time variable to reduce the number of false positives for further investigation. For a full solution you set a rule breach to email the data quality team(s)

  • @maxfrantzyemmanueljean-pie8098

    Great video!

  • @NorahFahad-rn6uu
    @NorahFahad-rn6uu 23 дні тому

    what if i need for 3-level maps?

    • @vizwiz
      @vizwiz 12 днів тому

      I'll do you one better. Here's a 4 level drill down. ua-cam.com/video/w4vlyXajJCU/v-deo.htmlsi=vJblWJldf5LV3MPS Here's one for 3 levels. This uses a scatterplot, but there no reason you can't follow the exact same steps for a map. ua-cam.com/video/PqrIUZEXJgA/v-deo.htmlsi=vx14dYF9nryPy2tr

  • @decya9492
    @decya9492 24 дні тому

    Thanks!

  • @diegochavez3599
    @diegochavez3599 24 дні тому

    Love it Andy! Straight to the point.

  • @uniconepowaaa
    @uniconepowaaa 25 днів тому

    You save me points I’m sure on my homework that’s due in about 10 minutes!! Thank you