The DO’s of a Reporting Analyst

Amazed as I am at how much time has passed since I first wrote the article below and how much more varied experience I've been able to gather since then, I've yet to discover a case where most of these tips wouldn't prove relevant It has now been 6 months since I started studying at … Continue reading The DO’s of a Reporting Analyst

5 super handy things to remember if you’re an MS Access newbie

My dataset is too big for Excel to handle efficiently As I've mentioned before, Excel is not a storage place! If you're having problems processing the sheer volume of your data with it, you might need to look into consolidating monthly compilations into a centralized place. Assuming you have no DB access and no ETL … Continue reading 5 super handy things to remember if you’re an MS Access newbie

10 Best Practices of Spreadsheet Management

Assuming Excel is your play tool and that you need to handle data worth of 30,000 rows + in order to produce your analyses, below are some tips that could help improve and optimize your spreadsheet usage: 1. Do change the default csv connection properties! • Prompt for file on refresh: achieves nothing but render … Continue reading 10 Best Practices of Spreadsheet Management