Portfolio - vikas kumar

vikas kumar

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Welcome to my portfolio page. Hi there! I’m Vikas Kumar, and I’m passionate about data analysis. I love turning raw data into clear, actionable insights. With skills in Excel, Power BI, MySQL, Python, Looker Studio, Tableau, and Big Query, I enjoy finding patterns and trends that help businesses make smarter decisions.
I started with a B.Com but discovered my true calling in data analysis. I’m now pursuing an MCA in Data Analytics to deepen my expertise. Although my previous roles were in different areas at MNCs, I’ve tackled many data-focused projects that you can see in my portfolio.
I’m excited about the opportunity to use my skills and experience to make a real impact as a Data Analyst. Thanks for visiting my portfolio!

Key Skills

python

Looker Studio

Google Cloud Platform

Tableau

MySQL

Statistics

My Projects

Sales Analytics(FMCG)

Domain/Function: FMCG

Super mart Sales Dashboard

Domain/Function: Sales Analytics

Business Insights 360

Domain/Function: Sales Analytics

Hospitality Domain Data Analysis

Domain/Function: Hospitality Domain

E-Commerce-Store-Data-Analysis SQL

Domain/Function: Sales Analytics

Hotel Domain Analysis

Domain/Function: Hotel Domain Analysis

Awards & Certificate

Data Visualisation

Data Analytics Job Simulation

Excel Skills Job Simulation

Artificial Intelligence Job Simulation

Data Analytics and Visualization Job

Data Science Job Simulation

Introduction to Data Science Job Simulation

Data Science Job Simulation

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/vikas-kumar1855/

Call Me

+91 8595049329

GitHub

https://github.com/Vikas1855

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

I created two detailed reports for the sales team to evaluate customer performance and analyze their market position relative to targets, aiding in strategic decision-making and performance improvement.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report in Excel tracks key metrics like purchase frequency and order value, helping businesses analyze customer behavior.

The Monthly P&L Statement provides a detailed breakdown of profit and loss each month, offering insights into revenue, expenses, and net income.

Project Details

In this project, I developed a sales report using Excel pivot tables to assist businesses in identifying optimal customer discounts, improving negotiations with consumers, and spotting potential growth opportunities in high-potential countries. The insights and recommendations from these reports will help businesses refine their sales strategies, boost customer satisfaction, and drive revenue growth.

PowerBI Project

Super mart Sales Dashboard

Domain/Function: Sales Analytics

I implemented a Power BI sales dashboard that boosted sales by 10% and created dashboards that cut report time by 30%. Additionally, I developed models that improved sales forecasting accuracy by 25%.

View Project
Engagement

View Project
on GitHUB

Implemented a Power BI sales dashboard, boosting sales by 10% and cutting report time by 30%. Developed models that improved sales forecasting.

Enhanced data insights with Power BI, leading to a 10% sales increase and 25% better forecasting accuracy. Reduced report time by 30%.

Project Details

I implemented a Power BI sales dashboard that delivered valuable insights, resulting in a 10% increase in sales. Additionally, I designed dashboards that streamlined the reporting process, reducing report generation time by 30%. Furthermore, I developed advanced forecasting models that enhanced sales prediction accuracy by 25%. These initiatives collectively improved the efficiency and effectiveness of our sales operations, driving better decision-making and performance outcomes.

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Sales Analytics

Created a Power BI dashboard integrating sales data from Excel/CSV and SQL sources. Optimized with DAX Studio, achieving a 5% performance boost and cutting data-related expenses by 20%.

View Project
Engagement

View Project
on GitHUB

Developed a Power BI dashboard integrating sales data from Excel/CSV and SQL, with finance, sales, and marketing views. Optimized performance by 5% an

Developed a finance view in Power BI that integrates data from Excel/CSV and SQL, optimizing performance by 5% and cutting expenses by 20%.

Project Details

I developed a Power BI dashboard that consolidated sales data from two sources: Excel/CSV and an SQL database. By optimizing the dashboard with DAX Studio, I achieved a 5% improvement in performance and reduced data-related expenses by 20%. This integration provided a comprehensive view of sales metrics, streamlining data analysis and enhancing decision-making efficiency.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Domain Data Analysis

Domain/Function: Hospitality Domain

Led a thorough market and competitor analysis to address a 20% decline in market share and revenue. Enhanced online presence and booking channels, increasing online bookings by 30% and reducing booking rate by 20%. Achieved a 10% boost in market share and revenue in 6 months with strategic promotion

View Project
Engagement

View Project
on GitHUB

Led market analysis for a hotel chain, improving online presence and booking channels to boost bookings by 30% and market share by 10% in 6 months.

Revamped booking channels and marketing strategies, achieving a 30% increase in online bookings and a 10% rise in market share within 6 months.

Project Details

In my Hospitality Domain Data Analysis project for a hotel chain, I led a thorough market and competitor analysis to pinpoint the causes of a 20% drop in market share and revenue. By enhancing the online presence and optimizing booking channels, I drove a 30% increase in online bookings and reduced the booking rate by 20%. Additionally, I implemented targeted promotional offers, which resulted in a 10% increase in market share and revenue within 6 months. This project effectively addressed the decline and set the foundation for sustained growth.

Project video

Live Interactive Dashboard

SQL Project

E-Commerce-Store-Data-Analysis SQL

Domain/Function: Sales Analytics

Developed an E-Commerce Store Data Analysis project using MySQL and Excel, featuring complex SQL queries to extract new and repeat customer details. The report includes Category, Brand, Product, State, City & State views, MTD Orders, and metrics for unique and new customer retention.

View Project
Engagement

View Project
on GitHUB

Created an E-Commerce data analysis project with MySQL and Excel, including complex queries for customer details, and insights by Category, Brand, Pro

Developed an E-Commerce analysis with MySQL and Excel, providing detailed views on customers, orders, and retention across various dimensions.

Project Details

In this E-Commerce Store Data Analysis SQL project, complex SQL queries are employed to extract detailed insights on new and repeat customers. The comprehensive report features various perspectives including Category Level, Brand Level, Product Level, State Level, City & State Level, and Month-to-Date (MTD) Orders View. Additionally, it provides in-depth analysis on Unique Customer Retention and New Customer Retention, offering a holistic view of customer behavior and sales performance. This project aims to deliver actionable insights to enhance customer engagement strategies and optimize business operations.

Project video

Python Project

Hotel Domain Analysis

Domain/Function: Hotel Domain Analysis

This Hotel Domain Analysis project involved data cleaning, transformation, and insights generation across bookings, occupancy, and revenue. Key outcomes include an 18% occupancy improvement, 25% revenue tracking accuracy increase, and a 12% reduction in invalid data entries.

View Project
Engagement

View Project
on GitHUB

This Hotel Data Analysis project improved occupancy by 18%, boosted revenue accuracy by 25%, and reduced invalid data entries by 12% through cleaning

Project Details

The Hotel Domain Analysis project focused on analyzing data from multiple sources, including bookings, occupancy rates, and revenue. The project involved extensive data cleaning to remove outliers and invalid entries, improving the overall data quality by 12%. Data transformation techniques, such as creating occupancy percentage columns and merging datasets, were used to provide actionable insights. Through detailed analysis of room categories, cities, and booking platforms, the hotel achieved an 18% improvement in overall occupancy. Additionally, by integrating time series data for check-in dates and booking platforms, the project enhanced the accuracy of revenue tracking by 25%, helping the hotel with better financial forecasting and operational efficiency. The project provided valuable insights into guest preferences, seasonal trends, and platform performance, enabling the hotel to optimize resources and improve customer satisfaction.