Infopreneur

infopreneur, internet, information, product, laptop, entrepreneur,

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

I discovered what it was an infopreneur by reading Tim Ferriss‘s book « 4-Hour Workweek ». It was a book that was recommended in a personal development’s blog and this book has completely changed my way of seeing a « job ». This is definitely a point of view that we don’t learn at school, even at business school.

The profession of infopreneur is a very interesting profession and evolves all the time because of new technologies. In fact, if you don’t know, an infopreneur is a person who earns money on internet with information products. These information products aren’t news but they’re information to help people achieve a goal on a specific area.

What is special about this job is that we enable people to be more effective in things that are important to them and the result is that they’re happier.

Workplace

One of the advantage of this job is geographical freedom. The company is based on internet, which means that you only need a computer and an internet connection to work. There is no obligation to go to a workplace, you can work every day in a different place or in a different country as long as you have access to an internet connection. There are more and more jobs that allow you to have this freedom like programmer, virtual assistant, bookkeeper, data entry, copy writing, translator, travel agent, transcriber, etc.

It’s a profitable business because selling information on internet makes it easier to reach a large number of people with little money.

Distribution

internet company

Imagine how it was to sell a book before the invention of printing. Even if you had written the best book in the world, it was hard to live on it. Imagine, so that 2000 people can read your book, you needed 2000 handwritten copies of your book. Copying books was not a really cool job, so you can imagine how complicated it was. If you offer me a job that consists of copying 2000 books of 300 pages, I’ll answer you : « No, thanks !!! ».

With the invention of printing, authors started earning more mony because more people could read their books and that to increase later with the invention of copyrights.

With digital books (ebooks), it’s possible to sell 100 or 1 000 000 books without the huge costs of printing, distribution, storage and return management. There are still costs but they’re very low for the servers and the support (for example a client didn’t receive the email to download the ebook).

With internet, it give you the opportunity to manage the distribution of your information products yourself. Before internet, you had to have an appointment with a manager of a radio, television to reach as many people as possible. If this manager liked your work, you could have ads on radio, television but if this manager didn’t like your work, no ads.

Many talented people couldn’ have a great exposure to make known their talent because of these « Gatekeepers ». Internet allows you to no longer need to these gatekeepers to reach a large number of people.

If you want to know more, I advise you to read this article that I wrote. Click here .

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.

Please follow, like and share:

Trick To Be More Productive

work

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

Have you ever finished a day completely exhausted and after analysis, have the impression of having accomplished nothing ?

Don’t worry, it has happened to me and it happens to everyone a few times. The truth is that it’s important to understand that there is a difference between being productive and being busy. It’s really something that you have to remember often.

To be busy

Here is an example, imagine that you spend all day pushing a building with hands. It’s serious, you really want to move the building. It’s obvious that at the end of the day, you’ll be very tired but the building will not move.

You’ll have to spend a lot of energy, give a lot of effort but the results are negative, the building did not move a millimeter. In fact the efforts you make aren’t systematically correlated to the results you will get.

With the building’s example, it’s easy to understand that this task destined for failure but with the activities of every day, it’s more complicated to identify.

Let’s use another example. Imagine that you spend all day pushing a block of stone on the sand. At the end of the day, the block of stone will have been moved a little bit (and this is a better result than with the building). But is there a way to move this block of stone faster ? Yes, with a crane, it’s more efficient and it takes less effort. It’s true that finding a crane requires a lot of energy and time, but the crane allows you to have better results more impressive. With the crane, you can move the block of stone in 30 minutes to the destination.

To be productive

be productive

Often the methods to be productive requires a lot of effort and you have the impression to build nothing, but when the methods are put in place, it will give you continuous results without asking you a lot of effort.

Today, after my training, I spoke with a gym employee about blogs. He wondered why I had a blog because for him blog are dead. It’s true that blogs are less fashionable than videos and it’s true that a blog takes years to have an interesting traffic to build a company.

But what he doesn’t see and what the majority of people don’t see is that if the content of the blog has no expiration date, 5-20 years later, your blog’s content will have always value and will be usable. If yo create content based on news, 2 months after your content is no longer valuable and no longer usable.

And it must be added that the blog’s mailing list is more efficient than social media’s subscribers when it comes to promoting your product/service. It also makes me think that since 2005, every year, people say email is dead, ahhaha haahahah.

Vision

It’s not easy to realize that we’re busy instead of being productive and it depends on our perception. By having a clear vision of what you want, you create a company that is at the service of your life rather than your life at the service of your company. Creating content with no expiration date to educate people is my vision. On internet, one of the keys to success is to be able to create the maximum content without expiration date to not be dependent on fashion phenomens.

With this vision, it helps you identify when you’re busy and when you’re productive. This skill allows you to search for what is most effective to reach your vision. At first, there are things that you consider effective and they’re not and vice versa. The process to reach your vision is to explore new things to move forward and grow.

Have you already identified things in your work that you think are effective and in fact they aren’t (like pushing a building with your hands) ?

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.

Please follow, like and share:

This Problem Is Blocking Your Success

problem

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

In the last Leonardo da Vinci’s biography written by Walter Isaacson (who is also the author of the Steve Jobs biography, 2011), we can see that he was an extremely curious man. This curiosity allowed him to explore several different areas, boost his creativity and make a huge contribution to art. But the downside is that he kept changing projects.

Because of this, Leonardo da Vinci left a mind-blowing number of unfinished works of art. There are several scientific fields where he could have advanced the humanity of 2 centuries, if he worked more and published his results.

Attitude

This show us that we all have different attitudes to things that interest us, to our projects. We can explore something because we want to know how it works or master it to improve our lifestyle.

Attitude is very important in life. For example when you do something you like, you don’t have the same attitude as for something you like moderately or not at all. The last project you did, did you give the best of yourself to the end or not ? The question is whether you’re aware of the mission you want to accomplish through the project.

Mission

mission

In a project, the mission, the goal is essential. There are many people around me who say they want to be successful. They say things like : «  Yes, I want to be successful, if I find success around the corner, I would not say no. It would be cool ». But that doesn’t happen like that. To succeed in a mission, it’s necessary to give the best of oneself. And it can take many years, so don’t be naive. With internet, there is a myth that makes everyone believe that in 2-3 years we can be a millionaire, that’s wrong.

When I created my blog, I had friends who also had their blog or YouTube channel, but they all stopped. We didn’t have the same mission and the same attitude when we started. You can see in the top left of my blog this sentence : « I’m building my legacy ». This is my mission.

It’s really good to be curious, but once you’ve found something that interests you, focus on it. Work on this passion in « Guerrilla » mode to develop it, because it will become your main source of income. When I say « Guerrilla », it means that you give the best of yourself. You want to know what skill you have to learn, you want to learn from the best players in the field, you do tests to innovate, etc.

With a definite mission, a « Guerrilla » attitude and patience, you’ll have the success you deserve in your project.

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.

Please follow, like and share:

Machine Trunk Rotation

machine trunk rotation abs

What’s up ? This is THE stephane ANDRE ! I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Attention

Torso’s rotation in the machine are proscribed for people suffering from lower back or having already had a herniated disc, as they might aggravate or reappear this lumbar pathology.

machine trunk rotation abs

Standing on the turntable with your hands on the handles :

  • Rotate your pelvis from one side to the other, keeping your shoulders fixed and controlling the rotation. Your knees are slightly bent to avoid the risk of ligament stretching.

This exercise works mainly external and internal obliques and a little less rectus abdominis. Sets with high reps give better results.

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

-Steph

Please follow, like and share:

Validate Data Mining In Tableau With A Chi-Square Test

validate validation

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

In this article we will start using statistics. Don’t worry we’ll do something simple, we’ll use the Chi-square test in a basic way. There is a special section to learn how to do statistics at an advanced level.

I’ll explain why we’re going to learn how to use the Chi-square test. The results we have with theses 2 bar charts are good. We see on theses 2 bar charts that age has a significant impact on the rate of client leaving the bank. We also see in which age groups the clients leaves the bank the most and which age groups the clients leave the bank the least. With that we have good insights.

In the A/B test « Gender », we can see that there is a correlation between the male and female sex and the choice to leave the bank. But as I said before, this A/B test is basic. The results of a basic A/B test visually shows us what is probably happenning in reality but we aren’t 100% sure of these results. To validate these results, we need do to use statistical tests like Chi-square test.

Doing a report based on basic A/B test is very risky and you can have completely false insights. I don’t advise you to do it (unless you want to leave your job). It’s for this reason that using Chi-square will help us to have strong insights.

Chi-square will allow us to know if our results are statistically significant. Our results are based on a sample of 10 000 clients and Chi-square test will tell us if these results are due to chance effects or if these results can represent all the client of the bank.

For example in our A/B test « Gender », we observed that in our sample of 10 000 clients, women are more likely to leave the bank compared to men.

tableau data mining science chi square test a/b test

Now, we aren’t sure if the results of this sample represent the behavior of all the bank’s clients.

To use basic Chi-square test, we use an online tool. Click here  .

tableau data mining science chi square test a/b test

On internet, there are plenty of websites to do a Chi-square test but we’ll use this one so that you can understand how it works. To do a Chi-square test, we need to use absolute values and in our A/B test we have percentage.

Let’s go back to Tableau. We’ll create a new tab with a version of A/B test with absolute values. In this way, we keep the A/B test with the percentages. Do a right-click on the « Gender » tab and select « Duplicate ».

tableau data mining science chi square test a/b test

Name the new tab « Gender Actual » to specify that it’s absolute values.

tableau data mining science chi square test a/b test

To have the absolute values, move « Number of Records » in « Measures » to the « Marks » area and put it over top of « SUM(Number of Records ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Move « Number of Records » in « Measures » to « Rows » over « SUM(Number of Records ».

tableau data mining science chi square test a/b test

Cool, we have our absolute values.

tableau data mining science chi square test a/b test

We also need total absolute values, which means the total number of men and women. There is a very fast way to get that. Right-click on the vertical axis and select « Add Reference Line ».

tableau data mining science chi square test a/b test

Then in « Value », click on the drop-down on the right and select « Sum » to have the total sum of the observations.

tableau data mining science chi square test a/b test

And in « Scope », you select « Per Cell » option to specify that you want the total sums for each category, male and female.

tableau data mining science chi square test a/b test

Now, we have the total sum at the top of the bars. We will modify labels to have the absolute values. In « Label », we will change « Computation » to « Value » and click on the « OK » button.

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, we have the total amount of observation at the top of each bar : 4543 women and 5457 men. We have what we need to use our online tool.

tableau data mining science chi square test a/b test

OK, I’ll explain how this tool works. « Sample1 » and « Sample2 » correspond to the independent variable « Gender ». You choose in which order you enter the data, « Sample1 » for men or the opposite. In our case, we use « Sample1 » for women and « Sample2 » for men.

« #success » corresponds to the result Y=1, which means in our case « yes, the client left the bank ».

« #trials » is the total number of observations, which means the total number of women in « Sample1 » and the total number of men « Sample2 ».

That’s how you enter the data :

  • For « Sample1 » in #success, you enter 1139 because there are 1139 women who left the bank. For « Sample1 » in #trials, you enter 4543 because there are 4543 women in total.

 

  • For « Sample2 » in #success, you enter 898 because there are 898 men who left the bank. For « Sample2 » in #trials, you enter 5457 because there are 5457 men in total.

tableau data mining science chi square test a/b test

Here is the verdict : « Sample1 is more successful ». « Sample1 » corresponds to women and #success is :« yes, the client left the bank ». This verdict means that of all the bank’s client, women are more likely to leave the bank than men. And look, there is something important, it’s « p<0.001 ». This means that the « p » is strictly less than 0.001.

tableau data mining science chi square test a/b test

« p » is the value that indicates whether an independent variable has a statistically significant effect on a dependent variable. In our case, the independent variable is « Gender » and the dependent variable is « Exited », which is : « yes, the client left the bank ». So « p » is strictly less than 0.001, which means that the independent variable « Gender » has a statistically significant effect on the dependent variable « Exited ». This shows us that out of the total number of bank’s clients, women are more likely to leave the bank than men.

This is how we use Chi-square test with this online tool. This is the same principle on all online tools that you can find on Google or DuckDuckGo . You can repeat these instructions that I gave you with other tools, you will get the same results.

It’s cool with the Chi-square we validated the A/B test and to specify that this A/B test is validated, we’ll color the tab in green.

Right-click on the tab, select « Color » and select « Green ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, now we’ll validate another A/B test. Selects « HasCreditCard » tab.

tableau data mining science chi square test a/b test

We’re going to create an A/B test « HasCreditCard » only with absolute values. To save time, right-click on « Gender Actual » tab and select « Duplicate ».

tableau data mining science chi square test a/b test

We’ll remove the green color on the tab « Gender Actual (2) ». Right-click on the tab and select « Color » and « None ».

tableau data mining science chi square test a/b test

You rename the tab « HasCreditCard Actual ».

tableau data mining science chi square test a/b test

Move the variable « HasCrCard » over « Gender » in « Columns ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Excellent, everything is ready to do a Chi-square test. We’ll remove « Exited » labels to better see the absolutes values. Make a click and drag out.

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, let’s go back to our online tool. In this case, « Sample1 » is « no », which means client who don’t have credit card and « Sample2 » for « yes », which means clients who have a credit card.

That’s how you enter the data :

  • For « Sample1 » in #success, you enter 613 because there are 613 clients who left the bank. For « Sample1 » in #trials, you enter 2945 because there are 2945 clients who don’t have a credit card.
  • For « Sample2 » in #success, you enter 1424 because there are 1424 clients who left the bank. For « Sample2 » in #trials, you enter 7055 because there are 7055 clients who have a credit card.

tableau data mining science chi square test a/b test

Let’s look at the verdict, it’s « No significant difference ». « p » value is very high, it’s above 5%. This confirms that the independent variable « HasCrCard » has no statistically significant effect on the dependent variable « Exited ». That was the conclusion we had made when we had done the A/B test with percentages.

We had seen that there was 21% of « Exited » (clients who left the bank) in the category « no » and 20% in the category « yes ». With these results we concluded that most likely the variable « HasCrCard » had no impact on the rate of clients who left the bank. Chi-square test confirms our conclusion and we can put the tab « HasCrCard » in green to say that it’s OK.

Right-click on the tab « HasCreditCard » => « Color » => « Green ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Excellent, now, you can do a statistical A/B test with 2 categories. Soon, we will do statistical A/B tests with more than 2 categories.

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

-Steph

Please follow, like and share:

Broomstick Twists

broomstick twist

What’s up ? This is THE stephane ANDRE ! I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Standing with your legs apart and the stick placed on your trapezius above your posterior deltoids. Your hands are on the stick but don’t press on it :

Make a torso rotation on one side then the other, keeping your pelvis motionless with an isometric contraction of your glutes.

This exercise works when your right shoulder is forward : the right external oblique, left internal oblique and a little bit rectus abdominis, quadratus lumborum and extensor spinae on the left side.

For more intensity, it’s possible to slightly round your back. A variant is to do this movement sitting on a bench, which will block your pelvis and focus the effort on your abs.

seated broomstick twist

It’s with sets of several minutes that you get the best results.

Attention

Torso rotations are prohibited for people suffering from low back or having had a herniated disc as this may aggravate or resurgence of this lumbar pathology.

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

-Steph

Please follow, like and share:

A Pratical Tip To Validate Your Approach

data science tableau check

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

How was the A/B test « Number Of Product » ? Easy or difficult ?

Here is the result I found.

data science tableau check bar chart

I think you noticed there was something bizarre. There is an anomaly. We imagine that the more the client has products, the more the client is satisfied with the bank so this type of clients should stay in the bank.

In the first 2 bars we can see that a client who has 1 product is more likely to leave the bank than a client who has 2 products. But when a client has 3 or 4 products, we see a huge rate of clients leaving the bank.

Look, there is a little bizarre detail. In the 2nd bar, we can’t see the « Exited » label. This is because there is no place in the orange part to put the text. To make it simpler, we’ll remove the label « Exited ». Drag and drop on the « Exited » text label to the outside.

data science tableau check bar chart

data science tableau check bar chart

Perfect, we can read the percentages. On the 1st bar, we can see that among the client that have 1 products, 28% left the bank. On the 2nd bar, we can see that among clients who have 2 products, 8% left the bank. This show us that clients who have 1 products are more likely to leave the bank than clients with 2 products.

And for the next bars, we observe an anomaly. On the 3rd bar, we can see that among the clients who have 3 products, 83% left the bank. On the 4th bar, we can see that among clients who have 4 products, 100% left the bank. We clearly see that there is a problem and we need to do a deeper analysis to understand what is going on .

As a Data Scientist, we need to explain what happens in bars 3 and 4. Usually when a client has 3 or 4 banking products, that means he/she is satisfied and is loyal to the bank. But in our case, it’s the opposite because there is a high rate of client who left the bank. This is the time to do deeper analysis.

The first thing to analyze is the quality of the data. There is a very big anomaly and it may be because there is something insignificant in our data that disturbs the statistics. For example, it’s possible that when the bank selected these clients in this sample, there were very few clients with 4 products and all those clients with 4 products left the bank. Sometimes chance can create anomalies and you have to play attention to these effects of chance because they don’t seem important but they can create false interpretations.

To start, we will check the number of clients with 4 products.

In « Measure », move « Number Of Records » (which gives the number of observations) on « Label ».

data science tableau check bar chart

data science tableau check bar chart

We observe on the first 2 bars than many clients with 1 or 2 products selected for our sample. For clients with 3 or 4 products, we can see that there were fewer clients selected for our sample.

There are 220 clients with 3 products and 60 clients with 4 products. These small number of clients probably explain why we observe these anomalies.

In this sample of randomly selected clients, there are very few clients with 4 products and they all left the bank. In this situation, we can confirm that it’s a chance. When thing like that happen, you have to be very careful not to make conclusion too fast and make misinterpretations.

The conclusion is that a lot of clients have been selected for category 1 and 2. For category 3 and 4, there have been few clients selected so we can’t do accurate statistics. We need to do deeper analyze for these categories of clients with 3 and 4 products.

Now, let’s put the percentage back on the bar chart. Click on the « Back » button.

.

data science tableau check bar chart

Or do a click and drag of « SUM(Number of Record) » to outside.

data science tableau check bar chart

data science tableau check bar chart

We saw that there is an anomaly and what is interesting to do is to have a comment to remember to do a more in-depth analysis of columns 3 and 4.

Right-click between the bar chart’s title and the bars. Select « Annotate » then « Areas… ».

data science tableau check bar chart

A window appears. In this window, you write « Low observation in last 2 categories » and click on the « OK » button.

data science tableau check bar chart

data science tableau check bar chart

Click on the comment and move it on bars 3 and 4.

data science tableau check bar chart

data science tableau check bar chart

The next time you work on this bar chart, you will see this comment that will remind you to seriously analyze client who have 3 and 4 products.

Validate our approach

It’s time to show you how to validate an approach and how to validate the data. For this we will create a new A/B test.

Duplicate this worksheet with a right-click on the « NumberOfProducts » tab and select « Duplicate ».

data science tableau check bar chart

And rename the tab « Validation ».

data science tableau check bar chart

For this tab, we will erase the comment. Select the comment and press the « Delete » button on your keyboard.

data science tableau check bar chart

data science tableau check bar chart

Everything is ready, the idea is to find a variable that doesn’t affect our results. That is a variable that has no impact on a client’s decision to leave or stay in the bank.

Take for example, the variable « Customer Id ». Client’s identification number has no influence on the client’s decision to stay or leave the bank.

We’ll do an A/B test with the last digit of the « Customer Id » and we’ill check that there is the same clients proportion who leave the bank in the 10 categories of the last digit of the « Customer Id ». The 10 categories are the numbers 0,1,2,3,4,5,6,7,8,9.

Let’s g.To start, we will create the variable that contains the last digit of the « Customer Id ». To have this variable, we will create a « Calculated Field ».

Right-click on « Customer Id », select « Create » and click on « Calculated Field ».

data science tableau check bar chart

data science tableau check bar chart

Name the calculated field « LastDigitOfCustID ». In the text field, we use the « RIGHT » function with « Customer Id » in parenthesis to select the last character of the « Customer Id ». In our case, the last character of the « Customer Id » is the last digit.

Here is the code to write in the text field : Right ({Customer Id},1)

data science tableau check bar chart

data science tableau check bar chart

Oooops, you see there is a small mistake => The calculation contains errors.

There is an error in the formula because « Customer Id » is a number variable and the « RIGHT » function applies to a variable of type « STRING ».

To use the « RIGHT » function, we will convert « Customer Id » into a string. We will use the « STR » function with « Customer Id » in parenthesis.

Here is the code to write in the text field

And click on the « OK » button : Right (STR({Customer Id}),1).

data science tableau check bar chart

Now, you can see that our calculated field « LastDigitOfCustID » is in « Dimensions ».

Click on « LastDigitOfCustID » and move it on top of « NumOfProducts » in « Columns ».

data science tableau check bar chart

data science tableau check bar chart

Now we have a new bar chart and we see that for every last digit of the « Customer Id » there is about the same proportion of clients leaving the bank. All these proportions don’t correspond exactly to the average of 20% but these slight variations aren’t important.

Seeing this uniform distribution allows us to validate our data because these data are homogenous.

Conculsion

Here’s how you can check the homogeneity of your data. You take a variable that has no impact on the fact that a client leaves or stays in the bank. The example we did with the last digit of the « Customer Id » is excellent. We were able to verify that in each of the categories taken by this variable, if there was the same proportion of clients leaving the bank. As is the case, we can validate our data.

Imagine another result. When we do the test with the last digit of the « Customer Id », we observe that for one of the numbers, the rate of clients who left is really higher than the average. This shows us that there is a problem in our data because it indicates an anomaly.

You can find other ways to verify your data by using other « insignificant variables » to see if the distribution is homogeneous. But be careful when you select an « insignificant variable » because there may be traps.

Here is an example. If you create a variable that takes the first letter of the first name, the distribution will not be homogeneous. The reason is simple, there are many more people who have a name that starts with the letter « M » than with the letter « Y ».

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

-Steph

Please follow, like and share: