Practical Charts Course Preview
14:16
The problem with slope charts
7:14
4 жыл бұрын
Пікірлер
@levon9
@levon9 24 күн бұрын
Super useful - thank you.
@practicalreporting
@practicalreporting 23 күн бұрын
Glad it was helpful!
@user-eco2023
@user-eco2023 2 ай бұрын
Your explanation is just like strawberry - so easy to grasp and very delicious! Thank you very very much!
@practicalreporting
@practicalreporting 2 ай бұрын
😂 Thanks, @user-eco2023!
@peltiertech1879
@peltiertech1879 2 ай бұрын
I never thought the irregularity of data points was necessary for using a step chart. The persistence of a value from one point to the next is the necessary requirement. The data point is in a sense distributed over the horizontal line segment. In the second chart, showing the average of hourly spot prices for each day over a span of several days, obviously a regular line chart is used. This is where I like to use markers, because markers help to drive home that the point has a discrete horizontal location, and is not distributed over a horizontal distance.
@PrathamGupta-g6b
@PrathamGupta-g6b 2 ай бұрын
Perfect Video. The only video one need
@valerioharvey7289
@valerioharvey7289 2 ай бұрын
finally an explanation that I can at least grasp
@agaming16
@agaming16 3 ай бұрын
Very informative
@matthewkarasoulis5680
@matthewkarasoulis5680 3 ай бұрын
Amazing video, really helped me out alot!
@koushikrafsan5820
@koushikrafsan5820 3 ай бұрын
Best video on Box plot, I found so far. It is extremely helpful for me.
@azwarmzafar
@azwarmzafar 4 ай бұрын
Thank you, Nick! I always gain valuable insights and inspiration from your content. I have a question: Could you share the font and color code (#) you typically use for the markdown notes in your graphs, including the ones in this video?
@bryanpierce616
@bryanpierce616 4 ай бұрын
I work with Nick and would be happy to answer your question about the purple callout text. The typeface is called "Segoe Print" and the color code is #7030A0. Take care!
@azwarmzafar
@azwarmzafar 4 ай бұрын
@@bryanpierce616 many thanks
@XoCortanaXo
@XoCortanaXo 6 ай бұрын
Super helpful! Thank you
@SweetPeachannel
@SweetPeachannel 6 ай бұрын
very useful, thank you and great explanation/
@StaceyBarr
@StaceyBarr 6 ай бұрын
Nick this is great. Such a clear process to follow and very powerful to see the visual changes as you tell the story of why.
@practicalreporting
@practicalreporting 6 ай бұрын
Thanks, Stacey! Delighted that you found the video to be of interest!
@Popup-hr4wm
@Popup-hr4wm 7 ай бұрын
Bro is LEGEND
@o_O29866
@o_O29866 10 ай бұрын
great job! thank you!
@practicalreporting
@practicalreporting 10 ай бұрын
Glad you found the video to be useful!
@kishore_balasubramaniam
@kishore_balasubramaniam 10 ай бұрын
The analyticspress website is not working?
@elviscalvinowusu385
@elviscalvinowusu385 10 ай бұрын
precise and concise
@matheuszapparoli1520
@matheuszapparoli1520 11 ай бұрын
Great Video!
@practicalreporting
@practicalreporting 10 ай бұрын
Thanks!
@user-sw5tx3pr7m
@user-sw5tx3pr7m 11 ай бұрын
Thank you for this !!! :)
@practicalreporting
@practicalreporting 10 ай бұрын
No problem 😊
@danielpalacios7546
@danielpalacios7546 11 ай бұрын
Thank U <3
@t199589
@t199589 11 ай бұрын
Oh my God thank you so much I finally understand it
@ivanvakulenko9830
@ivanvakulenko9830 Жыл бұрын
thanks
@Dergicetea
@Dergicetea Жыл бұрын
Mr., I have got a question. In which tool did you design the Frequency Heatmap? It was very stylish and clear to interpret data.
@practicalreporting
@practicalreporting Жыл бұрын
It was actually created in Excel, using conditional formatting (and making the numbers in the cells invisible, see support.microsoft.com/en-au/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33 )
@Pulvy10
@Pulvy10 7 ай бұрын
@@practicalreportingthis will only work if the value we want to represents are inside the table. What if we wanted to see the frequency of that value and represent that in the heatmap? in this vid that would be for example 20 people with >120k salary. Our data would have 20 different names with >120k salary. To represent that 20 people we need a table of countif salary>120k and we need to do this for each salary band. Then we do the conditional formatting.. CMIIW. Good vid!!!
@practicalreporting
@practicalreporting 7 ай бұрын
@marior6662 To make a distribution heatmap, yes, each cell has to contain (or be associated with) the number (or %) of values that fall within that cell. That value then determines the color of that cell. The example that I showed was created in Excel using conditional formatting, and the numbers in the cells were made invisible using this trick: support.microsoft.com/en-us/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33#:~:text=Hide%20cell%20values&text=On%20the%20Home%20tab%2C%20click,Type%20%3B%3B%3B%20(three%20semicolons).
@jsousa94
@jsousa94 Жыл бұрын
Would November 15th be World DataViz Day? 😅Looking forward to reading the 2 new books!
@nataliakiseleva6349
@nataliakiseleva6349 Жыл бұрын
Thank you! It's such a pleasure! The DnD metaphor is just the best! 🥰
@practicalreporting
@practicalreporting Жыл бұрын
LOL! Thanks!
@ebrahimemad5100
@ebrahimemad5100 Жыл бұрын
aswome
@practicalreporting
@practicalreporting Жыл бұрын
Thanks!
@MrX-wd8cm
@MrX-wd8cm Жыл бұрын
Underrated, pretty good explanantion
@anima8450
@anima8450 Жыл бұрын
As someone who's studying to become a psychologist this was very useful thank you!
@anima8450
@anima8450 Жыл бұрын
AHHHHHHHHHHHH
@dianndp4957
@dianndp4957 Жыл бұрын
It was very helpful and easy to understand, thanks for the hard work
@feshy
@feshy 2 жыл бұрын
Useless. to hard get better pay 2 win go play roblox you noob
@aleziafrimpong2828
@aleziafrimpong2828 2 жыл бұрын
Please how will you report - 1.113 skewness
@practicalreporting
@practicalreporting 2 жыл бұрын
Well, skewness in general (not just 1.113) will appear in a box plot as the "whisker" and/or "box" sections at one end of the box and whisker shape being shorter than the box and whisker shapes at the other end. In a distribution heatmap, skewness appears as colored cells at one extremity of a column of cells being darker than cells at the other extremity. Kind of hard to explain without visual aids...
@aleziafrimpong2828
@aleziafrimpong2828 2 жыл бұрын
Okay
@joyprokash4013
@joyprokash4013 2 жыл бұрын
Excellent sir.
@muhammadzaidhasan1426
@muhammadzaidhasan1426 2 жыл бұрын
something abouut u says you r canadian
@practicalreporting
@practicalreporting 2 жыл бұрын
I am!
@muhammadzaidhasan1426
@muhammadzaidhasan1426 2 жыл бұрын
@@practicalreporting sorry.....i am watching too much of "how i met your mother"
@daianamariatamas9934
@daianamariatamas9934 2 жыл бұрын
Très intéressant! I hope for another interview soon !
@thejohnringo
@thejohnringo 2 жыл бұрын
Your explanations were exceptionally clear.
@donakarunaratne6012
@donakarunaratne6012 2 жыл бұрын
Amazing video! Thank you!
@Must23
@Must23 2 жыл бұрын
This is veery useful ty~
@chessmaps-v5q
@chessmaps-v5q 2 жыл бұрын
Super video, nice content package. Thanks for skipping advertising fireworks
@practicalreporting
@practicalreporting 2 жыл бұрын
Thanks, Raymond. I appreciate it when marketing materials get straight to the point and skip the superlatives and buzzwords, so I try to do the same in my own materials.
@helenarc5790
@helenarc5790 2 жыл бұрын
this explanation helped me, thank youuuu!!!
@arandhir
@arandhir 2 жыл бұрын
Great video 👍
@BS33875
@BS33875 2 жыл бұрын
really nice, thank you.
@laymanpsychology6115
@laymanpsychology6115 2 жыл бұрын
very helpful
@RadfanOjailah
@RadfanOjailah 2 жыл бұрын
amazing
@Arqueovader
@Arqueovader 2 жыл бұрын
Nice video, but how do you locate extreme values?
@practicalreporting
@practicalreporting 2 жыл бұрын
I didn't cover it in the video, but there's a widely used convention for determining what's an outlier and showing them in a box plot. This article describes it: www.real-statistics.com/excel-capabilities/creating-box-plot-outliers-manually/
@rwlpfrench
@rwlpfrench 3 жыл бұрын
Thank you for articulating what I have seen as I explore this field, nice to know its not just me 🙂
@bpj4345
@bpj4345 3 жыл бұрын
good video nick
@philiplearnswoodworking
@philiplearnswoodworking 3 жыл бұрын
Loved this breakdown! You're bringing a lot of clarity to things that have been confusing and bugging me for a long time.
@nataliakiseleva6349
@nataliakiseleva6349 3 жыл бұрын
Thank you so much for this project! It's wonderful!
3 жыл бұрын
Thank you so much!
@practicalreporting
@practicalreporting 3 жыл бұрын
You're welcome!
@anthonyfancher3590
@anthonyfancher3590 3 жыл бұрын
Nick you are a legend! I am the director of data for a mental wellness startup for K-12 schools and love your content and am planning on overhauling our data viz products to your logic. Thank you
@practicalreporting
@practicalreporting 3 жыл бұрын
Delighted that you found the video to be useful, Anthony!