Portfolio - Amisha Anil Kakad

Amisha Anil Kakad

Data Analyst

Resume

3

PowerBI Projects

2

SQL Projects

About Me

Hey there! 👋 I'm on a mission to turn numbers into stories as a budding Data Analyst. Armed with a degree in IT, I stumbled upon my love for playing with data – making Excel, PowerBI, SQL, and Python my sidekicks.

Spent a year rocking it as a Software Developer at Xpressbees Logistics, where I learned the ropes and dived deep into the world of data. Now, I'm here to share my knack for turning data puzzles into clear, actionable insights.

Check out my portfolio below to see some cool business projects I've tackled. I'm all about making data less intimidating and more fun. Let's chat – excited to bring my skills to a team that's ready to make data-driven decisions! 🚀

Key Skills

Effective Communication

Data Cleaning and Preprocessing

Python

SQL

Business Intelligence

DAX

My Projects

Consumer Goods Ad Hoc Insights

Business Insights 360 Dashboard

HR Analytical Dashboard

Pizza Sales Data Analysis

T20 Cricket Analysis Dashboard

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://linkedin.com/in/amisha-kakad-2b4b08197

Call Me

+91 9370703103

GitHub

https://github.com/AmishaKakad2002

SQL Project

Consumer Goods Ad Hoc Insights

This project contains a set of SQL queries designed to provide insightful data analysis for AtliQ Hardware, a leading computer hardware producer in India. The company aims to enhance its decision-making capabilities by leveraging data analytics. The challenge focuses on evaluating analytical skills.

View Project
on GitHUB

SQL Challenge Problem Statement.

Entity Relationship Diagram for a given database.

Project Details

SQL Challenge: Provide Insights to Management in Consumer Goods Domain
Domain: Consumer Goods | Function: Executive Management
Problem Statement:
AtliQ Hardware's is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Hence, he decided to conduct a SQL challenge which will help him understand the skills.
Key Insights :
• Identified the sales channel contributing the most to gross sales in 2021 and its percentage contribution.
• Calculated percentage increase of unique products from 2020 to 2021.
• Ranked top 3 products by total sold quantity in each division for 2021
• Determined the quarter of 2020 with maximum total sold quantity.
• Reported top 5 customers receiving highest average pre-invoice discounts in 2021 (Indian market).

PowerBI Project

Business Insights 360 Dashboard

A comprehensive business intelligence dashboard offering detailed views on finance, sales, marketing, supply chain, and executive insights to enhance decision-making and performance analysis.

View Project
on GitHUB

Supply Chain View

Sales View

Project Details

Project Overview:
The Business Insights 360 Dashboard is an advanced business intelligence tool designed to provide a holistic view of key business metrics and insights across various functions. This project integrates multiple data sources to deliver real-time analytics and performance tracking, aiding businesses in making informed strategic decisions.
Key Insights:
• Customized a multi-functional Power BI dashboard to analyze AtliQ hardware’s sales trends globally, gathering data from Excel/CSV files and a SQL database.
• Built data models and visualizations in Power BI, optimizing the report with DAX Studio to improve performance by 5%.
• Enabled AtliQ hardware to analyze different department sales trends, leading to a projected 10% revenue acceleration and a 20% reduction in data-related
expenses.
Usage: The dashboard is designed for use by business analysts, financial officers, marketing managers & supply chain coordinators.

Live Interactive Dashboard

PowerBI Project

HR Analytical Dashboard

Developed a comprehensive HR Analytics Dashboard using Power BI to provide actionable insights into employee attendance, work-from-home trends, and sick leave patterns. This tool enables HR managers to monitor workforce productivity, identify attendance issues, and optimize remote work policies.

View Project
on GitHUB

Overall Presence Percentage and Detailed Employee Data

Daily Attendance Trends

Project Details

The HR Analytics Dashboard is designed to provide comprehensive insights into employee attendance, work-from-home (WFH) trends, and sick leave (SL) patterns. Utilizing Power BI, the dashboard enables HR managers and decision-makers to monitor and analyze key metrics related to workforce productivity and engagement.
Benefits :
1. Improved Attendance Management: Enables HR managers to quickly identify attendance issues and address them promptly.
2. Enhanced Remote Work Monitoring: Tracks WFH trends to optimize remote work policies and ensure productivity.
3. Strategic Planning: Assists in forecasting and planning based on attendance patterns, helping to allocate resources more efficiently.
4.Employee Well-being: By monitoring sick leave trends, the dashboard helps in identifying periods of high illness, allowing for better health and wellness planning.

Live Interactive Dashboard

SQL Project

Pizza Sales Data Analysis

The objective of this project is to analyze pizza sales data to derive meaningful insights that can help the business understand its performance and customer preferences. The analysis involves retrieving key metrics, identifying trends, and performing advanced revenue calculations.

View Project
on GitHUB

Entity Relationship Diagram.

Key Insights and Analysis for Pizza Sales.

Project Details

In this project, I conducted a comprehensive analysis of pizza sales data to extract actionable insights for business decision-making. This analysis aims to provide a deeper understanding of customer preferences, financial performance, and operational efficiency. By examining various metrics and trends, the project highlights key areas that can help optimize sales strategies and enhance overall business growth. This project showcases my ability to handle real-world data, perform in-depth analyses, and present findings in a clear and meaningful way.

Key Insights:
1.Financial Performance
2.Customer Preferences
3.Growth Analysis
4.Business Activity

PowerBI Project

T20 Cricket Analysis Dashboard

This project showcases a T20 Cricket analysis dashboard created using Power BI. The dashboard provides a comprehensive analysis of player performance in the T20 format, focusing on finding top 11 players. It is offering insightful analysis for cricket enthusiasts and professionals.

Specialist Fast Bowlers

Middle Order Batsmen

Project Details

The dashboard provides an in-depth analysis of player performance across different roles, including Power Hitters/Openers, Anchors/Middle Order, and Specialist Fast Bowlers. It is a valuable tool for cricket analysts, coaches, and enthusiasts looking to gain insights into player statistics and performance trends.

Key Features:

Data Sources and Processing:
1. Utilized web scraping in Python to collect player performance data from various cricket websites.
2. Employed data cleaning techniques to ensure the accuracy and consistency of the dataset.
3. Conducted data modeling to structure the data for effective analysis and visualization.

Dashboard Pages:

1.Power Hitters/Openers
2.Anchors/Middle Order
3.Finishers
4.All Rounders
5.Fast Bowlers
6.Top 11 Players
7.Players Analysis