(Giveaway details are at 4:22) I’m giving away 3 copies of my Excel book, Guerrilla Data Analysis 2nd Ed. In this video I describe what’s in the book and who it’s for. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
For #SSSVEDA Day 9 I’m taking a moment to describe what the heck I mean by “Crap Data.” In a word: motivation. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
#SSSVEDA Day 8: Here, a list of Twitter handles weren’t consistent with the ‘@’ symbol out front. How do we fix that? Don’t play around. Start by getting rid of all of them! My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 Darkness is Coming by Kevin MacLeod is licensed under a Creative Commons Attribution […]
Everything is data, and it’s important for teams to have someone–an insider–who at least understands data. They might not be able to “do” data, but at least understand data-related needs and how they connect to business rules and processes. In this video I describe the reasons why. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition […]
Doing things the wrong way is different from being just plain wrong. Here, I describe having been wrong in my analysis and someone was issued a check for $5000 more than they were due. The good news is that the problem was caught, decisions were made, and everyone survived. Being wrong is part of the […]
Today Alex Powers at ItsNotAboutTheCell posted a comment that reminded me that: 1. We all started using Excel all the wrong ways. 2. The Excel community is great about sharing knowledge and helping others not have to work so hard. Here, I share a story about the olden days and doing things the hard way. […]
#SSSVED is Vlog Every Day in April, inspired by Amy Schimttauer at SavvySexySocial. https://www.youtube.com/user/savvysexysocial This vlog takes you into my Excel work style and environment: the things that you won’t learn in a workshop but the kinds of things that we each feel are essential to be in place when we sit down to whoop […]
A friend offers you ghost peppers and uses a chart to prove that the ghost pepper isn’t as hot as a poblano pepper, check the vertical axis on the graph. It might be logarithmic scale. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 Sound fx from: http://www.freesfx.co.uk/
Event planners are fascinating. Talking with them is invigorating because everything they do is about data: guests, food, client budget, beer & wine, seating, table rental, time, fees … A good event planner has a handle on all that data. In this video I show a data model/template that I’ve been developing in Excel, based […]