Tips To Be More Productive

productivity, growth, increase, income

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

You know, sometimes I worked all day like crazy and at the end of the day, I felt like I haven’t progressed. Maybe you have already experienced this? That’s why I’m always learning new things to be as productive as possible. There are 2 books that help improve productivity and time management, it’s “Getting Things Done” and “Cut To The Chase” .

Here are tips from these 2 books to improve all this.

If a task can be done in less than 2 minutes, do it right away

Immediately make a task that requires less than 2 minutes has several benefits:

  1. Adding a task on your To-do list requires less than 2 minutes, it’s the same number of minutes as for a task that can be done right away.
  2. It’s more efficient to add the task that require more than 2 minutes on the To-do list, otherwise this list will be endless and unmanageable.
  3. Don’t make a task that requires less than 2 minutes right away can have disproportionate consequences in relation to the time needed to achieve it (like sending a confirmation or cancellation message).

So remember, if this task takes less than 2 minutes, do it now.

Warning

Sometimes you have to plan moments to focus only on a task or an important project. These specific moments shouldn’t be interrupted, even by a task than requires less than 2 minutes.

Try it so you don’t have any insomnia

Insomnia reduce productivity. Often the source of insomnia is malaise, bad mood, stress, poor sleep hygiene, etc. Insomnia can have serious consequences in the relation with others and can also cause road accidents, drowsiness, memory loss, absenteeism and the list goes on.

For chronic insomnia, it’s advisable to see a doctor for treatment. For transient insomnia (up to 3 months), there is an tip to free your spirit of thoughts that obsesses you.

Put a paper and a pen next to your bed. When you have a thought that obsesses you, you write it on the paper and beside you write the action you have to do to erase this thought.

Here is 2 example:

  • If the thought is: “I have to send a quote to this client”. You note on the paper: “Client quote => Look for supplier prices”.
  • If the thought is: “I have to lose weight”, you note “Lose weight => Look for a personal trainer”.

As you write down your thoughts and the action you should take, you should feel more peaceful.

Have an attitude “Let’s go see”

Sometimes, going on the field can help you learn more than analyze data on your computer. So the next time there is a problem, go see for yourself on the field. This may allow you to have ideas for finding a solution more quickly.

Don’t use a foul language in the workplace

foul, language,

It may sound like grandparent’s advice but it’s common sense. When you use a foul language, you can offend a person without knowing it. A person who doesn’t feel offended in the workplace is a serene and productive person. An offended person doesn’t want to work and wants to find another job. Many entrepreneurs have lost talented people because of their foul language without knowing it.

Not using foul language avoids conflict and difficult situations to manage.

When you do something, ask yourself why you do it

Often we do things out of habit, without wondering if it’s worth doing. This can waste time and energy and it would be better to stop doing this task or delegate it.

So regularly, ask yourself this question: “What happens if I delete this task?”. If the answer is nothing, stop doing this task. If the answer is something else, look if you can delegate this task.

Do it

No matter what dream you have, do it realize in your life. Here is a quote from Goethe: “Boldness has genius, power, and magic in it”.

Close the loop

has anyone ever told you, “Well call you back if there’s a problem”. And 2 week later you have no news and you wonder if everything works well. I know there is this quote: “No news is good news” but it’s frustrating t be in uncertainty. When a person doesn’t close the loop, it leaves others waiting and this can complicate relations. Don’t be like these people, stay in touch to avoid complicated situations.

Don’t let your smartphone become your master

With new technologies, we can stay in touch 24h/24h. But that’s not a reason for every smartphone notifications to be a priority. Sometimes I see people, every time there is a notification, they take their smartphone as if it was the end of the world. No matter where they’re and no matter what they do.

Define time slots and limits for the use of new technologies. Turn them off when you need to be focused for a task or meeting. Let others know that you no longer look at your emails and messages after a certain hour or weekends.

With that, you create a clear border between the moment you work and your private moments. It allows you to destress.

Personally, I turned off the sound for notifications from my smartphone. It’s really cool to do that, I’m more serene.

Save your computer file regularly

There are 2 types of users:

  • Who often back up
  • Who don’t back up until the day they lose important data

Losing files on a job you’ve been working on for months is very annoying. So backup often and take advantage to make copies at different locations (such as an external hard drive). With Cloud, you also have access to Google Drive and Dropbox which are very effective. Better to save than not enough.

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

-Steph

Create Frequently Content Boost Your Business

create content

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

Here are the benefits of creating content frequently.

Share techniques

share

I like to share the techniques, tactics and methods that I tested and worked for me and for others. As an athlete, I like to see my potential’s extent, I like to win and I like to see people around me win. It’s always frustrating to see someone who has a talent and isn’t fighting to realize their dream.

Often when I discover something in a book or someone shows me a technique that I test and that works, I want to say to the world « Look this technique works, try it right now ». That’s why I created my blog.

Challenges

I watched a The Family‘s video  (I wrote an article about it Part 1 , Part 2 and Part 3). I decided to publish 5 articles per week for several reasons :

As an athlete, I like to push my limits. Posting 5 articles per week has forced me to find themes that fascinate me so I can enjoy learning new things and writing articles about it. Every day, I’m looking for new things. There are articles I write and don’t published because I realize that it doesn’t fit my vision.

At the beginning of my blog, you can see that I write articles to introduce some bodybuilders and I stopped doing that because I decided not to talk about athletes using steroids. With challenges, it allows me to refine the vision of my blog and my failures are part of the learning process.

Frequency

frequency publication

From, 2014 to 2015, I published 1-2 articles per week. Toward the end of 2015, I watched a video about a 30-day challenge. After watching this video, I decided to write 5 articles a week for 30 days and after published 1-2 articles a week. During the 30 day challenge, it was difficult for me to write articles (find subjects and find the time to write texts) but my blog’s traffic seriously increased. When I took the rhythm of 1-2 articles a week, I felt less stressed because I had less pressure but my blog’s traffic of my blog had decreased.

I started to get frustrated because one of the important things for a blog is to have traffic. So, I started again this challenge of 5 articles per week during 30 days by writing only on topics where I have fun. My blog’s traffic increased like the first time. Frankly, it’s cool because I know that with this frequency, I can reach more people. And that allows me to develop my business. Yes, it’s possible to bring value to the world by bringing value to yourself, thus making money. Both are compatible.

Today, I have prospects and clients coming from my blog. People read my articles, it’s free and then they send me emails or messages with social media to find out if I can solve one of their problem.

Learn

With this frequency of publication, 5 articles per week, it allows me to accelerate my learning curve. You can see the difference of writing between my first articles and my last articles. I improved my writing style. All that, it took me a long time and I know that I have a lot of things to improve. And I also learned that success is something that builds little by little. There is no success in 3 months or 1 year. Success is a thing in the long run. You learn to make the difference between lies and truths to have a healthy life in all areas.

For 1-2 years, you can see I’m learning to make videos on Instagram and Snapchat. I make 5 videos a week. Since about 6 months, I make an audio file (podcast) on my old exercise articles. In this audio file, I read the article so that you can have the information in a passive way. You can listen to my audio file while driving, working instead of listening to music. Making videos and podcasts are things I learn to do for my blog.

Have fun

have fun

Sharing content frequently no matter the format, text, audio, video, it’s something that I do with fun. People are asking me how do I keep doing this for years. The answer is that I have fun when I do that. It’s like when I train or dance Cuban salsa. When I do that, I have fun and if I can learn something to improve myself, I do it.

I know there are people who create content to make money quickly but it doesn’t happen that way. You need to do this for 3-5 years for free to build your reputation and then you can afford to make money. That’s why it’s important to have fun when you do that because the difficulties come, you see them from a different angle. There is no cheat code so have fun.

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

-Steph

Connect Tableau to An Excel File

tableau connect excel file geographic map

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

Now that you downloaded the dataset in Excel file format, we’ll use Tableau to analyze this.

We’ll connect to the dataset using the « Excel » option.

Now that you downloaded the dataset which is in Excel format, we will use Tableau to analyze this.

We will connect the the dataset using the « Excel » option.

tableau connect excel file geographic map

Select the dataset in Excel file you downloaded and click on the « Open » button.

tableau connect excel file geographic map

And as you can see, there is only one tab.

tableau connect excel file geographic map

There is only one tab because in the Excel file there is only one tab. If in the Excel file there were several tabs, they would all have been listed here.

tableau connect excel file geographic map

It’s necessary to check that all data is « OK ». Scroll the lines and columns to see that. Everything is good, there are 10 000 lines as in the Excel file.

tableau connect excel file geographic map

Excellent, we connected our Excel source file to Tableau.

Now, click on the « Sheet1 » tab to access the Worksheet.

tableau connect excel file geographic map

tableau connect excel file geographic map

We’ll have a little fun.

For example, let’s look at what we have with « Geography »

tableau connect excel file geographic map

« Geography » is the dimension that gives us the country, so we’ll make a map to see where the clients from the bank come from.

Move « Geography » on this area.

tableau connect excel file geographic map

tableau connect excel file geographic map

Ah, it’s odd, nothing happens ?!? Why ? Look, when you look at « Geography », it’s not recognized by Tableau as a geographic dimension. Here,, you can see that Tableau recognized « Geography » as a dimension of type text with the label « ABC »

tableau connect excel file geographic map

Don’t worry, we can fix it quickly. Click on the arrow of « Geography ».

tableau connect excel file geographic map

Selects « Geography Roles » and « Country Region » so that the « Geography » dimension become geography’s type.

tableau connect excel file geographic map

Now you remove « Geography » made a table with a click-and-drag.

tableau connect excel file geographic map

tableau connect excel file geographic map

Look, we have a globe next to « Geography ». This means that Tableau recognize that « Geography » is a geographic dimension.

tableau connect excel file geographic map

Since « Geography » is a dimension of geography type, there are 2 new measures that have appeared : Latitude (generated) and Longitude (generated).

tableau connect excel file geographic map

Put « Geography » in this space with a click and drag.

tableau connect excel file geographic map

Look, this time there is a map.

tableau connect excel file geographic map

You have the possibility of zooming with these buttons.

tableau connect excel file geographic map

The map is fine but we’ll remove the blue dots and modify the map so that it’s easier to read.

We’ll color the countries and display the clients number that has in each country.

We know that in the dataset each line corresponds to a client. What we can do is use the « number Of Record », it means the total of number of observations. In this way, we can visualize the number of lines attended to each country and the number of lines attended to each country is the number of client per country.

Then, take the « number Of Record » and move it to « Colors ».

tableau connect excel file geographic map

Boom ! Each country has a color.

tableau connect excel file geographic map

Look at the color contrasts. France has a darker color which indicates that it is the country with the most clients. Germany and Spain have almost the same colors which indicates that they have almost the same clients number.

But we want to know the clients number per country without have the cursor on the country.

To do this we’ll add a label. Take « number Of Record » and moves it to « Label ».

tableau connect excel file geographic map

tableau connect excel file geographic map

We’ll increase the text’s size and put in bold. Click on « Label », click on « Font » and select « 12 » and bold.

tableau connect excel file geographic map

It’s cool, we can see the clients number per country. You have the possibility to zoom on a region. Click on « Zoom area » and drag and drag to select the region on the map.

tableau connect excel file geographic map

tableau connect excel file geographic map

Now we can see that the majority of clients are in France, this represents almost half of the total clients number of the dataset. Germany and Spain have almost the same number of clients.

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

-Steph

Dataset For Data Mining

dataset data mining

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

To have the dataset to do Data Mining, you need to go to the superdatascience website . In « Part.1 Visualization », you see the section « How to use Tableau for Data Mining ». Click on « Churn Modeling » to download the file.

dataset data mining

Once you have downloaded the file, move the file to the directory you created for the course. In this directory, create a new directory (unless you already do it) named « 2.Chunk investigation ».

dataset data mining

dataset data mining

Open this fiel with Excel or with other spreadsheet software.

dataset data mining

Know that we use this dataset for the visualization part but we will also use this dataset for the modeling part.

Let’s analyze the data of this dataset.

This dataset is quite large because it contains 10 000 lines and a few columns. This is the list of a bank’s client. The client information is :

  • Customer id (login)

  • Surname (last name)

  • Credit score ( is the measure that indicates the client’s ability to borrow)

  • Geography (client’s country)

  • Gender (male or female)

  • Age

  • Tenure -(the number of years the client is in the bank)

  • Balance (balance of the client’s bank account)

  • NumOfProduct (number of product that the client has in the bank – credit card, contract, account)

  • HasCrCard (does the client have a credit card ?)

  • IsActiveMember (did the client use his/her credit card during the last month ?)

  • EstimatedSalary (the bank’s estimate of the client’s annual salary)

  • Exited (did the client leave the bank ?)

Now, I will explain the context related to this dataset. This bank has branches in several countries like Germany, Spain and France. This bank noticed that lately there were many clients who left the bank. The bank has a report called « churn rate » which is the customers rate who leave the bank and for a few months the « churn rate » is really higher than usual. It’s for this reason that the bank needs a data scientist (you) to find the problem and propose solutions.

This dataset is a small sample of clients bank. These are 10 000 randomly selected client.

The column « Exited » is a column that didn’t exist before. This column has created when the bank realized that there was an abnormal number of client who were leaving the bank.

dataset data mining

Then the bank observed these clients for 6 months to see which client left the bank.

dataset data mining

In the « Exited » column, the number « 1 » means that the client left the bank and the number « 0 » means that the client stayed in the bank.

To analyze this dataset, you’ll need to do A/B Tests. For exemple, a classic A/B Test is to see if women are more likely to left the bank than men. That’s means, see the number of men who left the bank, see the number of women who left the bank and then normalize by the total number of clients. It’s important to normalize the number of clients because there are not the same proportions of women as men. Next, based on the last column « Exited », you’ll find out if it’s the men or women who are likely to left the bank.

Once you have relevant results, you can show your report to the bank. And with this report you should be able to propose solutions to the bank. For example, if the report says that women leave the bank in bulk, it’s because there is a problem and it’s necessary to see whether the bank is offering women something right. Or it’s possible that another bank offers a much more attractive offer for women or something else.

You will learn how to investigate in the dataset and find answer through client information with A/B tests.

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

Connect Tableau Public To A CSV File

tableau connect file csv data science

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

After downloading the file « OfficeSupplies.csv », you will open this file with Tableau. When you open Tableau, there is a « Connect » column :

tableau connect file csv data science

Click on « Text File » and open the file « OfficeSupplies.csv » :

tableau connect file csv data science

The connection manager appears for this source file :

tableau connect file csv data science

At the top left, there is « Connect » where the file is located and below it, there is « File » with 1 file. There is 1 file because you imported 1 file. I’ll show you later how to import several files of the same type.

tableau connect file csv data science

In the center, there is a window with the files you connected. And it’s possible to connect several files.

tableau connect file csv data science

For exemple, if you do a drag and drop here, Tableau will try to connect these 2 files.

tableau connect file csv data science

You can work with data comes from several differents files, different tables from different CSV files. We’ll see that later.

At the bottom, there is a preview of the file with columns and rows. Colums « Order Date », « Region », « Rep » and « Items » identified as data in text format. Columns « Units » et « Unit Price » identified as data in number format.

tableau connect file csv data science

Now you’re gonna go on the dashboard. To access it, click here.

tableau connect file csv data science

Here is the dashboard. 

tableau connect file csv data science

We will discuss the various function in more detail in the next section.

Now, I just want to show you that we have « Data » column with our source file.

tableau connect file csv data science

If you do a right-click and click on « View Data », you see the data as in the previous window.

tableau connect file csv data science

tableau connect file csv data science

You’ve seen, it’s simple to connect a source file to Tableau.

Wait, I’ll show you how you can connect more source files. Click here to return to the connection manager where you can connect several different files.

tableau connect file csv data science

Of if you want to stay on the dashboard, you can click on the top left on « Data » then « New Data Source ».

tableau connect file csv data science

Or click on this icon on the dashboard. Here are the files types you can connect to Tableau

tableau connect file csv data science

What is interesting with the « Statistical File » is that we can connect files type SAS, SPSS and R.

tableau connect file csv data science

We have access to different server with OData and others.

tableau connect file csv data science

It’s perfect, now you can connect a data source to Tableau and you’ll see later how to connect data faster.

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

-Steph