Customer Behavior

By:

• Andrew Samy
• Renad Hamdy
• Mohamed Walid
• Mohamed Osama

🎯 Contributors

🍀 Sponsors

This project exists thanks to: information technology institute(ITI)

About the data

This is a behavior data set that contains about 9 million rows for two months (October and November 2019) from a medium cosmetics online store hosted by REES46 niche-specific personalization engine Platform.

Each row in the file represents an event. All events are related to products and users. Each event is like many_to-many relation between products and users. A session can have multiple purchase events if it's a single order.

File structure:

Property	Description
event_time	Time when the event happened (in UTC).
event_type	view - cart - remove_from_cart - purchase
product_id	ID of a product
category_id	Product's category ID
category_code	Description
Property	Product's category taxonomy (code name) if it was possible to make it. Usually present for meaningful categories and skipped for different kinds of accessories.
brand	Downcased string of brand name.
price	Float price of a product. Present.
user_id	Permanent user ID.
user_session	Temporary user's session ID. Same for each user's session. Is changed every time user comes back to the online store after a long pause.

Business Requirements:

• To what extent we are meeting our KPI’s?

• products to feature in the next campaigns and promotions

• Brand that the customer loyal to

• Who is the most valuable customers ?

• Is there any price trends !?

• How to increase the profit

• Activate the sleepy customers

• Percent of lost customers

• Design a system that helps the customer by suggesting products related to his cart Customized discounts

To fulfill the following Business Requirements, we will go through a series of:

• Data cleansing
• Data Transformation
• RFM analysis
• Power BI dashboards
• Design a recommendation engine using association analysis

Gallery:

...