A Real-Life Excel Test from a Job Interview: Can You Pass??

Feb 18th, 2020 / Data Analysis
Ten year ago, I was interviewing for an analyst position and I’d sat in the interviewer’s office going on and on about all my great spreadsheet skills. And then the interviewer was like, “Prove it. Come with me.” I was then led to an office with a computer that had an Excel test just waiting for me. My heart just about stopped– what did I say I knew how to do again?? Spoiler alert: I got the job but fast forward ten years later- can I still pass that Excel test today?
More »

Taking Federal Grant Data from Dull to Dynamite with Custom Visualizations

If you’ve ever worked with publicly available government data, you probably know the headache and eye strain that comes with trying to make sense of a huge spreadsheet. Guest author Megan Johanson explains how you can easily create a customized chart that will make your federal grant data conversations a breeze. Megan Johanson is the Data Analytics and Insights Manager at the Educational Service Center of Central Ohio. She’s also a student in Depict Data Studio’s hybrid synchronous/asynchronous training program.
More »

Visualizing Your Annual Survey Results: Four Makeovers That Didn’t Work, and the Fifth That Did

Virtually every organization conducts satisfaction surveys of one kind or another. I’m going to show you the before version followed by five makeovers. The first makeover didn’t work. The second makeover didn’t work. The third makeover didn’t work. The fourth makeover didn’t work. Just as I was about to give up, I found a winning design with my fifth attempt!
More »

The Future of Data Visualization: Predictions for 2019 and Beyond

What’s in store for the future of data visualization? A decade ago, I celebrated making my very first 3d exploding pie chart for a report that I was writing. Nowadays, I can’t open my laptop without my jaw dropping on the floor as I scroll through site after site of data visualization masterpieces. How times have changed! In this article, we’ll celebrate data visualization accomplishments from the past 12 months and make predictions for data visualization in the coming 12 months (and beyond). I turned to YOU, the data visualization community, and listened to your feedback. I created a quick poll on Google Sheets and I also asked you to reflect on both Twitter and LinkedIn. Here’s what you said about the best data visualizations of 2018 as well as your predictions for the future of data visualization in 2019 and beyond.
More »