All posts tagged with 'analytics'
Control freaks: how we built our own version control for Matillion
We’ve all been there - it’s a couple of days or even the night before an important deadline and one of the following happens: You lose your memory stick with all your work on it and scramble to recreate it but can’t get it back to the way it was.You make some more ‘advancements’ to your work and suddenly everything is broken and you can’t seem to get it back… Continue reading
A day in the life of a Web Analyst
Hi, I’m Lana and I’m a Web Analyst within the Analytics team here at FreeAgent. I primarily look after our Google platform products such as Google Analytics 360, Google Optimize, Google Data Studio and Google Tag Manager. When I tell people my job title, usually the next question I get is ‘So what is it you actually do then?’ To help answer this question, I decided to spend a day… Continue reading
Six years of data science and analytics interns at FreeAgent
It’s hard to believe we’ve been running internships in our data teams for six years now, and we’re about to start recruitment for the seventh time. Things have changed a little since our first intern started, as last year saw more than four times as many staff in the wider team and our first remote internship during the coronavirus pandemic. I’ve always tended to think of our internships as a… Continue reading
Answering bigger questions with BigQuery
Over the past few weeks, we’ve configured BigQuery to enable us to combine our Google Analytics (GA) front-end data with our internal back-end data. In this post I’m going to talk about why we needed to do this, how we went about it and what we are hoping to achieve as a result. What’s the problem? Historically, two separate systems have been used at FreeAgent to track, store and analyse… Continue reading
Empowering our practices: Take 2
‘How can we use our data to understand and empower our accountancy practice partners?’ This is the question that I posed in my previous blog about delivering practice insights last summer. This question was the foundation for my project last year and is the one I came back to continue answering this year. To recap how the project was left at the end of last summer; I had created three… Continue reading
Return of the intern
A year on from my first data science internship at FreeAgent, I’m about to start my second one, and I’m getting ready for my second first day. It’s different this time though. Aside from the fact that I am now a fully fledged graduate (scary!), this internship is going to be based entirely within my living room, as the entire company is now working remotely. I have never worked remotely… Continue reading
What is a Business Intelligence Analyst?
The term Business Intelligence Analyst (or BI Analyst for short) can be a confusing one. Broadly speaking, the role of a BI Analyst can overlap with lots of other job titles that you might see out in the wild, such as: Data AnalystData ScientistInsight AnalystProduct AnalystMarketing AnalystCommercial AnalystReporting AnalystMI AnalystWeb AnalystCRM/Customer Analyst In general - and especially in the data world - job titles can often be inconsistent and subjective.… Continue reading
Deriving and verifying the uncertainty on conversion rate predictions
For the past few weeks I’ve been working on building a machine learning model that can estimate the probability that a customer will convert from the free trial to a paid subscriber. In practice, I combine the predictions from this model for cohorts of companies, which are defined by their acquisition channel and acquisition month, and so a method is required for calculating the conversion rate uncertainties for each cohort.… Continue reading
Being a Data Science Intern at FreeAgent: The first month
As the end of my second year at university was approaching I knew I needed to get some real-world experience to help me get a clearer vision of what career path I want to follow in the future. The best way of achieving this was getting a summer internship. After reading some blog posts of past Interns at FreeAgent (who knew I would be writing one myself a few months… Continue reading
Dealing with dirty data: useful functions for data cleaning in R
In this blog post, I’ll explain how to use some simple R-based data cleaning solutions (mostly in the ‘tidyverse’ package1) to address the most common dataset errors with the help of my favourite analogy: the untidy kitchen! NB: There are a plethora of valuable data cleaning tools in other software and even within R there are many different tools available. While the approach that I describe here is not necessarily… Continue reading