- Видео 40
- Просмотров 225 887
OPX Data
Сингапур
Добавлен 12 май 2020
Hi i am an experienced data analyst specialising in data visualization and business intelligence.
I will be sharing my knowledge and journey on data, do follow and subscribe the channel if you wish to learn more about data analytics, data science, data engineering.
🙏 If you would like to show some appreciation:
paypal.me/opxdata
I will be sharing my knowledge and journey on data, do follow and subscribe the channel if you wish to learn more about data analytics, data science, data engineering.
🙏 If you would like to show some appreciation:
paypal.me/opxdata
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 ...
👉 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
Switch/Toggle Charts, Data - Tableau Tips
Просмотров 2,2 тыс.2 года назад
Switch/Toggle Charts, Data - 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
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!
hi! Tell, please: How to do Index column?
3Q
god bless you dear, thank you
Awesome
How can I contact you?
that’s exactly what i needed because everything i was reading was confusing……..thank you very much
Thank youu!!! Been struggling with this for ages!
Awesome
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?
Thank you.
How to combine both?
THANK YOU SO MUCH!!!!! SPENT HOURS TRYING TO FIGURE THIS OUT!
OMG OMG OMG this was EXACTLY what I was looking for... amazing thank you thank you thank you
This was so easy to follow! Thanks!
You have hidden the product name in the process of hiding extra row, what kind of stupid video is this
Thanks so much! Great job!
Are we able to still sort the data with this method?
You are awesome. Thank you.
I have an interview coming up and this video was extremely useful. Thank you for being so cute and smart 🙏🤍
Exactly what I was looking for. Thank you! 👍
Just want to say you do an excellent job in providing an easy to follow instructions with great examples! Thank you very much!!
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!
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!
Kudos to you👏 , You explained the SQL codes so well.
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
This was so helpful, so glad I found this channel!
Exactly what I was looking for. Thanks!!
Great video. Thanks for sharing.
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
Hi, how you are moving with the blank container as well. Can you please explain
Hi, how amyou are moving by holding with blank container as well
This is a life saver!
How to show min and max labels for two measures in the stacked bar chart?
I have been looking for this -whith this detailed explanation- for hours. Thanks.
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?
Were you able to figure this out? have same issue
Please let me reason apply filter not working for one click...when i double click then its working
Why do we have to put the fields in detail tab can anyone explain
Thanks for the video....
Thank you so much dear I have been searching for this from long time
Thank you so much dear
great video
Great video! Exactly what I was wrestling with. Thank you.
Life saver!!!
I have the same question - will this method work for more than 2 measures? I am working with 5 measures
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?
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
THANK YOU ITS REALLY AMAZING
Great video, Thanks
Really great tip, liked it, Thanks,👍
Hi, great video. But can you show how to created the Report Date parameter?
learn how to create parameter: ruclips.net/video/BVJGFp4S4AI/видео.html filtering with date parameter:ruclips.net/video/ZmPOD6zS5wk/видео.html Hope this helps