Veruca Salt And The Just Give Me Everything Routine
This is part 1 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ For those business stakeholders who can’t make a single decision … Read more
How To Eliminate Stupid Mistakes In Your Data Reports
Mistakes. I’ve made a few but then again, too few to mention. If only the second part was true… Big mistakes, small mistakes I don’t mean the huge life altering … Read more
Technology Is Eating My Excel Reporting Job, What Should I Do To Survive?
The robots are coming for us. I’ve written before about the gnawing anxiety many of us feel about the threat of technological change engulfing us all. This is more applicable … Read more
URGENT! URGENT! URGENT! How To Deal When Someone Else’s Poor Planning Becomes Your Emergency
The Moment Your Blood Pressure Starts To Rocket Arrives We’ve all experienced the immediate stress of an email subject title like “URGENT! URGENT! URGENT!” hitting our inbox at the very … Read more
What Is The SAS Equivalent Of The LEFT Function In Excel?
I see an awful lot of hate for Excel on Data Science and Business Intelligence forums and blogs but there is a very good reason why it is the world’s … Read more
Which Degree Course Should I Choose For A Career As A Data Analyst?
When The “Best Days Of Your Life” Are Drawing To A Close. I’ve covered off my own painful experience of choosing a degree course when I was at school in another … Read more
How Much Experience Do I Really Need For An Entry Level Data Analyst Role?
A Question From The Floor. I’ve been answering a few questions over on Reddit recently for young graduates. Most are finding it tough to get their foot onto that first … Read more
WTF Is … Data Wrangling?
“Data wrangling, sometimes referred to as data munging, is the process of transforming and mapping data from one “raw” data form into another format with the intent of making it … Read more
How Do I Add A Row Number / ID Column To A Dataset in SAS?
Let’s say you want to add a simple Row number to a dataset you have created in Base SAS. Maybe you need to do distinct counts on the rows or … Read more
What Is The Best Way To Learn A New Data Analytics Skill?
The world of analytics moves on quickly. Everyone is talking about shiny new toolsets and languages they are working on and in and you’re afraid of being left behind. What’s … Read more