Jacob Brown

SQL project

• Designed and implemented a full relational database with 3 linked tables (Customers, Products, Orders)
• Populated the database with 25 transactions to stimulate real-world business scenarios
• Wrote efficient JOIN queries to generate business insights such as monthly sales trends and best-selling products

Excel project

• Built a dynamic financial model to predict and asses the impact of exchange rate fluctuations on business profitability
• Created two-way data table sensitivity analysis to evaluate changes in profit margains and key performative metrics
• Implemented interactive charts, applied conditional formatting, and produced a summary dashboard to provide rapid insight and scenario comparison

Python project

• Developed a command-line tool which reads student grades from a CSV file and calculates key statistics
• Implemented robust error handling through try/except and validation checks
• Formatted the output data into tables and percentages; easily expandable to support further datasets

Upcoming development

• Enrolling in AMSP "Mathematics into Data Science and AI" starting in January of 2026 The course will cover Data analysis, Machine learning, Artificial Intelligence, and will utilise the tool Python
• Developing a Loss prevention Analytics project using Python which will generate realistic retail transaction and refund data and SQLite for relational modelling and transformations of data