Portfolio - Y Amisha

Y Amisha

Data Analytics - Consultant

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

👋 Welcome to my portfolio! I'm Y Amisha, a budding Data Analyst ready to make waves in the industry🌊. While my journey began with a Bachelor's degree in Electronics and Communication Engineering, I quickly realized my passion lies in deciphering data. 📊

💡 Proficient in:
Excel 📑
Power BI 📊
SQL 🛠️
Python 🐍

I thrive on extracting meaningful insights from complex datasets. My transition from engineering to data analysis was fueled by a natural knack for understanding patterns and trends. 📈

🚀 Through a series of hands-on business projects, I've showcased my ability to turn raw data into actionable strategies. Each project in my portfolio reflects my dedication to excellence and my commitment to delivering impactful solutions. 🌟

🔍 Join me as I embark on this exciting journey of data exploration. Together, we'll unlock the potential of your data and drive business success. Let's connect and bring your data to life! 🌐✨

Key Skills

SQL

Python

Data Analysis

Problem Solving

Stakeholder Management

Effective Communication

Excel

Power BI

My Projects

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Revenue Insights in Hospitality Domain

AtliQ Hotels Data Analysis

Shield Insurance Dashboard

Pizza Sales Analysis

My Experience

Experienced

Schneider Electric, Bengaluru – Data Analytics Consultant

Aug 2024 - Present

Conducted in-depth data analysis on UPS systems, focusing on charging-discharging algorithms, battery performance, and logistics optimization.
Created interactive dashboards using Excel, Power Query, and Power BI to visualize key performance indicators (KPIs) such as temperature, humidity, and system health.
Processed and cleaned large datasets (30 files) containing static and transport devices data, ensuring accurate and actionable insights.
Collaborated with cross-functional teams to provide data-driven recommendations on battery storage and warranty management, leading to improved operational efficiency.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Scam Awareness Course

Python: Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

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.

Download Resume

Resume

Mail Me

[email protected]

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

Call Me

+91 7090286243

GitHub

https://github.com/amishay22

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware company is expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make informed decisions..

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Revenue Insights in Hospitality Domain

AtliQ Grands, a prominent player in India's luxury hotel sector for two decades, faces declining market share and revenue due to competitive pressures and management inefficiencies. My aims to elevate competitiveness by implementing Power BI analytics, transcending reports for data-driven insights.

Data Modelling of tables

User-empathetic landing page as a part of dashboard design

Project Details

In this project, the goal is to be one report which has all analytic solution using Power BI that will enable the company to get insights and make informed decisions The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Learnt to build a new visual (Calendar visual) using matrix table, which can be utilized for different purpose of analyze.
2. By referring different cancellation polices followed by different hotels, understood that most of the hotels charge zero fee, only if the booking is cancelled before three months of booking date. If the booking is cancelled after that, the charge range from 60 to 90% of the booking cost.
3. Learnt, how to use bookmarks and selection for different purposes.
4. Tried using color palette and stick with that colors throughout the dashboard

Live Interactive Dashboard

Python Project

AtliQ Hotels Data Analysis

Atliq Grands, a well-established entity in India's hotel industry, is currently facing competition and a decline in revenue. To address these issues, My aim is to empower Atliq Grands to make informed decisions and regain a competitive edge in the industry.

View Project
on GitHUB

Crafted average rating per city and pie chart of revenue per booking platform.

Crafted a table of average occupancy rate per city.

Project Details

Project Goal
The goal of this project is to conduct a comprehensive analysis of the hotel domain using Python. By employing data-driven insights and strategic recommendations, my aim is to empower Atliq Grands to make informed decisions and regain a competitive edge in the industry.

Project Highlights
Data Cleaning- Handling missing values and outliers.
Data Transformation - Added occupancy% columns.
Insights generation-key questions answered
calculating average occupaancy rate by room type and city.
Identifying occupancy rate on weekdays and weekends.
Analyzing revenue

Skills Learned
Python Programming: Enhancing proficiency in Python for data analysis,cleaning ,transforamtion and visualization.
Data Viusualization: Leveraged Matplotlib library for creating charts and bars.
Pandas Fundamentals: creating various dataframes,group by functions,concate and merging,hanling NA values,read csv files etc.

PowerBI Project

Shield Insurance Dashboard

As part of my virtual internship at Codebasics, I'm thrilled to present my final project: a comprehensive Power BI Dashboard for Shield Insurance. This project aimed to provide actionable insights and enhance decision-making for client.

View Project
Engagement

View Project
on GitHUB

Data modelling Snapshot

General View of Dashboard

Project Details

🎯 Objective:
Develop a Power BI Dashboard to facilitate better decision-making for Shield Insurance.
Create an engaging video presentation to simplify the dashboard's explanation for our client's understanding.
.
📈 Key Insights:
Customer Base: 26,841 customers.
Revenue: $989.3 million in total.
Top Location: Delhi, with 11,007 customers generating $401.6 million.
Top Age Group: 31-40 years, contributing $356 million from 11,455 customers.
Peak Month: March, showing the highest customer enrollment and revenue.

🚀 Key Learnings:
Data Integration: Gained experience in integrating various data sources into Power BI.
Dashboard Design: Learned how to create interactive and user-friendly dashboards.
Analytical Skills: Enhanced my ability to derive meaningful insights from complex datasets.
Presentation Skills
Project Management

Project video

Live Interactive Dashboard

SQL Project

Pizza Sales Analysis

View Project
on GitHUB

Snapshot of sample query 1

Snapshot of sample query 2

Project Details

This project aims to provide a comprehensive analysis of pizza sales data using SQL. By examining various aspects of the sales data, we can gain insights into sales trends, product performance, customer behavior, and operational efficiency. This analysis can help inform strategic decisions for improving sales and operational processes.

Primary Objectives
Sales Analysis
Product Performance
Customer Insights
Operational Efficiency

Key Learnings from the Pizza Sales Analysis Project
Data Analysis with SQL
Sales Trends Identification
Product Performance Evaluation
Customer Insights
Revenue Analysis
Data-Driven Decision Making