![sqlbelle](/img/default-banner.jpg)
- 164
- 3 081 944
sqlbelle
Canada
เข้าร่วมเมื่อ 1 ก.ย. 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/
มุมมอง: 2 559
วีดีโอ
LOD #11 - How to Percent Difference Against Average in a Range
มุมมอง 7793 หลายเดือนก่อน
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
มุมมอง 2K3 หลายเดือนก่อน
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
มุมมอง 1K3 หลายเดือนก่อน
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
มุมมอง 1.4K3 หลายเดือนก่อน
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
มุมมอง 2.1K4 หลายเดือนก่อน
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
มุมมอง 2.8K4 หลายเดือนก่อน
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
มุมมอง 2.8K4 หลายเดือนก่อน
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
มุมมอง 4.3K4 หลายเดือนก่อน
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
มุมมอง 9K4 หลายเดือนก่อน
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
มุมมอง 3.5K4 หลายเดือนก่อน
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
มุมมอง 1.7K4 หลายเดือนก่อน
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
มุมมอง 8K4 หลายเดือนก่อน
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
มุมมอง 11K5 หลายเดือนก่อน
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
มุมมอง 1.1K5 หลายเดือนก่อน
#Tableau - Use Bar Charts to Show Change in Rank Over Time
#Tableau - Create Connected Scatter Plots to Show Change in Rank Over Time
มุมมอง 7225 หลายเดือนก่อน
#Tableau - Create Connected Scatter Plots to Show Change in Rank Over Time
#Tableau - Create Bump Charts to Show Change in Rank Over Time
มุมมอง 4.1K5 หลายเดือนก่อน
#Tableau - Create Bump Charts to Show Change in Rank Over Time
Tableau - What percent of customers account for 80% of sales?
มุมมอง 6K8 หลายเดือนก่อน
Tableau - What percent of customers account for 80% of sales?
Master Tableau's Order of Operations - Beginner's Guide - Comprehensive Tutorial with examples
มุมมอง 16K8 หลายเดือนก่อน
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
มุมมอง 3.2K9 หลายเดือนก่อน
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
มุมมอง 14K10 หลายเดือนก่อน
Tableau Quick Tip - SUM vs WINDOW_SUM vs TOTAL
Dynamic Zone Visibility | Comprehensive Tableau Tutorial with 4 Practical Use Cases
มุมมอง 50K10 หลายเดือนก่อน
Dynamic Zone Visibility | Comprehensive Tableau Tutorial with 4 Practical Use Cases
Fix messy data: Practical Guide using Union in Tableau and Microsoft Power Query
มุมมอง 6K10 หลายเดือนก่อน
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
มุมมอง 5K10 หลายเดือนก่อน
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)
มุมมอง 12Kปีที่แล้ว
Tableau for Beginners - Shared Axis vs Dual Axis Charts (aka Combined Charts vs Combo Charts)
Tableau - Dynamic Axis Titles are finally here!
มุมมอง 13Kปีที่แล้ว
Tableau - Dynamic Axis Titles are finally here!
Tableau Tutorial for Beginners - Rank over time - bump chart, slope chart, connected scatter plot
มุมมอง 6Kปีที่แล้ว
Tableau Tutorial for Beginners - Rank over time - bump chart, slope chart, connected scatter plot
Tableau, LOD and SQL - Behind the scenes | sqlbelle
มุมมอง 9Kปีที่แล้ว
Tableau, LOD and SQL - Behind the scenes | sqlbelle
Tableau Prep - Add Rows for Daily and Monthly Reports / Dashboards | sqlbelle
มุมมอง 4.9Kปีที่แล้ว
Tableau Prep - Add Rows for Daily and Monthly Reports / Dashboards | sqlbelle
Tableau and Custom SQL - plus stored procedure, parameters and initial SQL | sqlbelle
มุมมอง 42Kปีที่แล้ว
Tableau and Custom SQL - plus stored procedure, parameters and initial SQL | sqlbelle
this vedio was very useful, can you please teach to fillter out the tickers which fall under negative value based on % Difference from Selected Range instead of seleting one by one ticker and see which is negative or possitve
you are awesome madam and excellent way of demonstrating and explaining
Ei recebo todas as bênçãos em minha vida
half understood, but what I mostly don't understand is why is this useful?
You explanations are awesome. Your approach of breaking down a complex concept into the fundamentals are really impressive.Thank you Ma'am, for your amazing tutorials.
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])}?
"we have the same numbers for every year at the most frequent level (17, 13)" 13 7 17 1 consider 13 first: For this row grand total is 7, it means there are 7 distinct customers each ordered through 13 distinct order IDs. and for every year countd(customerID) is 7, means all these 7 customers ordered in 2017, 2018, 2019 and 2020. Similarly for 17 1.
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