Aishwarya Arya

Data Analyst

[email protected]

Resume

Hello, I am

Aishwarya Arya.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

Hey there! Aishwarya here, your a passionate data explorer. I’ve got a talent for turning ordinary numbers into compelling stories that light the way for smart decisions.

So, what’s fueling my journey?
I’m on the hunt for opportunities that match my skills, give me a good challenge, and let me sprinkle some meaningful magic.

Why give me a shot?
I’ve got this passionate drive for turning raw data into real-world gold using Excel, SQL, and Power BI.

Real impact, real skills
I may not have followed the traditional corporate path yet, but that hasn’t stopped me from diving into hands-on projects that showcase my expertise. I believe in learning through action, solving real-world problems, and continuously improving my craft.

Key Skills

SQL

Python

Power BI

Excel

My Projects

Sales and Finance Analytics

Domain/Function: Sales & Finance

Business Insights 360

Domain/Function: Business Intelligence & Analytics.

Blinkit Sales Analysis

Domain/Function: Sales Analytics

My Experience

As a fresher Data Analyst, I have hands-on experience in transforming raw data into meaningful insights. In Sales and Finance Analytics (Excel), I analyzed sales trends and financial performance using advanced formulas and visualizations. With Business Insights 360 (Power BI), I developed dynamic dashboards that provided a comprehensive view of business performance. For Blinkit Sales Analysis (SQL), I leveraged complex queries to extract key sales metrics, driving data-backed decision-making. My ability to work across Excel, Power BI, and SQL enables me to deliver impactful insights that enhance business strategies.

Awards & Certificate

Excel: Mother of Business Intelligence

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

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/aishwaryaarya/

GitHub

https://github.com/AishwaryaArya

Excel Project

Sales and Finance Analytics

Domain/Function: Sales & Finance

Objective: Analyzed sales trends and financial performance to optimize business decisions. Key Insights: Identified revenue patterns, cost trends. Impact: Provided data-driven recommendations to enhance financial strategy.

View Project
on GitHUB

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Relationships (Diagram View)

Project Details

I made a sales report using Excel that helps businesses figure out good discounts for customers, talk better with them, and find new places to grow. The report gives advice on how to make sales better, make customers happier, and earn more money.

I learned to:

1. Use special tables in Excel
2. Work with data in a smart way
3. Do some basic math for data
4. Make things look pretty with colors
5. Make reports nice to look at
6. Know important sales numbers

This project is all about giving businesses the tools they need to watch, understand, and improve how they sell things. By looking at sales info, companies can find chances to do better, grow, and stay ahead in the changing market.

Project video

PowerBI Project

Business Insights 360

Domain/Function: Business Intelligence & Analytics.

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

View Project
on GitHUB

Other Tools

MY SQL

Dashboard's Home Page

Data Modelling involving 10+ tables

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends,revenue by division and channel, top 5 customer

Project video

SQL Project

Blinkit Sales Analysis

Domain/Function: Sales Analytics

This project analyzes Blinkit's sales data to uncover trends based on item type, fat content, outlet location, and size. It involves data cleaning, transformation, and generating KPIs like total sales, average sales, and sales distribution to optimize product offerings.

View Project
on GitHUB

Other Tools

My SQL

This project analyzes Blinkit's sales data using SQL to generate KPIs like total sales, average sales, item count, and sales distribution.

This analysis breaks down Blinkit's sales by item type, outlet location, fat content, and establishment year to uncover sales trends.

Project Details

This SQL-based project analyzes Blinkit's sales data to extract insights on item types, fat content, outlet locations, and sizes. It involves data cleaning, transformation, and aggregation to generate key KPIs like total sales, average sales, item count, and sales distribution. SQL queries are used for filtering, grouping, and summarizing data, helping businesses optimize product offerings and sales strategies.

Learnings:
- Data Cleaning & Preparation – Used SQL to handle missing values and structure raw data.
- Query Optimization – Applied indexing and joins for efficient data retrieval.
- KPI Calculation – Used SUM(), AVG(), and COUNT() to analyze sales trends.
- Filtering & Grouping – Leveraged WHERE, GROUP BY, and HAVING for insights.
- Sales Performance Analysis – Identified top-performing products and outlets for better decision-making.