Darsh Shah

Data Aspirant

[email protected] +91 6352461552

Resume

Hello, I am

Darsh Shah.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Welcome to my portfolio website! I'm a data enthusiast dedicated to unraveling the hidden stories behind numbers. My passion for data analysis led me to dive headfirst into this captivating field.

I specialize in Excel, PowerBI, SQL, and Python, transforming raw data into actionable insights. From crunching numbers to crafting compelling visuals, I love turning complex information into understandable narratives that drive business success.

Though I do not have formal work experience yet, I’ve completed several business projects that showcase my data analysis skills. These projects are highlighted in my portfolio below.

I’m eager to collaborate with innovative organizations, applying my skills to support data-driven decision-making. Explore my portfolio to see the exciting projects I’ve undertaken and the value I can bring to your team. Let’s unlock the power of data together!

Key Skills

Python

SQL

Problem Solving

My Projects

Sales Analytics

Domain/Function: Data Analysis

Business insights 360

Domain/Function: Insights & Visualization

Cricket World Cup 2022

Domain/Function: Insights & Visualization

AtliQ Hospitality

Domain/Function: Data Analysis

Pizza Sales Analysis

Domain/Function: Data Analysis

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/darsh-shah-5a2b6b24b/

Call Me

+91 6352461552

GitHub

https://github.com/DarshShah02

Excel Project

Sales Analytics

Domain/Function: Data Analysis

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. Empower businesses to monitor and evaluate their sales activities and performance.

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

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

Domain/Function: Insights & Visualization

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
on GitHUB

This home page features a display of all dashboards, including the refresh date and project details.

Executive Dashboard Offers market share against competitors, trend analyses, revenue breakdowns, and highlights the top 5 customers

Project Details

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

Live Interactive Dashboard

PowerBI Project

Cricket World Cup 2022

Domain/Function: Insights & Visualization

Created an interactive Power BI dashboard for the World Cup 2022, using power query to analyze player and team performance, providing valuable insights for strategic decisions in the dynamic tournament.

This visual representation highlights the analysis of each player.

This visual representation highlights the top 11 standout players of the World Cup 2022.

Project Details

World Cup 2022 Performance Analysis Dashboard

Project Overview: Created an interactive Power BI dashboard to analyze player and team performance in the World Cup 2022.
Data Processing: Utilized Power Query for data cleaning and transformation.
Analysis: Provided valuable insights into player statistics, team performance, and match outcomes.
Outcome: Delivered actionable insights for strategic decisions in the dynamic tournament.

Live Interactive Dashboard

Python Project

AtliQ Hospitality

Domain/Function: Data Analysis

Conducted data analysis for AtliQ Hospitality using Python and Pandas to uncover key business insights, optimize operations, and improve customer satisfaction.

View Project
on GitHUB

Revenue realized from different platforms.

Customer occurrence percentage by city.

Project Details

AtliQ Hospitality Data Analysis

This project involved a comprehensive analysis of AtliQ Hospitality's business data to identify trends and insights that could help optimize operations and enhance customer satisfaction. Key aspects of the project included:
Data Collection and Cleaning: Utilized Python and Pandas to gather, clean, and preprocess data from various sources, ensuring accuracy and consistency.
Exploratory Data Analysis (EDA): Performed EDA to uncover patterns, correlations, and outliers using data visualization library Matplotlib.
Reporting: Created detailed reports and visualizations to communicate findings and support data-driven decision-making.
The analysis provided actionable insights that helped AtliQ Hospitality enhance their operational efficiency and improve overall customer experience.

SQL Project

Pizza Sales Analysis

Domain/Function: Data Analysis

Analyzed pizza sales data using SQL to uncover sales trends, customer segments, and product performance, enhancing marketing strategies and inventory management.

View Project
on GitHUB

The percentage contribution of each pizza type to total revenue.

The top 3 most ordered pizza types based on revenue for each pizza category.

Project Details

Project Overview This project involves analyzing pizza sales data using SQL to uncover key insights and trends. The goal is to identify sales patterns, customer segments, and product performance to enhance marketing strategies and improve inventory management.

Key Features Data Cleaning and Preprocessing: Ensured data accuracy and consistency through SQL queries. Sales Trend Analysis: Identified peak sales periods and seasonal variations

Tools and Technologies SQL: For data extraction, transformation, and analysis.