Explanation Of The Challenge And Data

challenge

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

This is the 1st challenge. Use your web browser to go to superdatascience website  to download a data set. In the « Part 1 Visualization » section, click on « Offices Supplies » to download the file « OfficeSupplies.csv ».

data csv file

To organize myself, I created a folder « Visualization » with 3 subfolders. Each subfolder corresponds to the section of « Visualization ». I put the data set « OfficeSupplies.csv » in the 1st subfolder.

data csv file

« OfficeSuplies.csv » is a CSV file. A CSV file is a text file that represents an table but the elements separated by comma.

You can open this CSV file with NotePad++  for PC or with Sublime Text  for Mac.

On the 1st line (column title), we see that we have 6 columns. Each column separated by a comma and the file contains 44 lines.

data csv file

You can also open a CSV file with Excel, OpenOffice  or LibreOffice  to have a table, which is easier to read.

To open a CSV file with Excel, here are the instructions :

  • Open a blank workbook

  • Go to Data tab

  • Click button « From Text » in the general external data section

  • Select your CSV file

  • Follow the Text Import Wizard (in step 2, select the delimiter of your text).

data csv file

This data set contains data from a store that sells office equipment :

  • Order date – date of sale

  • Region – The store is in 3 region (East, Central and West)

  • Rep – salesperson’s first name

  • Item – product’s name

  • Units – product’s quantity

  • Unit Price – price per unit

Each line shows how many sales there were for a product.

The challenge is to help the manager to know who made the most sales per region in the period of this data set. The period of this data set is from July 2014 to June 2015.

The person who made the most sales in each region has a bonus and there are 3 bonus so 1 bonus per region.

It’s will this challenge that we’ll use Tableau Public.

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

-Steph

How To Do Dumbbell Shrugs

dumbbell shrugs

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

Stand with your legs slightly apart. Your head is straight or a little bent forward. Your arms relaxed along your body with a dumbbell in each hand :

  • Shrugs your shoulders as high and as far back as possible

  • Lower the dumbbells to the starting point

dumbbell shrugs rotaion

This exercise works the upper trapezius, levator scapulae and rhomboids when you press your scapulae together to shrug your shoulder to the rear.

Note

With heavy weights, the shoulder’s rotation becomes impossible.

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

-Steph

Body Under Construction 2017 09 30

body

That my evolution. The right photo (2014) and the left photo (2017), I have the same weight. The middle photo, I decreased my weight to have my muscle more visible. 

Each month I do my body check to track my body’s evolution with photo, measurements and body fat(%) to reach my Golden Ratio.

I take my results in the morning with my stomach empty or just a glass of water.

I calculate my body fat ( %) with the 1 site skin fold (fat caliper) and I use the caliper’s chart.

Current

  • Height : 175 cm (5 ft 8.8 in)

  • Weight : 80.9 kg (176.36 lbs)

  • body fat(%) : 10.5 %

  • Waist : 86 cm (33.85 in)

  • Chest : 98 cm (38.58 in)

  • Arms : 34 cm (13.38 in)

  • Forearms : 29 cm (11.41 in)

  • Shoulders : 119.5 cm (46.85 in)

  • Hips : 95.5 cm (37.40 in)

  • Thighs : 60.5 cm (23.62 in)

  • Calves : 40 cm (15.74 in)

  • Neck :38.5 cm (14.96 in)

Goals (Golden Ratio)

  • Height : 175 cm (5 ft 8.8 in)

  • Weight : 80 kg (176.37)d

  • body fat(%) : 8 %

  • Waist : 75.07 cm (29.55 in)

  • Chest : 107.25 cm (42.22 in)

  • Arms : 39.93 cm (15.72 in)

  • Forearms : 31.63 cm (12.45 in)

  • Shoulders : 121.47 cm (47.82 in)

  • Hips : 91.16 cm (35.88 in)

  • Thighs : 61 cm (24.01 in)

  • Calves : 39.61 cm (15.59 in)

  • Neck : 39.68 cm (15.62 in)

Websites where I found my Golden Ratio. Here  and there .

Websites where I calculate my body fat(%), here  and there .

And you ? Have you set your goals ?

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

-Steph

Be Curious And Effective

curious

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

I personally like to learn new things in different fields. Generally these are fields that I don’t know at all. This stimulates my curiosity especially when it’s something I don’t know and I see a lot of people using that. I think it’s the same for you.

That’s right, I’m curious and I like learning but how to be curious and learn a new thing effectively to use it as quickly as possible everyday ?

How long to learn

the right time clock how long

This is something that I’m always adjusting but there are some fundamental principles for it to work.

Here is an excellent example : speaking a foreign language. I hope (and if not, I advise you to learn another language) that you’re a person who speaks a foreign language at a level that allows you to have simple conversations.

Now do a little analysis. How long did it take you to reach this level to have simple conversations (a level that allows you to understand 80 % of a conversation or a text) ?

As everyone is unique in his/her method of learning, imagine that with effective learning techniques, it took you 2-3 years to reach the 80 % level of understanding in foreign langage. How much time do you think it is necessary to move from a level of understanding of 80 % to 99.9 %?

The truth is more impressive than you think. To go from the understanding’s level of 80 % to 99.9 % (the native’s level), it’ll take you 20 years !

You know, it’s not necessary to have a 99.9 % level of understanding to be bilingual. If you understand subtile jokes, you can consider yourself a bilingual. On the other hand, if everyone around you laughs and you wonder why, you aren’t yet a bilingual.

What is effective

effective

It’s destabilizing but it’s a reality, it’s faster to go from 0 % level to 80 % level than to go from 80 % level to 99.9 % level. This is the law of diminishing returns. This law works in all fields. This law is similar to the Pareto’s principle. The Pareto’s principle is the fact that 20 % of actions brings 80 % of results, 20 % of customers brings 80 % of the company’s turnover , etc.

This means that at one time, it’s more costly to learn the little things that remain to be learned in this field than to learn something new in another field.

Let us continue with the foreign langage’s example. It took you 2-3 years to get an understanding’s level of 80 %. In the next 2 choices, what’s the most interesting for you ?:

  • To spend 20 years to reach the 99.9 % level for a foreign langage

  • To spend 20 years to learn 6-10 new foreign languages at a level of 80 %

You see the number of opportunities you can create in your life by knowing how to speak several langages, it’s cool.

But there is a difficulty in knowing when the law of diminishing returns is put into action, This is a difficult question to answer because it depends on the individual and the field. It’s a personal expedition. We must also not confuse this with the « crossing of the desert » that everyone does when we start a new project.

The thing I do and I advise you is to track your progress to know when 20 % of your actions bring you 80 % of the results. With this tracking of your results, you can know everyday if you approach or if you move away from your goals. If you move away from your goals, it means that you have to adjust your strategy quickly.

When you have found a smart way to track you progress, it’s cool because you have an intellectual horizon, cultural horizon, tools, methods, strategies that are extremely varied and diverse that the majority of people. You have an effective toolkit that comes from an extremely varied horizon.

You can see in my blog’s articles that I speak of different field. I’m curious and I show what I learn by giving my sources because I find that being curious give me excitement to be alive. When you travel to a country where you don’t understand either language or writing, it’s exciting, right ? You can do the same thing on a daily basis by learning things in different fields.

Assemble different concepts

assemble assemblage

Now, let’s move on to the next level in curiosity. When you know extremely different fields, have fun connecting the concepts to each other. There is a type of creativity that involves linking concepts in a new way. Have fun connecting concepts that weren’t thought to be linked together and create something new. Look at how music evolves. You take 4 music’s types that nobody listen to, you mix all it and you create a new music’s type.

Today, we have the facility to have access to knowledge with books on billions of subjects. There are books on money, cooking, foreign languages, etc.

Attention, you need to learn in an efficient way with the principle of 20/80 and action (execution) everyday, no matter how difficult. If you learn all these things only to give you a good conscience and to impress your friends in discussions, you waste you time. It’s intellectual masturbation, it’s an illusion. It’s like this expression of Julien Greaux : « To be rich on Instagram, it’s like being rich in the game Monopoly ! ».

I hope that I motivated you to explore and learn new things effectively. And most important, you learn these new things to use them every day to boost your lifestyle.

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

-Steph

Squat Correctly (Part 2)

sqaut

I read a Nerd Fitness article  and I learned good stuff.

Click here to read the Part 1 

Barbell Squat

I know 3 types of squat and this is the best known : the high bar back (also named « Olympic Squat » or « Oly Squat »), the low bar back squat and the front squat. Maybe there are others but I’ll talk about the best known.

The difference is how you place the barbell.

Depending on how you place the barbell on your body, this will modify the squat’s mechanism and geometry. Which means that you will use your muscles slightly differently depending on how you place the barbell.

  • The Low Bar Back is a posterior chain dominant squat

    posterior chain muscle

  • The High Bar Back and Front Squat are a quad dominant squat.

Here a diagram form the book « Starting Strength » to better visualize the barbell’s placement.

diagram barbell placement squat strating strenght

Don’t worry, these 3 squat’s type work the same basic muscles. As you know each exercise has its variants. Now, you know the 3 variants of squat.

Go, find in your gym a squat rack,  a power cage or a squat stand  and place the barbell at the height of your clavicle. If you can’t do this and the height is too low or too high, choose the too low. I have never seen anyone lift on toe and with heavyweight, the accident is guaranteed.

power rack squat rack squat stands

As you read in my articles « Know how much weight to lift (Part 1 et Part 2) » [url link], it’s important to do a warm up with the barbell without weight. I don’t want to know how much you want to lift, do some sets with the barbell without weight to prepare your muscles and joints.

Low bar back squat

It’s the most popular squat’s type for beginners, general lifters and powerlifters. It’s also the squat’s type taught in the book « Starting Strength », one of the best book for beginners.

Once you have adjusted the barbell’s height, be in front of the barbell. Take a step to be under the barbell and grab it with your hands. For this squat’s type, you’ll use a thumbless grip so that your wrists aligned with your forearms.

Usually the grip’s width is near of the shoulders to create a meaty shelf to place the barbell on the muscles in our upper back (deltoid posterior). If you aren’t comfortable, you can have a wider grip. And with time, when you have more flexibility, you can have a grip near of your shoulders.

Here is the difference between a « wrapped grip » (left) and « thumbless grip » (right) : 

barbell wrapped grip thumbless grip

Once the barbell is on your back, stand up, contract your core (squeeze butt and abs) and step back. Normally, if you followed instructions well, you can only step backward. If you can take a step forward, you’re in the wrong direction.

This squat’s type is a posterior chain dominant squat and you’ll be able to lift heavier that the 2 others squat’s type.

High bar back squat

For this type of squat, you’ll start the same way but you’ll put your thumble around the barbell. This isn’t a thumbless grip.

The grip’s width is near of the shoulders to create a meaty shelf to place the barbell on the muscles in our upper back (deltoid posterior) like for the low bar back squat.

If you lack of flexibility to have a narrow grip, you can place the barbell 5cm (2inches) higher on your trapezius instead on your posterior deltoid. Which means that the barbell is placed almost on your shoulders.

Look the difference between a high bar back squat (left) and a low bar back squat (right) :

high bar back squat low bar back squat

Attention : the barbell placed almost on your shoulders and not on your spine. If you feel the barbell touching your spine, it’s too high and this can cause serious damage.

Place the barbell on your back and take a step back. Stabilize and tighten your core and squat down.

To do this squat version well, you need to keep your torso more upright. If you had difficulties to keep your torso upright with the bodyweight squat, it will be a little be more difficult here.

You can try, there is no problem but lift lightweight until you do it well to correct yourself. It would be a pity if your torso collapses and the barbell rolls on your neck (avoid this pain, really).

Front squat

For this squat’s type, you need to place the barbell in front of your shoulders. This squat’s type is quad dominant so you have to be able to keep your torso even higher than the high bar back squat.

Instead of stepping under the barbell, you place the barbell in font of you on your shoulder. To grip the barbell, it’s a little bit more complicated because you need to have mobility and flexibility in your wrists.

Front squat is done with a full grip around the barbell like the other 2 squat types but most people let the barbell roll on their fingertips (a three finger grip is enough). If you like’re me, you don’t manage to have 3 finders around the barbell, there are 2 variants :

Keep your hands to hold the barbell (if not the 3 fingertips is enough) and keep your shoulders high so that your upper arms are parallel to the floor. And squat down.

It’s important that you keep your shoulder as high as possible during the front squat. When you’re gonna squat down, you’re gonna feel the weight on your arms and it will probably correct your position, drop the weight otherwise you will hurt yourself.

What squat do ?

This is an excellent question. You’ll meet 2 clans that clash in the gyms : high bar back squat VS low bar back squat. Both clans have good arguments but that doesn’t help you make a choice.

The truth, test the 3 types and look with which you feel most comfortable, which you have the best technique and with which you can squat down the lowest (your hips joints lower than your knees). Once you have well studied and tested the 3 types of squat, you’ll find your type of squat.

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

-Steph

How To Do Barbell Shrugs

barbell shrugs

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

Stand with your legs slightly apart. You’re in front of the barbell which is on the floor or on a support :

  • Take the barbell with a pronated grip or a over-under grip if the weight is heavy. The spacing of your hands is your shoulder’s width.

  • Your arms are relaxed with you back straight and your abs squeezed. Shrug your shoulders.

This exercise works the upper trapezius and a little bit deltoids.

Note

When you lift heavy with a over-under grip, it’s advisable to change the hand grip to each set to balance the trapezius. Do a set with the right hand with a pronated grip and the left hand with a supinated grip and the next set the right hand with a supinated grip and the left hand with a pronated grip.

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

-Steph

How To Do Upright Rows

upright rows

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

Standing with your legs slightly apart and your back is straight. You hold the barbell with a pronated grip and the spacing of your hands is a palm’s width or a little more.

  • Inhale and you pull the barbell along your body to your chin by raising your elbows as high as possible.

  • Expire and return to the starting position by controlling the movement.

This exercise works mainly upper trapezius, deltoid and a little bit brachialis, brachioradialis, forearm flexors, abs, buttdock and sacrospinalis.

The more you put your hands apart, the more you work your deltoids and the less you work your trapezius.

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

-Steph

Stretching At The Bar

stretching bar back

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

Suspended at the fixed bar with the hands apart and with a pronated grip (thumb inwards) :

  • Inhale and exhale slowly focusing on the relaxation of your body. This allows you to relax your back and rebalance the pressure inside the intervertebral discs (the discs that connect the vertebrae to each other).

  • When you feel your muscles relaxed, lower you head forward to try to touch your sternum with your chin. This allows you to stretch the middle and the top of your back.

To increase the stretch, you can ask a person to grab your hips and pull you slowly down or you can swing slightly.

This stretching is essential. When you do it regularly at the end of deadlift, squat or other exercise that compresses the spine, this allows you in the long term to limit the deterioration of your intervertebral discs. This means that this stretch reduces the risk of spinal disc herniation.

Variant

With a tight grip, you stretch more the latissimus dorsi and teres major.

Note

When you do this stretch, it’s possible that you hear cracking of the spinal column followed by a pleasant sensation of release and relaxation of the back.

Don’t worry, these crackles have no gravity. It’s because of the relaxation of the paravertebrale muscle that allow the brutal decompression of the small intervertebral and costovertebral joints. This make the same effect as a suction cup that you take off.

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

-Steph

Install Tableau Desktop and Tableau Public

tableau desktop public data visualization

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

Today, I’ll show you how to install Tableau.

Use your web browser to go to https://www.tableau.com/ . On the homepage, there are several options of packages to be installed.

For the course that I do, there is the choice between 2 versions : Tableau Desktop and Tableau Public.

Tableau Public charged and of course, there is a trial version of 14 days. Tableau Public is free and is perfectly usable for this course because there are the same features as Tableau Desktop.

Install Tableau Desktop

Click on the « Try Now » button on the top right

tableau desktop public data visualization

Here there are 3 options : Tableau Desktop, Tableau Online and Tableau Server. What interests us is Tableau Desktop and for that we need to give an email. Once you gave your email, the installation file downloaded automatically.

tableau desktop public data visualization

Don’t worry, the download contains the correct version of the file. This will be a « xzy.EXE » file for Windows and a « xyz.DMG » file for Mac.

If this isn’t the right version that has been downloaded, you can always do this manually with these links.

tableau desktop public data visualization

As soon as the download is complete, you can watch tutorial videos in the « Get Started » area. It’s simple and intuitive.

Install Tableau Public

To install Tableau Public, it’s a little different because you have to go to another website. Use your web browser to go to https://public.tableau.com/s/.

Like for Tableau Desktop, you need to give an email to install the installation file automatically.

tableau desktop public data visualization

The majority of people who use Tableau Public are journalists or public organisations that do not have confidential data because Tableau Public data is on public servers. And as you know, data of a public server is freely accessible to everyone on internet.

Here the Tableau Public main graphic user interface.

tableau desktop public data visualization

Tableau Desktop and Tableau Public have the same structure, features and visualization layout.

But there are 3 differences :

  • With Tableau Public, you can’t extract data because your data is on a public server.

  • With Tableau Public, you need to make screenshots (printscreen) of your charts because you can’t export them.

  • With Tableau Desktop, you can connect to more file type and you can export your charts.

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

-Steph