Download the workbook here: http://datascopic.net/wine-calc

This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week.

Here’s high-speed footage of my actual development. I had no idea how I’d approach this until I turned the camera on.

Please subscribe to my channel and let me know your real-world needs with Excel. Maybe it’ll turn into a video.

Guerrilla Data Analysis 2nd Edition

My blog: http://datascopic.net/blog2-2

George Mount asked about my experience taking Improv classes at Chicago’s Second City Training Center. In this video I share several things that have stuck with me.

One lesson: the audience wants you to win.
So, whatever anxiety we may have when we’re in front of people, it helps to know that the audience wants us to win. They’ve invested time–and possibly money–in partnering with us to be successful.

Guerrilla Data Analysis 2nd Edition

My blog: http://datascopic.net/blog2-2

My blog: http://datascopic.net/blog2-2

Guerrilla Data Analysis 2nd Edition

#SSSVEDA Day 23. 7 days left and I invite you to ask questions or suggest content for these final 7 days of Vlog Every Day in April.

In this video, I describe the time I had to train someone who started crying. We were in a situation where we had to do some intense data cleansing before we could get to the main task.

We couldn’t trust the reports that had been made for the task so, we had to start with the raw data. Wailing and gnashing of teeth ensued.

Guerrilla Data Analysis 2nd Edition

My blog: http://datascopic.net/blog2-2