E-commerce Business Intelligence & Customer

E-commerce Business Intelligence & Customer Behavior Dashboard Developed an E-commerce Business Intelligence solution to analyze customer behavior, purchasing patterns, sales performance, and user engagement.

The analysis covered a large dataset containing:

100,000+ Users

124,923 Orders

1,048,575 Events

Key Analysis Areas:

Customer Acquisition and Engagement

Customer Retention and Repeat Purchases

Sales and Order Performance

Customer Behavior Analysis

User Session Data Quality

E-commerce Funnel Analysis

Key Findings:

Approximately 69.1% of user session records contained NULL user identifiers.

Repeat customers represented approximately 37.5% of buyers.

Repeat customers contributed approximately 60.1% of total sales.

Tools & Technologies: SQL, BigQuery, Power BI, DAX, Data Modeling, Business Intelligence.