At storytelling with data, we help people and organizations create graphs that make sense and weave them into compelling, action-inspiring stories. Watch, learn, and become a better data storyteller through our videos and webinars.
📊 Practice & receive feedback at community.storytellingwithdata.com
🖥 Check out our numerous free resources: www.storytellingwithdata.com
🎧 Listen to our podcast: www.storytellingwithdata.com/podcast
🍎 Attend a workshop: www.storytellingwithdata.com/public-workshops
📚 Order our newest book: storytelling with YOU: amzn.to/3yksTOS
📚 Order the best selling book: storytelling with data: amzn.to/32rU8Xr
📚 Check out the practice book: storytelling with data: let's practice amzn.to/2KNSea4
Subscribe to start honing your data visualization and storytelling skills. kzread.info
Пікірлер
Can you also remove the 0.5 labels so that you have 0k, 1k, 2k, and put a tick mark at the midpoint of each whole number for visual reference? Removes more clutter from the axis
Yes, you could. There isn't a right or wrong way to format any graph, so you could reduce the labels to reduce clutter.
You are pretty ❤❤
I would never use a stacked bar chart. I would have created a dumbbell chart instead.
There are certainly many other ways to graph this data. It depends on what message you are trying to convey, the underlying data, the audience, etc. Feel free to check out the complete makeover and download the data. www.storytellingwithdata.com/blog/2017/10/30/a-story-about-opportunity
Why do you need an inner black border? The dark blue is already quite distinct from the white.
Oh, interesting! The border of the first stack (patients using PX) could be navy. It'd be a subtle change, but a navy border on the first stack would make the second stack stand out further. Great thought. In the example, the entire bar is outlined in black, as the black color encoding represents the total number of patients and not just those who aren't using PX. One of the exciting yet frustrating parts of data visualization is that there are multiple ways to format charts!
HOw did you add th names of the categories in the Y axis? That part is missing
The categories were manually added to the graph via a text box. Select the chart, then on the Insert tab, choose the Text Box option. You can then type the labels and adjust the spacing as needed to align with the gridlines. This is a brute-force approach that works well for ad-hoc charts.
@@storytellingwithdata :D ahh, thank you very much :)))))
I loved this video. Sharing with my team next week!
That’s awesome! So glad you enjoyed it and want to share with others.
LOVELY
Very nice
Thank you
I'm excited for this video I had it in my watch list for a week - glad I saved it.
That’s awesome! So glad you enjoyed it.
Can you speak a bit quicker as its too slow!
KZread has an amazing feature where you can change the speed up or down, depending on your needs or taste. Just click the gearbox in the lower right corner of the video.
@@storytellingwithdatathank you!
Learning a lot - thank you
Happy to hear it and thank you for the support!
Great Video..Must watch for anyone building dashboards, reports.. We are in a information overload world.. and Dashboard just adds to that problem. For effective decision making it is imperative to communicate your data in a manner that is short and simple to understand for your stakeholders.. and that is where we become storytellers.. every data has a story and needs to be told well and represented visually well..
This is insanely helpful. I always do this manually in PPT lol thanks for this!
nice video, are you open to ideas ?
It depends 🙂
@@storytellingwithdata okay, how to connect ?
Feel free to connect with us at [email protected]
very well tutorial! thank you
Briliiant. Which program did you use to make the changes?
Thanks for the kind words, I'm glad you enjoyed the video :-) All the graphs were built in a combination of Excel and PowerPoint with the video editing being performed in Da Vinci Resolve.
11:33 How do you determine the slope of that line?
This really is an exceptional skill set. Well done.
Awesome
🎉 I love it , it is very clear and gives the business insights
THANKS
Nice one, Alex!. Concise but full of knowledge.
Thank you :-). Glad you enjoyed it.
Excellent demonstration of a complicated chart. Great work!
Thank you for the kind words. Glad you enjoyed watching :-)
Absolutely inspiring! Cole's mini-workshop is a masterclass in the art of data storytelling. Watching her transform ordinary graphs into extraordinary visual narratives is nothing short of magical. She doesn't just teach you how to present data; she shows you how to craft compelling, action-inspiring stories that captivate your audience and drive meaningful decisions. This session is a must-watch for anyone looking to elevate their data communication skills to the next level. Thank you, Cole, for sharing your expertise and passion with us!
Thank you for your kind words! We're so glad you found the session inspiring :-)
This is brilliant
Thanks for watching :-)
Hi just wondering how common is lollipop chart used in real life? thanks
They are definitely more novel and, therefore, nowhere near as common as a standard bar chart.
Game changer for me! I will never look at data and work with data the same way. Thanks for sharing this content!
Thanks for the kind words. Glad you enjoyed it :-)
I'm THRILLED to share my new book! Daphne brings the magic of data & graphs to kids of all ages. Visit the site linked in the description above to learn about some fun promotions (including early access!). Comment below with any questions you have about the book, I'll be happy to answer them.
How to order it in Europe Union?
@@evgeniy9582 Cole here. Hello and thanks for your question! You can order from your local Amazon or place a special order with your favorite bookseller. Availability in Europe and the rest of the world will lag US by a week or two (the books are all being printed in the US for consistent quality). Thanks for your interest!
can you please share the dashboard link presented in the video ?
No problem, here you go: bit.ly/exploreandexplain
Thanks for sharing.
😂😂😂😂😂😂😂
Great video, i am pretty new to this, can I please ask, how do you get the proposed value when comparing the current and proposed viewership, target audience and overall cost? Is there a formula on how to get the proposed value? Thank you so much.
Thanks for asking. For time and clarity, we simplified and condensed some of the exploratory analyses in this mini-workshop. We decided to simply set benchmarks: compared to the larger set of shows at the beginning, we wanted: our smaller lineup to be similar to our hit show (and we found out in our analysis, that meant "find shows popular with millennials"); to have about 15-20% as many shows to manage; to get more viewers per dollar spent; and to have shows that aren't as expensive. We weren't fully able to meet that last requirement, as it turns out, but like the traditional cliche of "fast, cheap, good - you can only pick two," it's sometimes not viable to meet all of the original goals. What we were able to recommend to our leadership team met all of the other goals, and we tried to make a case for why that was the direction to go. So there's no magic formula here that aggregates or puts a numeric index value for each show across all of the dimensions we considered. One could do that, but it seems to me that doing so is maybe more effort than is necessary. Logic and common sense found us a reasonable collection of shows that met all or most of our goals individually, and made sense collectively. Having said that, you do have access to the dashboard and all of the underlying data, so if you want to try to build a numeric model that weighs and balances all of our stated goals, and generates an index value for each show, that might be an interesting experiment. I'll close with this thought, one that my long-ish history in analysis has led me to believe: in any exploratory or predictive analysis, there's a danger of getting fixated on finding the absolute, no-doubt-about-it, bulletproof answer for what to do next. To find this elusive solution, it's easy to get sucked in, and spend weeks or months building models, running simulations, considering more and more dimensions (what if some of the shows had shorter seasons? are some of them growing in popularity? could we defray production costs by bringing in partners or sponsors? and so on), until you're so paralyzed by the analyses that no action ever seems like the optimal one. My wife and I have a running joke that comes from the Netflix show "Master of None." Aziz Ansari plays the lead character, and one night he is trying to use his phone to find the best taco truck in the city. He's having a hard time getting the info he wants, and and one point whines in frustration, "What am I supposed to do, eat at the SECOND-BEST taco truck?" The joke, of course, is that whether any given taco truck is the second-best, third-best, or tenth-best is irrelevant. It's (a) an arbitrary ranking, and (b) probably not worth worrying over. You just don't want to find the WORST taco truck. Your analysis should serve the purpose of understanding the challenges that we're facing, and finding a reasonable, positive action that will mitigate or overcome those challenges. Often, if you can find the 90th percentile answer in 30 minutes, you're better off being satisfied with that and moving on, rather than taking 3 weeks to find the 99th percentile answer. The second-best taco truck is still going to give you a pretty great meal.
@@MikeCisnerosSWD THANK YOU SO MUCH for your time to answer my questions. it is much appreciated. It is very helpful. thanks again :)
@@MikeCisnerosSWDI can reread this over and over. It's a really brilliant answer. 🎉
Excited to see more of this. Amazing!!
Please which softwares are used for graphing and presentation?
The graphs used in the final presentation (explanatory visuals) were created using Powerpoint. The dashboard and other exploratory visuals were built in Tableau.
this is a phenomenal transformation. I have a similar graph as the before example and will definitely apply this information when trying to make it over!
Happy to hear you found this helpful! Good luck redesigning your slide.
fantabulous
Wow , We need more video like this , it improves our analytical and other skill ,[sry for my english]
what if i have like 8 thousand points?
worked it out. if anyone had the same question. create another column and put the label next to the table for the points you want to mark then select value from cells and select the new column
This is a great session, totally beyond my expectation. Thank you Mike & Cole for sharing with us
Thanks for the lessons! Crystal clear explanation and very informative.
How did you change the line style for only a segment?
Great question! When you click on a line the entire series is selected. Click again (2x in total) to select only a segment or data point in the series. Here's a short tutorial: kzread.infoSD8tI1H7xIs
This is an amazing and helpful session. Thanks for sharing.
Cole here. You're welcome and thanks for your kind comment! Mark your calendar for our next live event-I'll be presenting (and reading) to grown-ups and kids of all ages: www.daphnedrawsdata.com/
Very well presented. Good example session from beginning to end. Thanks!
Thank you!
Thank you for this amazing mini-workshop! I am the type of person who's rewatching again🤣 Just have a quick question, how does Mike come up with 40% viewership on 20:27.
Hi! Great question. In working through the analysis, we had come to understand that limiting our potential list of shows to keep to those with an audience of 50% millennial or more wasn't going to yield enough viable candidates. It would be ideal to get as big of a chunk of our audience in our target demographic as possible, but 50% turned out to be too high of a bar to clear. Given this, we had to drop our cutoff point some. Logically, we wouldn't want to go any lower than 33% millennial, since that's not really targeting our chosen demographic at all. For the purposes of exploration, we chose a threshold between 33% and 50%, and decided that 40% was broad enough to start from. As it turns out, even that was a bit too high-you can see in the sci-fi and drama genres, we wind up keeping a couple of shows that are JUST barely below 40%, but have audiences and/or ROIs that are so good that it seemed foolish to exclude them over a few tenths of a percentage point. We often say that visualizing data is a blend of art and science; so too is exploring and analyzing data. We can use objective, hard-line, quantitative values as cut-off points or filters for our data, but we also have to be thoughtful about the actual objective we're driving toward. Also, keep in mind that any objective, quantitative values we use as filters were at some point selected arbitrarily by human beings. The TL;DR here is: 40% is a boundary we chose because it seemed a reasonable compromise between audiences that were majority-millennial (50%) and random-chance millennial (33.3%). It was a guideline, not a rule, however: looking at options just outside that boundary helped ID other potentially valuable shows to keep.
Review no 4 is "listen to yourself" not review number 3, ya ibu. Thanks for the knowledge.
That's what I need ! Thank you so much for this shared knowledge 🙏🏼
Glad it was helpful!
Thank you to everyone who joined live, as well as those who are watching the recording! I always enjoy watching Mike present. For additional insight, I'll share a tech challenge behind the scenes: at around minute 32, Mike's laptop started threatening to reboot. Every time he needed to advance a slide, he had to stand, close the window directing him to force-quit, quickly advance the slide, then sit back down-all while speaking coherently! I was proud to watch him masterfully maintain composure during this unexpected hiccup. This was only possible given how well he knew his material. When we are adequately prepared, we can respond gracefully-if not perfectly-to almost any challenge that arises!
Very insightful ❤
I didn't win a book 😭
Sorry to hear that! You can still access plenty of free resources: as mentioned in the session, check out our other videos here on KZread, and practice and exchange feedback in our online SWD community: community.storytellingwithdata.com/