ABHAY KUMAR
DATA SCIENTIST | DATA ANALYST
Embedded Files
Power BI
Power BI
Analysis enhances banking decisions by leveraging transaction data for insights and predictive modeling.
Developed dynamic Online Sales Dashboard in Power BI for General Store, enabling real-time insights nationwide.
The system integrates Python, MySQL, and Power BI for data generation, storage, visualization, and informed decision-making.
Crafted dynamic HR Analytics Dashboard in Power BI, empowering informed decision-making and optimizing workforce strategies.
Restocks and Inventory Management
Cost Price Reduction
Data Analysts in the Buying and Sourcing Team for the Apparel Industry
Data Analysts in the Buying and Sourcing Team for the Apparel Industry
Objective:
To provide actionable insights and strategic recommendations to help the buying and sourcing team optimize their strategies, reduce costs, improve quality, and ensure a reliable supply chain in the apparel industry.
Scope:
Restocks and Inventory Management
Cost Price Reduction
Advance Excel
Advance Excel
Transformed supply chain insights with Excel, correlating consumer behavior and operations for strategic decision-making.
Analyzed hotel bookings with Excel, created pivot tables, and developed a data dashboard.
Comprehensive Excel dashboard for tracking, analyzing, and visualizing cryptocurrency investments and performance.
Interactive tool tracks India's online sales with diverse visualizations, user-driven parameters, and drill-down functionality.
Tableau
Tableau
Analysis of 64,500 food safety records revealed trends, risks, and demographic insights for public health.
Tableau visualizations analyze hotel bookings: hotel-wise, distribution channels, cancellations, time trends, guests, and revenue.
SQL
SQL
SQL Medical Analysis: Executed complex queries to assess patient health metrics, including BMI and glucose levels.
Database Optimization: Improved data integrity and query speed through schema enhancements and indexing.
Insightful Reporting: Created patient views and ranked data by glucose levels for detailed analysis.
Machine Learning
Machine Learning
Enhanced bike-sharing program efficiency in Seoul by predicting rental demand through machine learning analysis.
SVM outperformed other models, achieving 96% accuracy, aiding mobile companies in competitive pricing decisions.
Predict Yes Bank's monthly closing prices using Ridge Regression, Random Forest, and XGBoost models.
Explore hotel booking trends, preferences, and factors influencing bookings through thorough EDA and visualizations.
Relational Database - Product Dissection
Relational Database - Product Dissection
Product Dissection on Koo
Product Dissection on Koo
Koo app analysis highlights multilingual microblogging, regional engagement, and innovation for diverse users.
Product Dissection on Flipkart
Product Dissection on Flipkart
Designed Flipkart's schema, tackling challenges with user-centric features like reviews, COD, and recommendations.
Coffee Shop Sales Analysis Using
Coffee Shop Sales Analysis Using
Python, SQL Power BI, Tableau, & Excel
Python, SQL Power BI, Tableau, & Excel
Disclaimer: The content on this portfolio is for personal and professional use only. Unauthorized use, reproduction, or distribution of any materials contained here is strictly prohibited without prior permission. While every effort is made to ensure the accuracy of the information presented, no warranty or guarantee is provided. Views and opinions expressed are those of the author and do not constitute professional advice. Use of this site is subject to the terms and conditions outlined herein.
Copyright @ ABHAY KUMAR
Page updated
Google Sites
Report abuse