Adity Sharma

Data Aspirant

[email protected]

Resume

Hello, I am

Adity Sharma.

1

Excel
Project

2

PowerBI
Projects

About Me

Certainly, here’s an introduction without specific project references:

---

**Welcome to my portfolio website!**
I am an aspiring **Data Analyst** with a passion for uncovering insights and driving impact through data. With a Bachelor’s degree in **Computer Science Engineering**, I discovered my enthusiasm for data analysis and have since been committed to building a career in this field. Here’s what I bring to the table:

- **Technical Expertise**:
- Skilled in **Excel**, **Power BI**, **SQL**, and **Python** for data exploration, visualization, and analysis.
- Proficient in creating meaningful visualizations and reports that support data-driven decision-making.

- **Analytical Strengths**:
- Exceptional ability to transform complex data into clear, actionable insights.
- Strong focus on identifying trends, uncovering patterns, and delivering precise, data-backed recommendations.

- **Professional Mindset**:
- Driven by curiosity and a passion for continuous le

Key Skills

Excel

Power BI

Effective Communication

Stakeholder Management

My Projects

Sales & Finance Analysis - AtliQ Hardware

Domain/Function: FMCG

Business Insights 360- AtliQ Hardware

Domain/Function: FMCG

Blinkit Sales Analysis

Domain/Function: Sales Analysis

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.

Mail Me

[email protected]

https://www.linkedin.com/in/adity-sharma-9506a3220?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=ios_app

GitHub

https://github.com/adity0202w

Excel Project

Sales & Finance Analysis - AtliQ Hardware

Domain/Function: FMCG

Developed 2 P&L Report for Sales & Finance team driving financial decision making for the Management ensuring efficiency & growth of the company & optimizing market performance

View Project
Engagement

View Project
on GitHUB

Developed 2 P&L Report for Sales & Finance team driving financial decision making for the Management ensuring efficiency & growth of the company & o

Customer Net Sales Performance for different regions, markets & divisions for FY 2019-2021 & Sales Comparison between 2020 & 2021

Project Details

Analyzed AtliQ Hardware’s financial and sales performance from 2019 to 2021 to support strategic decision-making.

Key Learnings:

ETL Process to streamline data handling
Data Cleaning: Efficiently streamlined data using Power Query Editor
Data Modeling: Established relationships using Power Pivot
DAX Measures: Created measures for detailed financial and sales analysis
Pivot Tables: Generated comprehensive P&L statements and sales performance reports

Financial Insights
Net Sales increased from $87.48M in 2019 to $598.88M in 2021
Gross Margin grew from $36.24M to $218.16M
GM% declined from 41.43% to 36.43%

Sales Insights
Top Product: 'AQ Electron 4 3600 Desktop Processor' with $19.35M in sales
16 new products in 2021 generated $176.16M in sales
Highest sales markets: India, USA, and South Korea

The comprehensive report provided valuable insights enabling data-driven decisions for growth & efficiency.

PowerBI Project

Business Insights 360- AtliQ Hardware

Domain/Function: FMCG

AtliQ Hardware, a computer hardware company faces challenges with maintaining large volumes of data. Objective: Move from Excel to PowerBI based analytics for effective reporting that draws actionable insights enabling data-driven decisions for AtliQ's growth & to sustain market competitiveness.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

DAX Studio

User-empathetic landing page as a part of dashboard design

Data Modeling: Established relationships between 15 tables for accurate & effective analysis

Project Details

AtliQ Hardware faced challenges with outdated Excel-based analysis, requiring advanced methods for effective reporting & data-driven decision-making.

Power BI Techniques Implemented:
Data modeling with 15 table relationships
DAX measures, calculated columns
Bookmarks, page navigation
Dynamic titles, conditional formatting
Publishing & sharing on Power BI Services

Dashboard Highlights:
Home Page: Centralized navigation hub
Finance View: Detailed financial metrics
Sales View: Sales performance insights
Marketing View: Strategy analysis
Supply Chain View: Operations optimization
Products View: Product & customer insights
Executive View: Strategic decision-making metrics

This project enhanced AtliQ’s data-driven informed, cross-departmental decisions making abilities.

Live Interactive Dashboard

PowerBI Project

Blinkit Sales Analysis

Domain/Function: Sales Analysis

A comprehensive sales analysis for Blinkit, focusing on metrics like total sales, average order value, product performance, and customer demographics. The project uses Excel for data exploration and visualization, offering insights into sales trends and helping identify key areas for optimization.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

SQL

Graph displaying total sales by item type, highlighting the top-performing product categories.

Bar chart of total sales across different outlet sizes, showing how sales vary between small, medium, and large outlets.

Project Details

The Blinkit Sales Analysis project delves into sales data to provide insights into overall sales performance, customer purchasing patterns, and product popularity. Using Excel’s advanced features, the project highlights key sales metrics, identifies top-performing products, and pinpoints the busiest sales hours. The insights gained from this analysis are intended to support decision-making processes, enabling Blinkit to better align its operations and promotions with customer demands.