OPX Data
OPX Data
  • Видео 40
  • Просмотров 225 887
Tableau Calculations and Level Of Details (LOD)
In this video of tableau explained, we will look at the different type of calculations in tableau and understand the concepts behind them.
👉 Order of operation explained:ruclips.net/video/lTvLMYcqWck/видео.html
0:00 Intro
0:17 Overview
0:35 Basics overview
0:35 Types of basic calculation
1:33 Row level calculation - Concept
2:04 Aggregation - Concept
2:26 Tableau demo
2:36 Aggregation - default
3:10 String Manipulation
3:22 Split
4:23 Aggregation - sum
4:30 Aggregation - average
4:38 Example of row level vs aggregation
4:53 Row level - Arithmetic calculation
6:04 Problem with row level calculation on aggregation
6:10 Aggregation vs row level explained
7:11 Problem fixed: aggregation
7:48 Table Calculation ...
Просмотров: 152

Видео

Tableau Filters and order of operations
Просмотров 196Год назад
In this video of tableau explained, we will look into the different types of filters to learn how and why to use them and also understand the Example where context filter needs to be considered 👉 Fix incorrect Rank Filter: ruclips.net/video/5WEwpN3QzdA/видео.html 0:00 Intro 0:15 Extract Filter 0:58 Data Source Filter 4:10 Context Filter 5:55 Dimension and Measure Filter 7:48 Table Calculation 👍...
MUST READ for Data Analyst! Takeaways from Storytelling with Data
Просмотров 595Год назад
In this video, i share my summary and takeaways from the book: Storytelling with Data 00:00 Intro 00:13 Personal Opinions 01:17 Context 02:00 Effective Visuals 03:36 Design Principles 05:42 Audience Attention 06:07 Think like a designer 10:32 Storytelling Find the book on amazon: amzn.to/44Eq4ph
How to Create a Chart for Rolling Month Comparisons - Tableau Tips
Просмотров 2,3 тыс.Год назад
Here on another episode of tableau tips, we will learn how we can do a rolling month calculation to compare 12 rolling month/6 rolling month against the monthly results 0:00 Intro 0:15 Window calculation logic 1:45 Validating rolling month calculation 2:35 Creating Charts and potential problem 3:21 Combining final chart 3:55 Other examples of use case: running total, rolling month average 👍 If ...
How to Sort Data in Tableau
Просмотров 4,4 тыс.Год назад
In this guide on tableau, we will learn basics to sorting and tricks on how to sort with multiple columns and values 0:00 Intro 0:13 Basic Sort - 1 column 0:48 Basic Sort - 2 column 1:33 Nested Sort 2:44 Logic - Sort on second column on entire table 3:27 Solution - Sort on second column on entire table 4:54 Dynamic sorting - select column 6:41 Dynamic sorting - select measure 👍 If you enjoy thi...
How to hide measure names from filter - Tableau Tips
Просмотров 7 тыс.Год назад
Here on another episode of tableau tips, we will learn how we can hide and restrict the list of measure names available for the users 0:00 Intro 0:11 Use Case 1 1:11 Solution Logic 2:12 Solution - duplicate data source 3:36 Use Case 2 4:18 Solution - parameters 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: ruclip...
How to Dynamically Update Column Headers and Titles in Your Tableau Dashboard - Tableau Tips
Просмотров 6 тыс.Год назад
Here on another episode of tableau tips, we will look at how we can create dynamic title and custom column headers 0:00 Intro 1:20 Dynamic Title 1:35 Formatting dynamic date title 2:43 Setting up dynamic column headers 5:15 Aligning column headers with containers 6:52 Tips on how to work with conatiners 7:41 Formatting column headers and table 9:20 Demo 10:05 Line break column header 👍 If you e...
Hacks to filtering dates in Tableau - Tableau Tips
Просмотров 2,6 тыс.2 года назад
Here on another episode of tableau tips, we will look at alternative ways of how to filter dates in tableau 0:00 Intro 0:23 Basic date filters 1:38 Demo on using one parameter as filter 3:14 Using parameters as start and end date filter 6:45 Selecting data points as filter 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new vi...
66 days of data - Learning Power BI
Просмотров 1,9 тыс.2 года назад
As inspired by Ken Jee's #66daysofdata , I decided to try this out and learn Power BI. In this video, I documented my journey of how i started, what i did for these 66 days. 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: ruclips.net/user/OPXDataAnalytics 🙏 If you would like to show some appreciation: paypal.me/opx...
How to Perform Basic Date Functions in Tableau
Просмотров 9 тыс.2 года назад
Here on another episode of tableau tips, we will look at the basic date functions: what are they, how they can be used. 0:00 Intro 0:37 Text to Date 1:48 DATEPARSE 2:33 DATE 3:07 How to get parts of date 3:17 Text part of dates - DATENAME 4:08 Numerical part of dates - DATEPART 4:32 What is start of week option 5:39 Use case of start of week 5:55 Start of the week - DATETRUNC 7:15 Start of mont...
SQL Crash Course for data analyst: Learn SQL in under 20 mins!
Просмотров 10 тыс.2 года назад
In this crash course, you will learn the basics to sql in under 20mins. You will learn what you need to at least know as a data analyst. sql online: www.w3schools.com/sql/trysql.asp?filename=trysql_select_where 00:00 Intro 00:47 select 01:54 where 02:25 like 04:08 order by 05:20 into 05:45 aggregation 07:21 groupby 08:25 case 09:35 Logical operator: AND, OR 12:05 join 15:14 left join vs inner j...
How to calculate percentages - Tableau Tips
Просмотров 2,9 тыс.2 года назад
Here on another episode of tableau tips, learn how to calculate percentages and percentage difference in tableau 0:00 Intro 0:10 Percentage differences 0:43 Percentage between 2 values 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: ruclips.net/user/OPXDataAnalytics 🙏 If you would like to show some appreciation: pa...
Ultimate Guide: How to compare time periods in Tableau
Просмотров 12 тыс.2 года назад
Here on another episode of tableau tips, we will look at the different types of analysis involved with comparing dates and time. We will look at how to compare yearly trend, how to calculate percentage differences to compare YOY,QOQ,MOM results. We will also look at how we can do Period to date calculation such as YTD, QTD, MTD. 0:00 Intro 0:12 Overview of the type of time comparison 0:35 Yearl...
Stacked bar chart with 2 measures - Tableau Tips
Просмотров 22 тыс.2 года назад
Here on another episode of tableau tips, learn how to create bar charts with multiple measures and see how to add percentage of total label for separate measures on stacked bar chart 0:00 Intro 0:14 2 separate bar charts for each measures 01:02 how to create stacked bar chart with multiple measures 02:18 side by side bar chart 02:39 intro to add proportion % on bar chart 03:08 default proportio...
Hide item filter options - Tableau Tips
Просмотров 1,3 тыс.2 года назад
Here on another episode of tableau tips, learn how to hide specific items from the list of filter options 0:00 Intro 0:43 Solution 🙏 If you would like to show some appreciation: paypal.me/opxdata 🔔 To stay notified of new videos, subscribe here: ruclips.net/channel/UCRPYChgxw1QjFV5ognREhGg 👉Checkout the playlist to find more tableau tips and tricks: ruclips.net/p/PLpHJ_PjqnioijTdyTtLzakb7fr8jzl...
How to Fix Incorrect Rank and Rank Total | Tableau Tips
Просмотров 8402 года назад
How to Fix Incorrect Rank and Rank Total | Tableau Tips
Data Scientist vs Data Analyst vs Data Engineer
Просмотров 21 тыс.2 года назад
Data Scientist vs Data Analyst vs Data Engineer
Hide specific subtotal that has only one row - Tableau Tips
Просмотров 6 тыс.2 года назад
Hide specific subtotal that has only one row - Tableau Tips
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
Просмотров 3,7 тыс.2 года назад
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
Table and Inline Charts - Tableau Tips
Просмотров 3,7 тыс.2 года назад
Table and Inline Charts - Tableau Tips
Pivot Table | Dynamic Table - Tableau Tips
Просмотров 4,6 тыс.2 года назад
Pivot Table | Dynamic Table - Tableau Tips
P&L Table | Data Densification | Custom Subtotal | Color Headers - Tableau Tips
Просмотров 1,4 тыс.2 года назад
P&L Table | Data Densification | Custom Subtotal | Color Headers - Tableau Tips
Toggle Button Custom - Tableau Tips
Просмотров 6 тыс.2 года назад
Toggle Button Custom - Tableau Tips
Switch/Toggle Charts, Data - Tableau Tips
Просмотров 2,2 тыс.2 года назад
Switch/Toggle Charts, Data - Tableau Tips
Reset All Filters - Tableau Tips
Просмотров 20 тыс.2 года назад
Reset All Filters - Tableau Tips
Custom Shapes - Tableau Tips
Просмотров 2 тыс.2 года назад
Custom Shapes - Tableau Tips
Apply All Button for filter and parameter - Tableau Tips
Просмотров 24 тыс.2 года назад
Apply All Button for filter and parameter - Tableau Tips
Tableau Basics 10 - How to build tableau dashboard | Tableau dashboard design
Просмотров 1,9 тыс.2 года назад
Tableau Basics 10 - How to build tableau dashboard | Tableau dashboard design
Tableau Basics 9 - How to use Groups/Sets
Просмотров 2,1 тыс.2 года назад
Tableau Basics 9 - How to use Groups/Sets
Tableau Basics 6 - Creating Calculations
Просмотров 4,5 тыс.3 года назад
Tableau Basics 6 - Creating Calculations

Комментарии

  • @dominico.s.6376
    @dominico.s.6376 4 дня назад

    The fact that these tutorials are necessary demonstrates why Tableau is a terrible product. Reset all filters? Why is this not a default functionality in Tableau, for crying out loud!

  • @annaani6766
    @annaani6766 10 дней назад

    hi! Tell, please: How to do Index column?

  • @cmchouhchs
    @cmchouhchs 18 дней назад

    3Q

  • @noammaman3942
    @noammaman3942 24 дня назад

    god bless you dear, thank you

  • @張皓TimChang
    @張皓TimChang Месяц назад

    Awesome

  • @yasinislamrobin5091
    @yasinislamrobin5091 Месяц назад

    How can I contact you?

  • @ndlvndlv8993
    @ndlvndlv8993 Месяц назад

    that’s exactly what i needed because everything i was reading was confusing……..thank you very much

  • @jayamehay1689
    @jayamehay1689 2 месяца назад

    Thank youu!!! Been struggling with this for ages!

  • @saradaroutray8432
    @saradaroutray8432 3 месяца назад

    Awesome

  • @spankmobley
    @spankmobley 3 месяца назад

    A standard P&L statement lists expenses with positive numbers (the assumption being that they would be understood as negative, given that they are under the Expenses section of the statement), which would complicate your net income calculation. How would you address that?

  • @jennykuwn
    @jennykuwn 4 месяца назад

    Thank you.

  • @ParagSahasrabuddhe
    @ParagSahasrabuddhe 4 месяца назад

    How to combine both?

  • @rodolfopresa2821
    @rodolfopresa2821 4 месяца назад

    THANK YOU SO MUCH!!!!! SPENT HOURS TRYING TO FIGURE THIS OUT!

  • @elwyndude
    @elwyndude 5 месяцев назад

    OMG OMG OMG this was EXACTLY what I was looking for... amazing thank you thank you thank you

  • @TheQueenEPK
    @TheQueenEPK 5 месяцев назад

    This was so easy to follow! Thanks!

  • @kusumgupta8831
    @kusumgupta8831 6 месяцев назад

    You have hidden the product name in the process of hiding extra row, what kind of stupid video is this

  • @AmaDavies
    @AmaDavies 6 месяцев назад

    Thanks so much! Great job!

  • @ppjn348
    @ppjn348 6 месяцев назад

    Are we able to still sort the data with this method?

  • @pattybaselines
    @pattybaselines 6 месяцев назад

    You are awesome. Thank you.

  • @TheSeveer123
    @TheSeveer123 6 месяцев назад

    I have an interview coming up and this video was extremely useful. Thank you for being so cute and smart 🙏🤍

  • @AI-hn1nr
    @AI-hn1nr 7 месяцев назад

    Exactly what I was looking for. Thank you! 👍

  • @nismokid
    @nismokid 7 месяцев назад

    Just want to say you do an excellent job in providing an easy to follow instructions with great examples! Thank you very much!!

  • @JillianSolomon-hm7qj
    @JillianSolomon-hm7qj 7 месяцев назад

    Thank you for this! Love your content and I am hoping you know how to solve for doing some sort of fixed rank. I always have an issue setting up a rank calculation that does not change when a name filter is applied. An example is rank(sum(profit)) works for a list of employees, and let's say Joe is ranked number 3, but when I filter for Joe's name, his rank is now 1 instead of 3. Any ideas how to solve? I always solve for it in the query but would be nice to have a Tableau fix too. Thank you!

  • @ZheyuanZ
    @ZheyuanZ 8 месяцев назад

    Thanks you so muchhhhhhhhhhhhh!!!! I have been struggling on this for 3 hours, it is so hard to integrate different measures together inside on chart. Really helpful!

  • @deepti61
    @deepti61 8 месяцев назад

    Kudos to you👏 , You explained the SQL codes so well.

  • @RhushikeshHiralalChavan
    @RhushikeshHiralalChavan 8 месяцев назад

    Great video! I will solve multi select parameter option problem But it is not working with filters there is any way like i dashboard we use the filters that also applied to this data source

  • @hetilemabunda9705
    @hetilemabunda9705 8 месяцев назад

    This was so helpful, so glad I found this channel!

  • @edgarvasquez47
    @edgarvasquez47 8 месяцев назад

    Exactly what I was looking for. Thanks!!

  • @gabonicabas
    @gabonicabas 8 месяцев назад

    Great video. Thanks for sharing.

  • @BradStone-1
    @BradStone-1 9 месяцев назад

    Thanks for the video. I created a toggle button like the one shown in the video. However, the toggle button must be double clicked in order to switch between values. It appears that when the button is clicked, it "selects" the button and triggers the Tableau action which properly switches the chart. However, the next click appears to "deselect" the button and does not trigger the action. Another click "selects" the button which triggers the action and the chart changes. It is hard to tell, but at the end of the video, it looks like the button in your example may have been double clicked to change the chart after the first click. Is this true? If so, is there a way to make it work so that a double click is not required? Tableau v2023.1.7

  • @burujulaseenu2388
    @burujulaseenu2388 9 месяцев назад

    Hi, how you are moving with the blank container as well. Can you please explain

  • @burujulaseenu2388
    @burujulaseenu2388 9 месяцев назад

    Hi, how amyou are moving by holding with blank container as well

  • @KevinWee90
    @KevinWee90 9 месяцев назад

    This is a life saver!

  • @vigneshwaranm5836
    @vigneshwaranm5836 10 месяцев назад

    How to show min and max labels for two measures in the stacked bar chart?

  • @thepenguin74
    @thepenguin74 10 месяцев назад

    I have been looking for this -whith this detailed explanation- for hours. Thanks.

  • @WadeSteele-m7l
    @WadeSteele-m7l 10 месяцев назад

    I tried to execute this step by step. When I then try to alter the selections in a multi-select dropdown on my dashboard, it triggers a query as soon as I click on any checkbox in the list. I was expecting it to not do anything at all, until I click the Apply Filters button I created. Am I missing something?

    • @zsBears
      @zsBears 5 месяцев назад

      Were you able to figure this out? have same issue

  • @mounikapulijala1327
    @mounikapulijala1327 Год назад

    Please let me reason apply filter not working for one click...when i double click then its working

  • @Codewithmechs1996
    @Codewithmechs1996 Год назад

    Why do we have to put the fields in detail tab can anyone explain

  • @sushil_kokil
    @sushil_kokil Год назад

    Thanks for the video....

  • @abhishek12865a
    @abhishek12865a Год назад

    Thank you so much dear I have been searching for this from long time

  • @abhishek12865a
    @abhishek12865a Год назад

    Thank you so much dear

  • @srikantbattula8408
    @srikantbattula8408 Год назад

    great video

  • @garypansino2484
    @garypansino2484 Год назад

    Great video! Exactly what I was wrestling with. Thank you.

  • @robespierre2575
    @robespierre2575 Год назад

    Life saver!!!

  • @TariniMathur-i1b
    @TariniMathur-i1b Год назад

    I have the same question - will this method work for more than 2 measures? I am working with 5 measures

  • @ericpeterson6822
    @ericpeterson6822 Год назад

    Wah this came at the right time.I am doing a project and these tips are helping me a lot! Thanks so much lah! Btw here's a suggestion. Can you do a video on what kinda qualifications and skills recruiters look for in an entry level data analyst position in SG?

    • @OPXDataAnalytics
      @OPXDataAnalytics Год назад

      I do have a video that talks about skills needed for data analyst. Not specifically from recruiter point of view, but it’s applicable to get an idea of what is required for the role. Data Scientist vs Data Analyst vs Data Engineer ruclips.net/video/olGI1NHa5z0/видео.html

  • @PreethikaThambiraj
    @PreethikaThambiraj Год назад

    THANK YOU ITS REALLY AMAZING

  • @vamsireddy5051
    @vamsireddy5051 Год назад

    Great video, Thanks

  • @vamsireddy5051
    @vamsireddy5051 Год назад

    Really great tip, liked it, Thanks,👍

  • @akak1816
    @akak1816 Год назад

    Hi, great video. But can you show how to created the Report Date parameter?

    • @OPXDataAnalytics
      @OPXDataAnalytics Год назад

      learn how to create parameter: ruclips.net/video/BVJGFp4S4AI/видео.html filtering with date parameter:ruclips.net/video/ZmPOD6zS5wk/видео.html Hope this helps