Published inLearning Data·Sep 6Advanced PivotTable Tips & Tricks for Excel ProsI read an article this morning about how “long tails drive everything”. This essentially means that outliers, or special cases in a data set, are where most of the value is gained/created. …Pivot Tables6 min readPivot Tables6 min read
Aug 15From Start-up to Unicorn: Analysing the JourneyFor this SQL project, I chose to analyse a dataset showing details of all companies which have achieved “unicorn” status — a $1 billion valuation. This turned out to be a very interesting dataset which definitely provides a lot of opportunity for further investigation. As well as using some new…Sql9 min readSql9 min read
Published inLearning Data·Aug 143 Top Tips to Take your Power BI Dashboards to the Next LevelI’m pretty far along into my data analysis journey now, having already learned Excel & SQL. …Power Bi6 min readPower Bi6 min read
Aug 8Game Changers: Unravelling NBA Player of the Week InsightsIn my first SQL project for my portfolio, I take a look at the past winners of the NBAs Player of the Week award. This dataset was provided by Khan Academy, as part of their SQL course which I recently completed. …Sql6 min readSql6 min read
Published inLearning Data·Aug 4Adventure Works: Showcasing Analysis TechniquesThis is the first project I created for my Data Analysis portfolio, as a part of Maven Analytics Power BI Course and developed a bit further using some tips from other resources — shout out to Guy In A Cube for some very cool tips and videos. In this project…Data Analytics6 min readData Analytics6 min read
Mar 3, 2021A look at the investment landscape and some trends moving forwardWritten 28/04/2020. This post actually started off as an answer to an examination question which I faced during my final Masters examinations. The question asked us to outline what we thought the most important macro-economic & demographic trends are going to be over the coming decade. The last decade has…Macroeconomics5 min readMacroeconomics5 min read
Mar 3, 2021My Virtual Internship Experience with JP MorganThis is a recent piece I was asked to write for the Trinity Business School MSc Blog. The blog is a pretty cool collection of current students, alumni and staff giving their thoughts on various different topics — you can check it out here if you’re interested. A bit about…Studying Abroad4 min readStudying Abroad4 min read