Who am I?

My name is Serhan Bayram. I graduated from Bilkent University Industrial Engineering Department in 2016. Currently I am working as Business Intelligence Analyst at ModaCruz, an e-commerce company, mostly focused on second-hand. My main responsibilities are:

My data interests started in my university years. My major is mostly related with data, and I saw the power and the future of the data. Also, in one of my internships I had a chance to get involved with data analysis and data visualization. After that internship I decided to improve myself in this field.

I am planning to use my data science skills to offer more personalized experience to our users in order to increase revenue and retention.

My Linkedin profile

useR! 2020 - metashiny: build Shiny apps with a Shiny app

In this session a useful package named metashiny is described. This package helps users to create Shiny apps very easily. Actually its best part is that, in order to create a Shiny app with metashiny, you do not need to have any coding skills. This package has an point and click interface, which allows the users to create an app by selecting some variables. In the video it is mentioned that this package is currently in development process. For the future, Package Dependencies, Drag and Drop interface and Platform-agnostic Deployment are planned developments.

Video Link

R Post #1 - Association Rule Mining – The Apriori Algorithm

In this article, the main purpose is to identify item pairs which are more likely to be purchased together. Thus, we can offer specific products to our customers by checking their shopping carts or redesign our store. To do this, a transaction dataset is used and three measures of association is defined, support, confidence and lift.

Support is the number of transactions which an item or an itemset is bought. Confidence is the measurement of likelihood that an itemset is purchased when another itemset is purchased. Lift measure is to control the popularity of items in order to prevent randomness. After all measures are set, Brute Force Rule Mining method is applied. However, there to many possiblities in this method and it is computationally infeasible. Therefore, in order to eliminate some options Apriori Algrorith is used.

This algorithm combines itemset and check whether there are not less than minimum Support point and works until there is no itemset which is less than minimum support. In the end, we receive our itemset and use it in order to increase our sales.

Article Link

R Post #2 - Estimating individual Customer Lifetime Values with R

Estimating a customer’s lifetime value (CLV) is very beneficial for a company. If we know (or estimate accurately) every customers’ value, we can classify them. We would know which customer will bring us more profit or which customer is more likely to be loyal. This way, we can choose more efficient ways to reach our customers and optimize our marketing spendings. We can try to activate our customers with different methods. Also, by aggregating every customers’ lifetime value, we can see the performance of our decisions. Let’s say, decreasing values is probably a signal of unsuccessful loyalty program.

In order to calculate CLV by considering multiple variables, we can use The CLVTools Package. This package, combines customers churn behavior with customers purchase behavior. It has several types of settings for different customers segments and businesses. Users can select the setting which fits to their needs.

This package takes transactional data as input, which are Unique Customer Id, Order Date and Price. Also, time-varying factor can be added to a model. After giving the inputs the package estimates the parameters and predicts CLVs for each customer.

Video Link

R Post #3 - Customer Segmentation and Strategy using RFM Analysis in RStudio

In this article an RFM analysis is explained by using R. RFM analysis is based on three metrics which are Recency, the recency of last order (R), Frequency, how many times a user made order (F) and Monetary, how much a user spent (M). Based on the quartiles of each metric, every user is represented by an RFM score. Based on their score, each user is assigned to different segments. Each segment represent the customers current status. For instance in Can’t Lose segment the RFM scores are 134, 143, 144, 234, 242, 243, 244 which tells us that these customers were good buyers in the past but recently they did not make any purchases. Therefore, special actions for them would make them buy new products from us. This method allows us to make efficient and segment specific marketing campaigns and increase customer retention.

Article Link

Back to my Progress Journal.