Portfolio - Bhavani Bhisetti

PowerBI Project

CodeX Marketing Insights

CodeX, a German beverage company, introduced its energy drink in 10 Indian cities to enter the market. They surveyed 10,000 people to understand what consumers think and want. The goal is to make more people aware of the brand, sell more drinks, and improve the product based on feedback.

View Project
on GitHUB

Most respondents were young, aged 19-30, and 60% were male. Marketing ads are the best way to reach people.Youth drink energy drink 2-3 times a week.

In Bangalore, young adults (60% male) drink CodeX 2-3 times weekly, choosing it for reduced sugar. Despite positive views in Chennai, Ahmedabad showed

Project Details

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India.
Their Marketing team is responsible for increasing brand awareness, market share, and product development. They conducted a survey in those 10 cities and received results from 10k respondents.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

AtliQ Hardwares is rapidly expanding in electronics but is lagging due to its dependence on Excel for reports. My goal is to implement an intelligent data system with Power BI to enhance the company's understanding and support better decision-making for the future.

View Project
on GitHUB

The data modeling process incorporated a total of 10 tables.

Sales View provides a detailed look at sales performance, making it easy to spot the best-selling products and top customers.

Project Details

Finance View: Track all financial details, including revenue and expenses.
Sales View: Identify top-performing products and customers.
Marketing View: Analyze the effectiveness of marketing strategies.
Supply Chain View: Ensure sufficient product availability and efficiency.
Executive View: Provide executives with insights on top products, key customers, and overall performance.

Live Interactive Dashboard

Excel Project

Awesome Chocolate Project

Examine the sales trends of Awesome Chocolates over the past year to support business analysis.In this Excel project, I used Power Pivot, data modelling, custom formats, conditional formatting, sparklines, charts, data validation, and slicers for an interactive dashboard.

View Project
on GitHUB

This dashboard shows which team has the highest sales and profit, as well as geographical and product performance.

This sheet contains pivot tables that were used to prepare the dashboard.

Project Details

The dashboard contains business summary, geographical performance, team and people performance and product performance.

Process Followed

1. Reading data for better Understanding.
2. Data Cleaning it as required.
3. Data Modelling to connect relationships between tables
4.Data Analysis with the help of Pivot Tables

Learning from project:

1.Utilized Power Pivot to handle large data sets efficiently.
2.Created a data model to organize and relate different data sources.
3.Applied custom formats and conditional formatting for better data visualization.
4.Implemented sparklines and charts to illustrate data trends clearly.
5.Used data validation and slicers to make the dashboard fully interactive.

PowerBI Project

Shield Insurance Project

The Shield Insurance Project aims to analyze our customer base and revenue streams to gain insights and improve business strategies. Separate pages will be created for sales mode and age group analysis to better understand customer demographics and preferences.

View Project
on GitHUB

Relationship between the tables

sales view shows total customers and total revenue by sales mode as well as month-wise revenue by sales mode.

Project Details

About Company : Shield Insurance provides 9 different policies. This company have branches in 5 major cities and have 4 different sales mode categories those are offline agent,offline direct,online app and online website.Company has shared data set from November 2022 to April 2023.The age group of customers are from 18 to 90.

Task List : This report is in 3 parts
1) General View : Consolidated demographic summary
2) Sales Performance : Contains Sales view
3) Age Group : Age -wise sales performance

Learning Points:
1) Power Query for data cleaning
2) Created custom columns as required
3) Effective data modelling techniques
4) Implemented page navigation
5) Switched between graphs using buttons

key measures are :

Total customers , total revenue, and daily growth rates for both customer and revenue.
Monthly policy changes will be tracked to spot trends. Customers will be grouped by age, and analyzed revenue and customer counts by city ,age group and settlement %.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

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

View Project
on GitHUB

Get the products that have the highest and lowest manufacturing costs

Shows which channel has highest gross sales in fiscal year 2021 and percentage of contribution.

Project Details

Fiscal Years:
FY 2020: September 2019 - August 2020
FY 2021: September 2020 - August 2021

Project Objective:
Our task involves addressing 10 Ad-hoc Requests from management using SQL queries and transforming the results into insightful visualizations. We will present actionable insights to Top-Level Management based on our data analysis.

Hello, I am

Bhavani Bhisetti

1

3

1

About

Key

My

CodeX Marketing Insights

Business Insights 360

Awesome Chocolate Project

Shield Insurance Project

Consumer Goods Ad-hoc Insights

Awards

Contact Me

Email

Github

Linkedin

Call

Bhavani Bhisetti

Download Resume