Sample of Previous Client Projects

Crowd Simulator

Industry Civil Security

Problem Statement

Given a certain location and crowd density, how would a crowd react in an emergency situation? Use real locations, streets and buildings to create real-life scenarios.

Considerations

  • How does a crowd behave in an emergency situation? Fight, flight or freeze?
  • How do demographics play a part? Age groups and genders may react differently.
  • How do building and obstacles affect people's directional choices?
Python Data Engineering Mathematics AWS

Subscription Platform for Financial Research

Industry Finance

Problem Statement

I am running my business, selling online subscriptions of my product. I need to know about the traffic to the website, who is buying what products and why?
Can my business data give me insights to help me make a better customer offering?

Considerations

  • Different data sources need to be unified - Google Analytics (website traffic), Hubspot (CRM platform) and WooCommerce (subscription software).
  • A data pipeline needs to be built before we can gather insights.
  • What are the key metrics to evaluate business performance?
Python Azure Databricks Data Engineering Analytics Looker Studio

Healthcare Data Analysis

Industry Healthcare

Problem Statement

The US has an EDI (Electronic Data Interchange) system to transmit data between insurance providers, healthcare providers and patients.
How can we improve the insurance claim rate by looking at the historical claim figures?

Considerations

  • Insights need to be digestable and actionable for care team administrators to improve their success rates.
  • We need load the data into a SQL database that can be easily queried for adhoc analytic requests.
  • We need a data visualisation tool to present findings to clients.
Python Google Cloud Snowflake SQL Looker Studio

AI Powered Financial Reports

Industry FinTech

Problem Statement

We need to create an data pipeline that pulls financial reporting data from the SEC into a labelled, categorised format.
This data needs to be accessed by an AI assistant that can help retail investors analyse companies to invest.

Considerations

  • Companies don't always have standard ways of reporting key metrics and accounts.
  • The data needs to be refreshed daily to have the latest data.
  • The assistant AI needs to be able to answer any user question with a high accuracy and evidential backup.
Python Data Pipeline Automation AWS Anthropic LLM

Healthcare Reporting

Industry Healthcare

Problem Statement

We are a data platform for healthcare hubs to record patient information and healthcare pathways.
We need to provide our HUB clients with data insights and reports on patients and their care coodinators.

Considerations

  • HUBs need to have pre-made reports to answer operational questions.
  • We also need self-service dashboards with different filters and views.
  • We have an existing data infrastructure, which needs to be augmented with views and leveraged with SQL statements.
SQL Oracle APEX Tableau


Data Consultancy

2025 AC Faber Ltd.

Contact | Charlotte Leysen