Work With An Alias

data science alias bar chart tableau mining

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

In the last article, I showed you how to do a simple A/B test. We will continue with the result we had with the A/B test.

data science alias bar chart tableau mining

Here is the result of the A/B test. What is in orange is the percentage of men who left the bank, it’s 16%. What is in blue is the percentage of women who left the bank, it’s 25%.

With our bar chart we can quickly see that women are more likely to leave the bank than men, all the rest being equal in our sample.

I remind you that this is a basic A/B test. There are 2 type of A/B test, the basic A/B test and the statistical A/B test. The statistical A/B test is done with a statistical test like the KHI-2 test. For our case, the basic A/B test already give us good insights.

To make our bar chart even easier to read, we will work with aliases.

The first thing we will do is we will improve the format. Right-click on this space between « Gender » and the bars and select « Format… ».

data science alias bar chart tableau mining

The « Sheet » tab appears. In « Worksheet » changes the text size to « 12 ».

data science alias bar chart tableau mining

What is good with data mining is that we aren’t obligated to make a perfect chart because we don’t have to present them in a report to managers or a meeting.

For example, if I had to present this chart in a report, it would be necessary to change the vertical title. But we only make a model so this change isn’t necessary.

Now, look at this rectangle. We can see « Exited », « 0 » and « 1 ».

data science alias bar chart tableau mining

« 0 » means that the client stayed in the bank and « 1 » means that the client left the bank. We can also see that client who left the bank are in orange so 25% for women and 16% for men. And the client who stayed in the bank are blue so 75% for women and 84% for men.

We did an excellent basic A/B test but it would be much easier to read if we replace « 0 » with « Stayed » and « 1 » with « Exited ».

With aliases we can do that. An alias is to replace the binary results « 0 » and « 1 » with « Stayed » and « Exited » because it’s not easy to remember the meaning of « 0 » and « 1 ».

There are 2 ways to do it : create a calculated field or use aliases.

We will use aliases. Know that aliases are not going to change the « 0 » and « 1 » in the dataset, this change is only in Tableau.

In « Dimensions », right-click on « Exited » and select « Aliases… ».

data science alias bar chart tableau mining

data science alias bar chart tableau mining

A small window appears. In this small window, you can create an alias for each value contained in the « Exited » variable.

The variable « Exited » contains the value « 0 » and « 1 ». For the value « 0 », we will create the alias « Stayed » to say that the client stayed in the bank. For the value « 1 », we will create the alias « Exited » to say that the client left the bank. Then click on the « OK » button.

data science alias bar chart tableau mining

Look, we can see the new values in the rectangle.

data science alias bar chart tableau mining

The values « 0 » and « 1 » have been replaced by « Stayed » and « Exited ».

Now that the aliases saved, we will take the variable « Exited » in « Dimensions » and move it to « Label ».

data science alias bar chart tableau mining

data science alias bar chart tableau mining

Look, we have our aliases « Stayed » and « Exited » on the bar chart.

In this ways, it’s easier for people to read the bar chart without asking what meaning of « 0 » of « 1 » values. « Stayed » and « Exited » are clearer.

Now you know how to use aliases so that people can easily read the binary values of a chart.

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

-Steph

Please follow, like and share:

The Trick To Have A Prodigious Result

results

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

This trick is one of the fundamental principles for success. If you want an exceptional result, you need to have an exceptional behavior.

Having an exceptional behavior means have a different behavior from the majority of people. Think about it, if you do the same thing as the others, you will have the same results as the others, it’s simple and logical.

Look at this example. Imagine that you’re doing karate and you want to become world champion :

Here are 2 choices :

  1. You’re looking for a teacher who has already been world champion and you use a technique that is different from others.

  2. You learn karate with people doing karate for fun. These people don’t have the ambition to become world champion.

Another example. Imagine that you want to have financial independence and that in your environment, there is no one who has financial independence.

Here are 2 choices :

  1. You’re looking for a person (on internet) who is financially independent and you use a technique different from the others.

  2. You listen to advice of people around you who don’t have financial independence.

We agree. In both cases, you’re more likely to succeed by looking for people who have already accomplished your goal. It’s interesting to see that the majority of people (my parents, for example) criticize people who are successful, but that shouldn’t stop you from listening to and using the techniques of people who are successful.

My opinion on

opinion

I think you noticed but everyone has an opinion on everything. Even a person who doesn’t know anything about a subject, likes to give his/her opinion. Is it in human nature ? I don’t know but to be successful, you need to learn how to sort out the good advice that will help you to reach your goal and the bad advice that will slow you down or block you.

I’m not going to lie to you, when you start, it’s really hard to sort out the good and bad advice. To get the best of luck from the start, I advise you to listen to people who have already accomplished your goal and not others.

Skepticism

skepticism

There is a method that is cool, it’s good skepticism. You’ll see, it’s easier to understand the difference between good and bad skepticism than a good and bad hunter.

Bad skepticism

Bad skepticism is when you see something that is too good to be true and you say : «  Pfff, it’ a scam » or « No, it’s not for me » and you’re not going to do anything.

Good skepticism

Good skepticism is as astonished as the bad skeptic, but he/she wonders : « Is it going to work with me ? ». Good skeptic thinks like that because he/she knows that the only way to know if it’s true is to test it yourself. He/She tests it by doing a simple experiment to see if it’s true or if it’s a scam.

I know we can’t absolutely test everything because sometimes we don’t have the time or the material but, it’s this concept that I share with you. When you have a project that you like, see if you can test different techniques or methods. Test different techniques or methods that have the potential to give you a lot of result with simple experiences.

With this article I want to motivate you to connect with people who already accomplished your goal. With theses people, you can advance your project faster by avoiding making fatal mistakes. It’s true that it’s easier to connect with people around you but you may stagnate. Be persistent and patient to connect with people who have already reached your goal and who are still progressing.

It’s extremely motivating to be surrounded by people who are always progressing.

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

-Steph

Please follow, like and share:

How To Do Sumo Deadlift

sumo deadlift

I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Standing with the barbell on the floor in front of you. Your legs spread with your feet outside (always in your knees axis) :

  • Bent your legs to have your thighs in horizontal. Your arms are straight, you take the barbell with a pronated grip. Your hands on the barbell are to your shoulders’ width. You have the possibility to have one hand with a supinated grip and the other with a pronated grip to prevent the barbell from rolling. And with this technique, you can lift an extremely heavy weight.

  • Inhale and block your breath. Arch slightly your back, squeeze your abs and you stretch your legs by straightening your torso to have a vertical position with your shoulder drawn back. Exhale at the end of the movement.

  • Put back the barbell on the floor by blocking your breath.

It’s important to keep your back straight during all the movement to avoid injury.

This exercise works especially quadriceps muscles and adductor muscles.

This exercise works less the back’s muscles than the classic deadlift because the back is less bent at the starting position.

Note

It’s important to lift the barbell in front of your shins at the beginning of the movement.

Do this exercise with light weights and high sets (maximum 10 sets) to strengthen the lumbar’s region by working thighs and gluteus.

If you do this exercise with heavy weight, you need to be careful to not trauma hips joints, adductors muscles, and lumbosacral junction.

The sumo deadlift is one of the 3 powerlifting’s movements.

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

-Steph

Please follow, like and share:

Understand How Your Workout Works In Your Body (Part 2)

body anatomy workout organs

I watched a Jamcore DZ’s video  and I learned good stuff.

If you didn’t read the Part 1, click here.

Knowing your type of morphology (ectomorph, mesomorph or endomorph) helps a lot to select a training program.

Morphology

morphology endomorph ectomorph mesomorph

Ectomorph

An ectomorph tends to be thin, and struggles to gain weight as either body fat or muscle. They can eat piles of food and stay looking the same, even when gaining muscular weight is their biggest goal. People who battle to gain muscle are often known as “hardgainers.”

Ectomorphs tends to have a lean build, long limbs, and small muscle bellies. Even if an ectomorph manages to put on weight, they may still look skinnier than they are, particularly in the calves and forearms.

Being an ectomorph doesn’t mean you’re doomed to be weak, though. You can still get remarkably strong, and you can be every bit as fit and healthy as someone who looks larger and more muscular. But if you want to gain weight, you’d better be prepared to eat like you’ve never eaten before.

Mesomorph

The mesomorph has a middle-of-the-road build that takes the best of both worlds. They tend to have wide shoulders, a narrow waist, relatively thin joints, and round muscle bellies.

In short, if you’re a mesomorph, you have a natural tendency to be fit and relatively muscular. Does this mean you can do nothing, eat everything, and get away with it forever? Definitely not—and you’re not necessarily healthier than the other two types, either. But you may be able to “bounce back” from being out of shape more easily than the other two body types, gaining muscle and burning fat with comparative ease.

Endomorph

The endomorph tends to gain weight and keep it on. Their build is a little wider than an ectomorph or mesomorph, with a thick ribcage, wide hips, and shorter limbs. They may have more muscle than either of the other body types, but they often struggle to gain it without significant amounts of accompanying body fat. If you ever feel like you gain 5 pounds simply walking by a donut shop, you may be an endomorph.

This definitely doesn’t mean that an endomorph can’t be healthy. They can be every bit as strong, healthy, and capable as the other two groups, and may actually have some strength advantages due to their additional muscle mass. But if and when they decide to lean out, it’ll take hard work!

If you don’t know your morphology type, you can click here .

It’s important to understand that our body is changing all the time due to the environment, age and food. That’s what this theory of Ecto, Meso and Endo is important for me to have results. I know there are people who don’t believe in this theory. My advise is to test this theory about yourself and see if it works or not.

There is also the skeleton and muscle genetics that influence muscle development.

You know, when I started to train seriously, my body responded well to exercises in the first year. I was happy, my body changed quickly. And all of a sudden BOOOOM, my body’s evolution stagnated. I started to worry and I think you know what I’m talking about.

Muscle mass

body anatomy workout muscle

Your muscle mass is decided by the stress that you will give to your muscle. The more you stress your muscle, the more it will respond. The more you rest, the more your muscle will respond. When you rest, your muscle recovers and your nervous system recovers. Understanding how much stress you put on your muscles is as important as knowing the difference between a set with high reps or low reps.

Look this example in my gym, click here.

You can’t walk around and talk to everyone in your gym like you’re in bar. The gym is not a bar ! When I started using the intensification methods, that’s where I really gain muscle.

Many people ask me if it’s possible to gain muscle and be shredded at the same time. The answer is that the first year of training, yes. In the beginning, you will gain muscle and burn fat, because you’re doing more intense physical activity than the year before.

But when you stop to train for more than 2 weeks , you have muscle atrophy and you start to store more fat.

If you spend several months without training, your muscles will turn into fat. The muscle is a tissue (soft tissue) and the fat is a tissue (adipose tissue). You understand !?! I know, I lost you and it’s the case for many people. The muscle and the fat are both cellular tissue.

It’s for this reason that you always need to continue to train because the more you train, the more you will gain muscle mass. And to gain muscle mass, you need to pay attention to your diet and recovery (sleep).

That’s the basis for gaining muscle. I know that on internet, there are several influencers like Christian Guzman , Steve Cook , Marc Fitt  who can say things that others dispute. But if you look deeper, there is only one way to gain muscle (regular training, diet and sleep), influencers explain only variants so don’t panic.

Conclusion

To explain it simply, you have your muscle and behind your muscle, there is fat. Fat is all the time waiting for the muscle works less to cover the muscle. The less you work on your muscle (muscle atrophy), the more the fat will cover your muscle. After several months without training, you will see in the mirror that you have lost your muscles. And you’re going to say : « Shit ».

Use a simple training program to understand the process for an effective training. It will be long. The 12-weeks training program is only a program that starts the process for your body to change, you need to train regularly all year long.

Stop listening to conflicting advice (it’s just for buzz), it’s the best way to stop you to have a better body. Choose a simple training program, adapt it to your schedule and use it all year long.

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

-Steph

Please follow, like and share:

Understand How Your Workout Works In Your Body (Part 1)

body anatomy

I watched a Jamcore DZ’s video  and I learned good stuff.

I will talk about the training or workout. It’s a simple subject but everyone is lost because of theories and training systems.

A training is a physical activity and we will return to the basic seeing the effects of a training in your body.

Why when we train we like to look at ourselves in the mirror and that makes us happy ? This is what we will see.

Training

training workout

Whenever we do an action, there is a reaction. When we’re training (lifting weights), there is an increase in oxygen consumption then, an increase in blood circulation and then, congestion of the muscle. Congestion depends on 3 important things : nutrition, H2O and muscle isolation.

Nutrition must be the best as possible. Water consumption must be high. Learning to master to isolate the targeted muscle during a exercise allows you to increase the possibility of having a huge muscle.

After the congestion (nutrition, H2O, isolation), there is sweat then, there is the release of hormones called endorphins. Endorphins will make you feel good. It’s happiness and it’s at this moment that you will look at the mirror to appreciate your body.

It’s the process of your body when you do a physical activity (training).

All training programs don’t work for everyone

training workout program

There are training programs that are good for you and some are not. To discover this, there are 2 principle :

  • Execution and mastery of the exercise

  • The experience that comes with time

These 2 principles aim to improve your ability to isolate muscle during exercise. Which means working the targeted muscle without the help of another dominant muscle. I wrote an article about it .

Joints

joints body

To master an exercise, it’s also necessary that you know your joints like oversupination, overpronation or valgus. Choose intelligently your exercises allows you to not break your joints (injury, tendinitis and muscle tears). Don’t do an exercise because someone told you it’s the best exercise in the world, choose an exercise adapted to your morphology.

For example for me, I know that I have the valgus , which means that when I do barbell curls to work my biceps, I have pain wrist. When I do barbell curls with an EZ bar, I have less pain. When I do dumbbell curls, I have no pain, it’s perfect. So for me, the best exercise for my biceps is the dumbbell curls and not the barbell curls because I know my joints.

Another example. When I walk, my feet are outside so when I squat my feet are outside and that’s happiness. If a person tells me that I have to squat with my feet in parallel because it’s the best position in the world, I could say : « Shut up, I know my morphology better than you because I have studied my morphology ».

The elements that influence the exercice’s performance are experience, joint’s flexibility and the respect of the biomecanics laws.

That’s why I’m telling you that you shouldn’t validate a piece of advice without having tested it on yourself. On internet, you can find video like « The 5 worst exercises ». These videos aren’t based on different type of morphologies, so they are not relevant information, it’s just to make buzz. If you want to work on your biceps, try several different exercises and keep the one that suits you best.

Here is another story. I watched a Christian Guzman’s video where he was doing the overhead triceps extension with an EZ bar. I did this exercise for 1-2 months and I noticed that I didn’t have a good feeling even if I had a good execution of the movement. I started looking for another exercise of the same type to work my triceps and I found the lying dumbbell triceps extension and now, it’s perfect.

I needed time to learn the exercise, realize that this exercise didn’t fit my morphology and find another better fit.

You may think I lost time testing this exercise for 1-2 months but I gained experience with this story. It’s by testing yourself the things you can know what is good and what is not good for you. Experience is the knowledge of things voluntarily acquired through pratice in the reality of life.

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

-Steph

Please follow, like and share:

How To Do Lying Leg Curls

lying leg curls anatomy

I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Lying on your stomach on the machine with your hands on the handles and your ankles under pads :

  • Inhale and bend your legs trying to touch your glutes with your heels. Exhale at the end of the movement.

  • Back to the start position by controlling the movement.

lying leg curls anatomy

This exercise works hamstrings, gastrocnemius and in depth popliteus.

hamstings anatomy lying leg curls

In theory, it’s possible to target the work on the semitendinous muscle and semimembranous muscle by making an internal rotation of the foot or to target the work on the femoral biceps, long head and short head by making an external rotation of the foot. But in reality, it’s very difficult that’s why it’s easier to target the work on hamstrings or gastrocnemius :

  • With the foot extended to target the work on the hamstrings

  • With the foot in dorsal flexion to target work on gastrocnemius.

Variant

lying leg curls anatomy alternative

It’s possible to do this exercise by flexing legs alternately.

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

-Steph

Please follow, like and share:

How To Do Quadriceps Stretchning

quadriceps stretching

I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Stand on one leg :

  • Take your ankle or your foot of your opposite leg.

  • Try to bring your heel closer to your buttocks by pulling upwards

This exercise works deep the iliopsoas and work a little bit the tensor fasciae latae.

To better feel the rectus femoris muscle (biarticular portion quadriceps), the thigh must be pulled as far back as possible. The quadriceps extension is naturally limited by the iliofemoral ligament’s tension.

Note :

To have a better balance, it’s possible to put your other arm on a stable object or a wall.

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

-Steph

Please follow, like and share: