Jack Carter

 About Data Editing Photography ☰

Data

Business Analytics

July 2024

Google Reviews Scraper - Mosaique Creative - Tewkesbury, UK

A tool that scrapes Google reviews and calculates metrics for a large UK automative firm's regional dealerships.

July 2024

Inclusiveness in Latin America - Latin Risk Pulse, online

A Tableau Dashboard examining inclusiveness for a Latin America focused political risk newsletter start-up.

June 2024

Security dashboard - Colombia Risk Analysis - Bogotá, Colombia

An internal Power BI dashboard on regional security related data across Colombia's 32 departments.

June 2024

Governance in Latin America - Latin Risk Pulse, online

A Tableau Dashboard examining Governance for a Latin America focused political risk newsletter start-up.
More business analytics >>

Nov 2023

Little Hotelier Data Migration - Saint James - London, UK

A Python script that transforms reservations data into a format that can be bulk uploaded into Little Hotelier.

Sep 2023

Price Algorithm - Saint James - London, UK

An algorithm that facilitates demand based variable pricing and provides a number of tuneable parameters.

Aug 2023

Rota Generator - Saint James - London, UK

A Python tool to generate rotas for the company's 15-17 staff with a variety of personalization features.

July 2023

Cancellations Analysis - Saint James - London, UK

A notebook that analyzes cancellations from over 4,000 check-outs between January and July 2023.

July 2023

No-shows Analysis - Saint James - London, UK

A notebook that analyzes no-show bookings from over 4,000 check-outs between January and July 2023.

July 2023

Check-outs Analysis - Saint James - London, UK

A notebook that analyzes a variety of indicators from over 4,000 check-outs between January and July 2023.

May 2023

Group Classifier - Skills Ladder - Tewkesbury, UK

A scoring algorithm that helps an IT training company automatically group its trainees based on ability.

April 2023

Trainee Analysis - Skills Ladder - Tewkesbury, UK

A notebook that helps a small IT training company to analyze the demographic makeup of its trainees.

Dec 2022

Support Distribution Algorithm - TIAFI - Izmir, Turkey

An algorithm that helps fairly distribute 250 monthly food and hygiene packages among Syrian refugees.

Nov 2022

Retool Database Apps - TIAFI - Izmir, Turkey

Two Retool database apps for an NGO's physiotherapy and information teams catering to over 9,000 people.

Oct 2022

Demographic Insights - TIAFI - Izmir, Turkey

A notebook detailing the demographic makeup of an NGO's 9,000+ membership of vulnerable people.

Oct 2022

Stats by Operator - TIAFI - Izmir, Turkey

A notebook indicating the monthly performance of an NGO's information point staff in Izmir, Turkey.

Oct 2022

Monthly Reporting - TIAFI - Izmir, Turkey

A notebook outlining an NGO's' monthly interactions with their 9,000+ membership.

Sep 2022

Extract-Physio-Data - TIAFI - Izmir, Turkey

A Python tool to extract and translate physiotherapy progress data from Arabic written Word documents.
Less business analytics ^^

Personal Analytics

April 2024

2008 Financial Crisis Response

A project using the OECD API, SQL and Python to demonstrate that Iceland took the most action after the 2008 financial crisis.

April 2024

Doing Business in Latin America

A project using the World Bank API, SQL and Python to show that the relative cost of doing business in Latin America is falling.

April 2024

Future Fortune

A simulation illustrating that you're better off investing your money in an index fund than a pension fund over the long haul.

April 2024

Scared to Debt

A simulation showing that my student loan repayments will probably not exceed the original amount in 2018 money.
More personal analytics >>

March 2024

Cut to the Data

A Tableau dashboard highlighting the parts of my CV that involve me working with data.

Feb 2024

Red or Black

A Python simulation demonstrating how the Martingale strategy provides false hope to Roulette players.

Feb 2024

Narcos

Uses World Bank data on terror risk, murders and sexual violence to examine the most dangerous countries in Latin America.

Jan 2024

Into the Wild

Attempts to address travel fears by providing information about a range of common travel related worries across regions.

May 2023

The Dictator

An analysis of Singapore's (likely) flawed democracy using Fisher's Exact Test and a Monte Carlo Simulation.

April 2023

London Boulevard

An analysis of the best neighborhoods in London based on rent, green spaces, travel and safety.

April 2023

The Pursuit of Happiness

A regression analysis indicating the lack of support for the effect of sunshine hours on happiness.

March 2023

The Intern

An analysis of where a young professional should want to work based on scraped wage and cost of living data from Numbeo.

March 2023

Lest We Forget

An analysis of the number of New York Times (NYT) articles mentioning Ukraine after the outbreak of the war.

Oct 2022

9 to 5

An country analysis of whether how hard you work translates into how rich you are with multiple regression.

Sep 2022

A World Apart

An analysis of the interconnectedness of the latest 300,000 Twitter followers of US and UK political parties.

Sept 2022

The Wrath of God

A sentiment analysis seeking to determine whether the holy books contain an above average amount of anger.

August 2022

Alien

An analysis of Hofstede's pioneering cultural dimensions data with the use of K-means clustering.

July 2022

The Usual Suspects

A K-means clustering analysis on various countries according to eight combined development indicators.

May 2022

Anchorman

A sentiment analysis examining political bias among the four major US broadcasters based on their Twitter data.

April 2022

Cast Away

An analysis of how being landlocked impacts economic development with multiple regression analysis.

June 2021

Risky Business

An analysis of the relative distribution of violence risks in the emerging world based on scraped local headlines.

June 2021

The Good, the Bad and the Ugly

An analysis with the NYT API showing how Trump's election changed the national conversation in the US.

May 2021

Rebel Without a Cause

A sentiment analysis on 1 million anti-authority word containing tweets between Anglosphere and Sinosphere Twitter users.
Less personal analytics ^^

Business Machine Learning

August 2024

Risk headline categorizer - Latin Risk Pulse - online

A regression model indicating whether or not a headline presents a political, security or economic risk to business interests

April 2024

Excelbot - Skills Ladder - Tewkesbury, UK

An LLM app using the OpenAI API that tests users' initial Excel knowledge and logs their score.

March 2024

Lumapps vs. Igloo - Mosaique - Tewkesbury, UK

An app using OpenAI and online resources to help an intranet reseller's customers differentiate service providers.

Jan 2024

ChatSJB - Saint James - London

An app using OpenAI and a 57 page operations manual to help efficiently train incoming staff at a London hostel.

Personal Machine Learning

May 2024

NLP TF-IDF

Outlines a series of optimization experiments to take into account when using TF-IDF to predict essay scores.

May 2024

NLP sentence encoders

Highlights trade-offs and optimizations to take into account when using sentence encoder models to predict essay scores.

April 2024

NLP unique words feature engineering

Shows how an apparent negative correlation between unique words and essay scores is actually due to spelling mistakes.

April 2024

NLP spelling mistakes feature engineering

Experiments with different methods to create a more accurate spelling mistakes machine learning feature.
More personal AI >>

April 2024

NLP punctuation feature engineering

Demonstrates how careful selection is better than using everything when making a punctuation machine learning feature.

April 2024

NLP initial feature engineering

Shows that a number of simple machine learning features can be extracted from text data to get an initial baseline.

Feb 2024

Scholar Me Up

A tool using Llama 2 to get an overview of the science on any topic before delving into an academic paper.

August 2022

Planet Terror

An analysis of the effectiveness of various neural networks on a small terrorism headlines dataset.
Less personal AI ^^

Data Feedback

June 2024 - Email

Poppie Dawson, Account Executive at Mosaique --- Google Reviews Scraper

"This looks great! [...] Thank you so much for your help."

May 2024 - Email

Ivon Sepulveda, Data Analyst at Colombia Risk Analysis --- Security dashboard

"I have been reviewing the dashboard and I think it turned out very well; [...] I really appreciate your effort and dedication."

More data feedback >>

April 2024 - Email

Daniel Heaford, Owner at Skills Ladder --- ExcelBot

"This is great, thank you so much!"

March 2024 - WhatsApp

David Handley, Managing Director at Mosaique --- LumApps Vs Igloo

"Really great work - I'm sure this is something we can use in sales calls as we try to migrate Igloo customers to LumApps."

Jan 2024 - Email

Stephen Sie, Owner at Saint James --- ChatSJB

"This looks awesome; a useful adjunct to the operations manual."

Aug 2023 - Email

Stephen Sie, Owner at Saint James --- Rota Generator

"Awesome Jack. This could be a real time/life saver."

July 2023 - Email

Stephen Sie, Owner at Saint James --- Cancellations/no-shows analyses

"Same helpful analytics - well done!"

Aug 2023 - WhatsApp

Andrew Darowski, Manager at TIAFI --- Distribution algorithm

"You're the best man, thank you."

May 2023 - Email

Daniel Heaford, Manager at Skills Ladder --- Group classifier

"This is a great time saver! Thank you so much!"

April 2023 - Email

Daniel Heaford, Manager at Skills Ladder --- Trainee analysis

"Nice one Jack. Thank you."

Dec 2022 - Requested review

Anne O’Rork, Founder at TIAFI --- Retool database apps

"Jack’s database apps have made it much easier to understand what’s going on with our information point and physiotherapy teams. Thank you Jack."

Less data feedback ^^