Linkedin
X (Twitter)

Email
Github
Medium Blog
π©βπ» About Me:
Sarah is a detail-oriented and business-focused Data Analyst with a strong foundation in Microsoft Excel, SQL(MySQL, DBeaver CE, PG Admin) and Power BI. I specialize in extracting, cleaning, and analyzing data to uncover actionable insights that support business decision-making in visuals and documentations.
This portfolio highlights projects that reflect my analytical thinking, data storytelling ability, and commitment to solving real-world problems through data. Iβm actively seeking internship, entry-level, or intermediate roles where I can bring value to a data-driven team, grow through hands-on experience, and contribute to impactful outcomes.
ποΈ Core Skills:
Microsoft Excel (Formulas, Pivot Tables, Charts) β’ SQL (Data Querying & Reporting) β’ Power BI (Dashboards, Power Query) β’ Data Cleaning & Analysis β’ Visualization & Storytelling β’ Attention to Detail β’ Critical Thinking β’ Communication β’ Fast Learner & Adaptable
Projects Gallery
πMajor Projects Documentations:
1. Pizza Sales Performance Report
Tool(s): PowerBi
Objective: Analyze historical pizza-order data to identify customer behavior patterns, best-selling pizzas, revenue trends, and overall product performance.
Process:
- Cleaned and structured raw data directly within Power BI.
- Used Power Query for data transformation and filtering.
- Built calculated measures and DAX formulas for deeper insights.
- Designed visuals including bar charts, line graphs, and donut charts.
- Applied slicers and filters for interactive, dynamic reporting.
Result:
- Top Pizza by Revenue: Barbecue Chicken Pizza was the highest earner.
- Category Insights: Classic and Supreme pizzas dominated revenue contribution.
- Size Preference: Large-sized pizzas (L) had the highest number of units sold.
- Customer Preference: Non-vegetarian pizzas made up 75% of total sales.
- Order Behavior:
- 47.4K orders were single quantity, while 1.89K multiple-quantity orders had higher average value.
- Trend Insights:
- Revenue peaks observed in April, July, and November, indicating seasonal spikes.
- Sunday had the highest order volume.
- Weekday sales made up nearly 75% of all transactions.
- Classic pizzas led both in quantity sold and total revenue.
Recommendations:
-
Promote Top Performers
β Feature combo deals for Barbecue Chicken and Classic pizzas.
-
Upsell Larger Sizes
β Offer party packs or discounts for L and XL sizes.
-
Capitalize on Sunday Orders
β Introduce Sunday-only family promos or loyalty perks.
-
Grow the Vegetarian Segment
β Launch a dedicated vegetarian menu or specialty offers.
-
Encourage Bulk Orders
β Implement bundle pricing to increase order size and revenue.
Screenshots: [Check the Gallery View ]
Download Analysis Doc: Pizza My Heart Detailed Analysis.docx
2. Data Exploratory Report (Supply Chain Analysis)
Tool: MySQL Workbench
Objective: Analyze historical pizza-order data to identify customer behavior patterns, best-selling pizzas, revenue trends, and overall product performance.
Process:
- Extracted and analyzed supply chain data using advanced SQL queries
- Performed data cleaning and transformation to ensure data quality
- Created complex joins to analyze relationships between suppliers, manufacturing, logistics, and sales
- Developed calculated metrics for lead times, defect rates, cost analysis, and performance KPIs
- Structured multi-dimensional analysis across transportation, quality control, inventory, and customer segments
- Implemented data validation and error debugging throughout the analysis process
Result:
- Transportation Efficiency: Air freight delivered shortest lead times; road transport caused significant delays
- Supplier Performance: Supplier 1 achieved lowest defect rates (top performer), while Supplier 5 had highest defect rates (needs improvement)
- Cost vs. Speed Trade-offs: Lower-cost shipping options consistently resulted in longer delivery delays
- Inventory Challenges: Haircare and Skincare products experienced frequent stockouts due to extended restocking cycles
- Carrier Analysis:
- Carrier A: Most expensive but fastest delivery
- Carrier B: Better on-time delivery rates at lower cost
- Customer Demographics:
- Female customers: Preferred Skincare products
- Male customers: Favored Haircare products
- Non-binary customers: Balanced preferences across categories
- Regional Performance: Kolkata showed highest profit margins; Bangalore had high sales volume but lower profitability
- Quality vs. Revenue: Skincare generated highest revenue but also had elevated defect rates, creating potential return risks
Recommendations:
- Optimize Supplier Strategy β Strengthen partnership with Supplier 1; implement stricter QC measures for Supplier 5
- Transportation Mode Selection β Use air freight for urgent shipments; road transport for non-critical deliveries
- Inventory Management β Maintain buffer stock for Haircare/Skincare; diversify supplier base to prevent stockouts
- Carrier Optimization β Deploy Carrier A for time-sensitive orders; use Carrier B for bulk shipments
π Resume & Contact