✅Social Media Analysis – May 2025 (﹙˓ 📶 ˒﹚)

🧭 Purpose of the Dashboard

To enable marketers, analysts, and business decision-makers to track, analyze, and optimize the performance of social media content and campaigns using real-time KPI visualizations and trend analysis

❇️KPI's (Key Performance Indicator) Requirements 📊

💡Important KPIs :

KPI Name Field Formula Insight Gained

(1.) Total Reach : SUM(Reach) - Audience size

(2.) Total Engagements : SUM(Engagements) - Interaction level

(3.) Total Impressions : SUM(Impressions) - Content visibility

(4.) Total Followers : SUM(Followers_Gained) - Growth measurement

(5.) Avg. CTR (%) : AVERAGE(Click_Through_Rate (%)) - Link performance

❇️Chart's Requirements 📶

1️⃣ Total Reach Per Platform

📶 Chart Type : Clustered Column Chart.
🎯 Purpose : Compare audience size per platform.
💹 Axis : Platform
🧮 Values : Total Reach(Sum)

2️⃣ Average CTR By Platform

📶Chart Type : Bar Chart
💹 Axis : Platform
🧮 Values : Click_Through_Rate (%) (Average)
🎯 Purpose : Discover which platform drives more clicks

3️⃣ Engagements By Post Type

📶Chart Type : Stacked Column
💹 Axis : Post_Type
🧮 Values : Engagements
🗃️Legend : Platform
🎯 Purpose : Assess content format effectiveness

4️⃣ Post-Level Breakdown

𝄜 Chart Type : Table
ᯓ★ Columns : Post_ID, Platform, Post_Type, Reach, Engagements, CTR, Followers_Gained
🎯 Purpose : Detailed analysis

5️⃣ Add Slicers

📶Chart Type : Add Slicers for dynamic filtering:

🚉 Platform

6️⃣ Engagements by Post Type

📶Chart Type : Ribbon Chart
💹 Axis : Platform
🧮 Values : Total Likes, Comment,and Shares.
🗽 Legend : Platform
🎯 Purpose : Assess content format effectiveness

✅Social Media Analysis – May 2025 Power BI Dashboard

[Social Media Analysis Dashboard](Social Media Analysis Dashboard.pdf)

Blinkit Grocery Analysis

✅Blinkit Analysis 🛒

❇️Business Requirements

To conduct a comprehensive analysis of Blinkit's sales Performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs and visualizations in Power BI.

❇️KPI's (Key Performance Indicator) Requirements 📊

(A). Total Sales : The Overall revenue generated from all items sold.

(B). Average Sales : The Average revenue per sale.

(C). Number of Items : The total count of different items sold.

(D). Average Rating : The Average customer rating for items sold.

❇️Chart's Requirements 📶

1️⃣ Total Sales by Fat Content

🎯 Objective : Analyze the impact of fat content on total sales.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Donut Chart.

2️⃣ Total Sales by Item Type

🎯 Objective : Identify the performance of different item types in terms of total sales.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Bar Chart.

3️⃣ Fat Content Outlet for Total Sales

🎯 Objective : Compare total sales across different outlets segmented by fat content.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Stacked Column Chart.

4️⃣ Total Sales by Outlet Establishment

🎯 Objective : Evaluate how the age or type of outlet establishment influence total sales.
📶Chart Type : Line Chart.

5️⃣ Sales by Outlet Size

🎯 Objective : Analyze the correaltion between outlet size and total sales.
📶Chart Type : Donut/Pie Chart.

6️⃣ Sales by Outlet Location

🎯 Objective : Assess the Geographic distribution of Sales across different locations.
📶Chart Type : Funnel Map.

7️⃣ All Metrics by Outlet Type

🎯 Objective : Provide a comprehensive view of all key metrics(Total Sales, Number of Items, Average of Sales, Average of Rating) broken down by different Outlet types.
📶Chart Type : Matrix Card.

✅Blinkit Grocery Online Platform Power BI Dashboard

Blinkit Dashboard.pdf

Git_Hub Profile