Become Insensitive To Haters

hater

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

To be successful, it’s really necessary to have the ability to ignore haters, especially on internet.

Beginners are unaware of the emotional impact that haters can create and it can also scare people who want to start their company online. When you develop your internet presence, avoid haters is impossible.

Hater

A hater is a person who feels the irresistible urge to send you a message by email, comment or tweet to tell you :

  • You’re the stupidest and ugliest person in the world

  • Your content is the most insignificant thing since the creation of the planet earth

  • That he/she hopes that you don’t make children to not spread the evil on the planet earth and that you die quickly

These 3 things are what say haters in general.

The truth is, you can’t avoid that. Select one of your favorite artists, athletes or actors, check out one of his/her video on Youtube and read the comments. You can see the quality’s level of comments and it makes people lose faith in humanity. And it’s not just haters, there are also people who tell a lot of bullshit and insult each other.

A hater is a person who is bored and has no purpose in life, so that person is trying to create trouble in your community and psychologically impact you in a negative way. Fortunately on social media, it’s possible to ban haters.

Don’t be afraid

don't be afraid

I know many people who want to create a blog, a podcast or a Youtube channel but they’re afraid of having a bad buzz. I know a medical student who wants to create something to help students who are in 1st year of medical school but he still doesn’t do anything. This is the same situation as people who never drive because they are afraid of an accident or people who never take a plane.

It’s important to understand :

  • It’s extremely unlikely

  • Even if you have a bad buzz, you’ll survive

  • In any case, you will build a community that will support you.

When you look at the biggest bad buzz in history, it’s rare to see that the sales falls caused the bankruptcy of the company (or maybe you know a case I don’t know). Sometimes there are people who have been a bit traumatized by a bad buzz but in the majority of cases, there is little damage.

The best revenge you can have for haters is to have a good life. To be afraid of the haters that make you afraid to act, that you’re paralyzing, it’s showing to the world that it’s you who are leaving intimidated by something that is very unlikely to happen.

Keyboard warrior

keyboard type

Haters are also called « Keyboard warrior » because generally haters allow themselves to make type of criticism about people on internet but they are unable to do in real life, face to face. They’re comfortable behind their keyboard because they suffer no consequence.

So don’t be intimidated by the keyboard warriors and what I recommend you to do, it’s to keep a bottle of champagne to celebrate your first hater. It’s important to know that having haters is a necessary step in your success. Having your first hater is a sign that you’re on the right track because you’re disturbing someone.

keyboard warrior

Constructive criticism

Among this ton of negative comments (95%), there are also critics who can help you improve. To identify these critics, you must ask yourself this question : « What is the intention of this criticism ? Do I feel that the person wants to help me ? ».

If you feel that the criticism of the person is to help you, you can analyze the criticism and see if you can do something that interest you. If not, you can ban the person. Unfortunately, you’ll see that the majority of critics are not made to help you.

Remember that about haters :

  1. They’re inevitable

  2. They’re a sign of your success. Everyone has haters, even the people you admire the most

  3. They’re keyboard warriors. They say things that he/she doesn’t allow himself/herself to say in real life, face to face.

  4. Keep a bottle of champagne for the day you’ll have yor first hater

  5. To identify constructive criticism, ask yourself this question : « Is there a positive intention in this criticism to improve myself ? ».

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

-Steph

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

Export Worksheet

data science tableau export worksheet chart

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

Now is the time to learn how to export your worksheet as an image in another document.

You have made an excellent report that can be shown to your customers or your managers and you need to export it in a Word, PowerPoint or other document.

The only way to do with the free version of Tableau (Public Tableau) is to make a snapshot (printscreen).

In the paid version of Tableau, there is a function to copy the bar chart with a right-click.

But before doing this, it’s necessary to change the worksheet’s title because at the top of the bar chart, you can read the title « Sheet 1 ».

data science tableau export worksheet chart

« Sheet 1 » is the tab’s name at the bottom of the screen.

data science tableau export worksheet chart

To change the tab’s name, you do a right-click on it and you select « Rename Sheet ».

data science tableau export worksheet chart

You rename the tab « Annual Bonus Analysis ».

data science tableau export worksheet chart

You have the possibility to put the title visible or not on the bar chart. Click on « Worksheet » and activate/deactivate « Show Title ».

data science tableau export worksheet chart

The worksheet’s title is at the top of the bar chart.

data science tableau export worksheet chart

You can edit the title by double-clicking on it.

data science tableau export worksheet chart

If you want to change the title border, do a right-click on it and select « Format Title ».

data science tableau export worksheet chart

On the left, a tab appears to change the border.

data science tableau export worksheet chart

If you want to change the text’s format, you need to double-click on « Annual Bonus Analysis ». A window appears to change the size, etc.

data science tableau export worksheet chart

To export the bar chart to a Word document, do a snapshot or a print screen with the PrintScreen key (PrtSc) or Command+shift+3 for Mac on your keyboard.

Personally, I use the Paint.net software  to remove unnecessary elements from the image.

One you saved the bar chart’s image, you insert or paste this image into the Word file.

data science tableau export worksheet chart

In this image, you can see that the bar chart’s title is « Annual Bonus Analysis » instead of « Sheet1 ». It’s perfect for presenting to your clients or managers.

Then you can add text below the bar chart to present your insights.

To export the bar chart into a PowerPoint document, it’s the same principle. Do a snapshot or a print screen with the PrintScreen key (PrtSc) or Command+shift+3 for Mac on your keyboard.

Then you remove the unnecessary elements of the image.

data science tableau export worksheet chart

Once you saved the bar chart image, you insert or paste this image into PowerPoint file. Be sure that the title on PowePoint is at the top of the page otherwise the title will be under the image.

data science tableau export worksheet chart

To save your workspace, click on the « File » menu and select « Save To Public Table As… »

data science tableau export worksheet chart

« Tableau Public Sign In » appears to connect to your account.

data science tableau export worksheet chart

A tab will appear on your web browser to display your Tableau Public account and you can see your workspace saved on the server.

data science tableau export worksheet chart

Caution, Tableau doesn’t automatically save your work so it’s up to you to save regularly.

This section is now closed. We made an introduction to Tableau with a simple dataset to discover functions like calculated field, add colors, add labels and how to format.

Now you know the basics of Tableau and later we will use complex functions.

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

-Steph

Add Color

colors

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

Podcast:

In the last article, we created our calculated field « TotalSales » that you can see in «Measure » zone.

In Tableau, the calculated field is very used (almost every time) because in most case the data don’t give the value you want to show.

The calculated field « TotalSales » is a simple example to make you understand how it works but know that you can do things more complex. I’ll show you that later.

In this article, I’ll show you how to manipulate colors because it’s an important element to communicate. With colors, people will understand more quickly what you want to explain to them.

Imagine that you have to show this bar chart to the manager who handles the bonuses. By putting a little color, a little art, you could improve the reading of this bar chart.

To use colors, click on this button.

data science tableau color

You can change the color with the basic colors.

data science tableau color

Or you can have more colors by clicking here.

data science tableau color

If you have a picture in the background, you have the possibility to change the opacity to have a transparent effect of colors.

data science tableau color

You can add a border, change the border’s color, etc.

data science tableau color

But what would be nice to do is to have bars with different colors.

To start, take « Rep » and move it on « Colors ».

data science tableau color

With this, there is a unique color for each representative.

data science tableau color

There is also another method to do that. Instead of taking « Rep » and moving it to « Color », you can click « Rep » here.

data science tableau color

If you move it to « Colors », you’ll break everything because « Rep » will no longer be in the « Columns » zone.

data science tableau color

To avoid this, press Ctrl or Command on your keyboard and click « Rep » to make appear the sign « + ». Now that you made a copy of « Rep », move it to « Colors ». It’s like making a copy/paste from « Rep » to « Colors ».

data science tableau color data science tableau color

With this method, « Rep » is always in the « Columns » zone. This is a method that is very practical when there are many dimensions.

It’s possible to change representative’s colors by clicking here.

data science tableau color

As you can see, there are several choices of palettes.

data science tableau color

You can test the « color blind » palette which is very useful for color blind people. To select this palette, click « Assign Palette » and « Apply ».

When a palette has fewer colors than representatives, you will have a message saying that some colors will be duplicated. But this is not a problem because there are names below the bars.

data science tableau color

Now we want to see something else with our bar chart. Press “Ctrl” or “Command” on your keyboard and click on SUM(TotalSales) to display the « + » sign. Then move SUM(TotalSales) to « Colors » to replace « Rep ».

data science tableau color data science tableau color

As you can see SUM(TotalSales) has different colors. The colors are on a continuous basis which means that the more sales there are, the darker the color.

For our case, this is not useful because the size of the bars represents the sales number but for other situations, this is useful.

The problem now is that there are duplicate colors and because of this, the Manager could misinterpret the results. An alternative approach would be to ensure that the Manager understands the results.

The solution is to take « Region » (by pressing “Ctrl” or “Command” on your keyboard) and move it to « Colors ».

data science tableau color

You can also take « Region » (with “Ctrl” or “Command”) and move it to SUM(TotalSales) to replace SUM(TotalSales).

data science tableau color

With that, the bars are colored by region.

data science tableau color

That way, you can clearly see the 3 regions through colors that are unique to each region and you can see the total sales per representatives with the size of the bar.

This is a small example so that you can understand the basics to manipulate colors in Tableau. There are still more complex techniques to manage the colors that I will show you later.

Plays with the colors so you can fully understand how it works. You could find your favorite palette and find your style. Have fun.

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

-Steph