Messy Data Horror Stories Session 2 25APR16
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
SSSVEDA Day 24 Responding to “TEACH ME EXCEL!”
/in Videos /by Oz du SoleilThanks to George Mount for asking this question:
How do you respond to the request “Teach me Excel””
That’s a tough question. One thing that needs to be made clearer to the public is that:
Excel is a development tool.
It’s more that something for budgets and making lists. Thus, with a vague request like “teach me Excel” it’s hard to know if the person will need financial modeling, data cleansing, web scraping, database connection, data vis, payroll management … etc.
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
SSSVEDA Day 23: Raw Data, Reports & Tears
/in Videos /by Oz du Soleil#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
SSSVEDA Day 22: Blab scheduled to discuss “messy data horrors!”
/in Videos /by Oz du SoleilSunday, 24APR16 at 10am PDT and again at 6pm PDT, Bob King and I will be discussing the horrors of bad data; the consequences, and what can be done about it.
Also, I will be giving away a copy of my Excel book, Guerrilla Data Analysis, at each session. Join us!
Link to the 10am PDT session:
Link to the 6pm PDT session:
http://bit.ly/1VIY5Pu
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog2-2
SSSVEDA Day 21 Prince: Cleansing a list of his hit songs
/in Videos /by Oz du SoleilThis was a tough morning! It was so sad to hear that Prince died at the age of 57. In his honor, I share a couple of memories of hearing his music.
Then, I show how to deal with data that’s pasted into Excel from a web page. The example is a list of Prince hit songs that needs to be cleaned up in Power Query (Get & Transform).
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
SSSVEDA Day 20: Connect Dynamic Text to a Shape in Excel
/in Videos /by Oz du SoleilYou’ve got calculations and you want a clear statement of the bottom line: Over of Under Budget!
Here’s how to connect that variable text/comment to a shape to make it big and obvious.
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
SSSVEDA19: Excel, Music, Data, R Kelly & D’Angelo
/in Videos /by Oz du SoleilEVERYTHING is data.
After exchanging comments with Sherwinn “Dupes” Brice (https://www.youtube.com/user/DupesDidIt) I decided to revisit the crossroads of music, Excel and data.
This video looks at important parts of 2 different songs:
– R Kelly’s “All I Really Want”
– D’Angelo’s “Spanish Joint”
Being a bassist diagnosed with ADHD, learning songs was hard for me. So I devised a method in Excel to help me visualize songs and recognize patterns. So, I share that with you.
Let me hear from you. Do you use music and Excel together?
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
#SSSVEDA Day 17: Excel IFS Function (Not sure I like it)
/in Videos /by Oz du SoleilThe new IFS function in Excel is one I’m not sure I like. It’d be great to hear from others how you like it.
The idea behind IFS is the elimination of nested IF statements. However, the final argument in the syntax feels like a perversion.
With an IF statement, there is an argument in case the logical test fails. In an IFS statement, we are forced to either:
1. Account for every scenario, or
2. Make up a TRUE logical test, or
3. Have the function bomb out with an error.
What do you think about IFS?
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
SSSVEDA Day 16: Flash Fill Part 2 and Splitting Names
/in Videos /by Oz du SoleilAfter posting the previous video, Rahym Aly asked about using Flash Fill to separate a list that’s more complex than first & last names.
Here’s my response. It creates a strategy and uses Flash Fill in combo with COUNTIFS
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition