The objective of this project is to develop a BI system that evaluates pricing strategies and discount effectiveness across products. The platform will help businesses understand pricing impact on revenue and customer behavior.
Collect pricing, discount, and sales datasets.
Clean and normalize pricing-related data.
Design a dimensional data warehouse for pricing analytics.
Integrate data using ETL workflows.
Develop dashboards showing revenue before and after discounts.
Analyze price sensitivity across product categories.
Identify optimal discount ranges.
Compare seasonal pricing strategies.
Create drill-down views for product-level analysis.
Validate insights using historical sales trends.
Document recommendations for pricing optimization.
