A collection of my various projects across different platforms.
Platform: Published Website, WordPress
Link: www.statgarden.com
Logline: A website which provides free datatsets.
Explanation: I built this website in 2024 as an experiment to familiarise myself with website building on WordPress and gain experience with translating raw data into visualisations. The whole project from start to finish took about 3 months, including building the site, cleaning the data, and fine-tuning the graphs. The most exciting part of the process was discovering all of the different ways organisations handle their data. Most of the datasets are from government sources, and there is almost no consistency in how the data is stored.
Platform: Excel
Logline: Find the best coffee in town with Project ICONIC (Iced Coffee or No Iced Coffee).
Problem: My team needed a way to find the best Iced Coffee in Pyrmont.
Solution: A visual score-sheet of all purchased Iced Coffees.
Explanation: This is definitely one of the more simple projects I’ve made, but I’m very proud of the acronym. Each morning when my team ordered their Iced Coffee, they added their averaged score and the colour of the coffee so we could keep track. There is a manual slider used to pick the coffee colour, but unfortunately it doesn’t work on web.
Select full-screen to view entire document
Platform: Piano Analytics
Logline: Real-time tracking of all Branded Content campaigns.
Problem: Reports for Branded Content campaigns were being run manually by an offshore team. Turnaround times for reports were 2 weeks long and there was no visibility for the sales team.
Solution: Provide a live dashboard to track progress and eliminate the need for manual reports.
Explanation: While working at BBC, this is one of the first projects I championed to resolve a lack of reporting efficiency. The dashboard can be easily customised and replicated through cloning meaning any team member can make their own. This was outside the scope of my role at the time, but provided our team with much needed visibility for their campaigns. As a result of it’s success this was picked up by the wider company and rolled out to the entire APAC region.
**All data displayed in this dashboard is dummy data.
Platform: Published Website, VS Code
Link: www.lottoresultsfinder.com
Logline: A website which provides the historic winning numbers of US lottos.
Explanation: This was the first website I built and is extremely rudimentary. I was using raw code to build it and definitely put more in than I got out. I was also not aware of APIs at this time so it is all based on static Excels.
Platform: Excel
Logline: Brilliant Layout Of Overall Dynamic Tracking Highlighting
Important Realtime Statistics To You.
Problem: Needed a way to track the delivery of campaigns and identify priorities. As well as tracking overall delivery KPIs.
Solution: A monthly performance tracker collating data in a simple format.
Explanation: This was my first ever completed Excel project, and despite it’s simplicity I’m most proud of it because of the name – which took me 2 weeks to come up with. At the time, our department had an extremely old and slow system used for booking ad campaigns on broadcast TV. By exporting the data from that system and filtering it through this Excel dashboard, it allowed us to track our delivery KPIs in a simpler and faster way.
**All data displayed in this dashboard is dummy data.
Select full-screen to view entire document
Platform: Excel
Logline: Translate GAM cohorts from ID to title.
Problem: When exporting reports from Google Ad Manager, audience cohorts would show up as number IDs and were impossible to identify.
Solution: Copy and paste the data into a table to match the IDs to the cohort titles.
Explanation: Export a report from GAM and paste it into this table. A VLOOKUP formula will match the IDs with a list of cohorts and return the actual name in the left-most column. The tool will also tell you how much of this audience is being reached by your campaign.
**All data displayed in this dashboard is dummy data.
Select full-screen to view entire document
Platform: Excel
Logline: Generate post-campaign reports instantly.
Problem: Creating reports for clients is too manual and repetitive.
Solution: Collate all of the data in the report, and use formulas to pick what data is relevant to your campaign.
Explanation: After a campaign had finished we had to generate a PCR for the client. The original process was to export the data from the individual campaign and copy and paste it into a report template. To expedite the process I created a macro which ran a report on all of our campaigns for the last two years, sent it to my email, saved it in a folder, and then uploaded that data into this Excel. That meant that all our sales team had to do was enter the name of their campaign, and formulas would filter in the relevant data. It would also organise the data by category (standard display, sponsorship, etc) and sum the totals. This tool turned a 15 minute process into a 30 second one.
**All data displayed in this dashboard is dummy data.
Select full-screen to view entire document