Portfolio - Prashanth Nangi

Hello, I am

Prashanth Nangi

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Senior Quality Analyst with 2.8 years of experience seeking Data Analyst role. Strong analytical skills, attention to detail, and a passion for process improvement. Proven ability to manage data, identify patterns, and translate insights into action. Skilled in SQL, Python, and Excel for data manipulation and analysis. Eager to leverage QA expertise for data-driven decision making in a dynamic environment. Actively pursuing Data Analytics Bootcamp for further skill development.

Key

Skills

MySQL

Python

My

Projects

Sales and Finance Analytics

Developed comprehensive reports for the sales team, focusing on evaluating customer performance metrics and analyzing market performance in alignment with their targets. These reports provide actionable insights to enhance strategic decision-making and optimize sales strategies.

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

AtliQ Hardwares, a fast-growing consumer electronics company, lags in data competitiveness due to reliance on Excel reports. I aim to implement Power BI for advanced analytics, empowering insightful decisions and competitive edge.

Awards

& Certificate

Python Basic

SQL Advance

Contact Me

Email

[email protected]

Github

https://github.com/Prashanthmonku

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

Call

+91 +919676011008

Prashanth Nangi

Data Aspirant

Download Resume

Resume

Excel Project

Sales and Finance Analytics

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. This report helps businesses understand customer discounts, negotiate better with customers, and explore new markets in promising countries. The reports give clear recommendations to improve sales strategies, boost customer satisfaction, and increase revenue.

Key Learnings:

Using Pivot Tables in Excel
Power Query for data handling
Basics of DAX formulas
Conditional Formatting for visual clarity
Making reports visually appealing
Understanding sales metrics
Overall, this project helps businesses monitor and improve their sales activities using data analysis, leading to growth and competitiveness in the market.

PowerBI Project

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

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

▶ Project Goal:In this project, the goal is to be one report which could be used by stakeholders from the sales, marketing, finance and executive team. The focus is made on the following.

Robust Data Modeling: Ensuring accuracy and analysis ease.
User-Empathetic Design: Meeting each group's needs effectively.
Drillable Insights: Enabling detailed data exploration.
Benefits: Empowering decision-making across all organizational levels

▶ Dashboard Overview:
Finance: Analyzing profitability, sales trends, and P&L for informed financial decisions.
Sales: Optimizing product offerings via customer buying pattern analysis.
Marketing: Crafting targeted campaigns from market research and customer insights.
Supply Chain: Enhancing forecast accuracy and logistics efficiency for inventory management.
Executive: Providing key metrics and KPIs for strategic business decisions.

▶ Tech Skills Acquired:
SQL
Power BI Desktop
Excel
DAX Language
DAX Studio

Hello, I am

Prashanth Nangi

1

1

About

Key

My

Sales and Finance Analytics

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

Awards

Contact Me

Email

Github

Linkedin

Call

Prashanth Nangi

Download Resume