Project Details

Project Details
Our project aims to create a unified report catering to stakeholders from sales, marketing, finance, and the executive team. We prioritize robust data modeling, user-centric report design, and drillable insights for informed decision-making.
Here are some of the learnings in this project:-
📊 Importing Data from various sources
📊Using power query to perform basic and advanced operations.
📊Data modelling (Star and Snowflake Schema)
📊 Creating date table
📊 Choosing the right visuals and formatting
📊 Generating report measures using DAX
📊 Calculated columns using DAX
📊 Filter context in Power BI
📊 Report optimization
📊 Navigation Menus
📊 Bookmarks
📊 Dynamic Headings based on filters
📊 Power Bi services
📊 Creating a connection gateway and SharePoint for Excel

Live Interactive Dashboard

Project Details

Developed a comprehensive sales report utilizing Excel pivot tables. This tool empowers businesses to ascertain optimal customer discounts, negotiate effectively, and pinpoint expansion opportunities in promising markets. The generated reports offer actionable insights and recommendations, facilitating sales strategy optimization, heightened customer satisfaction, and revenue maximization.
Here are some of the learnings in this project:-
📊 Pivot table
📊 Power Query
📊Vlookup and Xlookup
📊 DAX (Basics)
📊 Conditional Formatting
📊Report Beautification
📊 Sales Domain Metrics
Embark on a journey to transform business sales dynamics! 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.

Project Details

Employed Power BI for an in-depth analysis of Shield Insurance. Explored revenue, customer behavior, city trends, sales modes, and age group dynamics. Generated a comprehensive report leading to strategic decisions and actionable recommendations.

Live Interactive Dashboard

Project Details

🎯 Objective:
Create a comprehensive sales dashboard for Blinkit to analyze key metrics and derive actionable insights for business decisions.

🛠️ Steps:
✅ Collected data from various reliable sources.
✅Loaded and cleaned data in Power BI by removing duplicates, handling ✅missing values, and adjusting data types.
✅Performed detailed analysis using DAX functions.

📊 Key Metrics:
🔸Total Sales: $1.20M
🔸 Average Sales: $141
🔸 Items Sold: 8,523
🔸 Customer Rating: 3.9

💡 Insights:
🔹 Low-fat items dominate sales at 64.6%.
🔹Top categories: Fruits & Vegetables and Snack Foods, each with $0.18M in sales.
🔹Stores from 2018 generate the highest revenue ($205K).
🔹Tier 3 cities and medium-sized stores lead in sales performance.

Live Interactive Dashboard

Project Details

Project Details
TaskList:
1.Developrelevantmetrics.
2.Designanintuitivedashboard.
3.Uncovervaluableinsights.

𝐌𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐨𝐧𝐞𝐬 𝐚𝐫𝐞 𝐠𝐢𝐯𝐞𝐧 𝐛𝐞𝐥𝐨𝐰 :
📌 RevPAR(Revenue generated per available room(booked as well as non booked))
📌Occupancy means how many rooms are occupied amongst all the available rooms.
📌ADR(Average Daily Rate) is the measure of average paid for rooms sold in a given time
📌DSRN(Daily Sellable Room Nights) This metrics tells us on an average how many rooms are ready to be sold for a day
📌DBRN(Daily Booked Room Nights) This metric tells us how many rooms are booked per night and also includes cancellation & no show measures
📌Cancellation means the customers who cancelled their bookings and got a refund of 40%
📌No Show means the customers who neither cancelled their bookings nor showed up
📌DURN(Daily Utilized Room Nights) This metric tells us how many rooms are utilized per night

Live Interactive Dashboard