Protein (Part 3)

protein, supplement, whey, powder, shaker

Before read Part 3, be sure you read Part 1  and Part 2 .

Protein supplements

In training program, there is always a nutritional plan because to build muscle lifting weights isn’t enough. The good quantity of protein in relation to your bodyweight is an extremely important element. But as you’ve noticed, it’s difficult to eat enough protein without eating too much fat. Protein supplements are a solution.

Protein supplements can increase protein intake without increasing the fat’s amount in your body and ease protein intake several times a day. Eating several times a day is essential for a bodybuilder and having tips to make it easier is appreciated.

There is an incredible variety of protein supplements and they really have a dessert’s taste. What’s interesting is that they’re more and more rich in nutrients with vitamins and minerals and in macronutrients with proteins and carbohydrates. Find a protein supplement that meets your nutritional needs and tastes can be a help in your nutritional plan.

whey, protein, supplement, glass, milk, egg, soy, shaker, powder

As there is an incredible amount of protein supplement, there are several things to check to help you choose. First, reading the label is important because there are some that really contain too much carbohydrate. It’s good to know that carbohydrate improve the conversion of food protein to muscle protein but an excess of carbohydrate creates an excess of calories which prevents your body from easily burning fat. Therefore, it’s necessary to count the number of carbohydrate on the label.

Second, protein supplement that is consumed pure, without a meal or without carbohydrate, isn’t metabolized effectively. Research shows that for the protein to be used for protein synthesis, it must be consumed with calories, especially those from carbohydrate. Otherwise protein and used as energy production.

On the other hand, if you’re on a low carbohydrate diet and you increase your protein intake for energy (to compensate the lack of carbohydrates), it may be a good idea.

Third, the protein source of protein supplements comes from 3 foods :

  • Milk protein (whey, milk protein concentrate and caseinate)
  • Egg protein
  • Soy protein

All these proteins are of high quality. For the moment, no scientific studies show that there is one protein better than the other. Protein supplements made from milk and eggs are the most popular among bodybuilders. Soy protein has a specificity because it can reduce serum cholesterol rate in some people. This may be advisable for people with cholesterol problems but it’s careful because it’s possible to find a lot of GMOs in soy.

It’s important to remember that protein supplements aren’t created to be the only source of food protein. A balanced diet consisting of whole foods is essential for a healthy diet and building muscles.

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:

MRSA Infections

mrsa infection anatomy

What’s up ? This is THE stephane ANDRE. With my training, I’m interested in biomechanics to avoid injuries. I read « Sport Medicine Media Guide » and I learned some good stuff.

Methicillin-Resistant Staphylococcus aureus (S. Aureaus), or MRSA, is a bacterium that creates skin infections and other types of infections. The first time that MRSA was seen in US hospitals during the 1970s. Recently, there is a new strain of MRSA know as Community Acquired Methicillin-Resistant Staphylococcus aureus, or CA-MRSA, has left hospitals and began to spread in the community.

This is the strain that is prevalent among athletes. The difference between CA-MRSA and Healthcare-Associated MRSA (HA-MRSA) is in their effects. CA-MRSA usually creates skin infections while HA-MRSA causes bloodstream, urinary tract and surgical site infections. This make CA-MRSA less dangerous than HA-MRSA. Another difference is that CA-MRSA is more vulnerable to antimicrobial.

Symptoms

Signs of infections are :

  • Redness

  • Warmth, Swelling

  • Pus

  • Pain at sites where there are skin wounds

  • Abrasions or cuts

MRSA has the ability to spread to other organs in the body and when that happens, symptoms are more severe.

At this stage, symptoms are :

  • Fever

  • Chills

  • Low blood pressure

  • Joint pain

  • Severe headaches

  • Shortness of breath

  • An extensive rash over the body

These more advanced systemic symptoms require immediate medical attention.

Treatment

The 1st choice for treating MRSA skin infection is to use an antibiotic that has been created to kill bacteria with mild side effects. Most early infections with no widespread symptoms can be treated with oral antibiotics. Because of the nature of this decease and antibiotic options, many patients think they’re « cured » after only a few doses and decide by themselves to stop taking the prescribed drugs. However, MRSA is able to re-infect the patient and become resistant to antibiotics used previously.

For moderate to severe infections, treatment may be with intravenous antibiotics.

These infections associated with deep abscesses or boils require open surgical drainage in addition to antibiotic therapy. Most infections resolve in 7-10 days with an adequate treatment despite the fact that a deep abscess can take up to 4 weeks to eradicate the infection by resolving the abscess cavity.

Early identification and treatment of MRSA infections decrease the amount of playing time lost and decrease the chance that the infection will become severe. Skin may be protected by protective clothing or gear designed to prevent skin abrasions or cuts.

Prevention

mrsa infection anatomy

It’s necessary that athletes have good personal hygiene but it must be added that athletes and visitors to athletes facilities must also keep their hands clean by washing them often with soap and water or using an alcohol-based hand rub. The minimum is to have clean hands before and after sports and activities. For example when we use weight training equipment that is shared by all gym members, it’s important to have clean hands after using toilette or when someone is injured taking care the wounds (including changing bandage).

Ordinary and antimicrobial soaps are effective for washing hands. It’s noted that liquid soap is a better option because it’s not possible to share this type of soap compared to bar soap. Alcohol-based hand sanitizer that contain at least 60% alcohol are the perfect choice.

Athletes should shower immediately after exercise and shouldn’t share soap and towels. Washing all uniforms and clothes after each use is important. Athlete should avoid sharing items that are in contact with the skin and avoid sharing personal items as they contact the skin. Fortunately, most surfaces don’t provoke a risk of spreading staph and MRSA.

Athletes who have had MRSA

Several high school, college and professional athletes have contracted MRSA infections. There have already been epidemics among athletes on the same team. A study published in « The New England Journal of Medicine » shows an infection MRSA among St. Louis Rams professional football franchise (USA) athletes. During a single season, MRSA infections were found among 5 of 58 Rams athletes (9 percents) that was tested. All infections developed on areas of the body that are common places for turf injury.

Stats

  • Today, MRSA accounts for about 50-70% of the S. Aureus infections that are present in healthcare facilities across the world.

  • Statistics fro the Kaiser foundation in 2007 indicated that approximately 1.2 million hospitalized patients contract MRSA infections.

  • Serious MRSA infection is still predominantly related to exposure in the healthcare setting, where approximately 85 percent of all serious MRSA infections occur.

  • Fortunately, in children under 18 years old, mortality rates are much lower (1%), even though the number of hospitalized children with MRSA has almost tripled since 2002.

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:

Anterior Cruciate Ligament Injuries

anterior cruciate ligament injury tear

What’s up ? This is THE stephane ANDRE. With my training, I’m interested in biomechanics to avoid injuries. I read « Sport Medicine Media Guide » and I learned some good stuff.

Knee is the largest and most complex joint of the body. There are 4 primary ligaments (with their muscles and tendons) and secondary ligaments for the knee to function properly. Here are the ligaments of the knee : there are 2 ligaments on the side the medial collateral ligament (MCL) and the lateral collateral ligament (LCL) and two crossed ligaments in the center of the knee, the anterior cruciate ligament (ACL) and the posterior cruciate ligament (PCL).

Anterior cruciate ligament connects the front top part of the shine bone to the back bottom part of the thigh bone and keeps the shin bone from sliding forward.

anterior cruciate ligament

Injury

anterior cruciate ligament injury tear

There are several ways to have an injury to the anterior cruciate ligament :

  • The injury can be done because of a direct hit on the knee, which often happens in team sport.

  • The injury can be done without contact with an object in a situation where the knee forced to be in a abnormal position, which causes a tear in one or more ligaments of the knee. Or when an athlete in the race change direction. Or when an athlete make a hyperextend of the knee when landing a jump, which often happends in agility sports.

Diagnostic

In the majority of cases, the doctor is able to identify what is the injured ligament. But the knee can also be injured at the joint on the surface and in this situation, it’s more difficult to diagnose because of knee swelling. To make an accurate diagnosis, it will be necessary to use a MRI scan or arthroscopy.

Prevent

There are several fast, powerful movements that lengthen (eccentric phase) and shorten (concentric phase) a muscle. These prevention programs are for injuries without contact. These exercises are to improve the nerves/muscle control of the knee. These prevention programs use plymetrics, balance and strength/stability exercises.

Plymetrics

It’s a fast, powerful movement that lengthens (eccentric phase) and shortens (concentric phase) a muscle. The concentric phase increases the muscle power. Here is an example, an athlete who jumps from a box and immediately jumps into the air after touching the floor.

Balance

Balance exercices are done with the wobble or balance board. It’s also possible to perfom exercices by throwing a ball with a partner while balancing on one leg.

Strength/stability

To improve single-leg core strength and stability, there are excellent exercices such as jumping and landing on one leg with the knee flexed and momentarily maintaining this position.

Surgical treatment

In the past, there was a technique that consisted of stitching the ligament together but it was rarely successful. Currently, the technique involves reconstructing the anterior cruciate ligament by building a new ligament from tissue taken from one of the other tendons around the knee or from on organ donation. This tissue passed through drill holes in the thigh bone and the shin bone, and then ancored in place to create a new anterior cruciate ligament. Over time, this transplant becomes mature and becomes a new living ligament in your knee.

Recovery

recovery

Rheabilitation of the knee after the reconstruction of the anterior cruciate ligament requires time and work. To have a complete function, this can last between 6 weeks and 6 months depending on the severity and level of activity. Rehabilitation rate may take time depending on the specific requirements of the sport/physical activity of the individual.

The overall success rate of the anterior cruciate ligament surgery is very good. A lot of study show that more than 90% of patients are able to return to sport without symptoms of knee instability. It’s true that some patients complain of stiffness and pain after surgery, that is why it’s necessary to make an aggressive rehabilitation until the new surgical technique to reduce these problems.

Statistics

  • One of the most commonly injured ligament in the knee

  • Female athletes participating in basketball and soccer are 2-8 times more likely to suffer anterior cruciate ligament injury.

  • Athlete who suffer anterior cruciate ligament injury at increased risk of arthritis development later in life.

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:

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

Please follow, like and share:

Combine 2 charts

tableau chart compare paralell data mining science

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

We’ll move to the next level. We’ll work with 2 bar charts in parallel to have a more efficient data mining. In a previous article, we created 2 different bar charts. The 1st was an A/B test (actually, it’s a classification test) that told us in which age range the clients were most likely to leave the bank. The 2nd was a bar chart showing the age distribution of clients in our sample of 10 000 clients.

Let’s go. We’re going to have an A/B test with age range and we’ll add a bar chart of the client distribution below. To add a bar chart, we must start by choosing what we want to keep and what we want to add. In our case, we want to keep the columns because they’re the same in the 2 bar charts.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

And we just want to add a new line so we will add a new variable in « Rows ». As we want to add a bar chart of distribution, we will use the variable which corresponds to the number of observation « Number of Records ».

In « Measures » moves the variable « Number of Records » in « Rows » to the right of « SUM(Number of Records).

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

We have a 2nd bar chart below the 1st bar chart. As you can see, these 2 bar charts are in one column. « Columns » is « Age(bins) ». These 2 bar charts are in 2 different lines which are the lines that correspond to the 2 « SUM(Number of Records) » in « Rows ».

The space on the left has also changed. There is « All » which represents the 2 bar charts at the same time. It means, when your select « All », you make change in the 2 bar charts.

tableau chart compare paralell data mining science

Below this tab « All » we have 2 tabs. The 1st tab represents the 1st bar chart so the 1st « SUM(Number of Records) » in « Rows » and the 2nd tab represents the 2nd bar chart so the 2nd « SUM(Number of Records) » in « Rows ».

tableau chart compare paralell data mining science

Which means that if you want to make changes on the 2 bar charts at the same time, you make the changes in the tab « All ». If you want to make changes only in the first bar chart, you select the first tab below « All ». If you want to make changes only in the 2nd bar chart, you select the second tab below « All ».

So if you change the color in tab « All », our 2 bar charts will be colored by the same color.

Select the « All » tab and click on « Colors ».

tableau chart compare paralell data mining science

Click on « Edit Colors… » and select « Stayed ». Select the green color and click on the « OK » button.

tableau chart compare paralell data mining science

As you can see, the color changed in the 2 bar charts.

tableau chart compare paralell data mining science

Click on the tab of the 2nd bar chart.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

Removes the « Exited » variable from « Colors » to remove colors only in the 2nd bar chart.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

Removes the « SUM(Number of Records) » variable from « Label » to remove the labels only in the 2nd bar chart.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

We will add color on this 2nd bar chart. Click on « Colors », click on « More colors… » and select the blue color. Click on the « OK » button.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

Now, we would like to see the colors vary in intensity depending on the number of observations. Take « SUM(Number of Records) » from the 2nd line in « Rows » and holding « Ctrl » or « Command », move it to « Colors ».

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

Cool ! We will take care of the 1st bar chart. Select the tab of the 1st bar chart.

tableau chart compare paralell data mining science

Click on « Colors ». Click on « Edit Colors… ». Select « Stayed ». Select the brown color and click on the « OK » button.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

For more clarity, we will add labels in 2nd bar chart. Click on the tab of the 2nd bar chart. Take « SUM(Number of Records) » from « Colors » and holding « Ctrl » or « Command » and move it to « Labels ».

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

Perfect. Now we will change the location of the bar chart. We will put the 2nd bar chart instead of the 1st bar chart. According to the logic of « Rows » and « Columns », simply put the 2nd line « SUM(Number of Records) » to the left to pass in 1st line.

tableau chart compare paralell data mining science

tableau chart compare paralell data mining science

BOOM, the bar chart of the age distribution is going over because it’s in the 1st line in « Rows ». With these changes, tabs to change the bar charts have changed order.

Observation

What we can observe with these bar chart is that we see on the 1st bar chart that the majority of bank’s clients are in the age group of 30 to 34 years old and 35 to 39 years old. In these 2 age groups, we see on the 2nd bar chart that client of 30 to 34 years old are less likely to leave the bank than clients between 35 and 39 years old. Look at ages 30 to 34, the rate of clients leaving the bank is 8% while in the 35 to 39 age group, the number of clients leaving the bank is 13%.

In the age group of 40 to 54 years old, we see on the 2nd bar chart that the rate of clients leaving the bank is increasing and is above of the average rate of clients leaving the bank (20%). But we see in the 1st bar chart that the number of clients in the age group of 40 to 54 years old decrease with the age groups.

Do you remember the potential for anomalies in age groups 75, 85 and 90 ? We’ll check it. In the 1st bar chart we can see that there are 11 clients in the age group of 80 to 84 years old, 2 clients in the age group of 85 to 89 years old and 2 clients in the age group of 90 to 94 years old. We can conclude that these observations in age group of 80, 85 and 90 aren’t very significant from a statistical point of view because 2 clients is something negligible in this sample of 10 000 clients.

In the first age group of 15 to 19 years old, we can see that there are 49 clients, which is not very significant.

Compare these 2 bar chart in parallel allows us to have additional insights.

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: