Portfolio - Pranay Singh | Codebasics

Powered by
Codebasics DA Bootcamp

Pranay Singh

Data Automation Specialist

EMAIL

[email protected]

Download CV

About Me

Engineer by Education, Data Automation Specialist by Profession.

I specialize in automating time-consuming and repetitive manual tasks like data entry, and reporting.
Currently, I’m building an AI-enabled personal assistant designed to perform end-to-end administrative tasks with zero human intervention.
I also turn raw data into actionable insights using tools like SQL, Excel, PowerBI, Python, and AWS.
With experience as an SAP Business Analyst at Infosys and a Cloud Consultant at LinuxWorld, I bring a versatile skill set to solving complex business challenges.

Basically, I focus on solving real-world problems through automation, data analytics, and AI-driven solutions.

3

PowerBI Projects

2

Python Projects

Key Skills

SQL

NoSQL

AWS

Make.com

Pyhton

N8N

Automation

API

Agentic AI

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL (Intermediate)

SQL (Intermediate)

Sales Resume Project

Sales Resume Project

Let's Work Together!

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.

EMAIL

[email protected]

LinkedIn

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

GitHub

https://github.com/pranaysingh-27

PowerBI Project

Business Insights 360

Business Insights 360 leverages Power BI, SQL, MS Excel, and DAX Studio to analyze 2 million+ records of sectors like Finance, Sales, Marketing, and Supply Chain.

View Project
on GitHUB

Business Insights 360

Finance View Dashboard

Business Insights 360

Data Model

Project Details

Business Insights 360 [Power BI, SQL, MS Excel, DAX Studio]
• Analyzed 2 Million+ records, created visually compelling charts, graphs, and reports to communicate key findings
and recommendations.
• Developed 5 interactive dashboards for business sectors: Sales, Finance, Marketing, and Supply Chain, by gathering
data from 2 sources (MS Excel/CSV files and a SQL database).
• Performed ETL operations, built a data model and data visualizations in Power BI, optimized the report with DAX
Studio, improved the performance by 5%.

Live Interactive Dashboard

Python Project

Diwali Sales Analysis

Project to analyze sales data in Diwali season for an offline retail outlet to enhance customer experience, boost revenue, and identify target audiences for marketing initiatives.

View Project
Engagement

View Project
on GitHUB

Diwali Sales Analysis

Age group and gender bar graph

Diwali Sales Analysis

Top 10 States according to number of orders

Project Details

Objective:
Enhance customer experience, increase revenue, and target marketing effectively.

Learnings:
Cleaned and manipulated data
Conducted EDA using pandas, matplotlib, and seaborn.
Identified target customers and key sales drivers.
Optimized sales strategy based on top-selling products.

PowerBI Project

Ecommerce Sales Analysis

"Superstore" is an E-commerce store that operates in the US and sells furniture, office supplies, and computer peripherals. They want to analyze the sales performance over two years and find out what went right and what could be improved.

View Project
Engagement

View Project
on GitHUB

Ecommerce Sales Analysis

Sales Analysis Dashboard

Ecommerce Sales Analysis

Sales Forecast Dashboard

Project Details

> Objective:
To contribute to the success of Superstore by utilizing data analysis techniques specifically focusing on visualization with important KPIs and key metrics, time series analysis to provide valuable insights and accurate sales forecasting.

> Project Learning:
Incorporated data analysis techniques, specializing in time series analysis, to deliver valuable insights, accurate sales forecasting, and interactive dashboard creation, driving business success.

Live Interactive Dashboard

Stock Market Analysis

This project aims to find good stocks from given dataset, for possible investments based on past performance, PE ratio, industry, 52-week high, 52-week low, and other factors.

View Project
on GitHUB

Stock Market Analysis

Stocks Analysis

Stock Market Analysis

Industry Analysis

Project Details

Perform data cleaning and manipulation.
Make a spreadsheet of good stocks based on certain conditions.
Develop interactive dashboards for Stocks analysis and industry analysis, reports and visualizations with Key Performance indicators (KPIs).

PowerBI Project

Retail Store Analysis

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products.

View Project
Engagement

View Project
on GitHUB

Retail Store Analysis

Store Analysis

Retail Store Analysis

Product and Promotions Analysis

Project Details

Problem Statement: AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director, Bruce Haryali wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.

Live Interactive Dashboard

Python Project

Web Scraping

Scraped multiple pages for data of companies such as names, reviews, ratings, etc. from AmbitionBox website for Analysis using Python and its libraries.

View Project
Engagement

View Project
on GitHUB

-

-

Project Details

> Python Libraries Used:
- Pandas, Requests, BeautifulSoup