Portfolio - Venkamsetty Venkata Sai Naveen

Excel Project

Sales and Finance Analytics(FMCG)

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with data-driven strategies for growth and expansion. Acquired proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design.

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 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

Business Insights 360 is a powerful dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide AtliQ Hardware with valuable insights into their different departments such as Finance, Sales, Marketing and Supply Chain.

View Project
Engagement

View Project
on GitHUB

Welcome to Business Insights 360! Navigate finance, sales, marketing, supply chain, and executive views with real-time data freshness.

Strategic dashboard for high-level insights, performance summaries, and critical KPIs to guide top-level decision-making.

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

SQL Project

AdHoc Analysis: Consumer Goods Domain

AtliQ Hardware, a fictional company, is a major computer hardware maker in India and abroad. Yet, they lack quick insights for smart decisions. So, a SQL challenge is on the horizon to fill this data gap.

View Project
Engagement

View Project
on GitHUB

AtliQ Exclusive's marketing countries in APAC region

SQL query for the monthly sales amount report for the customer 'ATLIQ EXCLUSIVE'

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Python Project

Hotel Domain Analysis Using Python

AtliQ Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower AtliQ Grands with insights for customer retention and revenue growth.

View Project
Engagement

View Project
on GitHUB

Crafted average rating per city and pie chart of revenue per booking platform.

Crafted a table of average occupancy rate per city.

Project Details

In this project , I performed the following operations to get insights.
1. Data Cleaning- Handling missing values and outliers.
2. Data Transformation - Added occupancy% columns.
3. Insights generation-key questions answered
#calculating average occupaancy rate by room type and city.
# Identifying occupancy rate on weekdays and weekends.
# Analyzing revenue generated per city.
# Analyzing monthly revenue trends.
# Assessing revenue by booking platforms.

Hello, I am

Venkamsetty Venkata Sai Naveen

1

1

1

1

About

Key

My

Sales and Finance Analytics(FMCG)

Business Insights 360

AdHoc Analysis: Consumer Goods Domain

Hotel Domain Analysis Using Python

Contact Me

Email

Github

Linkedin

Call

Venkamsetty Venkata Sai Naveen

Download Resume