Portfolio - Anjali kumari

PowerBI Project

Business Insights 360

Domain/Function: Finance, supply-chain

This Dashboard helped AtliQ hardware to Increase Net Sales By 10%.I did Date cleaning ,Data validation, Data modeling, Data transformation Utilised DAX querries and Build this insightful Dashbord .

View Project
Engagement

Other Tools

Excel

Sql

This is home page of our dashboard from where we can negivate to diffrent pages . it also conatins the support and info icon.

Executive View ccontains valuable insights such as top 5 customers by revenue and top 5 products by revenue and many more such informative visusal.

Project Details

AtliQ Hardware expanded their operatins to diffrent locations and countries. But their Net sales was negative Because desicions made by the company were not data driven, they mainly rely upon intutions and excel sheets which do not provide any meaningful insight. I designed this Dashbord which helped the company to increase the net sales by 10 %.

Project video

Live Interactive Dashboard

SQL Project

Pizza Sales Analysis

Pizza sales analysis using SQL helped to understand the sales of pizza, Market Conditon and coustomer behaviour and Helped the business to grow.Data was loaded from excel sheets to Mysql Data base

View Project
on GitHUB

SQL querry showing Total sales of Pizza

SQL Querry performed to show most orderd pizza and its size

Project Details

Gathered Data and then cleaned it using Excel and pulled it in to SQl database for performing certain querries such as most orderd pizza, Top Customers Total sales etc .Pizza sales analysis using SQL, Helped to Extract valuable insight from raw data set and increase the pizza Sales. Data was in 5 Excel sheets which were pulled to the data base.

PowerBI Project

Hospitality Domain

I Created the metrics according to the metric list and then using metrics i created a visually appealinng dashboard according to the mock-up provided by stakeholders.Create relevant insights which helped the Atliq Grands to improve their Business in a highly competetive market

It empowered stakeholders with actionable insights, and provided meaningful insights.

This shows the thumbnail created for this project.

Project Details

Dashboard Development for AtliQ Grands
I undertook the initiative to develop and implement a comprehensive business dashboard aimed at enhancing decision-making processes and overall business performance. This project leveraged data-driven insights to provide actionable recommendations and improve operational efficiency across various facets of Atliq Grands' business operations.
The implementation of the dashboard resulted in several tangible benefits for Atliq Grands:

Improved Decision-Making: Enabled stakeholders to make informed decisions quickly based on real-time data.
Operational Efficiency: Identified inefficiencies and areas for improvement, leading to optimized resource allocation and cost savings.
Business Growth: Uncovered new market opportunities and optimized sales strategies, resulting in increased revenue and market share.
Customer Satisfaction: Enhanced customer satisfaction through better understanding of customer preferences and needs.

Hello, I am

Anjali kumari

2

1

About

Key

My

Business Insights 360

Pizza Sales Analysis

Hospitality Domain

Awards

Contact Me

Email

Github

Linkedin

Call

Anjali kumari

Download Resume