depictdatastudio

This is an Eval Central archive copy, find the original at depictdatastudio.com. Wondering how to visualize your qualitative data? Maybe you’ve got open-ended survey responses, focus group notes, or speech transcripts. Qualitative data visualization can bring our words and phrases to life. My friend Jon Schwabish from PolicyViz asked me to partner on his One […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Want to pass the Excel certification exam? Maybe you want proof that you can rock Excel for your resume? For your LinkedIn profile? Do you want a confidence boost that, yes, you know Excel? Do you want your boss to feel confidence that, […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Vlookup is my all-time favorite function in Excel! (Well, the entire lookup family—vlookup, hlookup, index-match, and xlookup.) In this blog post, you’ll learn: What vlookup is used for; Why vlookup can be tricky; and How to fill in the four pieces of the […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. That beautiful chart is one of the last steps in the analytical process. For most projects, it goes something like this: Planning. Figure out what data you need. You might get data requests from your boss. You might hold a months-long strategic planning […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. “You should go work at Microsoft and fix Excel’s terrible formatting.” I can’t tell you how many times I’ve heard this from workshop participants. Bill Gates, are you reading this?? Microsoft Excel is lonnnnng overdue for some updates. Don’t get me wrong—it’s still […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. “Which software program is best for data visualization???” This is one of the most common questions about getting started with graphs, charts, and diagrams. There are plenty of great software programs, like Excel and Tableau—and even PowerPoint! There’s also a lesser-known secret to […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. How can we design the best possible dashboards for business leaders? I addressed this question on the Data Strategy Show with Samir Sharma. Samir Sharma is a data strategy and analytics leader, CEO and Founder of datazuum. He has a history of helping […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently had the chance to talk with Emily Mills, who is a professional illustrator and expert in sketchnoting. She is also the founder of the Sketchnote Academy and author of The Art of Visual Notetaking.  Emily was a guest speaker in our […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently had the chance to talk with my longtime friend, Ben L. Collins, who is THE Google Sheets instructor.   Ben joined as a special guest at Office Hours (special live sessions for full course students where we share ideas and give feedback […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. In September, I was invited to speak at a Women in Data panel alongside Rebeca Pop. Thanks to Kanchan Malhotra for inviting me and for organizing the event!  Women in Data is an international non-profit organization started in 2015 whose mission is to bring women […]