Linkedin

X (Twitter)

ChatGPT Image Jun 27, 2025, 01_36_31 PM.png

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:


Result:


Recommendations:

  1. Promote Top Performers

    β†’ Feature combo deals for Barbecue Chicken and Classic pizzas.

  2. Upsell Larger Sizes

    β†’ Offer party packs or discounts for L and XL sizes.

  3. Capitalize on Sunday Orders

    β†’ Introduce Sunday-only family promos or loyalty perks.

  4. Grow the Vegetarian Segment

    β†’ Launch a dedicated vegetarian menu or specialty offers.

  5. 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:


Result:


Recommendations:

  1. Optimize Supplier Strategy β†’ Strengthen partnership with Supplier 1; implement stricter QC measures for Supplier 5
  2. Transportation Mode Selection β†’ Use air freight for urgent shipments; road transport for non-critical deliveries
  3. Inventory Management β†’ Maintain buffer stock for Haircare/Skincare; diversify supplier base to prevent stockouts
  4. Carrier Optimization β†’ Deploy Carrier A for time-sensitive orders; use Carrier B for bulk shipments

πŸ“„ Resume & Contact