Portfolio - Vemula Sindhu Sri

Excel Project

Sales and Finance Report

The sales report dives deep into AtliQ Hardwares' product sales, checking how well they're doing in each country, each year, and across different divisions. It also looks into how new products are selling in a particular year. The financial report tells us how AtliQ Hardwares is doing financially.

View Project
Engagement

Market Performance compared to Target: Allows stakeholders to evaluate the country's performance and compare it against established targets.

Customer Performance Summary: Presents the net sales performance of individual customers over multiple years.

Project Details

This report helps us look at how AtliQ Hardwares is doing financially when selling hardware to customers. It helps us see:
Sales reports for each division.
The best and worst performing products.
Gross Margin % analysis for Quarters in Subzone.
P & L analysis for each market.
This report doesn't just show numbers; it gives us useful tips to make our sales better. We also look at how much money we're making after expenses. This helps us make smart decisions to keep the company strong.

Project video

PowerBI Project

Business Insights 360

AtliQ Hardwares is a fast-growing electronics company, but it's falling behind competitors who use data better. Most of their reports are still in Excel. My mission is to bring in an advanced analytics solution using Power BI. My mission is to bring in an advanced analytics solution using Power BI.

View Project
Engagement

User-empathetic Home page as a part of dashboard design.

Data modelling involving 10+ tables

Project Details

AtliQ Hardware, a worldwide manufacturer, assigned us to extract insights . Created reports and dashboards to help make data-driven decisions in various business areas including Finance, Sales, Marketing, Supply Chain, and Executive.

Data Discovery & Integration:
Gathered over 1.8 million records from different sources like Excel, CSV, and MySQL, bringing them together in Power BI for in-depth analysis.

Data Magic (ETL - Extract, Transform, Load):
Used Power Query to work wonders with data, making extraction, transformation, and loading smooth and efficient.

Data Modeling & Insights:
Used DAX to create clever calculated columns and measurements.

Create reports:
Created custom-made reports like Finance's P&L, the Sales Performance Matrix, Marketing's NP% and GM%, Supply Chain's Forecast Accuracy, and Executives' Market Share Trend.

Creating Dashboards:
Made a cool dashboard in Power BI that shows everything different parts of AtliQ Hardware want to see.

Project video

Live Interactive Dashboard

PowerBI Project

IPL Analysis - Codebasics Resume Challenge 10

This project is all about diving into the last three IPL seasons using the given datasets. It's a challenge hosted by Codebasics, giving me a chance to showcase my love for analytics and my skills.

View Project
Engagement

IPL Analysis - Codebasics Resume Challenge 10

Describes about the primary insights of the project.

Project Details

Problem Statement: "Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Insights - Codebasics Resume Challenge 4

Presenting the Adhoc - Insights of Consumer Goods for Atliq hardware company. The tools used are SQL , PowerBI , Power Point Presentation. This Project helps to enhance our skills In SQL.

View Project
Engagement

View Project
on GitHUB

Consumer Goods Insights - Codebasics Resume Challenge 4

Provided the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

Provided a report with all the unique product counts for each segment and sort them in descending order of product counts.

Project Details

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions.
They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills.
Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

Project video

PowerBI Project

Codex Marketing Insights - Resume Challenge 6

CodeX, a prominent German beverage company, is launching their energy drink in 10 Indian cities to boost brand awareness, market share, and product development.

View Project
Engagement

View Project
on GitHUB

Codex Marketing Insights - Resume Challenge 6

Home page Overview

Presenting demographic insights

Project Details

CodeX, a renowned German beverage company, is set to make a significant impact in the Indian market. After launching their energy drink in 10 Indian cities, the Marketing team aims to boost brand awareness, market share, and product development. Peter Pandey, our marketing data analyst, is leveraging survey data to derive actionable insights. Utilized Power BI for data analysis and visualization.

Hello, I am

Vemula Sindhu Sri

1

3

1

About

Key

My

Sales and Finance Report

Business Insights 360

IPL Analysis - Codebasics Resume Challenge 10

Consumer Goods Insights - Codebasics Resume Challenge 4

Codex Marketing Insights - Resume Challenge 6

Awards

Contact Me

Email

Linkedin

Call

Vemula Sindhu Sri

Download Resume