Mahi Gill
Feltham,City of London
Summary
Data Analyst and Business Intelligence professional with expertise in analysing complex datasets and building interactive dashboards using Power BI, Tableau, SQL, and Python. Demonstrated ability to uncover trends, optimise performance, and support decision-making through freelance projects. Skilled in SQL database analysis, Python for statistical testing, and data visualisation. Proven track record in behavioural and customer insight analysis, market trend analysis, and problem-solving. Strong communication skills honed through stakeholder reporting and teamwork experience in retail environments.
Overview
1
1
year of professional experience
3
3
years of post-secondary education
Work history
Data analyst
Freelance
London
2025.10 - Current
Vendor Performance & Inventory Profitability Analysis
Analysed vendor efficiency, freight costs, and inventory turnover, identifying high‑margin brands and $2.71M in unsold stock to support cost‑saving decisions.
Taxi Revenue Optimization (NYC Taxi Dataset)
Used EDA and hypothesis testing to compare cash vs card fares, showing card trips generate higher revenue and guiding strategies to increase driver earnings.
Airline Occupancy & Revenue Optimization
Modelled booking trends and occupancy rates, demonstrating that a 10% occupancy increase significantly boosts revenue and informing pricing/capacity planning
Restaurant Success Analysis (Yelp Dataset)
Analysed 35k+ restaurants to uncover engagement patterns, peak hours, and elite‑user influence, helping improve visibility and customer retention strategies.
Data Analyst
Alexander Maclean
London
2025.05 - 2025.12
- Built interactive dashboards in Power BI and Tableau across Sales, HR, and Market datasets, improving data visibility and enabling faster, insight‑driven decision‑making.
- Cleaned and modelled multi‑source datasets using Power Query, DAX, and SQL, increasing data accuracy and reducing reporting inconsistencies.
- Conducted market analysis on Coursera, Udemy, and Edex, identifying trends in enrolment, pricing, and subject demand that informed strategic recommendations.
- Developed HR analytics dashboards that highlighted workforce demographics, salary distribution, and hiring trends, supporting more informed workforce planning.
- Restored and queried SQL databases to analyse student outcomes and assessment performance, uncovering patterns that improved understanding of learner behaviour.
- Delivered clear, actionable insights through reports and visual storytelling, helping stakeholders understand key trends and make evidence‑based decisions.
Education
Bachelor of Science - Psychology with Neuroscience
Middlesex University
London 2023.09 - 2026.04
Skills
Data Analysis and Business Intelligence: Skilled in analysing complex datasets and building dashboards through freelance BI projects, where I used Power BI, Tableau, SQL, and Python to uncover trends, optimise performance, and support decision‑making
SQL & Database Analysis: Gained hands‑on SQL experience restoring databases, running queries, and analysing student performance and vendor data, enabling deeper backend insight generation
Python for Analysis & Statistical Testing: Applied Python (Pandas, statistical tests, regression) in projects such as Taxi Revenue Analysis and Vendor Profitability to validate hypotheses and model behavioural patterns
Data Visualisation & Insight Storytelling: Built clear, interactive dashboards and visual reports across multiple freelance projects, presenting insights in a way that supported non‑technical stakeholders and improved decision‑making
Behavioural & Customer Insight Analysis: Strengthened by both Psychology and retail experience, enabling me to interpret user behaviour, engagement patterns, and decision‑making in projects like Yelp Restaurant Success and Market Intelligence dashboards
Market & Trend Analysis: Developed through analysing Coursera, Udemy, Edex (under Alexander Maclean), airline bookings, and retail sales trends, identifying opportunities, risks, and strategic insights
Problem‑Solving & Critical Thinking: Refined through end‑to‑end freelance projects where I identified inefficiencies (eg, $271M unsold inventory, vendor dependency risks) and proposed data‑driven solutions
Communication and Stakeholder Reporting: Strengthened through presenting BI insights, writing clear reports and research at the university, and delivering customer‑focused communication in retail and academic research settings
Teamwork & Customer Service: Built through one year of retail experience, where I collaborated with teams, supported customers, and maintained high service standards in a fast‑paced environment
Languages
English
Fluent
Hindi
Fluent
Timeline
Data analyst
Freelance
2025.10 - Current
Data Analyst
Alexander Maclean
2025.05 - 2025.12
Bachelor of Science - Psychology with Neuroscience
Middlesex University
2023.09 - 2026.04