Accidental Genius

genius, badge

What’s up ? This is THE stephane ANDRE !!! I heard Olivier Roland’s tips and I learned some good stuff.

There is an interesting book by Mark Levy named Accidental Genius . This book explains a method to unleash your creativity and brain’s power to find solutions to your problems.

This book doesn’t speak to the fact that supposedly we use only 10% of our brain but rather that we underestimate an important thing, write what we think. When we think without written support, we deprive ourselves of an enormous source of structuring thoughts. Our thoughts go further and more structured when we think in writing than when we think in our head and we forget those thoughts very quickly.

Unfortunately, there is a difficulty. It’s that we write very slow compared to the speed we think. But Mark Levy has a method to overcome this difficulty, it’s free writing.

Free writing

write, pen, free, writing

Choose a problem that takes your head, take a piece of paper or open a document on your computer and start writing all that happens in your head.

For exemple, if you wan to start a company, the problem can be : « how can I start a profitable company as soon as possible ? ». Like a brainstorming, you write a maximum of idea in a minimum of time. To ease this process, ,you write without paying attention to grammar, vocabulary, syntax, punctuation, etc. You write with lots of mistakes to make it fluid. Anyway, you don’t write for someone, you write for yourself so you can let go, write whatever you want.

When you have a moment where you block, keep writing. You can write 40 times the same word, it doesn’t matter. As you continue to write, you will force your brain to find other ideas and to return to the flow of thoughts. It’s advisable to do this for 10 minutes.

I tested this method and it’s surprising but I have to use it more often to develop this skill. What I like with this method is that I can use it for all areas of my life and it takes 10 minutes in the day.

My question is, are you also going to test this method or are you one of the people who reads my blog to make yourself feel good ? What are you doing ?

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here .

Emotionally Manage Negative Reviews

emotionally, manage, negative reviews, excellent, good, average, poor, worst

What’s up ? This is THE stephane ANDRE !!! I watched an Olivier Roland’s video and I learned some good stuff.

When we have company, we read customer reviews to improve the products/services. But we have a way of thinking that can hinder the company’s evolution. Here is an example, for a product the are 10 positive reviews and 1 negative review. The problem is that the entrepreneurs will think 1000 times more about the negative review rather than 10 reviews positive.

Bad comment

emotionally, manage, negative reviews

To change this way of thinkging, it’s necessary to understand that this is part of human nature. We have been educated by evolution to focus more on negative things than positive things. And yes, our ancestors lived in an unstable environment during the vast majority of the existence of the human being. Here are some examples :

  1. Our ancestors were very attentive to the elements that were partially negative. They could be very happy, have a great day but they had to pay attention to the powerful animals that could, by surprise, kill them.
  2. Our ancestors had to pay attention to the disputes that had in the village because these disputes could deteriorate the village’s stability. This can result in creating friction that undermines trust in terms of collaboration for survival.
  3. Our ancestors were never satisfied with their situation and this motivated them to improve their lifestyle through science.

Solution

emotionally, manage, negative reviews, positive

As you’ve seen, this is a way of thinking that we have in human nature and there are some tips to avoid being obsessed with these negative reviews. I propose 3 solutions :

  • Ignore them. The more negative reviews you see, the more you’ll be desensitized to that. It’s not very complicated because if your company is working well, you have few negative reviews.
  • Delegate the management of reviews to a member in your company. This allows you to avoid being on the front line in the emotional impact to be less affected. It’s true, this solution have a problem. It creates distance between the entrepreneur and the customers feedbacks. It’s for this reason that it’s recommended to set up a procedure for the member who handles the reviews saying : « From now on, it’s you who manages the reviews. The thing I would like you to do is that you only transfer negative constructive reviews to me ». Negative constructive reviews are the criticisms where you see the urge to help.
  • Create an email address only for positive reviews. For example, you can name this email : « positivereviews@yourCompanyName.com » and tell to the person who manages the reviews that each time he/she receive a positive reviews, he/she send it to this email. You can also tell to this person to make a screenshot of a positive review from social media and send it to this email.

With this email address, you create the email of happiness. This will be useful for moments of demotivation and doubt. If, for example, there is an negative reviews that makes you feel bad and you think about it several hours later, you can log on this email, read positive reviews and realize that you’re doing a good job. It’s really a special feeling to know that you’re changing the lives of many people. It’s really fantastic and it allows you to relativize.

It’s possible to make a combination of the 3 solutions. It means, you force yourself to read the negative reviews to desensitize you ; you delelgate part of the process to manage the reviews ; you create a magical email as a psychological support.

These solutions allow you to put things in their place so that you don’t get overwhelmed by negative emotions.

It’s possible that you know of other methods to handle negative reviews, if it’s true, share your method with us in the comments section.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here.

When Your Internet Company Is Not Working

internet company

I watched an Olivier Roland’s video  and I learned good stuff.

Here are some tips to improve your situation if you want to have an internet company or you already have an internet company. These principles are basically intended for infopreneurs, it means selling information products (ebook and online training) but over time all companies should use these principles to boost their reputations.

In an internet company, there are 3 pillars : traffic, authority and relation.

Traffic

This is the number of people who visit your website and your entire ecosystem (social media – instagram, youtube, facebook, snapchat, twitter, etc.).

Authorities

This is the way your audience sees you as an expert. You can be an excellent expert and not know how to communicate, so your audience sees your expertise at a level below your actual expertise. And it can also have the opposite situation where your audience sees your expertise at a level higher than your real expertise. In this case, you’re a crook !

Relation

This is the level where your audience appreciates you as a human being rather than a company.

Pillars check

What is interesting to do is to note where you think you are in the 3 pillars (traffic, authority and relation) from 1 to 10. « 1 » is the person who has just started and « 10 », is the person who is one of the best infopreneurs in the world like Gary Vaynerchuk  or Casey Neistat .

Don’t hesitate to ask people you know to have a more objective point of view. The ideal is a close friend who is really interested in your company and who understands what you’re doing. Ask this friend : « What rating would you give me between 1 and 10 ? Go ahead, be frank, you don’t need to spare my ego ! ». With an outside eye, it will help you find the problem.

Problems

problem

Perception

It’s possible that you have a huge traffic on your website but if people don’t perceive you as an expert who has enough experience to help them and they don’t like you (they perceive you more like a salesman as a human being), they will not buy your products and services.

Conversion rate

This concerns the conversion rate between your traffic and the people who sign up for your email list. People who sign up for your email list are people who are really interested in what you’re doing and who want receive the free gift you are offering (ebook or exclusive video). People who subscribe to your email list have given you permission to contact them through their email knowing they can unsubscribe at any time.

What it interesting to do is to note where you think to be in your conversion rate from 1 to 10 ? For example, when there are 100 people visiting your website, how many are subscribed to your email list ? If you rate is 0, you’re not offering any interesting gifts or you’re not making a call to action for your email list. In these cases, you have to work on it to offer a better free gift or tell people that they can sign up for your email list.

We must know that today, email remains the most effective way to contact people and it will remain so for a long time. Attention, that doesn’t mean that when you send an email thanking for the loyalty of your subscribers or a promotional email for a product/service, you shouldn’t also talk about that in your ecosystem (social media) with a video, a picture, a post on different platforms.

It’s important to know that if you’re doing content marketing and your company is based on the free content you create, you need at least a 5% conversion rate. If you do below that, you have work to do to improve your conversion rate.

Solutions

solution

Product/service

It’s possible that you don’t have a product or service to sell or like me at the beginning, I sold a product but there are only 5 people who bought it. In this case, you can do a survey with the people who are on your email list to find out what is the problem they would like to settle as quickly as possible. With this method, you’ll soon be able to create a profitable product because you solve the main problem of you audience. Attention, it’s necessary that you have 1000 people subscribed on your email list to make this survey.

Coaching

This is one of the simplest ways you can make money. It doesn’t matter if you have more than 1000 people on your email list. When we start an internet company, it’s the easiest thing to do. You offer your skills as a service to your audience. With a small audience, a good authority and a good relation, you’ll have people who will be interested to work with you by doing coaching sessions on Skype, for example.

Ebook

If you’re a person who likes to write (like me), you can create an ebook that you can sell between USD 17.- and 27.- to start earning some money.

Action

We could talk about this for hours because every situation is different. I don’t know your situation but by following these advices, you will be able to improve your company’s situation, so ACTION.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

An Extraordinary Tool To Solve All Your Problems

tool box

What’s up ? This is THE stephane ANDRE ! I watched an Olivier Roland’s video  and I learned some good stuff.

Nature has given an extraordinary tool to every human being. This tool has different performance depending on the people but it’s the best for solving problems compared to the tools invented by humans.

This tool is our brain. This tool is better than a computer because a computer needs a human to work. For now, artificial intelligence has lower performance than the human brain.

Unfortunately, many of us don’t use our brains to find solutions and solve problems that are important to us. Many of us consume a lot of distractions. The question is : « Are we asking enough questions to our brain to find solution ? ». If you don’t give problems to your brain, your brain will be less and less efficient. It’s the same principle for your body.

If you give junk food to your body all day long, you will be fat, bitter, you will not have any more energy, you will not have any more libido. Everything that will comes out of you brain will be diminished in quality and quantity. If you will give healthy food to your body all day long, you will be slim, you will have more energy, you will have a better libido. Everything that comes out of your brain will be increased in quality and quantity.

Training your brain

training brain

To improve the brain to solve problems, it’s necessary to ask questions. A question is the interface between our brain and reality. This is what will put the brain in mode : « search for solutions ». By asking questions, you will look for different angles of approach to deal with the problem. The better the question and the better the solution to the reality of the world.

To have a good quality of question, it’s necessary to learn to educate oneself with books, trainings, meeting people who share their experiences, etc. Realize that you have to dedicate time to solve problems, allows you to organize your days. It’s like dedicating a few hours in your day to play sports. There is a method that I advise you to test, it’s to have a diary.

Attention, it’s a special diary because you’ll ask yourself questions. The first thing is that you’ll tell events of your life and this will allow you to better understand them and better understand yourself. And the second thing is that you’re going to ask yourself questions. There will be general questions like: «  How can I become happier ? ». And more specific questions like : « How can I become happier with the 80/20’s law (Pareto’s principle)  from today and see a measurable result next week ? ».

With questions, you put your brain in mode : « search for solutions » and you find several ideas to test to solve the problem. It’s the human process to find a solution since first hominids. Imagine, millions years ago, first hominids already found solutions because of a constraint. Imagine this scene, a hominid finds an animal with a carapace that is dead. The hominid is hungry and seeing the animal dead, he’s even more hungry. He asks himself this question : « How can I eat this animal that I can’t eat ? ». His brain goes into mode : « search for solutions ». After a few minutes, he remembers that by tapping a stone on something, the stone become sharper. After several tests, he manages to cut the animal with a carapace that dead to eat it.

Virtuous circle

virtuous circle

This human process is a virtuous circle. You ask yourself questions to find solutions to problems. These solutions create other constraints that lead to others problems. So you have to ask yourself other questions to find a solutions. To evolve, we need challenges and there are always challenges in the world. Do you realize that millions of years ago, first hominids created tools with stones and wood and today we have internet technology ? With internet, people from distant country can read my blog’s articles 24/24 7/7, it’s incredible.

Among these questions, there will always be questions that will have different answers depending on what the situation you’re in your life. For example the question : « How can I become happier ? ». When you’re single, you have a solution. When you’re in a relationship, you have another solution and when you have children, you have another different solution. Solutions are influenced by different variants in your life and it’s important to ask yourself this question throughout your life.

Reserve some time in you day to ask yourself questions to solve problems. It’s a kind of physical activity for your brain. It’s a good process to become a better version of yourself. But beware, there are solutions that you will find quickly and others, it will be necessary to work on for months or years to find the solution.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

How To Reduce Stress (Part 1)

stress

I watched an Olivier Roland’s video  and I learned good stuff.

I am doing a synthesis of the Dale Carnegie’s book “How to stop worrying and start living”  and other sources on internet for a blueprint to manages stress in 4 steps.

Stress is about change, it means adapting to the environment of a changing structure. Stress is a feeling triggered by the interpretation of an event. It’s a reaction related to the constraints and the pressure undergone in its environment. Stress can be interpreted as something positive, whether it’s considered a challenge or as something negative, if it’s considered a harmful event.

The truth is that stress is a mistake of reasoning in relation to the attitude or behavior we adopt. This is an answer that isn’t adequate. It’s an alert for mental dysfunction as the body gives us an alert for physical pain. Fortunately, people can learn to control stress in 4 steps : Take a step back and analyze what triggered the stress ; anticipate and visualize ; organize yourself and communicate and turn away or adapt and accept.

1st step – Take a step back and analyze

 

keep calm stress

 

It’s necessary to step back and analyze what triggered the stress. Because before trying to solve that, it’s important to know what caused it. By analyzing what caused the stress, we can avoid certain consequences.

To do that, here’s what you can do :

  • Make a list of sources of annoyance that you have in your family, friends, school, work, transportation, etc. Once you have found them, classify them from the most impacting to the least impacting. You can also do a 20/80 analysis, that means identify the 20% of the sources that bring you 80% of your stress.

  • Ask yourself these questions : « What is the problem ? What is the cause of this stress in these sources ? What are the most serious consequences that I suffer of my experience ? »

  • Understand the emotion that created in these moments. Then check if it’s a real fear or rather a theoretical concern that doesn’t have much to happen in your life.

If a situation is truly unavoidable, you need to prepare yourself to accept it. We must give up the impossible because it’s extremely stressful to have no way to change a situation. To avoid this, you need to anticipate situations that may lead you into an impasse. Once these situations identified, you must try to really avoid them or change the course of things from the start.

It’s impossible to keep control of all things in your life. It’s useless to set inaccessible goals.

2nd step – anticipate and visualize

 

anticipate visualize telescope

 

 

The best way to handle stress is to anticipate. Based on the list you made in the first step (source of stress), imagine solutions and possible answers. Ask yourself these questions : « Why did you agree to be in this situation ? ». If what you do make sense, it limits the stress.

Decide how you want to live a situation. An event that happens to you can have not effect on you until you choose words to qualify it. If you say that an event is happy, boring, sad or extraordinary, it can become so. By qualifying the event, you modify the perception that you have of this event.

The way you see the event determines your body’s reaction. So take a moment to think before judging and classyfying a situation as negative.

Take Olivier Roland’s example. When Olivier Roland began to meditate, his neighbor’s dog was barking. At first it disturbed Olivier to focus on his breathing, it was stressful and annoying. After a while, Olivier realized that it wasn’t the barking dog that was stressful, it was Olivier’s interpretation of the situation. From the moment that Olivier decided that the barking dog was something neutral or positive, he began to appreciate when the dog barks. It’s a sign of life.

Imagination can be used to help fight stress. Get in shape before a stressful event. You can create a positive state of mind when an event is negative. Think of something positive like music, a holiday, projects in progress. Visualize a happy moment, a happy memory.

This the end of Part 1. In the 2nd Part, I talk about organize yourself and communicate and turn away or adapt and accept.

Share this article if you think it can help someone you know. Thank you.

-Steph

Create Bins and View Distributions

tableau, bins, bar, chart, distribution, age, data, science

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

It’s cool, you finished the 1st part. Now we’re going to do more deep Data Mining analysis with this bank’s dataset.

tableau, bins, bar, chart, distribution, age, data, science

To make these analyzes more deep, we’ll create a more statistical approach.

To do that we will create a new tab.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

For this new tab, we want to understand how client distributed according to their age. Is there a majority of young or old people ?

tableau, bins, bar, chart, distribution, age, data, science

Move the variable « Age » in « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

As we want to see the distribution of client ages, we need to use the variable « Number of Records » to see the number of observations. Move the variable « Number of Record » to « Rows ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Boom, we have a chart but there is only one point on the top right. What happened is that Tableau took the sum of the ages of all the bank’s clients and the sum of all the « Number of Records », it means the total number of clients, 10 000 clients.

We’ll find a solution but before we’ll change the format to better see the chart. Right-click in the middle of the chart and select « Format ».

tableau, bins, bar, chart, distribution, age, data, science

For the font’s size, select « 12 ».

tableau, bins, bar, chart, distribution, age, data, science

Here you can see that the total age is 39 218 but that’s not what we’re looking for. What we want to see is the number of clients for each age.

I’ll explain what’s going on. We took the aggregated sums of our variables. Aggregate means that we took the total sum of the variable for each category. We added the ages but in fact we want to see the total number of observations for each age separately.

To have that, just click on the arrow in « SUM(Age) » in « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

Then select « Dimensions »

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

You see, Tableau doesn’t take the aggregated sum of ages but it takes ages separately. We have a curve that shows us the continuous distribution of our clients ages. That is to say, for each age, the curve gives is the number of clients of this age.

We’ll look at the dataset. Right-click on « Churn Modelling » and select « View Data… ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

There is window that appears that shows us the data in detail. If you scroll to the right, you will find the column « Age ».

tableau, bins, bar, chart, distribution, age, data, science

We see that the ages rounded. As all ages rounded, Tableau is able to group clients by age. By positioning the mouse on the curve, we can see that there are 200 clients who are 26 years old.

tableau, bins, bar, chart, distribution, age, data, science

If in the dataset, ages weren’t rounded, you would have seen clients with 26.5 or 26.3 years. It would create a lot of irregularity, there would be plenty of spikes with lots of variations.

Oooooh look, there is a variation that isn’t normal.

tableau, bins, bar, chart, distribution, age, data, science

Let’s analyze it in detail. Around this peak, we see that there are 348 clients who are 29 years old.

tableau, bins, bar, chart, distribution, age, data, science

Here, 404 clients who are 31 years old.

tableau, bins, bar, chart, distribution, age, data, science

And this peak down that shows us that there are 327 clients who are 30 years old.

tableau, bins, bar, chart, distribution, age, data, science

How to explain this irregularity ? It’s possible that many people of 29 years old are about to turn 30 years old and many people of 31 years old who just had 31 years old. It’s chance that make us have inaccuracies. You may have other inaccuracies if you data isn’t precise and rounded. In our case, the ages are rounded but we want to get rid of our small irregularity that we see on our curve.

There is way to see our distribution without our irregularities, it’s « bins ». « Bins » consists of grouping the information into different categories. That is we’re going to regroup our clients in different age groups.

Right-click on « Age » in « Measures ». Select « Create » and select « Bins… ».

tableau, bins, bar, chart, distribution, age, data, science

A window appears. We’ll group our clients in 5-years increments. In « Size of bins », write « 5 » and click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

As you can see, the variable « Age » has remained in « Measures » but there is a new variable in « Dimensions ».This is the variable we created « Age(bins) ».

tableau, bins, bar, chart, distribution, age, data, science

Our « Age(bins) » variable was correctly placed in « Dimensions » because it is a category variable because each category corresponds to a 5-year age group.

For example, one category is 20 to 24 age group. Now we’ll create a new distribution based on « bins ».

To do that, we’ll remove the variable « Age » from « Columns » with a click and drag outside.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

You move the variable « Age(bins) » from « Dimensions » to « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Note

In this case, it’s not possible to directly replace « Age » by « Age(bins) » over « Age » on « Columns ». This is because « Age » is a measure and « Age(bins) is a dimension.

That’s nice distribution, it’s usually the type of distribution (chart) we see in economics or mathematics. The difference with the old chart is that this chart is discrete. This chart is discrete because the clients grouped by age group while the previous chart was continuous.

On this distribution (chart), each bar corresponds to an age range. For example, this bar corresponds to the 25-29 age group.

tableau, bins, bar, chart, distribution, age, data, science

Now, we’ll change the colors.

In « Row », move « SUM(Number of Record) » while holding down the « Ctrl » or « Command » key on your keyboard to « Colors ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

We get our distribution in blue but we’ll change the color to red. Click on « Colors » and click on « Edit Colors »

tableau, bins, bar, chart, distribution, age, data, science

In the window that appears, click on the blue square on the right to display the color pallet.

tableau, bins, bar, chart, distribution, age, data, science

Select the red color and click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

Click on the « OK » button of the « Edit Colors » window.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

To facilitate the reading of the bar chart, we’ll add the number of clients in each age group. In « Row », move « SUM (Number of Record) » while holding the « Ctrl » or « Command » key on your keyboard to « Label ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

That’s it, we can see how many clients there are in each age group.

We see that the dominant bar is the 35-39 age bracket and the second dominant bar is the 30-34 age bracket. Overall, we can see that most clients are between 25 and 40 years old, which seems consistent.

On our bar chart, we have absolute values. We’ll replace that with percentages. Click in the little arrow in « SUM(Number of Records) » in « Label » and you select « Add Table Calculation… » but I’ll show you another way to do it.

tableau, bins, bar, chart, distribution, age, data, science

Instead of clicking « Add Table Calculation… », click on « Quick Table Calculation » and select « Percent of total ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

It’s cool, we have the exact percentage of people in each age bracket. Now, we can see that in the 25 to 40 age group, we have 20 + 23 +17= 60% of clients.

I’ll show you one last thing.You can change the size of the slices easily, just click on « Age(bins) » and select « Edit ».

tableau, bins, bar, chart, distribution, age, data, science

In the windows, you can change the size of the slices (bins). Put « 10 » instead of « 5 » to get 10-years slices. Click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Now, we have a distibution with fewer slices and the dominant slice is 30 to 39 years old.

Well, it was just to show you how to change the size of bins. To go back to the old distribution with the 5-years slices, click on « Back » button.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

As you can see, the values on bars are in percentages but the values on the axis are in absolutes values. Here is an exercise that I ask you to do : « Put the values of the axis in percentage ». I’ll give you the answer the next article.

Share this article if you think if can help someone you know.Thank you.

-Steph

Dataset For Data Mining

dataset data mining

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

To have the dataset to do Data Mining, you need to go to the superdatascience website . In « Part.1 Visualization », you see the section « How to use Tableau for Data Mining ». Click on « Churn Modeling » to download the file.

dataset data mining

Once you have downloaded the file, move the file to the directory you created for the course. In this directory, create a new directory (unless you already do it) named « 2.Chunk investigation ».

dataset data mining

dataset data mining

Open this fiel with Excel or with other spreadsheet software.

dataset data mining

Know that we use this dataset for the visualization part but we will also use this dataset for the modeling part.

Let’s analyze the data of this dataset.

This dataset is quite large because it contains 10 000 lines and a few columns. This is the list of a bank’s client. The client information is :

  • Customer id (login)

  • Surname (last name)

  • Credit score ( is the measure that indicates the client’s ability to borrow)

  • Geography (client’s country)

  • Gender (male or female)

  • Age

  • Tenure -(the number of years the client is in the bank)

  • Balance (balance of the client’s bank account)

  • NumOfProduct (number of product that the client has in the bank – credit card, contract, account)

  • HasCrCard (does the client have a credit card ?)

  • IsActiveMember (did the client use his/her credit card during the last month ?)

  • EstimatedSalary (the bank’s estimate of the client’s annual salary)

  • Exited (did the client leave the bank ?)

Now, I will explain the context related to this dataset. This bank has branches in several countries like Germany, Spain and France. This bank noticed that lately there were many clients who left the bank. The bank has a report called « churn rate » which is the customers rate who leave the bank and for a few months the « churn rate » is really higher than usual. It’s for this reason that the bank needs a data scientist (you) to find the problem and propose solutions.

This dataset is a small sample of clients bank. These are 10 000 randomly selected client.

The column « Exited » is a column that didn’t exist before. This column has created when the bank realized that there was an abnormal number of client who were leaving the bank.

dataset data mining

Then the bank observed these clients for 6 months to see which client left the bank.

dataset data mining

In the « Exited » column, the number « 1 » means that the client left the bank and the number « 0 » means that the client stayed in the bank.

To analyze this dataset, you’ll need to do A/B Tests. For exemple, a classic A/B Test is to see if women are more likely to left the bank than men. That’s means, see the number of men who left the bank, see the number of women who left the bank and then normalize by the total number of clients. It’s important to normalize the number of clients because there are not the same proportions of women as men. Next, based on the last column « Exited », you’ll find out if it’s the men or women who are likely to left the bank.

Once you have relevant results, you can show your report to the bank. And with this report you should be able to propose solutions to the bank. For example, if the report says that women leave the bank in bulk, it’s because there is a problem and it’s necessary to see whether the bank is offering women something right. Or it’s possible that another bank offers a much more attractive offer for women or something else.

You will learn how to investigate in the dataset and find answer through client information with A/B tests.

Share this article if you think it can help someone you know. Thank you.

-Steph