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

Online Guarantee

online guarantee

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

In Europe (yes, I’m living in Europe), the law says that a consumer has 15 days to return a product he bought by mail. Products bought on internet are part of these purchases by mail as digital products, training or softwares.

The law also says that a consumer may waive the guarantee by checking or unchecking a checkbox to receive a product faster. Some companies have a procesure to wait until the guarantee’s period is completed before sending a product to allow time for the consumer to think about if he/she changes his/her mind.

The most interesting guarantee to make is a 30-day guarantee for online training. If you do a 1-year training, you can make a guarantee on results with conditions. If after 1 year, a person doesn’t have expected results despite that person has seriously followed and applied the training’s content by showing evidence, that person may claim the refund.

For the 30-day guarantee, there aren’t conditions. Whatever reasons, a person is systematically refund. It’s true that is interesting to know why a person wants to be refunded but it’s not obligatory.

A guarantee for success

guarantee for success

Yes, it help you to have success because guarantee is a trial period for the entrepreneur and the consumer.

Consumer

Many people are anxious to buy a product on internet, especially if the product is digital. The guarantee make it possible to reassure them.

People who have hesitated to take an online training will continue to hesitate for 30 days but more intelligently. Because the 30-days guarantee are free trial days so they can see how it works, how is the content’s quality, how the community interacts with coaches, how is the track’s quality of each participant, etc. If your product is good, you’ll have more sale than refund.

Entrepreneur

This allows you to filter out annoying consumers. If during the 30 days, you see a consumer who demands weird stuff or complains, criticizes all the time or isn’t polite, you can say it’s better to stop and pay him/her back.

It’s like for a job, the employer sees if the employee corresponds to the workstation and the employee sees if the job is suitable for him/her. This for both side and it’s a good method to avoid having unnecessary problems.

Attention

I don’t advise you to filter consumers when you start your company. You need to accept all consumers to reach your break-event point. Once you have reached a certain threshold of success, you can filter your consumers.

The guarantee is also a legal protection. When consmers aren’t happy, they leave, it’s simple.

Marketing

human behaviour

With marketing, we can see human behavior and there are some surprising things. Here an exemple with a form to receive an eBook. We can have 10 % more conversion when we fill in the first name and email of a person in the form. We can do it only if the person is subscribed to our newsletter but this is show how people are lazy by nature.

Yes, 10 % more only because people just have to press the button « OK » instead to type their first name and email, surprising !

Something else. It’s true that you’re going to have people who will just register to enjoy the 30 days free but reassure you, it’s a very small minority. Most people are honest and if you gave a product that gives value and quality, you’ll have more sale than refund.

It’s easier to use this kind of guarantee with digital product but it’s possible to do it with physical products.

How do you set up this type of guarantee for your product ?

-Steph

Know What We Want In Life

what you want

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

A lot of young and less young (30-50 years old) still don’t know what they want in life. It’s not something essential to succeed in life and be happy. But read this Seneca’s quote: « If one does not know to which port one is sailing, no wind is favorable ». Life can be more interesting when we know what we want to accomplish. When you take your car, before to go in your car, you know your destination. Do you already used your car without knowing the destination ?

I think it’s important that people know what they want accompish in life, what they want leave as inheritance or legacy. To do this, we need to find our passion, a passion that drive you to be better than yesterday.

I know people used different exercices to find their passion but they found nothing, it’s a failure and they’re frustrated. In my opinion, these people have just an exploration problem.

Exporation

exploration

Exlpore several activities is a great way to find a passion. It’s simple, how do you know you like an activity, if you have never tried this. May be you are an archery olympic champion but how do you know if you have never tried archery ?

I encourage you to do new activites, meet people, discuss with them and pratices to decrease the number of activites you don’t know. The truth is that your passion will not come to seek you.

Exlpore new activies, it’s good but don’t become addicted to exporation’s phase.

In a passion, there is 3 steps :

  • Exploration phase

    It’a like when we fall in love, everything is awesome, everything is beautiful.

  • Dry period phase

    For most people, it’s in this phase that they abandon. The enthusiasm of the beginning diminishes enormously. We spend a lot of energy for little result compared to a person who has done the same thing for 3-5 years.

    And it’s also in this phase where we must be careful to not be addicted to the exploration phase. For people who don’t like the dry period phase, they will find several excuses to change activity instead of holding on until to have good results.

  • Consecration phase

    It’s at this moment that we harvest the seeds that we sowed and generally success always exceeds us.

Project

project

Once we found a passion, have a project around this passion allow us to become a better version or ourselves. This project will allow us to get out of our comfort zone, to give the better or ourselves because we really want to succeed. The ideal is to combine a passion, skill and economic potential if you want to become an entrepreneur.

To test your project, I advise you to use « Lean startup » by experimenting in the field using little time, energy and money.

What is your last activity that you did and that you liked ? Do you plan a project with ?

-Steph