Portfolio - Mayank Pratap Singh | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Mayank Pratap Singh

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

I am a dynamic Data Analyst with over 3 years of experience in roles such as Production Analyst and Associate Product Manager. Proficient in leveraging data analytics tools such as Excel, SQL, Power BI, Tableau, and Python, I have a proven track record of driving a 20% increase in sales through the creation and maintenance of Power BI reports. My expertise extends to app feature improvement, business requirement gathering, and successful collaboration with cross-functional teams. With a strong background in production analysis and a keen eye for optimizing processes, I am now eager to contribute my skills and insights to a forward-thinking organization committed to innovation and growth

My

Projects

Consumer Complaints Analysis

Consumer Complaints Analysis

Prepared and summarized company-level data using Excel to analyze timely responded complaints.
Identified top 5 companies with the highest number of complaints and issues using advanced Excel functions.

Business Insights 360

Business Insights 360

Orchestrated 5 interactive dashboards using Power BI, SQL, Excel, and DAX Studio.
Identified high-yield segments with over 10% gross margin through data modeling techniques.

Retail Data Analysis

Retail Data Analysis

Utilized SQL to understand customer behavior through Point of Sales (POS) data.
Extracted insights such as top 10 products, top 5 customers, and marketing insights for the last 3 months.

Awards

& Certificate

Data Analyst(Python)

Data Analyst(Python)

Data Analyst(Excel,SQL,Tableau)

Data Analyst(Excel,SQL,Tableau)

Contact Me

Email

[email protected]

Github

https://github.com/mayankpratap0028

Linkedin

https://www.linkedin.com/in/mayank-pratap-singh-61160b149/

Call

+91 7742057902

Mayank Pratap Singh

Data Aspirant

Download Resume

Resume

Excel Project

Consumer Complaints Analysis

Prepared and summarized company-level data using Excel to analyze timely responded complaints. Identified top 5 companies with the highest number of complaints and issues using advanced Excel functions.

View Project
on GitHUB

Consumer Complaints Analysis

Analyzing consumer complaints underscores a need for streamlined online resolutions, focused attention on top categories ('Mortgage,' 'Debt Collection

Consumer Complaints Analysis

Utilized pivot tables to identify the top five companies and issues with the maximum complaints, and created line/area charts to illustrate monthly co

Project Details

Developed a comprehensive GitHub repository for consumer complaint analysis using Excel. The project involved the preparation and summarization of company-level data to determine the percentage of timely responded complaints, disputed complaints, and average closure times. Through advanced Excel functions, Pivot Tables, and data validations, the analysis identified the top 5 companies with the highest number of complaints and the top 5 most reported issues. The resulting insights offer valuable information for improving customer satisfaction and service efficiency

PowerBI Project

Business Insights 360

Orchestrated 5 interactive dashboards using Power BI, SQL, Excel, and DAX Studio. Identified high-yield segments with over 10% gross margin through data modeling techniques.

Business Insights 360

Finance view - Getting P&L statement for any customer/product/country or aggregation of above over any time period.

Business Insights 360

Supply chain View - Getting Forecast Accuracy,NetError and risk profile for product,segment,category,customer etc.

Project Details

Orchestrated the development of a comprehensive business insights tool, featuring 5 interactive dashboards created with Power BI, SQL, Excel, and DAX Studio. The project focused on identifying high-yield segments through meticulous data modeling techniques, resulting in a more than 10% increase in gross margin. These dashboards provide key stakeholders with real-time, visually appealing data visualizations, enabling informed decision-making and strategic planning.

Live Interactive Dashboard

SQL Project

Retail Data Analysis

Utilized SQL to understand customer behavior through Point of Sales (POS) data. Extracted insights such as top 10 products, top 5 customers, and marketing insights for the last 3 months.

View Project
on GitHUB

Retail Data Analysis

For all customers aged between 25 to 35 years find what is the net total revenue -- generated by these consumers in last 30 days of transactions

Retail Data Analysis

product category has seen the max value of returns in the last 3 months of -- transactions

Project Details

Applied SQL queries to analyze Point of Sales (POS) data, uncovering valuable insights into customer behavior. The project identified the top 10 products and top 5 customers based on quantity and collections. Additionally, it focused on securing product categories with the highest return in the last 3 months, as well as analyzing total revenue generated by different age groups of customers. This analysis empowers businesses with actionable information for inventory management, marketing, and customer segmentation strategies