Infopreneur

infopreneur, internet, information, product, laptop, entrepreneur,

What’s up ? This is THE stephane ANDRE !!! I watched an Olivier Roland’s video and I learned some good stuff.

I discovered what it was an infopreneur by reading Tim Ferriss‘s book « 4-Hour Workweek ». It was a book that was recommended in a personal development’s blog and this book has completely changed my way of seeing a « job ». This is definitely a point of view that we don’t learn at school, even at business school.

The profession of infopreneur is a very interesting profession and evolves all the time because of new technologies. In fact, if you don’t know, an infopreneur is a person who earns money on internet with information products. These information products aren’t news but they’re information to help people achieve a goal on a specific area.

What is special about this job is that we enable people to be more effective in things that are important to them and the result is that they’re happier.

Workplace

One of the advantage of this job is geographical freedom. The company is based on internet, which means that you only need a computer and an internet connection to work. There is no obligation to go to a workplace, you can work every day in a different place or in a different country as long as you have access to an internet connection. There are more and more jobs that allow you to have this freedom like programmer, virtual assistant, bookkeeper, data entry, copy writing, translator, travel agent, transcriber, etc.

It’s a profitable business because selling information on internet makes it easier to reach a large number of people with little money.

Distribution

internet company

Imagine how it was to sell a book before the invention of printing. Even if you had written the best book in the world, it was hard to live on it. Imagine, so that 2000 people can read your book, you needed 2000 handwritten copies of your book. Copying books was not a really cool job, so you can imagine how complicated it was. If you offer me a job that consists of copying 2000 books of 300 pages, I’ll answer you : « No, thanks !!! ».

With the invention of printing, authors started earning more mony because more people could read their books and that to increase later with the invention of copyrights.

With digital books (ebooks), it’s possible to sell 100 or 1 000 000 books without the huge costs of printing, distribution, storage and return management. There are still costs but they’re very low for the servers and the support (for example a client didn’t receive the email to download the ebook).

With internet, it give you the opportunity to manage the distribution of your information products yourself. Before internet, you had to have an appointment with a manager of a radio, television to reach as many people as possible. If this manager liked your work, you could have ads on radio, television but if this manager didn’t like your work, no ads.

Many talented people couldn’ have a great exposure to make known their talent because of these « Gatekeepers ». Internet allows you to no longer need to these gatekeepers to reach a large number of people.

If you want to know more, I advise you to read this article that I wrote. Click here .

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here.

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

Export Worksheet

data science tableau export worksheet chart

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

Now is the time to learn how to export your worksheet as an image in another document.

You have made an excellent report that can be shown to your customers or your managers and you need to export it in a Word, PowerPoint or other document.

The only way to do with the free version of Tableau (Public Tableau) is to make a snapshot (printscreen).

In the paid version of Tableau, there is a function to copy the bar chart with a right-click.

But before doing this, it’s necessary to change the worksheet’s title because at the top of the bar chart, you can read the title « Sheet 1 ».

data science tableau export worksheet chart

« Sheet 1 » is the tab’s name at the bottom of the screen.

data science tableau export worksheet chart

To change the tab’s name, you do a right-click on it and you select « Rename Sheet ».

data science tableau export worksheet chart

You rename the tab « Annual Bonus Analysis ».

data science tableau export worksheet chart

You have the possibility to put the title visible or not on the bar chart. Click on « Worksheet » and activate/deactivate « Show Title ».

data science tableau export worksheet chart

The worksheet’s title is at the top of the bar chart.

data science tableau export worksheet chart

You can edit the title by double-clicking on it.

data science tableau export worksheet chart

If you want to change the title border, do a right-click on it and select « Format Title ».

data science tableau export worksheet chart

On the left, a tab appears to change the border.

data science tableau export worksheet chart

If you want to change the text’s format, you need to double-click on « Annual Bonus Analysis ». A window appears to change the size, etc.

data science tableau export worksheet chart

To export the bar chart to a Word document, do a snapshot or a print screen with the PrintScreen key (PrtSc) or Command+shift+3 for Mac on your keyboard.

Personally, I use the Paint.net software  to remove unnecessary elements from the image.

One you saved the bar chart’s image, you insert or paste this image into the Word file.

data science tableau export worksheet chart

In this image, you can see that the bar chart’s title is « Annual Bonus Analysis » instead of « Sheet1 ». It’s perfect for presenting to your clients or managers.

Then you can add text below the bar chart to present your insights.

To export the bar chart into a PowerPoint document, it’s the same principle. Do a snapshot or a print screen with the PrintScreen key (PrtSc) or Command+shift+3 for Mac on your keyboard.

Then you remove the unnecessary elements of the image.

data science tableau export worksheet chart

Once you saved the bar chart image, you insert or paste this image into PowerPoint file. Be sure that the title on PowePoint is at the top of the page otherwise the title will be under the image.

data science tableau export worksheet chart

To save your workspace, click on the « File » menu and select « Save To Public Table As… »

data science tableau export worksheet chart

« Tableau Public Sign In » appears to connect to your account.

data science tableau export worksheet chart

A tab will appear on your web browser to display your Tableau Public account and you can see your workspace saved on the server.

data science tableau export worksheet chart

Caution, Tableau doesn’t automatically save your work so it’s up to you to save regularly.

This section is now closed. We made an introduction to Tableau with a simple dataset to discover functions like calculated field, add colors, add labels and how to format.

Now you know the basics of Tableau and later we will use complex functions.

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

-Steph

Add Color

colors

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

Podcast:

In the last article, we created our calculated field « TotalSales » that you can see in «Measure » zone.

In Tableau, the calculated field is very used (almost every time) because in most case the data don’t give the value you want to show.

The calculated field « TotalSales » is a simple example to make you understand how it works but know that you can do things more complex. I’ll show you that later.

In this article, I’ll show you how to manipulate colors because it’s an important element to communicate. With colors, people will understand more quickly what you want to explain to them.

Imagine that you have to show this bar chart to the manager who handles the bonuses. By putting a little color, a little art, you could improve the reading of this bar chart.

To use colors, click on this button.

data science tableau color

You can change the color with the basic colors.

data science tableau color

Or you can have more colors by clicking here.

data science tableau color

If you have a picture in the background, you have the possibility to change the opacity to have a transparent effect of colors.

data science tableau color

You can add a border, change the border’s color, etc.

data science tableau color

But what would be nice to do is to have bars with different colors.

To start, take « Rep » and move it on « Colors ».

data science tableau color

With this, there is a unique color for each representative.

data science tableau color

There is also another method to do that. Instead of taking « Rep » and moving it to « Color », you can click « Rep » here.

data science tableau color

If you move it to « Colors », you’ll break everything because « Rep » will no longer be in the « Columns » zone.

data science tableau color

To avoid this, press Ctrl or Command on your keyboard and click « Rep » to make appear the sign « + ». Now that you made a copy of « Rep », move it to « Colors ». It’s like making a copy/paste from « Rep » to « Colors ».

data science tableau color data science tableau color

With this method, « Rep » is always in the « Columns » zone. This is a method that is very practical when there are many dimensions.

It’s possible to change representative’s colors by clicking here.

data science tableau color

As you can see, there are several choices of palettes.

data science tableau color

You can test the « color blind » palette which is very useful for color blind people. To select this palette, click « Assign Palette » and « Apply ».

When a palette has fewer colors than representatives, you will have a message saying that some colors will be duplicated. But this is not a problem because there are names below the bars.

data science tableau color

Now we want to see something else with our bar chart. Press “Ctrl” or “Command” on your keyboard and click on SUM(TotalSales) to display the « + » sign. Then move SUM(TotalSales) to « Colors » to replace « Rep ».

data science tableau color data science tableau color

As you can see SUM(TotalSales) has different colors. The colors are on a continuous basis which means that the more sales there are, the darker the color.

For our case, this is not useful because the size of the bars represents the sales number but for other situations, this is useful.

The problem now is that there are duplicate colors and because of this, the Manager could misinterpret the results. An alternative approach would be to ensure that the Manager understands the results.

The solution is to take « Region » (by pressing “Ctrl” or “Command” on your keyboard) and move it to « Colors ».

data science tableau color

You can also take « Region » (with “Ctrl” or “Command”) and move it to SUM(TotalSales) to replace SUM(TotalSales).

data science tableau color

With that, the bars are colored by region.

data science tableau color

That way, you can clearly see the 3 regions through colors that are unique to each region and you can see the total sales per representatives with the size of the bar.

This is a small example so that you can understand the basics to manipulate colors in Tableau. There are still more complex techniques to manage the colors that I will show you later.

Plays with the colors so you can fully understand how it works. You could find your favorite palette and find your style. Have fun.

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

-Steph

Navigate In Tableau

front boat

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

We’ll explore Tableau’s tools

From the connection manager, we’ll go into the Tableau’s workspace.

Click on the « Sheet1 » tab at the bottom of the window.

data science tableau screenshot

Here is the Tableau’s workspace.

data science tableau screenshot

The 2 important elements of the workspace are « Data » on the left and the workspace on the right. It’s in the workspace that you’ll create tables and charts.

We’ll start with « Data » on the left.

data science tableau screenshot

« Data » divided into 2 zones : dimensions and measures.

The dimensions and measures are 2 different rules that will allow you to manipulate data.

Tableau sets the numerical values in « measures » and the categorical or quantitative variables in « dimension ». This is the Tableau’s settings by default.

There is also another way to explain « dimension » and « measures ». The « dimensions » are independent variables and the « measures » are dependent variables.

For exemple, « Units » is a measure, it’s the number of items sold per product. « Region » is a dimension, it’s the geographic region where the product sold. With 2 elements we can know how many items sold by region. This means that « Region » is an independent variable and « Units » is a dependent variable because it will be grouped by region.

But if you don’t like it, you can move the entities between dimension and measures and the opposite by click and drag.

In the menu bar, at the top, there is « File » where you can open and save file.

data science tableau screenshot

« Data » to connect to new source files.

data science tableau screenshot

« Worksheet » is the workspace to create analyzes

data science tableau screenshot

« Dashboard » is a combination of worksheet

data science tableau screenshot

« Story » is a combination of worksheet and dashboard

data science tableau screenshot

« Analysis » to specify how you want to do your analysis on your workspace

data science tableau screenshot

« Map » to add maps to the workspace

data science tableau screenshot

« Format » contains formatting options

data science tableau screenshot

Now, let’s study the workspace.

In the workspace, the main elements are « Columns » and « Rows ». This is where you decide which data goes in columns and rows in your worksheet.

You can also choose different format for these elements like colors, size, text level of detail and tooltips (useful tool optional).

data science tableau screenshot

Let’s do a test. Use data from « Region » (which is in « dimension »). Move « Region » with a click and drop to the center of your workspace. Now, « Region » is in the element « Rows ».

A table appears in your workspace.

data science tableau screenshot

You put a dimension in your workspace. Now put a measure in your workspace.

Uses the « Units » data. Move « Units » with a click and drop next to the « Region » column.

data science tableau screenshot

As you can see, Tableau automatically put « Region » in the « Rows » element and the « Units » data aggregated by region. In this way, you can tell how many items were sold by region.

Now, what you can do is to move « SUM(Units) » to the « Columns » element.

data science tableau screenshot data science tableau screenshot

And then, you have a « bar chart » to see how many items have been sold by region. You can enlarge the graphic with a click and drop.

Let’s look at the tools that are in « Show Me » zone.

data science tableau screenshot

Click on « Pie chart » to have this chart’s type.

data science tableau screenshot

Click on « Size » icon and drag from left to right you can increase the chart’s size.

data science tableau screenshot

In this chart, each region has a color and proportion of items sold by region.

You can also test the « bubble chart ». Tableau organizes the data automatically and everything and placed in the « Marks ».

data science tableau screenshot

You can test « Treemaps » chart. This is the same principle as « bubble chart » but it’s rectangles instead of circles.

data science tableau screenshot

As you can see in « Show Me », there are charts disabled. This is because you need some elelments in your data to be able to activate them.

For example for the « Area chart », you need « date »data to activate it.

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

-Steph

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

Being An Entrepreneur Is Being A Student

entrepreneur student entrepreneurship

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

I see a lot of entrepreneurs make this mistake. They create their companies based only on their technical skills. A good baker who create his/her own company is a excellent start but we must not forget the second part of the equation. When you create a company, you need to learn a second job, entrepreneur (CEO and manager).

Technical skills aren’t the same as the entrepreneur’s skills. A person can be very good technically in his/her job and bad as an entrepreneur. It’s important to spend time learning entreprenarial skills needed to avoid bankruptcy.

To be seriously trained as an entrepreneur is important. I think in your country there are mandatory training course for business start-up. Unfortunately, these courses last only a few days and it’s not enough.

It’s true that it’s complicated because there are no good academic trainings on entrepreneurship. By example successful business rate created by business school students is about 10 %.

Books

book

I think it’s possible to train ourselves at the core of entrepreunarial skills with books. The Personal MBA’s list  is a good start.

Did you see, the list is long. I advise to read these 3 books to start more easily.

« The 4 Hours Workweek » is a way of seeing entrepreneurship in another way. This book breaks the codes and allows you to have a more open mind to have more opportunity.

The Personal MBA is a summary of the essentials of what you need to know to build your company. The book is excellent but the problem is that it lacks coherence, which makes is a bit difficult to imagine how to use these concepts in your company. But don’t worry because with this book you’ll have the theoretical knowledge that 90 % of entrepreneur don’t have.

« The Ultimate Sales Machine » explains how to set up an effective system for sale in your company.

With books, you can have acces to the best brains for cheap, it’s cool.

Meet others entrepreneurs

meet people

To create opportunities for you, I advise you to meet creation of company’s organizations in your city.

The ideal is to make a combination of books, training (online and offline) and meet entrepreneurs. It’s a mix of theory and execution. You know, you can have all the theory of the world, if you don’t act, you will not able to change things. This is why that it’s motivating to meet entrepreneurs, precisely entrepreneurs who are more successful than you so that you can always remain motivated despite obstacles.

It’s like in sport, all athletes want to become world champion or Olympic champion. Having this state of mind in entrepreneurship is excellent. I hope you want to become the best in your market.

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

-Steph