Explanation Of The Challenge And Data


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.


Company Creation And Taxes


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

It’s true that a frequent question, how to optimize taxation when we start a company.

Solid foundation


It’s extremely simple. Here are the 3 most important steps to do when we create a company :

  • First step => sell

  • Second step => sell

  • Third step => sell

The only thing that is important is to find customers who are willing to pay for your products/services. Everything else is superfluous.

Spend all your days looking for ways to pay as little tax as possible or have a Zen office to stimulate your creativity or create your website with the best design in the world, all this is superfluous. This is intelligent procrastination.

To grow your company, you need to find customers in the most efficient way possible.

Be profitable

profitable profit growth

The truth is that you’re going to ask yourself how you can optimize your taxes when you ask yourself: « Wow, I’m paying too much taxes now, I need to improve that ! ». When you ask yourself this, you’ll have ways to pay a specialist’s service. And it will also mean that your company is profitable, which is excellent.

It’s normal for an entrepreneur to minimize costs as much as possible to make the company profitable. But taxes shouldn’t be an obsession because it can make you forget the company’s mission. Your company isn’t profitable because you pay the minimum taxes. Your company is profitable because of the added value of your products/services.

So when you start your company, the 3 most important things are to sell, sell, and sell to have a profitable company.

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


Intention (Part 3)

 lose fat

Chad Fowler’s story (continue)


“I learned the basal metabolic rate (BMR), also known as resting metabolic rate and I was amazed at how many calories I should eat to stay the same weight. It was huge. As I started watching calorie in healthy food, I felt like someone who had just eating non-stop all day if I wanted to stay huge. The BMR showed that (1) it wasn’t difficult to cut calories and (2) I must have made BIG mistakes before properly consume these calories, not small. This is good news”.

“Then I learned that 4 000 calories equals about 1 pound (0.45 kg) of fat. I know it’s too simplistic, but it’s cool. Simplify is one of the next things I’ll mention as a tool. But if 4 000 is about 1 pound (0.45kg) of fat and my BMR makes it fairly easy to eliminate certain number of calories per day, it becomes quite clear how to lose a lot of weight without exercise”.


“Add in a calculation the number of calories you burn in 30 minutes of exercise, for example, and you can pretty quickly arrive with a formula that looks something like:

BMR = 2 900

Current intake = 1 800

Deficit from diet = BMR – current intake = 1 100

Burning with 30 minutes of cardio = 500

Total deficit = deficit from diet + 30 minutes of cardio = 1600 “.

“So 1 600 calories saved in a day or nearly half of 1 pound (0.45kg) of bad weight I could lose in a single day. So to round up, I can lose 5 pounds (2.2kg) in 1 week and a half without working too hard. When you are overweight of 50 pounds (22.6kg) that makes 10% of your goal rapidly and it’s real“.

A important thing which I referred earlier is that all these numbers are somewhat bullshit. And it’s cool to realize that it was possible to make these major changes. When you are 50-70 pounds (22.5 -31kg) overweight or just lose weight, worrying about counting the calories consumed or burned is inaccurate. The fact of the matter is that there are no tools available for normal people that will tell us exactly how much energy we will burn or consume. But the numbers will direct you to the right direction, you can make a big difference”.

clothe size men

“Here is another useful pseudo-science thing: apparently 10 pounds (4.5kg) of weight loss is roughly clothing size [XL → L → M]. This has been a huge source of motivation. I loved donate clothes all year and shop without guilt”.

clothe size woman

“As a nerd, I am too easily discouraged by data collection projects where it’s difficult or impossible to have accurate data. I train myself now to forget all these differences”.

“Add that knowledge was the basis to understanding the way metabolism works. The main things I changed : Breakfast with 30 minutes of walk and eat 5-6 times per day about 200 calories at each meal. How I measured calories I didn’t. I put up an exact meal plan for just one week, I buy all ingredients. From there, It not a complicated work. I am become aware of it, based on 1 week of how many calories were contained in different types of food and I just guest portions. Again, try to count calories too strictly takes a lot of energy and demotivating . Establish a rigid model for a week, then use it as a basic guide is more durable and fun”.

“Just a few more tips” :

“I set up an office where I could pedal a recumbent bicycle while I’m working. I did really, a part of the book The Passionate Programmer was written, I played video games, chat with friends and looked ridiculous TV shows. Here’s how I learned to maximize my time while I stay in my aerobic zone. I know a lot of creative people hate exercises because it’s boring. I was before in this camp (I’m no more things change once you agree) The bike / office was my savior, this mix with a measurement system”:


“I have a heart rate monitor (HRM) and I started to use it for everything. I use it while pedaling to ensure that even when I do it, I enjoy, even to play video games, it make me feel good. If you know your heart rate zones (easy to find on internet), the discomfort of feeling to not be a fitness expert is quick forgotten. 30 minutes in your aerobic zone, it’s a good exercise and burns fat. Calculate how many calories you burn (the good HRM will do it for you) and the experience is fun and motivating. I started to wear my HRM when I was doing things like boring tasks in the house. You can clean the house and quickly burns fat. It’s true. With the constant use of HRM, I could combine fun and exercises or boring tasks and exercises, making all this and more I became less lazy”.

build muscle

“Building muscle is, as you know, one of the best ways to burn fat. But geeks don’t know how to build muscle. And as I mentioned, geeks don’t like to do things they don’t know how that works. We like the data. We appreciate expertise. So I hired a trainer to teach me how to do. I thought I could let go of the coach after a few sessions when I had learned to do “good” exercises but I stayed with all year”.

“Finally, as I said a friend, my difficulty is to write my ideas for weight loss, I lack specific knowledge”.

use data

“To some extent, the answer is simple “diet and exercise”. There are no gimmicks. I just used the data that we all have access to and simply trusted biology to work its magic. I gave it a trial of 20 days and I have lost a significant amount of weight. Even better, I started waking up in the morning thinking about exercises because I felt good”.

“It was easy”.

It was easy for Chad through its Harajuku Moment. It worked well because he used numbers.

In the next section, you will have your numbers. That’s when the fun begins.