👋 Hi, I'm Sharmell Day

Data Analyst | Business Analyst | Accountant

🧮 Accountant Turned Data Analyst
💻 Excel, Tableau, SQL, Python, R
🌄 Walking, Reading, Calligraphy
📍 Witney, UK


Technical Skills

  • Tableau

  • Power BI

  • SQL

  • Excel

  • Python

  • R


Projects

🍔 DoorDash Marketing Project

Excel | Exploratory Data Analysis
◾ Real world-marketing campaign data
◾ Using only Excel for analysis and data visualization
◾ Utilized VLOOKUPS, Pivot Tables, Scatter Plots, & Bar Charts
◾ Provided a comprehensive write up to help the marketing team on their next campaign

.

🏫 Evaluating School Success with Tableau Project

Tableau | Data Visualization
◾ Created dashboard evaluating 1,800 different schools' performance across 100's of features
◾ Used Scatter Plots, KPI's, Bar Plots, & Area charts to show performance differences
◾ Presented dashboard to stakeholders via recorded video

.

💵 Financial Analysis of World Bank Loans

SQL | Exploratory Data Analysis
◾ Data-mined 1.2M real bank transactions to find financial outliers, patterns, & trends
◾ Used SQL clauses such as SELECT, WHERE, FROM, GROUP BY, AVG, MIN/MAX, SUM, AND, etc
◾ Created written report highlighting findings

.

🏥 Analysing Hospital Data with SQL

SQL| Exploratory Data Analysis
◾ Analysed what affected hospital stay length in MySQL
◾ Created a histogram using SQL (weird, I know)
◾ Real data from over 101,000 hospital patients

.

🏀 Analysing NBA Data with Tableau

Tableau | Dashboarding
◾ Analysed the 2022 NBA season statistics
◾ Created Stacked Bar Charts, Heatmaps, Treemaps & Bubble Charts
◾ Built a Tableau story & shared via written report

.

⛏️Analysing Flotation plant Data with Python

Python | Exploratory Data Analysis
◾ Explored real flotation plant data using Python in DeepNote
◾ Visualised time-series trends with line plots, pairplots, and correlation checks
◾ Investigated process anomalies through % Iron, Silica, pH, and Column Level metrics

.

📊Analysing IBM Employee Data with R and Statistics

R and Statistics | Exploratory Data Analysis
◾ Explored IBM employee attrition data using R and statistics
◾ Visualised tenure and age trends with boxplots and correlation checks
◾Tested attrition patterns using Welch t-tests and regression models

.

💰Exploring Sales and Delivery Trends with Power BI

R and Statistics | Exploratory Data Analysis
◾Analysed regional profit and delivery trends using Power BI
◾ Visualised benefit per order and late delivery rates by region
◾Mapped high-risk areas to guide operational improvements

.


About Me

👋 Hi, I'm Sharmell—welcome to my portfolio! With 20 years of experience in finance, my path into data analytics grew organically from a career spent managing cash flows, investigating anomalies, and digging into the numbers that helped the business stay on track. The more I worked with financial data the more I realised how crucial accurate, well-structured data is for smart decision-making. That sparked a deeper curiosity, leading me to dive into tools like SQL, Excel, and Tableau. Now, I’m building on my accounting foundation to help businesses turn complex data into clear, actionable insights.I'm proficient in analyzing data with:
- Excel
- Tableau
- SQL
- Python
- R
I’m currently exploring opportunities to help businesses unlock insights from their data. If you'd like to connect or collaborate, feel free to reach out via email or LinkedIn.

Previous Experience

💻 Data-Driven Accountant
Raven's Haven Ltd / Sarah Raven's Kitchen & Garden Ltd
Accountant · May 2023 - Present
◾ Maintained and optimized KPI reporting systems to support month-end close and financial statement preparation, ensuring timely data delivery to senior leadership.
◾ Analysed multi-currency cash flow trends and presented weekly payment insights to stakeholders, improving forecasting accuracy and strategic decision-making.
🎥 Founder - Accountant
Inpavidus Ltd · Self-employed · Dec 2014 - Apr 2023
◾ Analysed financial data across diverse client accounts to identify trends, resolve discrepancies, and support strategic decision-making.
◾ Maintained and reconciled ledgers, trial balances, and bank statements using cloud-based tools like Excel, Sage, and Xero.