Blinkit Marketing And Customer Feedback Dashboard
A Dynamic Dashboard in PowerBi About Marketing and Customer Feedback of Blinkit
@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord
A Dynamic Dashboard in PowerBi About Marketing and Customer Feedback of Blinkit
@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord
Dataset Overview:
Contains sales data from Blinkit, including product details, order quantities, revenue, and timestamps.
Useful for demand forecasting, price optimization, trend analysis, and business insights.
Helps in understanding customer behavior and seasonal variations in online grocery shopping.
Potential Use Cases:
CREATE TABLE blinkit_customer_feedback (
"feedback_id" BIGINT,
"order_id" BIGINT,
"customer_id" BIGINT,
"rating" BIGINT,
"feedback_text" VARCHAR,
"feedback_category" VARCHAR,
"sentiment" VARCHAR,
"feedback_date" TIMESTAMP
);
CREATE TABLE blinkit_customers (
"customer_id" BIGINT,
"customer_name" VARCHAR,
"email" VARCHAR,
"phone" BIGINT,
"address" VARCHAR,
"area" VARCHAR,
"pincode" BIGINT,
"registration_date" TIMESTAMP,
"customer_segment" VARCHAR,
"total_orders" BIGINT,
"avg_order_value" DOUBLE
);
CREATE TABLE blinkit_marketing_performance (
"campaign_id" BIGINT,
"campaign_name" VARCHAR,
"date" TIMESTAMP,
"target_audience" VARCHAR,
"channel" VARCHAR,
"impressions" BIGINT,
"clicks" BIGINT,
"conversions" BIGINT,
"spend" DOUBLE,
"revenue_generated" DOUBLE,
"roas" DOUBLE
);
CREATE TABLE blinkit_order_items (
"order_id" BIGINT,
"product_id" BIGINT,
"quantity" BIGINT,
"unit_price" DOUBLE
);
CREATE TABLE blinkit_orders (
"order_id" BIGINT,
"customer_id" BIGINT,
"order_date" TIMESTAMP,
"promised_delivery_time" TIMESTAMP,
"actual_delivery_time" TIMESTAMP,
"delivery_status" VARCHAR,
"order_total" DOUBLE,
"payment_method" VARCHAR,
"delivery_partner_id" BIGINT,
"store_id" BIGINT
);
CREATE TABLE blinkit_products (
"product_id" BIGINT,
"product_name" VARCHAR,
"category" VARCHAR,
"brand" VARCHAR,
"price" DOUBLE,
"mrp" DOUBLE,
"margin_percentage" DOUBLE,
"shelf_life_days" BIGINT,
"min_stock_level" BIGINT,
"max_stock_level" BIGINT
);
Anyone who has the link will be able to view this.