Portfolio - Vinay Sahani

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: EXCEL PROJECT

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

View Project
on Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a

Project Details

📊 Empowering Sales Strategy with Excel-Based Analytics

In this impactful project, I harnessed the power of Excel Pivot Tables to develop dynamic sales reports that go beyond mere data summaries—they serve as strategic tools for business decision-makers. These reports empower organizations to:

🎯 Optimize customer discount strategies
🤝 Streamline sales negotiations
💡 Identify high-potential market opportunities

🔍 Each element of the report was carefully crafted to deliver actionable insights that elevate sales strategy, improve customer satisfaction, and fuel revenue growth.

The project showcases a blend of technical skill and business acumen.
🛠️ Core Competencies Developed

My journey through this project sharpened my skills in key areas:
🔄 Pivot Table Mastery – for deep-dive, multidimensional data analysis
⚙️ Power Query Integration – ensuring smooth, automated data loading from multiple sources

PowerBI Project

AtliQ Business Insights 360: End-to-End Analytics Dashboard

Domain/Function: Brick & Mortar and E-Commerce

AtliQ Hardware encountered difficulties handling data in Excel😕. Goal: Transition from Excel to Power BI for improved understanding 📊. Objective: Gain insights into finance💰, sales💼, and supply chain areas🛒. Data Volume: 1.8 million entries📈. Tools Utilized: SQL, Power BI, Excel, DAX Studio💻.

View Project
Engagement

View Project
on GitHUB

AtliQ Business Insights 360: End-to-End Analytics Dashboard

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights i

Business Insights 360 dashboard for AtliQ Hardware using Power BI to analyze finance, sales, and supply chain performance. Processed 1.8M+ records and transitioned reporting from Excel to Power BI for scalable analytics and data-driven decision-making.

Project Details

𝗣𝗥𝗢𝗝𝗘𝗖𝗧 𝗢𝗩𝗘𝗥𝗩𝗜𝗘𝗪:
🔷𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗩𝗶𝗲𝘄: Conducted P&L analysis, visualized net sales, and identified key product and customer trends.
🔷𝗦𝘂𝗽𝗽𝗹𝘆 𝗖𝗵𝗮𝗶𝗻 𝗩𝗶𝗲𝘄: Evaluated metrics for customers/products, analyzed sales errors, and enhanced forecast accuracy.
🔷𝗠𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗩𝗶𝗲𝘄: Delivered insights into customer/product performance, market trends, and profitability.
🔷𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝘃𝗲 𝗩𝗶𝗲𝘄: Presented market share growth, revenue trends, and channel insights for strategic planning.

𝗞𝗘𝗬 𝗟𝗘𝗔𝗥𝗡𝗜𝗡𝗚𝗦:
🔶 Developed expertise in P&L analysis and KPI creation.
🔶 Gained in-depth knowledge of the consumer goods industry.
🔶 Enhanced skills in stakeholder communication and data storytelling.
🔶 Performed advanced data extraction and transformation using MySQL and Power Query.
🔶 Built robust data models and created complex DAX calculations.
🔶 Validated datasets and ensured accuracy using Excel.
🔶 Designed optimized, interactive Power BI

Live Interactive Dashboard

Excel Project

Store Data analysis

Domain/Function: EXCEL PROJECT

A Store Data Analyst specializes in analyzing retail store data to optimize operations, enhance customer experience, and drive sales. They leverage tools like MS Excel, SQL, and Power BI to track inventory, monitor sales trends, and generate actionable insights. With expertise in data validation, re

View Project
Engagement

View Project
on GitHUB

View Project
on Excel-Sales Data Analysis

A Store Data Analyst specializes in analyzing retail store data to optimize operations, enhance customer experience, and drive sales. They leverage to

Project Details

🛍️ Store Data Analyst Overview
A Store Data Analyst plays a key role in optimizing retail operations by leveraging data to enhance customer experience and boost sales performance. 📊

They work with tools like MS Excel, SQL, and Power BI to:

📦 Track inventory levels and prevent stockouts or overstocking

📈 Monitor sales trends across different time periods and product categories

📌 Generate actionable insights for data-driven decision-making

With a strong foundation in data validation, reporting, and visualization, Store Data Analysts are equipped to:

🔍 Identify key performance patterns and inefficiencies

📉 Improve inventory management and streamline supply chains

🔮 Ensure accurate forecasting for better demand planning

Excel Project

Amazon Sales Dashboard in Excel

Domain/Function: EXCEL PROJECT

🚀 Overview An Amazon Sales Dashboard in Excel is a dynamic tool that tracks and analyzes sales performance on Amazon, offering real-time insights into key metrics to boost revenue and optimize strategies.

View Project
Engagement

View Project
on GitHUB

View Project
on Amazon Sales Dashboard in Excel 📊💻

Amazon Sales Dashboard in Excel to analyze sales performance and track key metrics. The dashboard provides insights into revenue trends, product performance, and sales patterns, enabling data-driven strategies to improve business growth and profitability.

Analysis highlights top-performing products, seasonal sales trends, and revenue patterns. Insights help identify high-demand items and optimize sales strategies to improve overall performance and maximize profitability.

Project Details

Amazon Sales Dashboard in Excel 📊💻

🚀 Overview
An Amazon Sales Dashboard in Excel is a dynamic tool that tracks and analyzes sales performance on Amazon, offering real-time insights into key metrics to boost revenue and optimize strategies.

🔑 Key Features
📈 Sales Performance : Visualize daily, weekly, and monthly sales trends using charts and graphs.
🛒 Order Insights : Monitor order volume, average order value (AOV), and fulfillment status.
💰 Revenue Analysis : Break down revenue by product, category, or region for deeper insights.
📦 Inventory Tracking : Ensure stock levels are sufficient with alerts for low inventory.
⭐ Customer Feedback : Analyze ratings, reviews, and returns to identify improvement areas.
📊 Visual Reports : Interactive dashboards with slicers for filtering by date, category, or geography.
⚡ Automation : Use formulas and macros to update data efficiently.

PowerBI Project

WaveCon TeleCom Industry

Domain/Function: POWER BI PROJECT

Wavecon is a leading telecom provider in India, recognized for its commitment to reliable, high-quality, and innovative services. With a reputation built on trust and technological leadership, Wavecon continues to shape the future of digital communication in the country. 🌐📞

View Project
Engagement

View Project
on GitHUB

Short Description : Developed a Power BI dashboard to analyze Wavecon’s telecom performance, focusing on service usage, customer trends, and revenue insights. The dashboard enables data-driven decisions to improve service quality, customer satisfaction.

Insights : Analysis highlights variations in service usage and revenue across regions and customer segments. Insights help identify high-performing services, optimize resource allocation, and support strategic decisions

Project Details

Wavecon is a leading telecom provider in India, recognized for its commitment to reliable, high-quality, and innovative services. With a reputation built on trust and technological leadership, Wavecon continues to shape the future of digital communication in the country. 🌐📞

🚀 In May 2022, Wavecon reached a major milestone by launching its next-generation 5G services. This strategic move signifies the company’s dedication to delivering ultra-fast, low-latency, and dependable connectivity to its customer base. The 5G rollout is designed to meet the evolving digital needs of:

📱 Individuals – by enabling seamless streaming, gaming, and real-time communication.

🏢 Businesses – by supporting smart operations, data-driven solutions, and innovation at scale.

Live Interactive Dashboard

PowerBI Project

Shield Insurance Business Performance Dashboard | Power BI

Domain/Function: POWER BI PROJECT

Shield Insurance aims to improve its data-driven decision-making by implementing a Power BI dashboard for actionable insights into key performance metrics. To evaluate this, they are considering a collaboration with AtliQ Technologies. As a Proof of Concept, Shield Insurance requires a Pilot Project

View Project
Engagement

View Project
on GitHUB

Shield Insurance Business Performance Dashboard | Power BI

Short Description : Developed a Power BI dashboard for Shield Insurance to analyze policy sales, revenue trends, and customer segmentation. Visualized key metrics such as premium revenue and policy distribution.

Insights : Analysis reveals revenue concentration in specific regions and policy types. Certain customer segments contribute significantly to premium growth, while others show lower engagement.

Project Details

💉 Domain: Insurance
⚙️ Technologies: Power BI, MS-Excel

🚀 Excited to share a pilot project developed for Shield Insurance as part of AtliQ Technologies’ Proof of Concept for data-driven decision-making!

❓Problem Statement:
Shield Insurance, a leading provider of comprehensive insurance plans, is looking to enhance its data-driven decision-making by implementing a Power BI dashboard for actionable insights into key performance metrics. As a Proof of Concept, AtliQ Technologies is tasked with developing a pilot project to showcase our ability to meet their unique needs before scaling up to a full-fledged collaboration.

🧩 This project allows us to dive deep into Shield's metrics, providing strategic insights that can drive better customer care, operational efficiency, and risk management. Looking forward to uncovering valuable insights for Shield Insurance!

Live Interactive Dashboard

PowerBI Project

PowerBI_Hospitality_Project

Domain/Function: POWER BI PROJECT

AtliQ Grands, a prominent player in the Indian hospitality industry with over 20 years of experience and multiple five-star hotels, is currently facing a significant decline in market share and revenue within the luxury/business hotel category. This downturn is attributed to strategic moves.

View Project
Engagement

View Project
on GitHUB

Data Modeling : Developed a Hospitality Revenue Analysis Dashboard using Power BI and Excel to analyze hotel performance metrics such as revenue, bookings, occupancy, ADR, and RevPAR.

Insight: Analysis shows revenue decline linked to lower occupancy, higher cancellations, and competitive pricing. Metrics like ADR and RevPAR highlight performance gaps across hotels, helping identify opportunities to optimize pricing

Project Details

📌 Project Background: AtliQ Grands – Business Intelligence Implementation
AtliQ Grands, a well-established name in the Indian hospitality industry with over 20 years of legacy and a portfolio of multiple five-star properties, is currently experiencing a notable decline in market share and revenue in the luxury/business hotel segment. 📉

⚠️ Challenges Identified
Aggressive strategies by competitors 🏨

Ineffective and delayed internal decision-making 🕰️

Absence of a dedicated in-house data analytics team 🔍

To address these critical issues, the Managing Director has initiated a strategic shift toward Business and Data Intelligence as a core component of the company's turnaround plan.

🎯 Objective
Engage a third-party data analytics provider to:

🧠 Analyze historical performance and market data

💰 Optimize pricing strategies using predictive insights

😊 Enhance customer satisfaction and retention

📊 Enable informed, timely decision-making at the executive level

Live Interactive Dashboard

Python Project

𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗖𝗵𝘂𝗿𝗻 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗳𝗼𝗿 𝗧𝗲𝗹𝗲𝗰𝗼𝗺 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆

Domain/Function: python

Customer churn is a critical challenge in the telecom industry, directly impacting revenue and long-term business sustainability. The given analysis provides insights into the factors influencing churn across various service categories. The findings suggest that customer retention is significantly

View Project
Engagement

View Project
on GitHUB

View Project
on https://github.com/vinayykewat/Churn-Analysis

𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗖𝗵𝘂𝗿𝗻 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗳𝗼𝗿 𝗧𝗲𝗹𝗲𝗰𝗼𝗺 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆

Analyzed telecom customer churn data to identify factors influencing subscriber attrition. Explored the impact of customer support availability and internet service types on churn.

Customers with limited customer support access show higher churn rates. Users with slower internet services like DSL are more likely to leave compared to fiber-optic users.

Project Details

📉 Customer Churn in Telecom Services
Customer churn—the rate at which subscribers discontinue their telecom services—is a major challenge for the industry. It affects monthly recurring revenue and has long-term implications for brand loyalty, operational costs, and market competitiveness.

This analytical project aimed to uncover key drivers behind customer attrition, with the goal of helping telecom providers implement effective retention strategies. 🔍📊

🔑 Key Insights Identified:

🧑‍💼 Customer Support Availability
The presence and responsiveness of customer service teams play a pivotal role in customer satisfaction. Limited support hours or unresolved issues were found to contribute significantly to churn.

🌐 Type of Internet Service
Customers using DSL or slower internet services were likelier to churn than those with fiber-optic or higher-speed alternatives. This suggests that investment in infrastructure and high-speed connectivity

📉 𝗦𝗮𝗹𝗲𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗳𝗼𝗿 𝗜𝗻𝗱𝗶𝗮-𝗕𝗮𝘀𝗲𝗱 𝗛𝗮𝗿𝗱𝘄𝗮𝗿𝗲 𝗖𝗼𝗺𝗽𝗮𝗻𝘆 | 📊 Tableau Project

Domain/Function: Sales-Insights---Data-Analysis-using-Tableau-SQL

🚀 Sharing "Sales Insights" – A Data Analysis Project 🔍 Performed using Tableau and SQL, this project analyzes sales data from an India-based hardware company. It’s a key milestone in my journey into Data Science, showcasing how data can drive business decisions through impactful visualizations and

View Project
Engagement

View Project
on GitHUB

View Project
on https://github.com/vinayyssahani/Sales-Insights---Data-Analysis-using-Tableau-SQL-/tree/main

📉 𝗦𝗮𝗹𝗲𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗳𝗼𝗿 𝗜𝗻𝗱𝗶𝗮-𝗕𝗮𝘀𝗲𝗱 𝗛𝗮𝗿𝗱𝘄𝗮𝗿𝗲 𝗖𝗼𝗺𝗽𝗮𝗻𝘆 | 📊 Tableau Project

Developed ETL mappings using SQL to extract the data from unstructured data and transformed it to the staging area to conduct data cleaning and design

Developed a Tableau dashboard to perform analysis, producing quantitative visualizations in Tableau to draw valuable insights based on different param

Project Details

🧩 Developed an interactive Tableau dashboard to perform in-depth analysis of company performance 📊.
✅ Utilized quantitative visualizations to highlight trends, patterns, and key metrics across different parameters such as revenue 💰, customer satisfaction 😊, and operational efficiency ⚙️.
📈 Enabled year-over-year comparisons to evaluate growth and identify underperforming areas.
🔍 Derived valuable business insights that informed data-driven decision-making and helped stakeholders implement targeted solutions.
🎯 Contributed to improved strategic planning, optimized resource allocation, and better performance monitoring.

PowerBI Project

Electric Vehicle Market Analysis

Domain/Function: Electric Vehicle Market

I conducted a market analysis for AtliQ Motors' entry into India's EV market, examining sales trends, state-wise penetration, and customer preferences. The project included projections up to 2030 and strategic recommendations on manufacturing locations and branding to support data-driven expansion.

View Project
Engagement

🌍 Sales by States: Highlighting EV sales, penetration rates, projected growth, and state-wise performance trends for effective market insights.

📊 Sales by Makers: Showcasing EV sales trends, market shares, revenue distribution, and growth insights for top-performing manufacturers.

Project Details

Project Details
● Grasp the current landscape of the EV market in India.
● Spot key trends and identify growth opportunities.
● Break down sales data by state, manufacturer, and vehicle category.
● Deliver actionable insights and strategies to boost AtliQ Motors' market share.

🔍 𝗞𝗲𝘆 𝗧𝗮𝗸𝗲𝗮𝘄𝗮𝘆𝘀:

🏆 𝗧𝗼𝗽 𝗘𝗩 𝗠𝗮𝗸𝗲𝗿𝘀 (𝗙𝗬 𝟮𝟬𝟮𝟯 & 𝟮𝟬𝟮𝟰):
● 𝗢𝗟𝗔 𝗘𝗹𝗲𝗰𝘁𝗿𝗶𝗰: Leading the pack for two consecutive years, while smaller players like Jitendra and Battre Electric are struggling to keep up.

🌍 𝗧𝗼𝗽 𝗦𝘁𝗮𝘁𝗲𝘀 𝗯𝘆 𝗘𝗩 𝗣𝗲𝗻𝗲𝘁𝗿𝗮𝘁𝗶𝗼𝗻 (𝗙𝗬 𝟮𝟬𝟮𝟰):
● 𝗚𝗼𝗮: Dominates in 2-wheeler adoption!
● 𝗞𝗲𝗿𝗮𝗹𝗮: Excelling in both 2-wheelers and 4-wheelers.💥

📊 𝗤𝘂𝗮𝗿𝘁𝗲𝗿𝗹𝘆 𝗧𝗿𝗲𝗻𝗱𝘀 𝗳𝗼𝗿 𝗟𝗲𝗮𝗱𝗶𝗻𝗴 𝟰-𝗪𝗵𝗲𝗲𝗹𝗲𝗿 𝗘𝗩 𝗠𝗮𝗸𝗲𝗿𝘀:
● 𝗧𝗮𝘁𝗮 𝗠𝗼𝘁𝗼𝗿𝘀: Outpacing competitors with the highest quarterly growth. 🔥

Live Interactive Dashboard

Python Project

E-commerce Sales & Profit Analysis with Python

Domain/Function: E-commerce

E-commerce Sales & Profit Analysis with Python 🔍 I'm excited to share insights from a recent E-commerce Data Analysis project where I leveraged Python to turn raw data into actionable business intelligence. Here’s what I explored and uncovered using pandas, matplotlib, plotly and seaborn

View Project
Engagement

View Project
on GitHUB

View Project
on Python

E-commerce Sales & Profit Analysis with Python

Performed 𝗘-𝗰𝗼𝗺𝗺𝗲𝗿𝗰𝗲 𝗦𝗮𝗹𝗲𝘀 & 𝗣𝗿𝗼𝗳𝗶𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝘂𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 to identify monthly sales trends, top-performing categories, and profit patterns. Analyzed customer segments and visualized insights using Pandas, Matplotlib, and Seaborn

𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: Monthly analysis shows clear sales fluctuations with peak performance in certain months. Technology emerges as the top-selling category, while some sub-categories underperform. Consumer segment generates the highest sales and profit .

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻
  • Conducted an E-commerce Sales & Profit Analysis using Python to extract meaningful insights from transactional sales data.
  • Utilized Python libraries including Pandas, Matplotlib, and Seaborn for data cleaning, analysis, and visualization.
  • Analyzed monthly sales trends to identify the highest and lowest performing months.
  • Evaluated category and sub-category performance to determine top-selling and low-performing product groups.
  • Performed monthly profit analysis to identify periods with the highest profitability.
  • Conducted segment-wise analysis to compare sales and profit across customer segments such as Consumer, Corporate, and Home Office.
  • Created visualizations and charts to clearly present trends, comparisons, and key business insights.

𝗧𝗼𝗼𝗹𝘀 & 𝗦𝗸𝗶𝗹𝗹𝘀: Python, Pandas, Matplotlib, Seaborn, Data Cleaning, Data Analysis, Data Visualization.

Excel Project

🏏 𝗜𝗣𝗟 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

Domain/Function: EXCEL PROJECT

Created an 𝗜𝗣𝗟 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹 𝘁𝗼 𝗲𝘃𝗮𝗹𝘂𝗮𝘁𝗲 𝗯𝗮𝘁𝘁𝗶𝗻𝗴 𝗮𝗻𝗱 𝗯𝗼𝘄𝗹𝗶𝗻𝗴 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 using metrics like 𝗿𝘂𝗻𝘀, 𝘄𝗶𝗰𝗸𝗲𝘁𝘀, 𝘀𝘁𝗿𝗶𝗸𝗲 𝗿𝗮𝘁𝗲, 𝗮𝗻𝗱 𝗲𝗰𝗼𝗻𝗼𝗺𝘆 𝗿𝗮𝘁𝗲, 𝗲𝗻𝗮𝗯𝗹𝗶𝗻𝗴 𝗱𝗮𝘁𝗮-𝗱𝗿𝗶𝘃𝗲𝗻

View Project
Engagement

View Project
on GitHUB

View Project
on

🏏 𝗜𝗣𝗟 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

𝗣𝗹𝗮𝘆𝗲𝗿 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: • Virat Kohli leads in total runs, while KL Rahul, Ishan Kishan, and Shivam Dube show strong batting contributions. Jasprit Bumrah tops the wicket chart, with Sunil Narine.

𝗣𝗹𝗮𝘆𝗲𝗿 𝘃𝘀 𝗧𝗼𝘁𝗮𝗹 𝗪𝗶𝗰𝗸𝗲𝘁𝘀 (𝗕𝗼𝘄𝗹𝗶𝗻𝗴) – 𝗞𝗲𝘆 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: • Jasprit Bumrah leads in total wickets. Sunil Narine, Trent Boult, and Mohammed Siraj are strong wicket-taking bowlers.

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻
  • Developed an interactive IPL Data Analytics Dashboard using Excel to analyze player performance across key batting and bowling metrics.
  • Performed data cleaning, transformation, and data modeling to prepare the IPL dataset for analysis.
  • Visualized key KPIs, including Total Runs, Total Wickets, Strike Rate, and Bowling Economy for performance evaluation.
  • Implemented interactive slicers and filters to enable dynamic analysis by player and venue.
  • Identified top-performing batsmen, leading wicket-taking bowlers, and overall player efficiency through data visualization.
  • Enabled clear comparison of player performance using structured charts and dashboards.
  • Demonstrated the ability to transform raw sports data into meaningful insights for performance analysis and decision-making.

𝗧𝗼𝗼𝗹𝘀 & 𝗦𝗸𝗶𝗹𝗹𝘀: Excel, DAX, Data Cleaning, Data Modeling, Data Visualization.

Excel Project

📊 𝗛𝗥 𝗔𝘁𝘁𝗿𝗶𝘁𝗶𝗼𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

Domain/Function: EXCEL PROJECT

Developed an 𝗛𝗥 𝗔𝘁𝘁𝗿𝗶𝘁𝗶𝗼𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 in 𝗘𝘅𝗰𝗲𝗹 𝘁𝗼 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 employee turnover, workforce trends, and retention risks. Visualized key HR metrics such as attrition rate, overtime, performance rating, and work-life balance using interactive filters for dep

View Project
Engagement

View Project
on GitHUB

View Project
on 📊 𝗛𝗥 𝗔𝘁𝘁𝗿𝗶𝘁𝗶𝗼𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

Developed an 𝗛𝗥 𝗔𝘁𝘁𝗿𝗶𝘁𝗶𝗼𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹 𝘁𝗼 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝗲𝗺𝗽𝗹𝗼𝘆𝗲𝗲 𝘁𝘂𝗿𝗻𝗼𝘃𝗲𝗿 𝗮𝗻𝗱 𝘄𝗼𝗿𝗸𝗳𝗼𝗿𝗰𝗲 𝘁𝗿𝗲𝗻𝗱𝘀.

𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: The sales department shows the highest attrition rate. Higher overtime and lower satisfaction scores correlate with increased employee turnover.

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻
  • Developed an HR Attrition Analysis Dashboard in Excel to analyze employee turnover patterns, workforce trends, and retention risks.
  • Performed data cleaning, transformation, and data modeling to structure HR data for accurate analysis.
  • Analyzed key HR metrics including Attrition Rate, Overtime Rate, Performance Rating, Work-Life Balance, Job Involvement, and Average Years at Company.
  • Built interactive visualizations and dashboards to compare attrition across departments, gender distribution, and hiring trends.
  • Identified high attrition departments and analyzed factors such as overtime and employee satisfaction impacting retention.
  • Implemented dynamic filters and slicers for real-time data exploration and better executive insights.

𝗧𝗼𝗼𝗹𝘀 & 𝗦𝗸𝗶𝗹𝗹𝘀: Excel, DAX, Data Cleaning, Data Modeling, Data Visualization.

Hello, I am

Vinay Sahani

5

5

2

About

Key

My

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

AtliQ Business Insights 360: End-to-End Analytics Dashboard

Store Data analysis

Amazon Sales Dashboard in Excel

WaveCon TeleCom Industry

Shield Insurance Business Performance Dashboard | Power BI

PowerBI_Hospitality_Project

𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗖𝗵𝘂𝗿𝗻 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗳𝗼𝗿 𝗧𝗲𝗹𝗲𝗰𝗼𝗺 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆

📉 𝗦𝗮𝗹𝗲𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗳𝗼𝗿 𝗜𝗻𝗱𝗶𝗮-𝗕𝗮𝘀𝗲𝗱 𝗛𝗮𝗿𝗱𝘄𝗮𝗿𝗲 𝗖𝗼𝗺𝗽𝗮𝗻𝘆 | 📊 Tableau Project

Electric Vehicle Market Analysis

E-commerce Sales & Profit Analysis with Python

🏏 𝗜𝗣𝗟 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

📊 𝗛𝗥 𝗔𝘁𝘁𝗿𝗶𝘁𝗶𝗼𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 | 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

My

Data Analyst

Data Analyst Intern — AtliQ Technologies (Remote)

🎓 Teaching Assistant Intern

Awards

Contact Me

Email

Github

Linkedin

Call

Vinay Sahani