WTF Is…A Data Lake
Reading Time: 4 minutes“Where do bad folks go when they die? They don’t go to heaven where the angels fly They go to …
Case Study: Using Your KPI Scorecard To Solve Small Business Problems
Reading Time: 3 minutesDigging for KPIs at the coalface. I’ve been measuring KPIs recently as we move forward with my wife’s boutique fitness …
Read moreCase Study: Using Your KPI Scorecard To Solve Small Business Problems
Picking Your Big 5 KPIs To Measure Corporate Business Success
Reading Time: 4 minutesI usually despise acronyms. Completing TPS reports. Filling in MAD-C forms. Horrible abbreviations invented by boring people to make themselves …
Read morePicking Your Big 5 KPIs To Measure Corporate Business Success
What Should I Do If My BI Project Gets Ignored?
Reading Time: 6 minutesLet’s see if you recognise this one. You’ve spent weeks deep in the bowels of a BI request. You’ve chased …
How Do I Prioritise When Everything Is Top Priority?
Reading Time: 6 minutesOK, hands up in the room if you work in a peaceful, serene, non-stressful, slow-paced environment? The kind of place …
Read moreHow Do I Prioritise When Everything Is Top Priority?
Frustrations Of The Data Analyst Life…And How To Fix Them
Reading Time: 1 minuteLet’s be honest with each other. Working as a data analyst seems like a pretty sweet deal. Some days though, …
Read moreFrustrations Of The Data Analyst Life…And How To Fix Them
But This Is The Way We’ve Always Done It
Reading Time: 3 minutesThis is part 6 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ …
The Unending Creep Of The Unspecified Scope
Reading Time: 3 minutesThis is part 5 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ …
Shiny New Objects and Boardroom Buzzword Bingo
Reading Time: 3 minutesThis is part 4 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ …
How To Deal With The Urgent! Urgent! Urgent! Boy Who Cried Wolf
Reading Time: 3 minutesThis is part 3 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them” …
Read moreHow To Deal With The Urgent! Urgent! Urgent! Boy Who Cried Wolf
The Fallacy That Everyone Wants (And Needs) Self Service BI
Reading Time: 4 minutesThis is part 2 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ …
Read moreThe Fallacy That Everyone Wants (And Needs) Self Service BI
Veruca Salt And The Just Give Me Everything Routine
Reading Time: 4 minutesThis is part 1 of a six part series titled “Frustrations of the Data Analyst Life…And How To Fix Them“ …
Read moreVeruca Salt And The Just Give Me Everything Routine
How To Eliminate Stupid Mistakes In Your Data Reports
Reading Time: 5 minutesMistakes. I’ve made a few but then again, too few to mention. If only the second part was true… Big …
Read moreHow To Eliminate Stupid Mistakes In Your Data Reports
Technology Is Eating My Excel Reporting Job, What Should I Do To Survive?
Reading Time: 4 minutesThe robots are coming for us. I’ve written before about the gnawing anxiety many of us feel about the threat …
Read moreTechnology Is Eating My Excel Reporting Job, What Should I Do To Survive?
URGENT! URGENT! URGENT! How To Deal When Someone Else’s Poor Planning Becomes Your Emergency
Reading Time: 4 minutesThe Moment Your Blood Pressure Starts To Rocket Arrives We’ve all experienced the immediate stress of an email subject title …
What Is The SAS Equivalent Of The LEFT Function In Excel?
Reading Time: 1 minuteI see an awful lot of hate for Excel on Data Science and Business Intelligence forums and blogs but there …
Read moreWhat Is The SAS Equivalent Of The LEFT Function In Excel?
Which Degree Course Should I Choose For A Career As A Data Analyst?
Reading Time: 3 minutesWhen The “Best Days Of Your Life” Are Drawing To A Close. I’ve covered off my own painful experience of choosing …
Read moreWhich Degree Course Should I Choose For A Career As A Data Analyst?
How Much Experience Do I Really Need For An Entry Level Data Analyst Role?
Reading Time: 3 minutesA Question From The Floor. I’ve been answering a few questions over on Reddit recently for young graduates. Most are …
Read moreHow Much Experience Do I Really Need For An Entry Level Data Analyst Role?
WTF Is…Data Wrangling?
Reading Time: 3 minutes“Data wrangling, sometimes referred to as data munging, is the process of transforming and mapping data from one “raw” data …
How Do I Add A Row Number / ID Column To A Dataset in SAS?
Reading Time: 1 minuteLet’s say you want to add a simple Row number to a dataset you have created in Base SAS. Maybe …
Read moreHow Do I Add A Row Number / ID Column To A Dataset in SAS?