Portfolio - Mounika Palli

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The Customer Performance Report displays the yearly net sales performance for each customer.

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

PowerBI Project

AtliQ- Business Insights--360

AtliQ Hardware is a rapidly growing consumer electronics goods company. This company is facing challenges in its Data Analysis practices as it relies on Excel files. So to overcome challenges they decided to onboard a Data analyst team and assign them a 360 project to know 360 degrees of company.

View Project
Engagement

View Project
on GitHUB

Landing Page which helps the users to navigate different views in the dashboard.

Executive View consolidating top insights from all dimensions of the business.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statements like GM, NP, NS, etc., and performance over time chart w.r.t to key metrics.
📣Sales View: Shows customers and product performance, unit economics, and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance, unit economics, and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends, and key metrics by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends, revenue by division and channel, top 5 customer

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

The primary objective was to provide valuable insights to the company through a SQL challenge, addressing the need for quick decision-making in their expanding data analytics team.

View Project
Engagement

View Project
on GitHUB

A sample of Ad-Hoc requests was solved along with the insights and visuals.

Project Details

Atliq Hardware - Ad_hoc Insights
(Consumer Goods Domain)

Tools Used:
SQL:
For querying and retrieving insights
Topics Involved:
Joins
Subqueries
Common Table Expressions (CTE)
Window Functions

PowerBI:
Created Visualizations
Creating measures and Custom columns
Using various types of visuals

Python Project

Hotel Domain Analysis

Objective: Atliq Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. I aim 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

Data Exploration, Data cleaning using Pandas

Analyzed data through Visualizations

Project Details

Here's a rundown of what I've been up to:
Data Understanding
Data Exploration
Data Cleaning
Data Transformation
Insights Generation

Skills Acquired: Mastering Python, Pandas fundamental, Matplotlib etc. for comprehensive data analysis and visualization, translating insights into actionable strategies!

PowerBI Project

Shield Insurance

As part of my virtual internship at Codebasics, I worked on analyzing data and creating a dashboard for Shield Insurance(an imaginary company). Objective: To help Shield Insurance make better decisions by analyzing data from November 2022 to April 2023.

View Project
Engagement

View Project
on GitHUB

General View to display KPIs and major insights into the business.

Sales Mode Analysis to show Total customers by sales mode, Total revenue by sales mode, and sales mode by month.

Project Details

Objective: To help Shield Insurance make better decisions by analyzing data from November 2022 to April 2023.
Task: To create a dashboard that shows all the insights required by the company.
Datasets Used:
Dim customer
Dim Policies
Dim Date
Fact premiums
Fact Settlements
Tools Used: Microsoft Power BI, Microsoft Powerpoint
Here are the main findings:
Delhi NCR had the highest revenue and the most customers compared to other cities.
More than half of the customers prefer offline agents.
The most popular policy, POL4321HEL, offers a coverage amount of 2 lakh and is the cheapest among all policies.
The age groups 31-40 and 41-50 have the most customers.
Offline agent sales are decreasing while online sales are increasing.
Although the settlement percentage is higher for the 65+ age group, the age group 31-40 has the highest expected settlement.
The age group 31-40 has the highest number of customers, which is 11k.

Hello, I am

Mounika Palli

1

2

1

1

About

Key

My

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

AtliQ- Business Insights--360

Consumer Goods Ad-hoc Insights

Hotel Domain Analysis

Shield Insurance

Awards

Contact Me

Email

Github

Linkedin

Call

Mounika Palli

Download Resume