Portfolio - Vaddireddy Naga Sai Lakshmi Prasanna

Excel Project

Sales Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

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 which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.
I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics
Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

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

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

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

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Telengana Growth Analysis

Empowering the Telangana government with comprehensive information to make informed decisions and effectively navigate intricate challenges, thus promoting sustainable development across diverse domains.

View Project
Engagement

Stamp Regristration Analysis

Transportation Analysis

Project Details

This initiative strives to systematically recognize and prioritize the socio-economic, infrastructural, and environmental challenges facing Telangana. Through the formulation of data-driven strategies and the cultivation of collaborative partnerships, the project endeavors to provide actionable recommendations in harmony with the state's developmental vision. Ultimately, the goal is to equip the Telangana government with the tools to make informed decisions and adeptly tackle multifaceted issues, thereby promoting sustainable development.

Project video

Live Interactive Dashboard

PowerBI Project

Shield Insurance Analysis

The Shield Insurance Analysis Report showcases the impactful role of data-driven decision-making in revolutionizing the insurance sector. Through a comprehensive overview and interactive visuals, the report delivers actionable insights that have the potential to reshape the industry landscape.

View Project
Engagement

Home Page:Basic Overview regarding shield insurance analysis

It shows Total customers,total revenue,daily revenue Growth %,and daily customers growth as key metrix

Project Details

About Shield Insurance:
Delivering top-notch insurance services across diverse Indian cities to meet varied customer needs.
🔍 Key Highlights:
Dive into the analytics with three dynamic views tailored for different needs:
1️⃣ General View:
Uncover essential KPIs empowering executives with in-depth insights for strategic decision-making.
2️⃣ Sales View:
Revolutionizing revenue tracking, comparing sales modes, and enhancing the sales team's efficiency.
3️⃣ Age Group View:
Unlock trends and preferences specific to age groups in policies and settlements, providing a holistic understanding.

Project video

Live Interactive Dashboard

PowerBI Project

Mitron Bank Credit Card Strategy Analysis

Mitron Bank's credit card strategy, guided by data-driven insights. Mitron Bank, a distinguished financial institution headquartered in Hyderabad, has set its sights on expanding its product offerings and market reach through the introduction of a new line of credit cards.

View Project
Engagement

Mitron Bank Credit Card Strategy Analysis

Demographic Analysis

Income utilization Analysis

Project Details

Mitron Bank has teamed up with AtliQ Data Services, a reputable entity with a proven track record in data analytics and strategy implementation. The collaboration was initiated following an internal link that unveiled an opportunity for strategic enhancement. However, recognizing the significance of precision in this endeavor, Mr. Bashnir Rover, Strategy Director at Mitron Bank, wisely proposed a pilot project. This initial phase involves a meticulous analysis of a sample dataset comprising 4000 customers across five cities, offering a microcosm of insights into online spend and related details.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Mart Promotion Analysis - Diwali 2023 & Sankranti 2024

Analyzed promotional performance for AtliQ Mart, revealing insights through Power BI dashboards. Explored store, promotion type, and product/category data, leading to actionable recommendations. Acknowledged by the Sales Director for strategic contributions

View Project
Engagement

AtliQ Mart Promotion Analysis - Diwali 2023 & Sankranti 2024

Home Page

Campaign Analysis

Project Details

Led a comprehensive analysis of promotional strategies at AtliQ Mart, a major retail player, aimed at optimizing sales performance. Leveraged Power BI to create interactive dashboards, offering a deep dive into store performance, promotion types, product categories, and campaign effectiveness during Diwali 2023 and Sankranti 2024

Hello, I am

Vaddireddy Naga Sai Lakshmi Prasanna

1

5

About

Key

My

Sales Analytics

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

Telengana Growth Analysis

Shield Insurance Analysis

Mitron Bank Credit Card Strategy Analysis

AtliQ Mart Promotion Analysis - Diwali 2023 & Sankranti 2024

Awards

Contact Me

Email

Github

Linkedin

Call

Vaddireddy Naga Sai Lakshmi Prasanna

Download Resume