About Me
I help businesses solve operational and data-related challenges by designing structured systems that automate workflows, improve visibility, and support better decision-making. My work focuses on turning messy processes into clear, reliable tools that teams can actually use in daily operations. I prioritize clarity, accuracy, and real-world usability over complexity or decorative dashboards.
Excel: Sales & Inventory Management
Business Problem
Product-based businesses often struggle with inaccurate stock records, delayed restocking, expiring items, and limited visibility into sales and profitability.
Solution
Built a comprehensive Excel-based sales and inventory management system that tracks stock-in and stock-out, inventory value, expiry dates, revenue, COGS, and profit in real time. The system includes smart data validation to prevent entry errors, interactive dashboards with slicers for quick analysis, and printable summary reports.
Impact
Improved inventory accuracy, enhanced visibility into product performance, and enabled faster decision-making around restocking, pricing, and expiring inventory.
SQL: Data Cleaning
Business Problem
Raw datasets often contain inconsistencies, duplicates, and formatting issues that make accurate analysis unreliable.
Solution
Used SQL Server to clean and transform raw housing data by standardizing formats, handling missing values, removing duplicates, and restructuring fields for analysis readiness.
Impact
Produced a clean, structured dataset suitable for reporting and analysis, improving data quality and reliability for downstream insights.
R Studio: Bikeshare Analysis
Business Problem
The company needed to understand rider behavior patterns to improve marketing strategies and increase customer retention.
Solution
Performed end-to-end data analysis using R, including data cleaning, exploration, visualization, and trend analysis. Tools used included dplyr, ggplot2, lubridate, tidyverse, and R Markdown to analyze usage patterns, ride duration, and customer segments.
Impact
Delivered actionable insights that supported data-driven marketing strategies and helped identify opportunities to improve customer engagement and retention.
Airtable: Inventory Management System for Multi-Store Businesses
Business Problem
Small businesses operating multiple stores struggled to track inventory accurately without expensive or complex enterprise systems.
Solution
Designed an Airtable-based inventory management system with linked tables for products, vendors, customers, and staff. The system supports automated stock-in and stock-out tracking, real-time dashboards, and email alerts.
Impact
Streamlined inventory control across multiple locations, reduced manual tracking, and provided business owners with real-time visibility into stock levels and movement.
Make: Data Processing and Email Generation
Business Problem
Manually reviewing structured data and preparing summary emails was time-consuming and prone to inconsistencies.
Solution
Built an automation workflow that parses structured JSON data, iterates through records, applies routing logic, aggregates results, and generates formatted email outputs automatically.
Impact
Reduced manual processing time, improved consistency, and ensured faster delivery of structured information to stakeholders.
Excel: 5-Year Sales Forecast Model | Revenue, COGS & Profit Projection
Business Problem
Businesses often lack structured forecasting models to plan growth, assess profitability, and evaluate long-term financial performance.
Solution
Developed a dynamic 5-year sales forecast model in Excel that projects revenue, COGS, and gross profit with monthly and yearly breakdowns. The model includes automated calculations, category analysis, percentage-of-total insights, and flexible visual reporting.
Impact
Enabled clearer financial planning, improved visibility into growth trends, and supported more confident, data-driven business decisions.
SQL: Data Exploration
Business Problem
Large public datasets can be difficult to interpret without structured exploration and analysis.
Solution
Used SQL Server to explore COVID-19 data by analyzing infection rates, death trends, and country-level comparisons through structured queries.
Impact
Generated meaningful insights from complex datasets and demonstrated strong SQL querying and analytical reasoning skills.
Make: Subscription Status Checker
Business Problem
Manually tracking subscription status across spreadsheets often leads to outdated records and operational delays.
Solution
Built an automation that checks Google Sheets for subscription data, applies conditional logic, updates records automatically, and communicates with external systems using HTTP requests and JSON handling.
Impact
Improved data accuracy, reduced manual follow-up, and ensured subscription records remained up to date in real time.
Excel: Sales Analysis
Business Problem
Raw sales data provided limited insight into performance trends and customer behavior.
Solution
Cleaned and analyzed a bike sales dataset in Excel, then built an interactive dashboard that highlights key metrics, trends, and performance indicators.
Impact
Improved sales visibility and enabled quicker understanding of performance patterns through interactive reporting.
Tableau: Air BnB Analysis
Business Problem
Understanding pricing patterns and market behavior in short-term rentals requires clear visualization of large datasets.
Solution
Created an interactive Tableau dashboard using Airbnb data sourced from Kaggle to analyze pricing, availability, and location-based trends.
Impact
Provided clear visual insights into market patterns, supporting better interpretation of pricing dynamics and regional performance.
Connect with me
- © Lucy
- Design: HTML5 UP