sapana patel

Data Aspirant

Hello, I am

sapana patel.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About Me

Hi, I'm Sapana Patel, a data enthusiast who enjoys uncovering insights from numbers. I'm skilled at using tools like Power BI, Excel, and MySQL to analyze data effectively.

Before diving into data analysis, I spent two years as a Software Developer, where I learned programming languages like Python and Java and worked on various projects to solve problems and improve efficiency.

During my time as a Software Developer, I collaborated with different teams to ensure project success and streamline processes.

In my portfolio, you'll find projects where I've used data to help businesses make smarter decisions. Whether it's creating visual reports or diving deep into data, I'm passionate about making information accessible and valuable.

I'm excited about the opportunity to bring my skills and experience to your team and contribute to achieving your data-driven goals.

Key Skills

Excel

Power BI

SQL

Python

My Projects

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Provide Insights to Management in Consumer Goods Domain

Domain/Function: Consumer Goods / Executive Management

Expense Tracking System

Domain/Function: Financial Technology

Awards & Certificate

Excel: Mother of Business Intelligence

Scam Awareness Course

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

https://www.linkedin.com/in/sapna-patel-00b08a270/

GitHub

https://github.com/s-pana

Excel Project

Sales Analytics(FMCG)

Skilled in producing Sales and Finance Reports for 2 years, employing Power Query and Excel Pivot Tables. Assisted in analyzing net sales and gross margin trends to optimize discounts, identify growth prospects, and align financial planning with strategic goals.

View Project
Engagement

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I utilized Excel pivot tables to craft a comprehensive sales report. This report serves as a valuable resource for businesses, aiding in the identification of optimal customer discounts, facilitating negotiations, and pinpointing potential expansion opportunities in promising markets. The generated reports offer actionable insights and recommendations aimed at optimizing sales strategies, improving customer satisfaction, and maximizing revenue.
Key Learnings:
1. Mastering Pivot Tables
2. Harnessing Power Query
3. Introduction to DAX (Data Analysis Expressions)
4. Implementing Conditional Formatting
5. Enhancing Report Presentation
6. Familiarity with Sales Metrics
Overall, the objective of this project is to equip businesses with the necessary tools and insights to monitor, assess, and elevate their sales operations. Through thorough analysis of sales data, organizations can unlock growth prospects, adapt to market dynamics, and maintain a competitive edge.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares seeks to enhance competitiveness by transitioning from Excel-based reporting to Power BI analytics. My goal: Implement Power BI for insightful decision-making.

View Project
Engagement

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

This project aims to create a unified report catering to stakeholders from sales, marketing, finance, and the executive team, emphasizing:
Robust Data Modeling
User-centric Report Design
Drillable Insights

Key Learnings Include:
1)Mastering Power Query for Basic and Advanced Operations
2)Proficiency in Basic and Complex DAX Formulas
3)Handling Data Modeling with 10+ Tables
4)Selecting Appropriate Visuals and Formatting
5)Understanding Dashboard Design Principles
6)Utilizing Bookmarks for Navigation
7)Deployment on Power BI Service
8)Incorporating Stakeholder Feedback
9)Understanding Sales, Marketing, Finance & Supply Chain Metrics

Live Interactive Dashboard

SQL Project

Provide Insights to Management in Consumer Goods Domain

Domain/Function: Consumer Goods / Executive Management

This project analyzes retail sales data for fiscal years 2020-2021,focusing on regional performance, product sales trends, customer purchasing behavior. Key insights include top products per division, sales by channel, discount trends, and monthly gross sales, enabling data-driven decision-making.

View Project
on GitHUB

Report with all the unique product counts for each segment

Complete report of the Gross sales amount for the customer “Atliq Exclusive” for each month .

Project Details

In the "Consumer Goods Domain" Project I Worked on the database of the Atliq hardware project. Facing the challenge of finding a data-informed decision. I answered 10 ad-hoc requests to extract actionable insights.

Find unique products in different categories like Accessories and notebooks and find which channel brings the most sales Retailer or Distributors.
In SQL I used some advanced concepts like CTE, some Windows functions Like Rank, Over Clauses, etc.

Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.

The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Python Project

Expense Tracking System

Domain/Function: Financial Technology

A full-stack web-based application that helps users track, manage, and analyze their personal expenses. The system includes a secure backend API, interactive frontend UI, real-time analytics, automated testing, and logging for robust monitoring.

View Project
on GitHUB

Add & Update Expense Tab: Developed interactive Streamlit tabs that allow users to add new expenses and update existing ones directly in the database

Analytics Tab: Implemented an interactive analytics tab in Streamlit that allows users to select a start and end date to generate dynamic bar charts.

Project Details

A full-stack application built with FastAPI, Streamlit, and MySQL to manage and analyze personal or business expenses. It includes secure CRUD operations, automated Pytest testing, and detailed logging for backend services. The Streamlit frontend offers an intuitive interface for expense tracking and data visualization. Expense analytics features provide insights like category-wise spending and monthly trends. Tools like Postman, PyCharm, and Git Bash were used throughout development. Complete with README.md and requirements.txt for easy deployment and collaboration.