Pratham Patel

Data Analyst

[email protected] +1 4803598429

Resume

Hello, I am

Pratham Patel.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

I’m a data analyst with expertise in SQL, Power BI, DAX, and Python, passionate about turning data into actionable insights. I specialize in analyzing large datasets and building interactive dashboards to support business decisions. In my career, I’ve worked across industries like consumer goods, electric vehicles, and retail, helping businesses optimize processes, boost revenue, and reduce costs.

My key projects include creating a Power BI dashboard for an EV company, leading to a 40% sales growth forecast by 2030, and analyzing 500K+ hotel bookings using Python to predict customer cancellations with 85% accuracy. Additionally, my advanced SQL queries uncovered a 15% growth in unique product sales, and I built a global sales dashboard for AtliQ Hardware, driving a 10% revenue increase.

I thrive on using data to solve problems, streamline operations, and deliver impactful results for businesses.

Key Skills

python

DAX

Power Query

Statistics

AI/ML

Tableau

SQL

Aws cloud

Finance

MySQL SQL Server

My Projects

EV Market Insights Dashboard

Domain/Function: EV sales analysis

Business 360

Domain/Function: Global Sales Analysis Dashboard

Hospitality Analysis Insights

Domain/Function: Consumer Goods

SQL Data Analysis Queries for Business Insights

Domain/Function: Data Analysis for Business Optimization

Excel Data Analysis Project

Domain/Function: Sales and Financial Analysis

My Experience

BISAG-IN, Ahmedabad– Security Data Scientist
Dec 2022 - April 2023

Developed and deployed a malware detection system capable of identifying 50 different types of malware, reducing cyber-attack risks by 70%. Utilized advanced analytical techniques and machine learning models to enhance system accuracy.
Collaborated with the IT and security teams to integrate and test the malware detection system, ensuring seamless operation within the existing infrastructure and improving overall cybersecurity measures.
Presented findings and system impact to senior stakeholders, leading to a strengthened cybersecurity posture and increased organizational resilience against cyber threats.
Implemented data protection measures and conducted regular security audits, which resulted in a 50% reduction in security breaches and enhanced data confidentiality across the organization.

Arizona State University, Tempe – Student Verifier Supervisor
Jan 2025 – Present

Trained over 15 new hires on the processing of transcripts for students from 50+ countries, streamlining the verification process and ensuring compliance with university policies.
Managed and coordinated weekly meetings with HR, optimizing the student verification process and improving operational efficiency by 20%.
Implemented process improvements based on feedback and performance metrics, which enhanced the accuracy and speed of transcript processing.
Facilitated the onboarding and integration of new team members, contributing to a more cohesive and efficient team environment.

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/pratham-patel-6972761b3/

Call Me

+1 4803598429

GitHub

https://github.com/pratham83/

PowerBI Project

EV Market Insights Dashboard

Domain/Function: EV sales analysis

This project focuses on creating a comprehensive Power BI dashboard to provide actionable insights into electric vehicle (EV) sales performance across multiple regions. Using data from FY22 to FY24, the dashboard was designed to track sales trends for both 2- and 4-wheeler vehicles. I utilized Power

View Project
Engagement

Dashboard projecting 2030 EV sales using CAGR 2022-24, displaying EV penetration rates, sales growth, and state-wise trends.

Power BI dashboard showing 2022-24 EV revenue by automaker, vehicle type, and state with CAGR projections to 2030 for market insights.

Project Details

Developed a Power BI dashboard to track EV sales across 5 regions using FY22-24 data for 2- and 4-wheelers. Built relationships across 4 tables, leveraging 15+ DAX queries to forecast a 40% sales increase by 2030. Improved team efficiency by 13% and cut reporting times by 20%, driving better strategic decisions for supply chain and sales planning.

Live Interactive Dashboard

PowerBI Project

Business 360

Domain/Function: Global Sales Analysis Dashboard

Developed an interactive Power BI dashboard for AtliQ Hardware, integrating Excel, CSV, and SQL data to analyze global sales trends and drive revenue growth.

This image shows the Finance view of the project

The image shows the supply chain dashboard of the project

Project Details

Created an interactive Power BI dashboard to analyze global sales trends for AtliQ Hardware, integrating data from Excel, CSV, and SQL sources. Enhanced report performance by 12% through optimized data modeling and advanced DAX queries, with a 15% improvement in loading times using DAX Studio. Delivered actionable insights into sales trends across departments, resulting in a 10% revenue growth and a 25% reduction in data management costs. Customized visualizations and reports enabled stakeholders to make informed, real-time decisions, driving strategic business outcomes.

Live Interactive Dashboard

Python Project

Hospitality Analysis Insights

Domain/Function: Consumer Goods

Leveraged Python to analyze 500K+ hotel booking records, providing insights into customer behavior, booking trends, and pricing strategies for improved revenue management.

View Project
on GitHUB

View Project
on

Image shows the transformation code with output

This image shows the Visualization of the data

Project Details

Conducted a comprehensive analysis of over 500,000 hotel booking records using Python to reveal trends in customer behavior, booking patterns, and pricing strategies. Utilized Python libraries such as Pandas and NumPy to clean and process 80% of the dataset, improving data accuracy and usability. Delivered over 10 visualizations that highlighted seasonal booking trends, enabling hotel managers to optimize pricing strategies. Developed machine learning models to predict customer cancellation rates with 85% accuracy, assisting hotels in mitigating potential revenue losses and enhancing strategic planning. Identified key factors influencing booking decisions and customer loyalty, providing actionable recommendations for targeted marketing and improved customer retention. Enhanced overall data-driven decision-making by integrating advanced analytical techniques with practical business insights.

SQL Project

SQL Data Analysis Queries for Business Insights

Domain/Function: Data Analysis for Business Optimization

Developed advanced SQL queries to analyze sales, product performance, and customer data, providing actionable insights for business optimization and strategic decision-making.

View Project
on GitHUB

View Project
on

The image shows a Stored Procedure which takes Region India in this case and takes year and the returns badge according to their performance.

It shows how I have created a function to return quarters (Q!..Q4) from the calendar date

Project Details

Developed a suite of advanced SQL queries to analyze sales, product, and customer data, employing techniques like JOINs, CTEs, and window functions to address critical business questions. Analyzed market data for "Atliq Exclusive" in the APAC region, revealing performance insights and geographic trends. Calculated a 15% increase in unique products sold between 2020 and 2021, pinpointing growth areas across various segments. Identified the top and bottom 5 products by manufacturing costs, enabling optimized procurement decisions and refined production strategies. These analyses contributed to more informed business strategies and operational improvements.

Excel Project

Excel Data Analysis Project

Domain/Function: Sales and Financial Analysis

Analyzed customer, product, and sales data using Excel pivot tables and Power Query, revealing trends, performance, and profitability from 2019 to 2021.

View Project
on GitHUB

View Project
on

It shows the yearly revenue for all stores and filters for region division and market

This shows a summary of profit with same filters

Project Details

This Excel Data Analysis Project involved an in-depth examination of customer, product, and sales data, utilizing Excel and Power Query to preprocess and analyze the information. Pivot tables were created to deliver actionable insights, including:

1. Yearly Revenue Analysis: Compared revenue from 2019 to 2021, identifying growth or decline trends across regions and divisions.
2.Target Comparison: Evaluated actual sales against targets for 2021, highlighting performance gaps and achievement rates.
3. Profit and Loss Analysis: Provided a detailed profit and loss statement with year-over-year comparisons, analyzing profitability by segment and market.