Shivansh

Aspring Data Analyst

[email protected] +91 8569808937

Resume

Hello, I am

Shivansh.

1

Excel
Project

3

PowerBI
Projects

1

Python
Project

1

SQL
Project

About Me

Welcome to my portfolio!
I am an aspiring Data Analyst with a passion for transforming raw data into actionable insights. While my academic journey led me to a Bachelor of Arts degree , but my true calling lies in the world of data analysis.

Through extensive self-learning and hands-on experience, I have honed my skills in Excel, Power BI, SQL, and Python, allowing me to efficiently analyze complex datasets and extract meaningful conclusions.

While I haven’t clocked office hours yet, my hands-on experience shines through several business projects showcased in my portfolio. From crunching numbers to visualizing trends, I’m ready to dive into real-world challenges.

I'm passionate about constantly improving myself and making decisions based on data. I believe that's the way forward for any organization looking to succeed.

Thank you for visiting my portfolio, and I look forward to connecting with recruiters who appreciate the power of data and are ready to leverage it for success.

Key Skills

Python

SQL

My Projects

Customer Performance Report

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

Hotel Data Analytics

HR Analytics

Sales Insights

Consumer-Goods---Adhoc-Insights

Awards & Certificate

IBM Data Science

Career Essentials in Data Analysis by Microsoft and LinkedIn

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.

Mail Me

[email protected]

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

Call Me

+91 8569808937

GitHub

https://github.com/shivansh8987

Excel Project

Customer Performance Report

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
Engagement

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 Hardwares is a consumer electronics company 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

View Project
Engagement

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

Project video

Live Interactive Dashboard

Python Project

Hotel Data Analytics

This Project is All about the Hotel Data Analysis we are using this imaginary company called AtliQ Grants for this project. Now this company is a hotel chain, which operates in various cities in India. They have hotels in four cities

View Project
on GitHUB

Starting the Project Hotel Data Analysis Of AtliQ Grant it is hotel chain Staring the importing required Libraries the started to explore the data

Analysing the data of AtliQ grant the hotel and here some graphs that shows some insights from the data

Project Details

They have hotels in four cities Dehli Mumbai Bangalore and Hyderabad and they have been in the industry for around 20 years. Now, they have
different types of hotels such as AtliQ season Exotica Bay & Palace. For example AtliQ Palace is a luxurious portal.

There are other Hotels such as Seasons which are in business category and they have different type of rooms, you know.

Hundred Allied premium presidential Etc. Now a person can book a hotel. Why are various medium? So number one is at

AtliQ grants own website. So you can go to their website and book a room there. You can also go to third party booking websites
such as make your trip and so on a booking happens through variety of mediums that data

will go into AtliQ grants booking database and from this database we want to now perform

data analysis because this company actually grants is facing a major Challenge from their competitors. They're losing their revenue their market

Project video

PowerBI Project

HR Analytics

In this end-to-end data analytics project, we take a REAL dataset for employee presence from a company called AtliQ and perform data analysis in Power BI. An HR from AtliQ Technologies who conveyed her requirements and we built a Power BI dashboard for her to help her with employees Preference

View Project
Engagement

Dasboard

Power Query Data Transformation

Project Details

In this project,
An HR from AtliQ Technologies her requirements and we built a Power BI dashboard for HR .
the goal is to be one report which could be used by HR from Employees Presence . The focus is made on the following
HR want to understand the working preference of people, between work from home and work from office.
If employee are taking frequent work from home, or either on monday or the friday,
then what could be the reason behind that .
If people are taking sickleave, that
We want to understand the reason.

Live Interactive Dashboard

PowerBI Project

Sales Insights

This project is based on a computer hardware business which is facing challenges in dynamically changing market . GIves Sales Insights on Key Insights , Profit Analysis & on Performance Insights

View Project
Engagement

Home Page of Dashboard from where we can navigate through the different pages

This is how Perfromance Insights page looks like it gives the revenue trend by months and years

Project Details

Sales director decides to invest in data analysis project and he would like to build power BI dashboard that can give him real time sales insights. This project gives The overall view of sales insights of AtliQ Hardware like Key Insights gives Revenue & sales quantity insights Profit Analysis gives Profit with customer name & Performance Inisghts gives year trend Analysis

Live Interactive Dashboard

SQL Project

Consumer-Goods---Adhoc-Insights

In this project, I conducted an analysis for Atliq Hardware, a prominent hardware production company. The primary objective was to provide valuable insights to the company through a SQL challenge, addressing the need for quick decision-making in their expanding data analytics team.

SQL CODE

Project Details

this project, the focal discoveries revolved around determining the count of unique products, identifying the pinnacle of sales figures, and assessing the overall gross sales. These key findings play a pivotal role in shaping informed decisions for Atliq Hardware's strategic endeavors. Deepen customer insights, refine product recommendations, optimize pricing and inventory, and spot new product opportunities. Key intel for Atliq Hardware's strategic moves.