Portfolio - AAYUSHI SAXENA | Codebasics

Powered by
Codebasics Bootcamp

AAYUSHI SAXENA

Data Aspirant

EMAIL

[email protected]

PHONE

+91 9115718653

Download CV

About Me

Welcome to my Data Analytics Portfolio! I'm an aspiring Data Analyst passionate about uncovering insights using Excel, Power BI, SQL, and Python. I hold an M.Tech degree in AI & Machine Learning (2024) and gained valuable experience during a 10-month internship at Philips Innovation Campus.

During my internship, I conducted EDA to analyze human behavior in phishing attacks. I improved data integrity by addressing inconsistent formats, handling missing values, and performing correlation analysis, boosting dataset reliability by 15% and enhancing model accuracy.

I also forecasted the financial impact of data breaches using a risk quantification model, which provided actionable insights that addressed the top causes of crashes.

In addition to my internship, I have worked on several other projects, which you can explore below. Let’s connect and turn data into powerful stories that drive data-driven decisions!

1

Excel Project

1

PowerBI Project

1

SQL Project

Key Skills

Advanced Excel

Power BI

SQL

Python

Leadership

Stackholder Management

Presentation skills

My Projects

My Experience

Philips Innovation Campus(Sep 2023 - Jul 2024)

Data Analyst (Internship)

Conducted EDA to analyze human behavior in phishing attacks, improving data integrity by addressing inconsistent formats, handling missing values, and performing correlation analysis, boosting dataset reliability by 15% and enhancing model accuracy.
Forecasted financial impact of data breaches with a risk quantification model accounting for recovery costs and reputational damage; delivered findings to fix the three biggest causes of crashes.
Spearheaded rigorous code review process using static analysis tools, decreasing critical bugs by nearly 20% and improving software reliability across major Philips applications

Awards & Certificate

Philips Internship Certificate

Philips Internship Certificate

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 9115718653

LinkedIn

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

GitHub

https://github.com/aayushinidhi

Excel Project

Comprehensive Financial and Sales Analysis

Domain/Function: Sales and Finance

Generated a comprehensive Profit and Loss (P&L) report for AtliQ Hardware for FY 2022, utilizing advanced Excel features and DAX to provide in-depth insights into revenue streams, expenses, and profitability.

View Project
Engagement

View Project
on GitHUB

Comprehensive Financial and Sales Analysis

The Customer Performance Report provides a multi-year view of each customer's net sales, uncovering key trends and performance insights.

Comprehensive Financial and Sales Analysis

This report allows stakeholders to monitor country performance against targets and implement strategies for course correction and improved results.

Project Details

This project focused on creating a comprehensive sales analysis and reporting tool using Microsoft Excel. The goal was to provide businesses with the necessary data and insights to make informed decisions across key sales areas. The developed reports empower businesses to:

1. Optimize Customer Discounts: Analyze customer purchasing patterns and identify optimal discount levels to maximize sales and profitability.
2. Improve Customer Negotiations: Provide sales teams with data-backed insights to facilitate more effective negotiations and improve deal closure rates.
3. Identify Market Expansion Opportunities: Analyze sales data by region and country to pinpoint high-potential markets for expansion.

Key Skills/Technologies:
1. Pivot Tables
2. Power Query
3. DAX Basics
4. Conditional Formatting
5. Report Design
6. Sales Domain Metrics

These reports provide actionable insights to enhance sales strategies, customer satisfaction, and revenue growth.

PowerBI Project

Unveiling the Business Landscape: A Full 360° Insight - FMCG

Domain/Function: FMCG

AtliQ Hardwares, a rapidly growing electronics company, lacked data-driven decision-making due to reliance on Excel reports. I implemented a Power BI solution to provide actionable insights and improve competitiveness.

View Project
Engagement

View Project
on GitHUB

Unveiling the Business Landscape: A Full 360° Insight - FMCG

Home page: User-friendly landing page as part of the dashboard design

Unveiling the Business Landscape: A Full 360° Insight - FMCG

Data Model: Incorporating 10+ Tables

Project Details

Developed a unified Power BI report for Sales, Marketing, Finance, and Executives, providing actionable insights through robust data modeling, intuitive design, and drill-down capabilities.

Key Focus:
1. Robust Data Modeling
2. User-Empathetic Report Design
3. Drillable Insights

Learnings:
1. Power Query (Basic & Advanced)
2. DAX (Basic & Complex)
3. Data Modeling (10+ tables)
4. Visual Selection & Formatting
5. Dashboard Design
6. Bookmarks
7. Power BI Service Deployment
8. Stakeholder Feedback
9. Cross-functional Metrics

Project video

Live Interactive Dashboard

SQL Project

Sales and Revenue Analysis for AtliQ Hardware

Domain/Function: Sales and Finance

Using SQL queries answered 10 ad-hoc requests, making data the compass for Atliq's journey to success. SQL, Excel, and PowerPoint tools are used. Key insights included a significant increase in unique products, a dominant 'Notebook' segment and seasonal sales trends

View Project
Engagement

View Project
on GitHUB

View Project
on Power BI Service

Sales and Revenue Analysis for AtliQ Hardware

Bar Chart showing the number of unique products grew from 245 in 2020 to 334 in 2021, marking a 36.33% increase.

Sales and Revenue Analysis for AtliQ Hardware

A Pie chart visualizing sales contributions by channel for AtliQ Hardwares. It highlights that Retailers contributed the highest at 73.22%.

Project Details

Atliq Hardwares, a prominent computer hardware manufacturer, faced challenges in deriving actionable insights for quick, data-driven decisions. To address this, their data analytics director, Tony Sharma, launched a SQL challenge to assess potential junior analysts. The task involved solving 10 ad-hoc business queries using SQL to extract insights on product performance, customer behavior, and sales channels. I utilized SQL for data analysis and created visualizations in Power BI to present the findings effectively. This project tested both my technical skills in data querying and analysis, as well as my ability to present insights clearly. The solution provided valuable insights, helping AtliQ 's management make informed decisions across multiple business functions. The complete solution is available on GitHub, and a video/audio presentation is in progress to explain the approach and findings in detail.