Uploaded September 2023 | Updated November 2026, 2 hours ago
Do you want to know how to analyze data and create beautiful dashboards with Tableau? This video is for you. Learn how to go beyond the basics of Tableau and use concepts like:
π Calculated measures & columns
π Customizing visuals
π Creating histograms & box plots
π Working with "Marks"
π Field formatting
π Filters, Actions and using "Context"
π Cumulative totals
π Setting up a dashboard
We are going to the sample HR data (download it here: chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx) and answer these 10 questions.
1) How many people are in each Job?
2) Gender distribution
3) Age spread of our staff
4) Which jobs pay more?
5) Top earners by job
6) Qualification vs. Salary
7) Staff growth trend in the last 5 years
8) Employee filter by starting letter
9) Leave balance analysis
10) Quick HR Dashboard
β± Video topics & timestamps:
0:00 - Loading data into Tableau
0:30 - People by job (Q1)
1:45 - Adding labels & changing colors
2:20 - Gender distribution (Q2)
3:30 - Adding a job title filter for the pie chart
4:23 - Age spread of the staff (Q3)
5:02 - Bin customization for the histogram in Tableau
6:54 - Which jobs pay more (Q4)
8:26 - Adding tooltips
9:11 - Top earners by job (Q5)
10:36 - Context filters and fixing the top filter problem
12:23 - Qualification vs. Salary (Q6)
13:22 - Staff growth over time (Q7)
14:10 - Using "Quick Table Calculations" to get running total
14:46 - Employee filter by starting letter (Q8)
15:50 - Adding first letter calculated column
17:16 - Leave balance analysis (Q9)
17:40 - Staff with more than 20 days leave balance - Calculated Measure
18:42 - Quick HR Dashboard with Tableau (Q10)
20:39 - Dashboard actions and fixing context filter errors
22:54 - Adding titles with Textboxes
π»Data & Final Result
==================
Raw data (use this to practice) - chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx
Final Result (published version of my HR dashboard) - public.tableau.com/views/Tableau-10tips/Q10
πΊ More on Tableau & Power BI
==========================
Love Data Analysis with Tableau or Power BI? Check out these additional videos.
Learn Tableau in 15 minutes
youtu.be/tNLp_JVipoQ
Learn Power BI in 10 minutes
youtu.be/9tF1IrfLflg
Learn Power Query in 15 minutes
youtu.be/UAFExySaSPY
Power BI - Beginner to PRO Dashboard
youtu.be/uwe8C7K8fXY
Excel Dashboard
youtu.be/35VnP0Rz71I
Tableau Playlist
youtube.com/playlist?list=PLmejDGrsgFyALk7dA4ZPlUuFdclJEHLho
Power BI Playlist
youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
Power BI FULL Course (50 videos, 20+ hours material)
chandoo.org/wp/power-bi-course
~
#tableau #tableaufullcourse
Do you want to know how to analyze data and create beautiful dashboards with Tableau? This video is for you. Learn how to go beyond the basics of Tableau and use concepts like:
π Calculated measures & columns
π Customizing visuals
π Creating histograms & box plots
π Working with "Marks"
π Field formatting
π Filters, Actions and using "Context"
π Cumulative totals
π Setting up a dashboard
We are going to the sample HR data (download it here: chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx) and answer these 10 questions.
1) How many people are in each Job?
2) Gender distribution
3) Age spread of our staff
4) Which jobs pay more?
5) Top earners by job
6) Qualification vs. Salary
7) Staff growth trend in the last 5 years
8) Employee filter by starting letter
9) Leave balance analysis
10) Quick HR Dashboard
β± Video topics & timestamps:
0:00 - Loading data into Tableau
0:30 - People by job (Q1)
1:45 - Adding labels & changing colors
2:20 - Gender distribution (Q2)
3:30 - Adding a job title filter for the pie chart
4:23 - Age spread of the staff (Q3)
5:02 - Bin customization for the histogram in Tableau
6:54 - Which jobs pay more (Q4)
8:26 - Adding tooltips
9:11 - Top earners by job (Q5)
10:36 - Context filters and fixing the top filter problem
12:23 - Qualification vs. Salary (Q6)
13:22 - Staff growth over time (Q7)
14:10 - Using "Quick Table Calculations" to get running total
14:46 - Employee filter by starting letter (Q8)
15:50 - Adding first letter calculated column
17:16 - Leave balance analysis (Q9)
17:40 - Staff with more than 20 days leave balance - Calculated Measure
18:42 - Quick HR Dashboard with Tableau (Q10)
20:39 - Dashboard actions and fixing context filter errors
22:54 - Adding titles with Textboxes
π»Data & Final Result
==================
Raw data (use this to practice) - chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx
Final Result (published version of my HR dashboard) - public.tableau.com/views/Tableau-10tips/Q10
πΊ More on Tableau & Power BI
==========================
Love Data Analysis with Tableau or Power BI? Check out these additional videos.
Learn Tableau in 15 minutes
youtu.be/tNLp_JVipoQ
Learn Power BI in 10 minutes
youtu.be/9tF1IrfLflg
Learn Power Query in 15 minutes
youtu.be/UAFExySaSPY
Power BI - Beginner to PRO Dashboard
youtu.be/uwe8C7K8fXY
Excel Dashboard
youtu.be/35VnP0Rz71I
Tableau Playlist
youtube.com/playlist?list=PLmejDGrsgFyALk7dA4ZPlUuFdclJEHLho
Power BI Playlist
youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
Power BI FULL Course (50 videos, 20+ hours material)
chandoo.org/wp/power-bi-course
~
#tableau #tableaufullcourse
![Automatically Extract BOLD Text with VBA [Adv. Excel]
It seemed impossible to do in Excel. I had to extract Bold portions of 1000s of cells as part of the data cleanup process. Then I came across a simple VBA fix. In this video, let me share the solution and expose you to the limitless possibilities of VBA in Excel. You may want to put on your socks, cause this one is going to knock them right off π§¦π
π©βπ» Get the VBA Code Solution:
Visit https://chandoo.org/wp/get-the-bold-portion-of-a-cell-in-excel/ to get the full code and understand how to use it.
πΊ In this video:
The problem: How to get Bold text values from cells automatically.
Solution: using VBA custom function
Explanation: How to write your own getBoldText function in Excel and use it
β±Video Chapters:
0:00 - The impossible problem - getting the bold text values from cells
1:00 - Creating getBoldText function yourself
5:00 - Testing the function with sample data
π» MORE VBA EXAMPLES & VIDEOS
Learn more about VBA coding and automation with Excel using these videos:
Learn VBA in 20 minutes - https://youtu.be/5k-KpSkrROw
VBA Masterclass - https://youtu.be/7hd1Nn4cNyI
VBA Playlist - https://www.youtube.com/watch?v=7hd1Nn4cNyI&list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k
Full Length VBA Classes - https://chandoo.org/wp/vba-classes/
#VBA #excel #datacleaning
~ Automatically Extract BOLD Text with VBA [Adv. Excel]](https://i.ytimg.com/vi/wXJju5N4h58/mqdefault.jpg)








![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. π
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)
