Portfolio - Parth S | Codebasics

Powered by
Codebasics DA Bootcamp

Parth S

Data Aspirant

EMAIL

[email protected]

PHONE

+91 7709291072

Download CV

About Me

I’m an aspiring Data Analyst with a passion for turning data into actionable insights. I specialize in using tools like Excel, Power BI, SQL, and Python to explore data, uncover trends, and support data-driven decision-making. Whether it’s building dashboards, writing SQL queries, or performing exploratory data analysis in Python, I enjoy solving real-world problems through data.

I'm continuously learning and improving my skills through personal projects and hands-on practice. My goal is to contribute to organizations by helping them understand their data and make smarter, evidence-based decisions.

1

Excel Project

1

PowerBI Project

1

SQL Project

Key Skills

Advanced Excel, SQL, Power BI, Python

My Projects

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 7709291072

LinkedIn

https://www.linkedin.com/in/parth00s/

GitHub

https://github.com/Parth-S-DA

Excel Project

Sales Insights : P&L Report

Domain/Function: Sales Domain

AtliQ Hardware requires a comprehensive P&L report for Financial Year 2022 across various divisions to provide insights into revenue streams and product categories.

View Project
on GitHUB

Sales Insights : P&L Report

P&L by Fiscal Years

Sales Insights : P&L Report

Top 10 products

Project Details

A comprehensive P&L report with following objectives:
1. Customer Net sales performance
2. Market performance vs Target
3. Top 10 products based on the percentage increase in their net sales from 2020 to 2021
4. A "Division" report to present the net sales data for 2020 and 2021, along with the growth percentage.
5. Products ranked in the top 5 and bottom 5 in terms of quantity sold
6. New products that AtliQ Hardware began selling in 2021
7. Top 5 countries in terms of net sales in 2021
8. P&L by Fiscal years, and comparison of FY 2022 vs FY 2021
9. P&L by months of FY 2022 and past 2 years
10. P&L for Markets(Countries)
11. GM% by Quarters (Sub Zone)

PowerBI Project

AtliQ Business Insights 360

Domain/Function: Business Intelligence

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. The objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

View Project
on GitHUB

AtliQ Business Insights 360

Home page

AtliQ Business Insights 360

Executive view with important KPI's and key insights for stakeholders

Project Details

The goal of this project was to develop an interactive dashboard tailored for stakeholders across Sales, Marketing, Finance and Executive Leadership.
Core Focus Areas:
Robust Data Modeling: Establishing a reliable data model to support complex analysis.
User-Centric Design: Delivering easy-to-navigate reports aligned with stakeholder requirements.
Interactive Exploration: Incorporating drill-down capabilities for deeper data insights and analysis.

Key Learnings & Skills Developed:

Power Query – both basic and advanced data transformation techniques
Advanced DAX – crafting complex measures and calculated columns
Data modeling with over 10 interrelated tables
Selecting effective visualizations and applying appropriate formatting
Applying dashboard design best practices
Leveraging bookmarks for enhanced user navigation and storytelling
Publishing and managing reports in the Power BI Service
Iterating designs based on stakeholder feedback

Live Interactive Dashboard

SQL Project

Consumer Goods Ad Hoc Insights using SQL and Python

Domain/Function: Consumer goods

AtliQ Hardware Sales Analysis: Analyzed sales and operational data to uncover insights on customer segments, product performance, and trends. Used SQL for analysis, Python to create impactful visualizations, and applied data storytelling techniques to enhance decision-making.

View Project
on GitHUB

Consumer Goods Ad Hoc Insights using SQL and Python

SQL query for the ad-hoc request and its output

Consumer Goods Ad Hoc Insights using SQL and Python

Conversion of Output to visuals and insights

Project Details

Problem Statement:
▶ There are 10 ad-hoc requests for which the AtliQ hardware needs insights.

▶ Run a SQL Query to answer these requests.

▶ Convert into visualizations and present insights to top-level management.

This project was originally designed to leverage SQL for handling ad-hoc data requests and Excel/Power BI for creating intuitive data visualizations. However, due to the expiration of my Microsoft license, I adapted the approach and utilized Python to carry out the analysis and visualization tasks—demonstrating flexibility and technical versatility.

🔧 Tools & Technologies Used:

🔹SQL: For querying and exporting relevant data.

🧮Pandas: To read and manipulate CSV files generated from SQL queries.

📊Matplotlib: For creating clear and insightful data visualizations.