sqlbelle
sqlbelle
  • 164
  • 3 075 383
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/
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

Komentáře

  • @SatyakalaCh
    @SatyakalaCh Před 15 hodinami

    Thank you so much for these videos with crystal clear explanation .....I love to learn the concepts from your videos

  • @zeeshanahmed2594
    @zeeshanahmed2594 Před 20 hodinami

    How can I get the adjusted coffee chain dataset used in the video?

  • @ankittyagi1607
    @ankittyagi1607 Před 21 hodinou

    I don't have any qualified words which can do justice with your great appreciation. ❤

  • @angelav7999
    @angelav7999 Před dnem

    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])}?

  • @user-uw9wc7gj7z
    @user-uw9wc7gj7z Před 3 dny

    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 ❤

  • @zeeshanahmed9719
    @zeeshanahmed9719 Před 4 dny

    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.

  • @zeeshanahmed9719
    @zeeshanahmed9719 Před 5 dny

    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?

  • @nekpenegbon4051
    @nekpenegbon4051 Před 6 dny

    Thank you

  • @Aayisha-d2t
    @Aayisha-d2t Před 7 dny

    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.

  • @ramsharyt
    @ramsharyt Před 10 dny

    great video marathon on charts . gives a quick overview of all types opf charts. Fantastic insights. Thanks again...

  • @didichesmain8827
    @didichesmain8827 Před 15 dny

    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

  • @tailethanh8074
    @tailethanh8074 Před 15 dny

    I must said wtf while watching your video. It really blown my mind. Outstanding video.

  • @shubham7564
    @shubham7564 Před 18 dny

    Very Helpful, Thank You.

  • @tailethanh8074
    @tailethanh8074 Před 20 dny

    really really informative video, learn a lot from it. THANKS.

  • @RAJENDERKUMAR-ro8kb
    @RAJENDERKUMAR-ro8kb Před 21 dnem

    plz don't play background music .....it's topic part of career........?

  • @gerthaljr
    @gerthaljr Před 21 dnem

    You`re AWSOME! I learn a lot with your videos, and your explain is so easy. Thank you for your time

  • @ScissorN
    @ScissorN Před 21 dnem

    Perfect

  • @kennethwakhungu6513
    @kennethwakhungu6513 Před 23 dny

    This lady is fire on Tableau.

  • @jimbo5603
    @jimbo5603 Před 26 dny

    Doesn't actually explain anything

  • @ryuhayabusa3540
    @ryuhayabusa3540 Před 27 dny

    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.

  • @vsagar4b38
    @vsagar4b38 Před 28 dny

    Thanks for Sharing

  • @gritmanish
    @gritmanish Před 28 dny

    Thank you

  • @arvind7855
    @arvind7855 Před měsícem

    Where do we get the datasets so we can follow your videos and do along with you

  • @gritmanish
    @gritmanish Před měsícem

    Thank you Donabel

  • @harshabharti4509
    @harshabharti4509 Před měsícem

    How can I add dynamic up and down arrows for only my row totals not to the other columns in the table?

  • @marathiManus10
    @marathiManus10 Před měsícem

    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❤

  • @GopiKrishna-o7o
    @GopiKrishna-o7o Před měsícem

    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

  • @gritmanish
    @gritmanish Před měsícem

    Thank you very much

  • @gritmanish
    @gritmanish Před měsícem

    Thank you very much

  • @Priya-lg2ne
    @Priya-lg2ne Před měsícem

    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.

  • @manishsathe8371
    @manishsathe8371 Před měsícem

    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.

  • @gritmanish
    @gritmanish Před měsícem

    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.

  • @jubilantakku6993
    @jubilantakku6993 Před měsícem

    best video for LOD

  • @MrAstonmartin78
    @MrAstonmartin78 Před měsícem

    Useful tips. Thx

  • @BezawadaKeerthi
    @BezawadaKeerthi Před měsícem

    Great

  • @kurtbrummert1742
    @kurtbrummert1742 Před měsícem

    These are useful videos, but the background music is a bit loud, and probably not necessary at all.

  • @vsagar4b38
    @vsagar4b38 Před měsícem

    Great Nicely Explained,Enjoyed the Video. Thanks

  • @AliTwaij
    @AliTwaij Před měsícem

    This is amazing. Really impressive. Thankyou v much

  • @AliTwaij
    @AliTwaij Před měsícem

    Very nice thankyou. I really like the viz in tooltip feature.

  • @rahulhgupta
    @rahulhgupta Před měsícem

    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?

  • @rltewari
    @rltewari Před měsícem

    it helped me a lot

  • @cindymit2438
    @cindymit2438 Před měsícem

    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.

  • @bertolabra3681
    @bertolabra3681 Před měsícem

    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

  • @harshabharti4509
    @harshabharti4509 Před měsícem

    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

  • @harshabharti4509
    @harshabharti4509 Před měsícem

    @sqlbelle, How can I limit the indicator to just one column like a column that indicates the total or sum of other columns?

  • @Billamani03
    @Billamani03 Před měsícem

    😊😊

  • @shiv-u2s
    @shiv-u2s Před měsícem

    What an amazing session ....Simply brilliant lecture!!!

  • @kennisrogers2585
    @kennisrogers2585 Před měsícem

    This was an amazing guide!

  • @krishna369-t4o
    @krishna369-t4o Před měsícem

    Great video. Thank you so much!