![sqlbelle](/img/default-banner.jpg)
- 164
- 3 075 383
sqlbelle
Canada
Registrace 1. 09. 2020
I share tutorials, tips and tricks on Tableau and SQL, and other data-related topics. sometimes I share about life too.
LET'S CONNECT
sqlbelle.ck.page
NEWSLETTER
sqlbelle.ck.page/posts
BLOG
www.sqlbelle.com/
ARTICLES
sqlbelle.medium.com/
DIGITAL PRODUCTS - Practice sheets, sample questions, cheat sheets
sqlbelle.gumroad.com
ONLINE COURSES
courses.sqlbelle.com
TWITTER
@sqlbelle
CUSTOM TRAINING
Please reach out by email or LinkedIn for custom training creation and/or delivery.
DISCLAIMER
All views expressed here are my own and do not represent the opinion of any entity whatsoever with which I have been, am now, or will be affiliated. Any tutorials are based on my personal work/experience with the product/technology/methodology and provided for educational purposes only.
LET'S CONNECT
sqlbelle.ck.page
NEWSLETTER
sqlbelle.ck.page/posts
BLOG
www.sqlbelle.com/
ARTICLES
sqlbelle.medium.com/
DIGITAL PRODUCTS - Practice sheets, sample questions, cheat sheets
sqlbelle.gumroad.com
ONLINE COURSES
courses.sqlbelle.com
@sqlbelle
CUSTOM TRAINING
Please reach out by email or LinkedIn for custom training creation and/or delivery.
DISCLAIMER
All views expressed here are my own and do not represent the opinion of any entity whatsoever with which I have been, am now, or will be affiliated. Any tutorials are based on my personal work/experience with the product/technology/methodology and provided for educational purposes only.
How to Connect with Your Audience Through Data Stories
In this lesson, we dive into data storytelling and creating effective visuals.
As data professionals, we often have a lot of data and need to find hidden insights.
But how do we turn those findings into a story our audience can understand?
This video will provide tips on how to create compelling data stories and pick the right visuals.
--
This video is one of the modules in a bigger course on data visualization best practices, which I co-created with Data Governance expert George Firican.
Data Visualization for Data Storytelling
www.lightsondata.com/data-visualization-for-data-storytelling-course/
As data professionals, we often have a lot of data and need to find hidden insights.
But how do we turn those findings into a story our audience can understand?
This video will provide tips on how to create compelling data stories and pick the right visuals.
--
This video is one of the modules in a bigger course on data visualization best practices, which I co-created with Data Governance expert George Firican.
Data Visualization for Data Storytelling
www.lightsondata.com/data-visualization-for-data-storytelling-course/
zhlédnutí: 2 541
Video
LOD #11 - How to Percent Difference Against Average in a Range
zhlédnutí 766Před 3 měsíci
This video covers in depth the 11th use case from the Top 15 Level of Detail (LOD) Examples, based on the Tableau Whitepaper written by Bethany Lyons. This use case focuses on comparing the average value over a specified date range to a particular value elsewhere in the chart. Learn to create charts that show specific date ranges, allowing for dynamic comparisons of daily values across differen...
LOD #10 - Return Purchase by Cohort - #Tableau Level of Detail Expressions #Calculations
zhlédnutí 2KPřed 3 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #10 - Return Purchase by Cohort This step-by-step, easy-to-follow tutorial shows how to do some common cohort analysis using Level of Detail (LOD) Expressions in Tableau. This use case builds...
LOD #9 - Investigate First and Last Day of Period Values #Tableau Level of Detail #calculations
zhlédnutí 998Před 3 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com LOD #9 - Investigate First and Last Day of Period Values The 9th use case focuses on creating calculations that highlight monthly sales trends, while also diving into the specifics of sales on the fir...
LOD #8 - Actual vs Target - Did we meet target sales #Tableau Level of Detail #calculations
zhlédnutí 1,4KPřed 3 měsíci
Sign up for weekly, bite-sized data lessons, and practical SQL and Tableau tutorials. newsletter.sqlbelle.com #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case LOD #8 -Actual vs Target - Did we meet target sales This video shows how to use Level of Detail (LOD) expressions in Tableau to analyze profit and targets. Calculations incl...
LOD #7 - Average of Top Values - What is the avg of max sales per location #Tableau #calculations
zhlédnutí 2,1KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case LOD #7 -Average of Top Values This tutorial shows how to create different calculations to determine the average of the top sales by customer within each state, emphasizing the power of LOD ex...
LOD #6 - Comparative Analysis - How does one category compare to another #Tableau #calculations
zhlédnutí 2,8KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case LOD #6 - Comparative Analysis This video tutorial shows step-by-step how to perform comparative analysis in Tableau using features like LOD expressions, parameters, and visual indicators. - I...
LOD #5 - New Customer Acquisition Trend #Tableau Level of Detail Expressions #calculations
zhlédnutí 2,7KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #5 - New Customer Acquisition Trend This step-by-step, easy-to-follow tutorial shows how to visualize new customer acquisition trend: What's covered in this video: - Understanding Customer Ac...
LOD #4 - Percent of Total - LOD vs Table Calculations #Tableau Level of Detail Expressions
zhlédnutí 4,3KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #4 - Percent of Total - LOD vs Table Calculations This step-by-step, easy-to-follow tutorial shows the difference between table calculations and LOD when calculating percent of total. It also...
Tableau Filter Actions Explained - Comprehensive Step-by-Step Tutorial with BONUS Topics
zhlédnutí 9KPřed 4 měsíci
LET'S CONNECT Sign up for weekly bite-sized tips, lessons, and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com This video tutorial offers an in-depth exploration of Tableau's filter actions. You will learn how to use filter actions that allow dashboard users to interact with the data by selectin...
LOD #3 - Daily Profit KPI - Percentage of Profitable vs Unprofitable Days #Tableau Level of Detail
zhlédnutí 3,5KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons, and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #3 - Daily Profit KPI - Percentage of Profitable vs Unprofitable Days This step-by-step, easy-to-follow tutorial provides a comprehensive guide on analyzing business performance over time us...
What are the different #Tableau Actions - Introduction
zhlédnutí 1,7KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons, and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com What are the different Tableau Actions? - Introduction Tableau actions allow us to introduce more interactivity between our Tableau objects (sheets, dashboards, web) by interacting with marks. This v...
LOD #2 - Cohort Analysis - #Tableau Level of Detail Expressions #Calculations #tableaututorial
zhlédnutí 8KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #2 - Cohort Analysis This step-by-step, easy-to-follow tutorial shows how to do some common cohort analysis using Level of Detail (LOD) Expressions in Tableau. The tutorial starts with the ba...
LOD #1 - Calculating Customer Order Frequency - #Tableau Level of Detail Expressions #Calculations
zhlédnutí 11KPřed 4 měsíci
Sign up for weekly bite-sized tips, lessons and practical tutorials. sqlbelle.ck.page/posts #tableau #analytics #lod #calculation Practice Questions and other digital products sqlbelle.gumroad.com Use Case #1 - Customer Order Frequency This step-by-step, easy-to-follow tutorial shows how to analyze customer order frequency using Level of Detail (LOD) Expressions in Tableau. The tutorial aims to...
#Tableau - Use Bar Charts to Show Change in Rank Over Time
zhlédnutí 1,1KPřed 5 měsíci
#Tableau - Use Bar Charts to Show Change in Rank Over Time
#Tableau - Create Connected Scatter Plots to Show Change in Rank Over Time
zhlédnutí 715Před 5 měsíci
#Tableau - Create Connected Scatter Plots to Show Change in Rank Over Time
#Tableau - Create Bump Charts to Show Change in Rank Over Time
zhlédnutí 4,1KPřed 5 měsíci
#Tableau - Create Bump Charts to Show Change in Rank Over Time
Tableau - What percent of customers account for 80% of sales?
zhlédnutí 6KPřed 8 měsíci
Tableau - What percent of customers account for 80% of sales?
Master Tableau's Order of Operations - Beginner's Guide - Comprehensive Tutorial with examples
zhlédnutí 16KPřed 8 měsíci
Master Tableau's Order of Operations - Beginner's Guide - Comprehensive Tutorial with examples
Tableau Quick Tip - How to add 2 coordinated colors to chart - Tree Map and Sunburst Chart
zhlédnutí 3,2KPřed 9 měsíci
Tableau Quick Tip - How to add 2 coordinated colors to chart - Tree Map and Sunburst Chart
Tableau Quick Tip - SUM vs WINDOW_SUM vs TOTAL
zhlédnutí 14KPřed 10 měsíci
Tableau Quick Tip - SUM vs WINDOW_SUM vs TOTAL
Dynamic Zone Visibility | Comprehensive Tableau Tutorial with 4 Practical Use Cases
zhlédnutí 49KPřed 10 měsíci
Dynamic Zone Visibility | Comprehensive Tableau Tutorial with 4 Practical Use Cases
Fix messy data: Practical Guide using Union in Tableau and Microsoft Power Query
zhlédnutí 6KPřed 10 měsíci
Fix messy data: Practical Guide using Union in Tableau and Microsoft Power Query
Worth it? Becoming a Data Analyst with Google Data Analytics Certificate - Comprehensive Review
zhlédnutí 5KPřed 10 měsíci
Worth it? Becoming a Data Analyst with Google Data Analytics Certificate - Comprehensive Review
Tableau for Beginners - Shared Axis vs Dual Axis Charts (aka Combined Charts vs Combo Charts)
zhlédnutí 12KPřed rokem
Tableau for Beginners - Shared Axis vs Dual Axis Charts (aka Combined Charts vs Combo Charts)
Tableau - Dynamic Axis Titles are finally here!
zhlédnutí 13KPřed rokem
Tableau - Dynamic Axis Titles are finally here!
Tableau Tutorial for Beginners - Rank over time - bump chart, slope chart, connected scatter plot
zhlédnutí 6KPřed rokem
Tableau Tutorial for Beginners - Rank over time - bump chart, slope chart, connected scatter plot
Tableau, LOD and SQL - Behind the scenes | sqlbelle
zhlédnutí 9KPřed rokem
Tableau, LOD and SQL - Behind the scenes | sqlbelle
Tableau Prep - Add Rows for Daily and Monthly Reports / Dashboards | sqlbelle
zhlédnutí 4,9KPřed rokem
Tableau Prep - Add Rows for Daily and Monthly Reports / Dashboards | sqlbelle
Tableau and Custom SQL - plus stored procedure, parameters and initial SQL | sqlbelle
zhlédnutí 42KPřed rokem
Tableau and Custom SQL - plus stored procedure, parameters and initial SQL | sqlbelle
Thank you so much for these videos with crystal clear explanation .....I love to learn the concepts from your videos
How can I get the adjusted coffee chain dataset used in the video?
I don't have any qualified words which can do justice with your great appreciation. ❤
One comment at minute 7:50: Why do we have the same numbers for every year at the most frequent level (17, 13)? I interpret this report as follows: one customer bought 17 orders every year. If I add customers to the tooltip, I see the one who bought 17 orders every year, which seems incorrect. Do you think the calculated field should be modified like this: {FIXED [Customer ID], [Year Order Date]: COUNTD([OrderID])}?
Please keep up the great work. Your videos have helped me a lot in my learning journey. Every video is detailed and well explained. Thank you so much ❤
In customer acquisition trend use case, countd(customer_id) at a given min(order date) can also include those customer_ids that placed its 2nd or 3rd order on that day. Example: On 1st March 2017 five customers placed order for the very first time, including HR-14770. Tableau showing countd(customer id)=5 On 2nd March 2017 two customers placed order for the very first time. countd(customer_id)= 2. Now I added a row for one more order of HR-14770 on 2nd March 2017. This count should not be included for 2nd March 2017 because this is not HR-14770's very first order and HR-14770 is not a new customer on 2nd March 2017. But after addition of this row, countd(customer_id) for 2nd March 2017 changed from 2 to 3.
Thank you Ma'am, your explaination are excellent. I understood everything explained in the video except @ 30:00 in the acquisition trend chart, I got the same chart, but when I changed week (First order date fixed) to day(First order date fixed) to check the counts manually on Excel sheet, I see difference in the way in which countd(customer_id) and count(customer_Id) is calculated. countd(customer_id) calculation is intuitive and it counts distinct customer_id on that particular date only. whereas, in count(customer_id) calculation it counts all rows of that customer_id including the particular date as well as other dates. Please explain why count(customer_id) counting rows of customer_Id for other dates also?
Thank you
hi, The video is very helpful. But I am Not able to change BLANK fields (having no values) to 0 (zero). I think these conditions works only for NULL values. Please guide.
great video marathon on charts . gives a quick overview of all types opf charts. Fantastic insights. Thanks again...
Hi, can we have an explanation of the Alteryx? How to display the values? How to make them visible even if it’s several values
I must said wtf while watching your video. It really blown my mind. Outstanding video.
Very Helpful, Thank You.
really really informative video, learn a lot from it. THANKS.
plz don't play background music .....it's topic part of career........?
You`re AWSOME! I learn a lot with your videos, and your explain is so easy. Thank you for your time
Perfect
This lady is fire on Tableau.
Doesn't actually explain anything
Hii, could you please make a video on how to calculate dynamic threshold that can be changed by the end user? The gold is if the dollar value reaches the threshold, a message in sheet title should say something. The problem i have is that if multiple products reach that threshold, the message shows "All" instead of the message i want shown.
Thanks for Sharing
Thank you
Where do we get the datasets so we can follow your videos and do along with you
Thank you Donabel
How can I add dynamic up and down arrows for only my row totals not to the other columns in the table?
Hi Sqlbelle! First off, #bigFan Offtopic query about CSV downloading: I have a table in my dashboard, that some of colleagues in the company need to download as CSV. And few higher managers don't want to download CSV in regular way - they want single button to download data in view with applied filters. I tried to create a download button, and assigning dashboard URL ending with ".CSV" (Andy Kriebel's trick, a.w.a. extension from informationLab). Issue is - 10s of measures that I have arranged in individual columns get squashed into 2 columns: measureNames, measureValues. How to solve this? It would be helping hand if you can make a quick video about this❤
Thank you so much for your videos on Tableau , I always search your videos only whenever I need the tableau concept ...Thank you so much
Thank you very much
Thank you very much
Wonderful explanation with all the use cases and how to implement them. I learnt so much from this video. Thank you so much and keep up the great work.
Hi Madam How can we automate task in Tableau + Alteryx Project?? In case of Tableau + Tableau Prep Builder we can create workflow in Tableau Prep Builder then we can publish output ( Superstore.hyper) as well as workflow to Tableau Server. Then We can connect Tableau Desktop to data output( Superstore.hyper) from Alteryx which is already published on Tableau Server. After dashboard development with can publish Tableau Dashboard to Tableau Server. Then we can schedule data refresh and Workflow Refresh on Tableau Server.
Thank you. At least 10 years working on Tableau and I have never seen anyone not even from Tableau marketing guys showing this detailed explanation.
best video for LOD
Useful tips. Thx
Great
These are useful videos, but the background music is a bit loud, and probably not necessary at all.
Great Nicely Explained,Enjoyed the Video. Thanks
This is amazing. Really impressive. Thankyou v much
Very nice thankyou. I really like the viz in tooltip feature.
Query: At 9:00, you have used fixed LOD to show correct salary in joins example. If we use average of salary or min of salary or max salary without LOD that's also gives same result. Is there any specific reason to use LOD here?
it helped me a lot
When I add the calculation to the filter for the charts I want, why do my charts disappear on their own worksheet except for the first worksheet I added the calculation to? They'll show in the dashboard as normal but not in their own respective sheets.
Hello there, i just want to consult on you on how to work on 3 parameter with each of it has 3 list inside of it. Each required individual chart to show. Theres a hierarchy on the selection that would define which charts to show. Example the first parameter is (QTD, Yearly, Monthly), second parameter is (Region A,B), third parameter is (CostumerA,B). thank you appreciate your help
how to format header name when some of the header name are not visible properly in a table and we dont want to change table width
@sqlbelle, How can I limit the indicator to just one column like a column that indicates the total or sum of other columns?
😊😊
What an amazing session ....Simply brilliant lecture!!!
This was an amazing guide!
Great video. Thank you so much!