How To Reduce Stress (Part 1)

stress

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

I am doing a synthesis of the Dale Carnegie’s book “How to stop worrying and start living”  and other sources on internet for a blueprint to manages stress in 4 steps.

Stress is about change, it means adapting to the environment of a changing structure. Stress is a feeling triggered by the interpretation of an event. It’s a reaction related to the constraints and the pressure undergone in its environment. Stress can be interpreted as something positive, whether it’s considered a challenge or as something negative, if it’s considered a harmful event.

The truth is that stress is a mistake of reasoning in relation to the attitude or behavior we adopt. This is an answer that isn’t adequate. It’s an alert for mental dysfunction as the body gives us an alert for physical pain. Fortunately, people can learn to control stress in 4 steps : Take a step back and analyze what triggered the stress ; anticipate and visualize ; organize yourself and communicate and turn away or adapt and accept.

1st step – Take a step back and analyze

 

keep calm stress

 

It’s necessary to step back and analyze what triggered the stress. Because before trying to solve that, it’s important to know what caused it. By analyzing what caused the stress, we can avoid certain consequences.

To do that, here’s what you can do :

  • Make a list of sources of annoyance that you have in your family, friends, school, work, transportation, etc. Once you have found them, classify them from the most impacting to the least impacting. You can also do a 20/80 analysis, that means identify the 20% of the sources that bring you 80% of your stress.

  • Ask yourself these questions : « What is the problem ? What is the cause of this stress in these sources ? What are the most serious consequences that I suffer of my experience ? »

  • Understand the emotion that created in these moments. Then check if it’s a real fear or rather a theoretical concern that doesn’t have much to happen in your life.

If a situation is truly unavoidable, you need to prepare yourself to accept it. We must give up the impossible because it’s extremely stressful to have no way to change a situation. To avoid this, you need to anticipate situations that may lead you into an impasse. Once these situations identified, you must try to really avoid them or change the course of things from the start.

It’s impossible to keep control of all things in your life. It’s useless to set inaccessible goals.

2nd step – anticipate and visualize

 

anticipate visualize telescope

 

 

The best way to handle stress is to anticipate. Based on the list you made in the first step (source of stress), imagine solutions and possible answers. Ask yourself these questions : « Why did you agree to be in this situation ? ». If what you do make sense, it limits the stress.

Decide how you want to live a situation. An event that happens to you can have not effect on you until you choose words to qualify it. If you say that an event is happy, boring, sad or extraordinary, it can become so. By qualifying the event, you modify the perception that you have of this event.

The way you see the event determines your body’s reaction. So take a moment to think before judging and classyfying a situation as negative.

Take Olivier Roland’s example. When Olivier Roland began to meditate, his neighbor’s dog was barking. At first it disturbed Olivier to focus on his breathing, it was stressful and annoying. After a while, Olivier realized that it wasn’t the barking dog that was stressful, it was Olivier’s interpretation of the situation. From the moment that Olivier decided that the barking dog was something neutral or positive, he began to appreciate when the dog barks. It’s a sign of life.

Imagination can be used to help fight stress. Get in shape before a stressful event. You can create a positive state of mind when an event is negative. Think of something positive like music, a holiday, projects in progress. Visualize a happy moment, a happy memory.

This the end of Part 1. In the 2nd Part, I talk about organize yourself and communicate and turn away or adapt and accept.

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