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

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

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 organizations 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

Have A Lot Of Ideas For Articles Or Videos

ideas

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

Here is an idea for having several ideas to create articles and videos. This idea is to write a book of at least 50 pages.

The concept is to share regularly with your audience your reflections and the development of your book.

While you’re writing your book, you’re going to learn new things because you really want your book to help people. It’s for this reason that you show your book’s content before your publishing it.

Maybe for you it’s something stupid because your audience can read your book’s content for free but here is the detail of the process.

Infinite source

When you’re writing a book, you’re in a research mood much more powerful and motivating than usual and your brain will look for ideas for your book constantly with information, scientific studies, case studies, etc. All this will stimulate your creativity to make articles or videos.

Share

share

Share your book’s contents as quickly as possible, allowing you to see how people react to a theme or a chapter. When you know people’s reaction, you can correct your content if you see that it doesn’t interest anyone or change the way you present or write that. There are also people who will give you additional information.

Share allows you to avoid losing 2 years of your life writing a book in your bedroom and on the day of publication, no one wants to buy it because it’s not interesting.

Now it’s up to you to choose the content’s type with which you are most comfortable, written or video version. As you know, each one has its advantages and disadvantages.

But it’s always possible to give an excerpt from your book on a theme and start doing trailer videos while waiting for the book’s publication.

Write your book

It’s really interesting to write a book at any stage of your entrepreneurial life (beginner of expert) and it’s easy to write a digital book (e-book). All word processors convert a text file into PDF and it’s really cool.

Share your book’s content regularly with you audience in a text or video format to update your book’s contents and meet the needs of your audience with a theme that interests you. In addition with this process, this will create you unexpected opportunities that will help your to grow your business.

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

-Steph

 

Squat Correctly (Part 1)

squat

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

I’m sure that in your gym, everyone says it’s good to do squat ? But who do your see really doing ? There’s not a lot of people, it’s weird, no ?

I do the squat on leg’s day but the truth is that it’s actually a « full body » exercice. « Full body » means that it’s an exercice that work several different muscle group at the the same time.

The squat mimics a lot of natural movement that you use everyday and if your goal is to gain muscle and lose weight, the squat is perfect.

What I see in my gym is that people who have never done squat are very intimidated and they use Smith machine to be reassured. But the Smith machine is very bad to do squat because it prevents you from making a natural move.

With this article, you’ll know everything about the squat and you’ll be able to do it without problem.

Why

how much why

The squat is one of the most fundamental functional movements of our lives.

Look at babies, they bodyweight squat quietly. it’s by growing that we stop doing squat and be on a chair for hours.

When you travel, you see in countries, people do full squat to sit and chat, it’s fun. There are even restroom where you have to do a squat.

It’s modern furniture and technology that make us want to do less squat but fortunately we can get back to basics and squat all life.

Squat is a movement that uses multiple joints, hip and knee joint. This is what we call a compound movement.

Squat is a movement that uses legs muscles, hips muscles, core muscles, back muscle, shoulder muscle and arms muscle. That’s why I told you it was a full body exercice.

What is cool with squat is that it increases your flexibility and it strengthens your bones, your muscles and your knees.

The fact that squat uses several muscle groups in your body, your body must increase your anabolic hormone production  to exercise the movement. This is cool because it helps to lose fat and gain muscle.

Strengthening strength in your knees and in your hips decreases your chances of having injuries in everyday life.

You saw, it’s really good for your body to do squat. Now, look at the different type of squat.

Bodyweight squat

bodyweight squat

It’s the simplest squat version, it’s the squat we used to do when we were babies.

Stand with your feet slightly wider than your hips. Your toes should point lightly to the outside, about 5 to 20 degrees outside.

Look before you and fix a spot on the wall in front of you. You’re going to look at this point while you’re squatting. You don’t have to look at ceiling or look at the floor. For me, it also helps me to stay focused.

Put your arms straight forward so that they’re parallel to the ground. Keep your spine straight. Your spine shouldn’t be rounded or too arched.

Be concentrated to properly distribute the weight on your feet. The weight must be on your heels and the ball of your feet. You must feel like you glued to the floor. With this technique you’re able to move your toes throughout the squat.

During the squat keeps your whole body contracted. Here we go.

Inhale, swing your hips back and push your butt back. You swing your hips back to bend your knees. It’s important to swing your hips back to begin the movement. If you start by bending your knees to begins the movement, the day you’re going to lift a heavy weight, you’ll quickly feel the pain and difficulty.

Continue to look in front of you by fixing the spot on the wall in front of you. Keep your back straight to have your spine in a neutral position and your chest and your shoulder up.

Get down

As you go down, stay focused so that your knees are aligned with your feet. I remember that when I started squatting, I had to concentrate on not having my knees inside my toes. When this happened, I would push my knees out to be aligned with my feet. Of course, your knees must not exceed the width of your feet.

Imagine you have a Start Wars light saber on your knees. The light saber should be between your second and fourth toes, it’s a little trick to help you have your knees aligned with your feet.

Squat down until your hips joints are lower than your knees, this is the parallel position. It’s necessary to look at the hips position and not the thighs position because the thighs size can be different from one person to another. If your hips joint aren’t lower than your knees, you do a partial squat.

Once you’re down, it’s time to get back on your feet.

Get up

Continue to have your whole body contracted and push on your heels and keep your feet on the ground as well.

Stay focus so that your knees are aligned at your feet like when you get down and contract your butt up to be sure to use your glutes.

The most important thing is that you have to keep your body and your core contracted all along the squat. It’s important to learn to do this right away because the more you lift heavy, the more it will help you to have a good body’s position during the squat.

Note :Every human being has a unique body so none of our squats will look perfect. A person who has a short femur  will have a slightly different squat than a person who has a long femur. And it should be added that many people are working to improve their mobility problems. What I mean is that if your squat looks different from the person next to you, it doesn’t mean you’re doing it wrong.

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

-Steph

Data Science Domains

matrix

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

In Science, there are several domains. In Data Science, it’s the same.

data science domain

Data Science is composed of 3 fields : computer science, math and statistics and domain knowledge. But for some years, this changed a bit. Data Scientists need to have other skills than programming and statistics.

Look at this new diagram :

data science domain

Let’s look at these skills in detail.

Statistics

Data is the basis of the Data Scientists so they must be able to filter the data to have relevant data that will provide them with insights. This allow Data Scientist to build models to classify the population and make reliable forecasts of future events.

Visualization

Do you know the computers langage ? Do you know bytecode like « 00100010100101010110 » ? No and it’s the same for me. It’s for this reason that Data Scientists must have the ability to see through the data and especially show them to others. This is why visualization is an important skill to show the data.

Data Mining

This is the part of the work where the Data Scientist has to make the detective like Sherlock Holmes. It’s in this phase that we must look in the data for insights and abnormalities.

Database and Data process

It’s simple, the Data Scientist cleans the data, stores and processes the data in the database.

Pattern recognition, Machine learning et Neurocomputing

These 3 disciplines help explain to computers how to learn do to a specific task on its own. There are not things I’ll learn but these are interesting disciplines for some business problems.

In our world where competition is increasingly aggressive, technical skills are no longer enough. Here are other skills that Data Scientist need to have.

Communication

communication

Data Scientists need to interact with people everyday. They have to do that because the insights are not just in the data. There are insights that we can only find by talking to people. That’s why it’s important to not afraid to talk to people to ask them questions on a daily basis.

Presentation

This is another type of communication . In this case the Data Scientist doesn’t try to extract information but to explain what he/she found to the people. This is a very important skill because the Data Scientist is the intermediary between insights and people. It’s a bit the data translator, it’s simply explain the content of data.

Domain knowledge

Data Science can be used in any industry. One day you can do research to find fraudulent transactions and another day you can build a compensation model for employees of a medical establishment.

That is why, in what industry you work, you must do research and know quickly the necessary part of the industry. The rest will come naturally. Quickly learn the basics of the industry where you work.

Practice in real situations

Proverb : « It’s by forging that one you become a blacksmith » says everything. This concept is extremely applicable in Data Science.

Programmation

The 2nd basic domain of Data Scientists. The better you talk to your computer and the more efficient you are, the more successful you will be. If you don’t know how to program, learn this from today. Programming has to become a hobby, something you like to do.

Creativity

This is what make the difference between Data Scientist and Data Analysts. To become an excellent Data Scientist, you need to work your creativity. Be curious and you will find insights that nobody would never have found.

Now you know the skills needed to become an excellent Data Scientist. As you see I have a lot to do.

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

-Steph

Studying Success

study success

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

Here a quote from Jim Rohn : « Success leaves clues».

In all areas, you can study how others have succeeded.

To understand the concepts of studying success in a good way, I’ll take the magician’s exemple. A magicien make a show in front of thousands of people and what happens is that thousands of people see things that doesn’t exist and doesn’t see things that exists. Thinking about that, we’re always impressed by the magicien show because they do things we have never seen.

How learn

be interested in

Studying success is the opposite. You need to see the things that exist but are hidden and not let you blinded by illusions.

To be able to study success successfully, there are a few tricks :

  • Read biographies or autobiographies of successful people in your field. It‘s even more interesting to read the biography after the person is dead because the hidden elements are revealed.

  • You can meet successful people if they’re still alive to ask questions or participate in a seminar.

Collecting the knowledge of successful people will help you speed up your success.

Techniques subtleties

study success

It’s like when I learned a Pencak Silat’s technique (Indonesian martial art). My teacher showed me a technique and I said to myself : « Oh, it’s easy ! ». After 3 attempts, I realized that it was difficult. I couldn’t perform this technique and I didn’t understand how to do it.

After a few minutes, I asked my teacher how he did that. You have to know ask for help to unlock a situation and not take it as a weakness.

My teacher explained to me that brute force wasn’t the most important element in this technique. You have to know how to use gravity and angle. Click, I had the technique and even I was surprised by the result. But my technique is much less fluid and « aesthetic » than my teacher (it’s nice to see when my teacher does this). I still have a lot of work to do.

Focus on things that exist and stop being disturbed by illusions (newspapers, magazines, gossips, etc). Look for the source by being in direct contact with people who are successful in your field.

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

-Steph