Portfolio - Aastha Agarwal

Hello, I am

Aastha Agarwal

Data Aspirant

Resume

2

PowerBI
Projects

1

SQL
Project

About

Welcome to my portfolio! I'm a data enthusiast currently studying Computer Science Engineering at IMS Engineering College. Despite my academic focus on technology, I've found a deep passion for analyzing data and uncovering its secrets.

Through my journey, I've become proficient in tools like Excel, Power BI, SQL, and Python, which help me turn raw data into valuable insights. Even though I'm still a student, I've completed impactful projects that demonstrate my ability to analyze data effectively.

I love transforming complex information into easy-to-understand stories that drive success. I thrive in challenging environments that push me to learn and grow continuously.

Explore my portfolio to see how I turn numbers into actionable insights. Let's collaborate and make sense of data together!

Key

Skills

Python

MySQL

My

Projects

Business Insights 360

My technical arsenal boasts expertise in Power BI, SQL, and DAX Studio, enabling me to craft visually compelling dashboards and optimize data modeling for insightful analysis. Dashboard highlights include financial insights, sales performance, marketing analytics, and supply chain metrics.

HR Analytics

In this end-to-end data analytics project, we will take a REAL dataset for employee presence from a company called AtliQ and perform data analysis in Power BI. we built a Power BI dashboard with employee insights.

AtliQ Hardwares Finance and Supply Chain Analytics

Analyzing sales, products, customers, and regions for Atliq Hardware to derive actionable insights.
Solving key queries related to sales, market analysis, customer behavior, and supply chain forecasting.

Awards

& Certificate

programming for everybody(Getting started for python)

Contact Me

Email

[email protected]

Github

https://github.com/aastha1680

https://www.linkedin.com/in/aastha-agarwal168/

Call

+91 9149127006

Aastha Agarwal

Data Aspirant

Download Resume

Resume

PowerBI Project

Business Insights 360

✅ Financial View - Net Sales Performance Trend, Top Products and Customers based on NS, GS, GM/%, COGS, NP/%, Pre & Post Deductions.

✅ Marketing View - Analyze Product Performance, Market/Regional/Customer Performance, GM% & NP% Performance on Segment, and Unit economics with COGS.

Project Details

Tech Toolbox: My technical arsenal received a significant upgrade with the acquisition of skills such as:
➡ Power BI for creating compelling visualizations.
➡ SQL for seamless data retrieval and manipulation.
➡ Power Query Editor for data transformation.
➡ DAX language for robust data modeling.
➡ DAX Studio for report optimization.
➡ Project management tools for streamlined execution.
📊 Dashboard Highlights:
✅ Financial View - Dive into P&L statements, Net Sales Performance Trend, Top Products and Customers based on NS, GS, GM/%, COGS, NP/%, Pre & Post Deductions.
✅ Sales View - Explore Customer and Product Performances, Performance matrix with NS and GM% on customers, Unit economics with COGS and deductions.
✅ Marketing View - Analyze Product Performance, Market/Regional/Customer Performance, GM% & NP% Performance on Segment, and Unit economics with COGS, Operational expenses, and NP.
✅ Supply Chain View - Investigate Forecast Accuracy, Net Error, ABS Error, Key metrics.

Live Interactive Dashboard

PowerBI Project

HR Analytics

Attendance is high and consistent, around 94%. Work From Home (WFH) is lower and more variable, around 5% to 16%.

It shows that overall attendance is high (around 89.7%) and consistent. Work From Home (WFH) is lower (around 11.2%) and varies by day.

Project Details

In this comprehensive data analytics initiative, we leveraged a genuine dataset sourced from AtliQ, a leading company, to conduct an in-depth analysis using Power BI. Collaborating closely with AtliQ Technologies' HR department, we meticulously addressed their requirements, culminating in the development of a bespoke Power BI dashboard.

Live Interactive Dashboard

SQL Project

AtliQ Hardwares Finance and Supply Chain Analytics

Analyzing sales, products, customers, and regions for Atliq Hardware to derive actionable insights. Solving key queries related to sales, market analysis, customer behavior, and supply chain forecasting.

View Project
Engagement

Stored procedures are essentially saved sets of SQL statements that you can reuse in your database.

The results show various sales-related data, including variant, sold quantity, gross price, pre-invoice discount, and net invoice sales.

Project Details

➡ Amazon recorded the highest net sales of 109.03M in fiscal year 2021, followed by AtliQ Exclusive with 79.92M.
➡ India led in generating the highest net sales of 210.67M in fiscal year 2021, followed by the USA with 132.05M.
➡ Amazon contributed 13.23% of the total net sales in fiscal year 2021 across all customers.
➡ Among APAC customers, Amazon accounted for the highest net sales percentage of 12.99% in 2021.
➡ In APAC, India ranked first in total gross sales.
➡ In EU region, AtliQ E-Store had the highest net sales percentage of 9.87% among other customers in 2021.
➡ In EU, LATAM, & NA regions, the UK, Mexico, & USA respectively ranked first in gross sales.

Hello, I am

Aastha Agarwal

2

1

About

Key

My

Business Insights 360

HR Analytics

AtliQ Hardwares Finance and Supply Chain Analytics

Awards

Contact Me

Email

Github

Linkedin

Call

Aastha Agarwal

Download Resume