Data projects
PROFIT ANALYSIS, PUBLIC DATA & MORE
For demonstration purposes, I will showcase 2 data projects, covering a range of data analytics concepts.
Project #1
A detailed business profit analysis using MySQL, MS Excel and visualising key findings in Power BI.
London Tours Profit Analysis
Project #2
Focused on data process phases using Big Query, Google Sheets data visualisation in Tableau.
Health Survey for England 2021
In this project, I take a hands-on approach to analysing sales data for a London-based tour operator. The goal is to identify key business insights that drive profitability and customer engagement. The analysis covers sales trends, customer segments, and revenue patterns over time.
Using mock datasets that reflect real-world business scenarios, I demonstrate my ability to clean, analyse, and visualise data to answer critical business questions.
About dataset:
The dataset consists of 3 CSV tables with a total of 2,070 records:
– bookings: Transactions, payment methods, and tour details.
– customers: Demographics, including date of birth, gender, and nationality.
– prices: Tour prices, discounts, and seasonal variations
Additionally, I incorporate a public dataset on local and international visits to London during the same period, segmented by purpose; leisure, business, or visiting friends and relatives (VFR).
Metadata:
Here is a glossary of definitions for the variables (fields) used in the dataset:
— invoice no
— tour id
— tour category
— tour name
— base price
— adult
— child
— student
— senior
— total paid
— tour status
— date and time
— booking pos
— payment method
— club card
— rating %
— customer nationality
— customer username
— customer gender
— customer age
The task / Project Objective:
The primary goal is to extract actionable insights that help improve sales performance. This includes:
✅ Identifying trends in bookings and customer demographics.
✅ Analysing revenue and profitability across different segments.
✅ Providing data-driven recommendations to enhance business strategy.
✅ Creating an interactive dashboard to present key findings to stakeholders.
Project pipeline:
1️⃣ Data Cleaning & Preparation – Handling missing values, duplicates, and inconsistencies in spreadsheets.
2️⃣ Database & SQL Queries – Organising data for efficient analysis.
3️⃣ Data Visualisation – Building interactive dashboards in Tableau & Power BI.
4️⃣ Insights & Recommendations – Summarising findings to drive business decisions.