Data Science

Customer Behavior Analysis

Lee Trawick, Associate Actuary

LeeTrawick@gmail.com

Data Science

// methodology

STEP 1

STEP 5

STEP 3

I loaded 5 flat csv files into Microsoft SQL server

I summarized my findings into a presentation

I built a predictive model using Python and XGBoost

STEP 4

STEP 2

I analysed the data for key insights

I built a Tableau Dashboard fed by the new database.

//average visit time

08

This chart shows the average time a customer spent inside a store. Keep in mind that the customer visit time is a left skewed distribution because most people are going to spend less than 3 minutes in the store. This will bring down the average. On average, only 20% of customers will stay in a store for more than 15 minutes.

//introduction

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.