Powered by
Codebasics DA Bootcamp

Nagendra Babu Vallepu

Data Analyst

+91 8096858486 [email protected]

Resume

Hello, I am

Nagendra Babu Vallepu.

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

Welcome to my my world of data exploration and innovation! I’m Nagendra, a dedicated data analyst with expertise in Power BI, SQL, Excel, Python. Currently honing my skills at TCS, I am on a mission to bridge my role with the world of data analysis, seeking opportunities to translate complex data into impactful insights.

My toolkit is packed with Power BI's dynamic visualizations, SQL's powerful querying abilities, Excel's meticulous analytics and Python's algorithmic strength,. My approach goes beyond crunching numbers—it's about crafting compelling narratives from data that drive informed decision-making and strategic growth.

At TCS, I've developed a keen understanding of how data can revolutionize business processes and strategies. I’m passionate about using this experience to make a lasting contribution as a Data Analyst.

If you’re seeking a data analyst who blends technical skill with creative problem-solving, let’s embark on this data-driven journey together!

Key Skills

SQL

Tableau

Python

Dax Studio

Power BI

Advanced Excel

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Certified Data Scientist

Certified Data Scientist

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.

[email protected]

https://www.linkedin.com/in/nagendra-vallepu

+ 91 8096858486

https://github.com/nagendravallepu

Excel Project

AtliQ Hardware Sales and Finance Analysis

Crafted an advanced Excel-based sales analysis report for AtliQ Hardware, highlighting key sales trends and metrics from 2019 to 2021. Utilized Excel's advanced features for data visualization and analysis, providing actionable insights to enhance strategic decision-making.

View Project
Engagement

View Project
on GitHUB

AtliQ Hardware Sales and Finance Analysis

Analyzed AtliQ Hardware’s market performance for 2019–2021 using Excel. Highlighted discrepancies against 2021 targets, aiding strategic planning.

AtliQ Hardware Sales and Finance Analysis

Compiled sales data for AtliQ Hardware's top 10 products. Used advanced Excel to visualize performance metrics, revealing significant sales trends.

Project Details

For AtliQ Hardware, I developed an advanced Excel-based sales analysis report covering 2019 to 2021. The report integrates key metrics such as net sales by customer, market, and division. Leveraging Excel’s advanced features like pivot tables, charts, and conditional formatting, I visualized sales trends, growth rates, and performance against targets. The analysis identified critical sales drivers, highlighted underperforming segments, and offered actionable insights. This empowered AtliQ Hardware to refine their sales strategies, leading to better resource allocation and improved overall business performance. The report provided a clear view of significant growth in AQ product lines and regional sales discrepancies.

PowerBI Project

Business Insights 360: AtliQ Hardware

AtliQ Hardware encountered challenges managing extensive datasets in Excel. They transitioned to Power BI to enhance data comprehension and derive actionable insights in finance, sales, and supply chain. The project handled 1.8 million records using SQL, Power BI, Excel, and DAX Studio.

View Project
Engagement

View Project
on GitHUB

Business Insights 360: AtliQ Hardware

This is the main gateway of the dashboard, providing users with streamlined navigation to various analytical sections.

Business Insights 360: AtliQ Hardware

Data modeling encompassing more than 10 tables requires intricate structuring and integration to establish robust relationships and optimize data ret

Project Details

Here’s a refined version of the project description, keeping it under 900 characters:

This project integrates Power BI, SQL, and Excel to tackle operational inefficiencies at AtliQ Hardware, a global leader in consumer electronics. Previous heavy reliance on Excel led to regional losses. Senior management initiated a data analytics transformation using last year's data to drive strategic enhancements.

🔶 Finance View: Provides a profit and loss overview, tracking Gross Margin (GM), Net Profit (NP), Net Sales (NS), and performance trends.
🔶 Sales View: Analyzes customer and product performance, unit economics, NS, and GM%.
🔶 Marketing View: Evaluates region and product metrics based on NS and GM%.
🔶 Supply Chain View: Monitors forecast accuracy, net error, and trends by customer and product.
🔶 Executive View: Insights into competitor market share, revenue trends, and top 5 customers.

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics at AtliQ Hardware

Domain/Function: Finance & Supply Chain

This project used SQL to analyze AtliQ Hardware's datasets, transforming raw data into actionable insights to optimize sales, market dynamics, customer behaviors, and supply chain forecasting.

View Project
on GitHUB

Finance and Supply Chain Analytics at AtliQ Hardware

About AtliQ hardware and its Business Model.

Finance and Supply Chain Analytics at AtliQ Hardware

I created a report on the top 5 customers by net sales for FY 2021, using SQL for data extraction and visualized the results in millions.

Project Details

This project centered on leveraging SQL to analyze AtliQ Hardware's extensive datasets, aiming to derive actionable insights into crucial facets such as sales trends, market dynamics, customer behaviors, and supply chain forecasting. The initiative was driven by the need to overcome performance bottlenecks associated with large Excel files, employing MySQL to efficiently transform raw data into invaluable business intelligence.

Key achievements included optimizing sales strategies, identifying lucrative growth opportunities, and conducting comprehensive market trend analyses. These insights were instrumental in guiding strategic decisions and enhancing operational efficiencies.

Through this project, I not only honed my SQL proficiency and data analysis skills but also gained a deeper understanding of business analytics, empowering me to contribute meaningfully to organizational success through informed decision-making and impactful insights.

PowerBI Project

Comprehensive Analysis of India's EV Market: Trends, Insights, and Projections

Domain/Function: Automobile Market Analytics

A detailed analysis of India's EV market, covering sales trends, manufacturer performance, regional adoption, and future projections, designed to assist in strategic planning and market expansion.

View Project
Engagement

View Project
on GitHUB

Comprehensive Analysis of India's EV Market: Trends, Insights, and Projections

The homepage offers a snapshot of India's EV market, featuring sections on market overview, manufacturer performance, regional insights, seasonal tren

Comprehensive Analysis of India's EV Market: Trends, Insights, and Projections

This data model integrates sales, emissions, pricing, and state-wise performance data for electric vehicles, allowing analysis by maker, category, and

Project Details

🔶 Comprehensive analysis of India's rapidly growing electric vehicle (EV) market.
🔶 Data sourced from multiple channels focusing on key market trends.
🔶 Analysis includes quarterly and monthly sales, manufacturer performance, and regional EV adoption across states.
🔶 Identifies top-performing and underperforming EV manufacturers.
🔶 Provides projected sales and revenue to support strategic market penetration.
🔶 Key metrics analyzed include:
🔹Compound Annual Growth Rate (CAGR)
🔹Penetration rates
🔹EV-to-public charging station ratios
🔹CO2 savings
🔶 Highlights seasonal fluctuations in EV sales and adoption.
🔶 Offers future projections for EV adoption and growth by 2030.
🔶 Essential insights for companies planning expansion into the Indian EV market, driving optimal data-driven strategies for growth.

Project video

Live Interactive Dashboard