Learn Data Skills
Beta
Andrew Buchanan

Andrew Buchanan

Analytics Manager

BT Group

Technologies

My Work

Take a look at my latest work.

course

Introduction to the Tidyverse

course

Introduction to R

course

Intermediate R

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

BT | Dec 2022 - Present

Senior Analytics Specialist

Leading the analytics roadmap for Consumer's regional segmentation and strategic broadband initiatives
Show More

Worldpanel by Kantar | Mar 2020 - Dec 2022

Media Insights Consultant

Leveraging Kantar's continuous shopper panels to optimise channel mix, and maximise the ROI of our clients' media campaigns

Worldpanel by Kantar | Nov 2018 - Mar 2020

Client Consultant

Consumer Insight Director, Expert Solutions. We answer the research questions of the largest FMCG manufacturing businesses. We use our best in class solutions alongside the most comprehensive, syndicated continuous panel dataset, to measure your shoppers' behaviours and the attitudinal drivers that lead them to their purchasing decisions.

Ardo | Aug 2017 - Nov 2018

MI Analyst

Projects and responsibilities: Delivery of MI Dashboard: Whilst in the process of upgrading to a new ERP system, the business has been in need of a reporting suite detailing all key business metrics - developed using a combination of SQL and VBA, outputting pivot charts into a monthly generated PowerPoint file to be circulated to senior management. Improving Cross-sell capabilities: begun building a collaborative filtering model in R to generate product recommendations, to be distributed using personalised MailChimp campaigns. Budgeting: Assisting the FD with the production of UK budgets and cost of sales forecasts. Pricing: Re-educating how pricing can be used as a lever for both margin and sales volume growth using a combination of elasticities and market insights. Ad hoc: Analysis of current inflationary environment as well as providing an overview of the key variations between CPI, CPIH and RPI in order to inform the MD of an appropriate inflation based wage increase for the the employees. Reporting on developments of currency fluctuations as required.

Brakes Group | Jan 2016 - Aug 2017

Market Analyst

Custodian of all competitor and market insight – tracking our market position, where we are cheap / expensive, how Brakes can add to its USP. Idea generation for margin / sales volume increasing opportunities, and subsequent analysis / implementation. Pricing of new products Feeding competitor analysis into bi-yearly price moves. Weekly Best Sellers analysis. Ad-hoc analysis / competitor / market insight as required for senior stakeholders in various areas of the business including: Sales / Procurement / Finance / Category & Pricing.

Brakes Group | Jul 2015 - Jan 2016

Interim Data Specialist

Facilitating Brakes Group's supply chain modernisation by: Providing bespoke reporting to key internal stakeholders including the Brakes sales force Automating reporting using VBA Liaising with Network Planning in order to review contractual issues Providing the Customer Transition Coordinators guidance on up and coming events, what reporting and communication actions are required, and when.

Brakes Group | Sep 2014 - Jul 2015

Banking Clerk

Managing the bank reconciliation process for Wild Harvest, along with investigating any discrepancies between the bank account and ledger. Uploading and clearing down ledgers of cash on delivery payments. Uploading and clearing down ledgers of PDQ payments. Investigating unidentified payments and moving them to correct customer accounts, contributing to the reduction of 60+ debt. Setting up new direct debit instructions, managing cancelled direct debits and processing direct debit runs to the value of seven figure sums.

Total Gas & Power Ltd | Sep 2012 - Aug 2013

Sales Operations

portfolio management, contract terminations, Contract CRM, loading gas and power data for pricing, query management, contract production, archiving, covering the phones and transferring clients to correct teams, producing sales renewal letters, credit checks

My Education

Take a look at my formal education

L7 AI Apprenticeship, Data ScienceCambridge Spark | 2023
Graduate Diploma, EconomicsUniversity of Sussex | 2014
Bachelor of Arts (BA), International PoliticsUniversity of Surrey | 2012
HND, Audio EngineeringSAE Institute UK | 2008
Reigate College | 2006

About Me

Andrew Buchanan

I am an experienced market research and analytics professional, currently working for one of the UK’s best known Telco businesses. I have extensive experience delivering complex research and analytics projects, specialising in campaign optimisation

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free