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

Accidental Genius

genius, badge

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

There is an interesting book by Mark Levy named Accidental Genius . This book explains a method to unleash your creativity and brain’s power to find solutions to your problems.

This book doesn’t speak to the fact that supposedly we use only 10% of our brain but rather that we underestimate an important thing, write what we think. When we think without written support, we deprive ourselves of an enormous source of structuring thoughts. Our thoughts go further and more structured when we think in writing than when we think in our head and we forget those thoughts very quickly.

Unfortunately, there is a difficulty. It’s that we write very slow compared to the speed we think. But Mark Levy has a method to overcome this difficulty, it’s free writing.

Free writing

write, pen, free, writing

Choose a problem that takes your head, take a piece of paper or open a document on your computer and start writing all that happens in your head.

For exemple, if you wan to start a company, the problem can be : « how can I start a profitable company as soon as possible ? ». Like a brainstorming, you write a maximum of idea in a minimum of time. To ease this process, ,you write without paying attention to grammar, vocabulary, syntax, punctuation, etc. You write with lots of mistakes to make it fluid. Anyway, you don’t write for someone, you write for yourself so you can let go, write whatever you want.

When you have a moment where you block, keep writing. You can write 40 times the same word, it doesn’t matter. As you continue to write, you will force your brain to find other ideas and to return to the flow of thoughts. It’s advisable to do this for 10 minutes.

I tested this method and it’s surprising but I have to use it more often to develop this skill. What I like with this method is that I can use it for all areas of my life and it takes 10 minutes in the day.

My question is, are you also going to test this method or are you one of the people who reads my blog to make yourself feel good ? What are you doing ?

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 .

Emotionally Manage Negative Reviews

emotionally, manage, negative reviews, excellent, good, average, poor, worst

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

When we have company, we read customer reviews to improve the products/services. But we have a way of thinking that can hinder the company’s evolution. Here is an example, for a product the are 10 positive reviews and 1 negative review. The problem is that the entrepreneurs will think 1000 times more about the negative review rather than 10 reviews positive.

Bad comment

emotionally, manage, negative reviews

To change this way of thinkging, it’s necessary to understand that this is part of human nature. We have been educated by evolution to focus more on negative things than positive things. And yes, our ancestors lived in an unstable environment during the vast majority of the existence of the human being. Here are some examples :

  1. Our ancestors were very attentive to the elements that were partially negative. They could be very happy, have a great day but they had to pay attention to the powerful animals that could, by surprise, kill them.
  2. Our ancestors had to pay attention to the disputes that had in the village because these disputes could deteriorate the village’s stability. This can result in creating friction that undermines trust in terms of collaboration for survival.
  3. Our ancestors were never satisfied with their situation and this motivated them to improve their lifestyle through science.

Solution

emotionally, manage, negative reviews, positive

As you’ve seen, this is a way of thinking that we have in human nature and there are some tips to avoid being obsessed with these negative reviews. I propose 3 solutions :

  • Ignore them. The more negative reviews you see, the more you’ll be desensitized to that. It’s not very complicated because if your company is working well, you have few negative reviews.
  • Delegate the management of reviews to a member in your company. This allows you to avoid being on the front line in the emotional impact to be less affected. It’s true, this solution have a problem. It creates distance between the entrepreneur and the customers feedbacks. It’s for this reason that it’s recommended to set up a procedure for the member who handles the reviews saying : « From now on, it’s you who manages the reviews. The thing I would like you to do is that you only transfer negative constructive reviews to me ». Negative constructive reviews are the criticisms where you see the urge to help.
  • Create an email address only for positive reviews. For example, you can name this email : « positivereviews@yourCompanyName.com » and tell to the person who manages the reviews that each time he/she receive a positive reviews, he/she send it to this email. You can also tell to this person to make a screenshot of a positive review from social media and send it to this email.

With this email address, you create the email of happiness. This will be useful for moments of demotivation and doubt. If, for example, there is an negative reviews that makes you feel bad and you think about it several hours later, you can log on this email, read positive reviews and realize that you’re doing a good job. It’s really a special feeling to know that you’re changing the lives of many people. It’s really fantastic and it allows you to relativize.

It’s possible to make a combination of the 3 solutions. It means, you force yourself to read the negative reviews to desensitize you ; you delelgate part of the process to manage the reviews ; you create a magical email as a psychological support.

These solutions allow you to put things in their place so that you don’t get overwhelmed by negative emotions.

It’s possible that you know of other methods to handle negative reviews, if it’s true, share your method with us in the comments section.

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.

When Your Internet Company Is Not Working

internet company

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

Here are some tips to improve your situation if you want to have an internet company or you already have an internet company. These principles are basically intended for infopreneurs, it means selling information products (ebook and online training) but over time all companies should use these principles to boost their reputations.

In an internet company, there are 3 pillars : traffic, authority and relation.

Traffic

This is the number of people who visit your website and your entire ecosystem (social media – instagram, youtube, facebook, snapchat, twitter, etc.).

Authorities

This is the way your audience sees you as an expert. You can be an excellent expert and not know how to communicate, so your audience sees your expertise at a level below your actual expertise. And it can also have the opposite situation where your audience sees your expertise at a level higher than your real expertise. In this case, you’re a crook !

Relation

This is the level where your audience appreciates you as a human being rather than a company.

Pillars check

What is interesting to do is to note where you think you are in the 3 pillars (traffic, authority and relation) from 1 to 10. « 1 » is the person who has just started and « 10 », is the person who is one of the best infopreneurs in the world like Gary Vaynerchuk  or Casey Neistat .

Don’t hesitate to ask people you know to have a more objective point of view. The ideal is a close friend who is really interested in your company and who understands what you’re doing. Ask this friend : « What rating would you give me between 1 and 10 ? Go ahead, be frank, you don’t need to spare my ego ! ». With an outside eye, it will help you find the problem.

Problems

problem

Perception

It’s possible that you have a huge traffic on your website but if people don’t perceive you as an expert who has enough experience to help them and they don’t like you (they perceive you more like a salesman as a human being), they will not buy your products and services.

Conversion rate

This concerns the conversion rate between your traffic and the people who sign up for your email list. People who sign up for your email list are people who are really interested in what you’re doing and who want receive the free gift you are offering (ebook or exclusive video). People who subscribe to your email list have given you permission to contact them through their email knowing they can unsubscribe at any time.

What it interesting to do is to note where you think to be in your conversion rate from 1 to 10 ? For example, when there are 100 people visiting your website, how many are subscribed to your email list ? If you rate is 0, you’re not offering any interesting gifts or you’re not making a call to action for your email list. In these cases, you have to work on it to offer a better free gift or tell people that they can sign up for your email list.

We must know that today, email remains the most effective way to contact people and it will remain so for a long time. Attention, that doesn’t mean that when you send an email thanking for the loyalty of your subscribers or a promotional email for a product/service, you shouldn’t also talk about that in your ecosystem (social media) with a video, a picture, a post on different platforms.

It’s important to know that if you’re doing content marketing and your company is based on the free content you create, you need at least a 5% conversion rate. If you do below that, you have work to do to improve your conversion rate.

Solutions

solution

Product/service

It’s possible that you don’t have a product or service to sell or like me at the beginning, I sold a product but there are only 5 people who bought it. In this case, you can do a survey with the people who are on your email list to find out what is the problem they would like to settle as quickly as possible. With this method, you’ll soon be able to create a profitable product because you solve the main problem of you audience. Attention, it’s necessary that you have 1000 people subscribed on your email list to make this survey.

Coaching

This is one of the simplest ways you can make money. It doesn’t matter if you have more than 1000 people on your email list. When we start an internet company, it’s the easiest thing to do. You offer your skills as a service to your audience. With a small audience, a good authority and a good relation, you’ll have people who will be interested to work with you by doing coaching sessions on Skype, for example.

Ebook

If you’re a person who likes to write (like me), you can create an ebook that you can sell between USD 17.- and 27.- to start earning some money.

Action

We could talk about this for hours because every situation is different. I don’t know your situation but by following these advices, you will be able to improve your company’s situation, so ACTION.

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

-Steph

An Extraordinary Tool To Solve All Your Problems

tool box

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

Nature has given an extraordinary tool to every human being. This tool has different performance depending on the people but it’s the best for solving problems compared to the tools invented by humans.

This tool is our brain. This tool is better than a computer because a computer needs a human to work. For now, artificial intelligence has lower performance than the human brain.

Unfortunately, many of us don’t use our brains to find solutions and solve problems that are important to us. Many of us consume a lot of distractions. The question is : « Are we asking enough questions to our brain to find solution ? ». If you don’t give problems to your brain, your brain will be less and less efficient. It’s the same principle for your body.

If you give junk food to your body all day long, you will be fat, bitter, you will not have any more energy, you will not have any more libido. Everything that will comes out of you brain will be diminished in quality and quantity. If you will give healthy food to your body all day long, you will be slim, you will have more energy, you will have a better libido. Everything that comes out of your brain will be increased in quality and quantity.

Training your brain

training brain

To improve the brain to solve problems, it’s necessary to ask questions. A question is the interface between our brain and reality. This is what will put the brain in mode : « search for solutions ». By asking questions, you will look for different angles of approach to deal with the problem. The better the question and the better the solution to the reality of the world.

To have a good quality of question, it’s necessary to learn to educate oneself with books, trainings, meeting people who share their experiences, etc. Realize that you have to dedicate time to solve problems, allows you to organize your days. It’s like dedicating a few hours in your day to play sports. There is a method that I advise you to test, it’s to have a diary.

Attention, it’s a special diary because you’ll ask yourself questions. The first thing is that you’ll tell events of your life and this will allow you to better understand them and better understand yourself. And the second thing is that you’re going to ask yourself questions. There will be general questions like: «  How can I become happier ? ». And more specific questions like : « How can I become happier with the 80/20’s law (Pareto’s principle)  from today and see a measurable result next week ? ».

With questions, you put your brain in mode : « search for solutions » and you find several ideas to test to solve the problem. It’s the human process to find a solution since first hominids. Imagine, millions years ago, first hominids already found solutions because of a constraint. Imagine this scene, a hominid finds an animal with a carapace that is dead. The hominid is hungry and seeing the animal dead, he’s even more hungry. He asks himself this question : « How can I eat this animal that I can’t eat ? ». His brain goes into mode : « search for solutions ». After a few minutes, he remembers that by tapping a stone on something, the stone become sharper. After several tests, he manages to cut the animal with a carapace that dead to eat it.

Virtuous circle

virtuous circle

This human process is a virtuous circle. You ask yourself questions to find solutions to problems. These solutions create other constraints that lead to others problems. So you have to ask yourself other questions to find a solutions. To evolve, we need challenges and there are always challenges in the world. Do you realize that millions of years ago, first hominids created tools with stones and wood and today we have internet technology ? With internet, people from distant country can read my blog’s articles 24/24 7/7, it’s incredible.

Among these questions, there will always be questions that will have different answers depending on what the situation you’re in your life. For example the question : « How can I become happier ? ». When you’re single, you have a solution. When you’re in a relationship, you have another solution and when you have children, you have another different solution. Solutions are influenced by different variants in your life and it’s important to ask yourself this question throughout your life.

Reserve some time in you day to ask yourself questions to solve problems. It’s a kind of physical activity for your brain. It’s a good process to become a better version of yourself. But beware, there are solutions that you will find quickly and others, it will be necessary to work on for months or years to find the solution.

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

-Steph

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

Create Bins and View Distributions

tableau, bins, bar, chart, distribution, age, data, science

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

It’s cool, you finished the 1st part. Now we’re going to do more deep Data Mining analysis with this bank’s dataset.

tableau, bins, bar, chart, distribution, age, data, science

To make these analyzes more deep, we’ll create a more statistical approach.

To do that we will create a new tab.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

For this new tab, we want to understand how client distributed according to their age. Is there a majority of young or old people ?

tableau, bins, bar, chart, distribution, age, data, science

Move the variable « Age » in « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

As we want to see the distribution of client ages, we need to use the variable « Number of Records » to see the number of observations. Move the variable « Number of Record » to « Rows ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Boom, we have a chart but there is only one point on the top right. What happened is that Tableau took the sum of the ages of all the bank’s clients and the sum of all the « Number of Records », it means the total number of clients, 10 000 clients.

We’ll find a solution but before we’ll change the format to better see the chart. Right-click in the middle of the chart and select « Format ».

tableau, bins, bar, chart, distribution, age, data, science

For the font’s size, select « 12 ».

tableau, bins, bar, chart, distribution, age, data, science

Here you can see that the total age is 39 218 but that’s not what we’re looking for. What we want to see is the number of clients for each age.

I’ll explain what’s going on. We took the aggregated sums of our variables. Aggregate means that we took the total sum of the variable for each category. We added the ages but in fact we want to see the total number of observations for each age separately.

To have that, just click on the arrow in « SUM(Age) » in « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

Then select « Dimensions »

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

You see, Tableau doesn’t take the aggregated sum of ages but it takes ages separately. We have a curve that shows us the continuous distribution of our clients ages. That is to say, for each age, the curve gives is the number of clients of this age.

We’ll look at the dataset. Right-click on « Churn Modelling » and select « View Data… ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

There is window that appears that shows us the data in detail. If you scroll to the right, you will find the column « Age ».

tableau, bins, bar, chart, distribution, age, data, science

We see that the ages rounded. As all ages rounded, Tableau is able to group clients by age. By positioning the mouse on the curve, we can see that there are 200 clients who are 26 years old.

tableau, bins, bar, chart, distribution, age, data, science

If in the dataset, ages weren’t rounded, you would have seen clients with 26.5 or 26.3 years. It would create a lot of irregularity, there would be plenty of spikes with lots of variations.

Oooooh look, there is a variation that isn’t normal.

tableau, bins, bar, chart, distribution, age, data, science

Let’s analyze it in detail. Around this peak, we see that there are 348 clients who are 29 years old.

tableau, bins, bar, chart, distribution, age, data, science

Here, 404 clients who are 31 years old.

tableau, bins, bar, chart, distribution, age, data, science

And this peak down that shows us that there are 327 clients who are 30 years old.

tableau, bins, bar, chart, distribution, age, data, science

How to explain this irregularity ? It’s possible that many people of 29 years old are about to turn 30 years old and many people of 31 years old who just had 31 years old. It’s chance that make us have inaccuracies. You may have other inaccuracies if you data isn’t precise and rounded. In our case, the ages are rounded but we want to get rid of our small irregularity that we see on our curve.

There is way to see our distribution without our irregularities, it’s « bins ». « Bins » consists of grouping the information into different categories. That is we’re going to regroup our clients in different age groups.

Right-click on « Age » in « Measures ». Select « Create » and select « Bins… ».

tableau, bins, bar, chart, distribution, age, data, science

A window appears. We’ll group our clients in 5-years increments. In « Size of bins », write « 5 » and click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

As you can see, the variable « Age » has remained in « Measures » but there is a new variable in « Dimensions ».This is the variable we created « Age(bins) ».

tableau, bins, bar, chart, distribution, age, data, science

Our « Age(bins) » variable was correctly placed in « Dimensions » because it is a category variable because each category corresponds to a 5-year age group.

For example, one category is 20 to 24 age group. Now we’ll create a new distribution based on « bins ».

To do that, we’ll remove the variable « Age » from « Columns » with a click and drag outside.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

You move the variable « Age(bins) » from « Dimensions » to « Columns ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Note

In this case, it’s not possible to directly replace « Age » by « Age(bins) » over « Age » on « Columns ». This is because « Age » is a measure and « Age(bins) is a dimension.

That’s nice distribution, it’s usually the type of distribution (chart) we see in economics or mathematics. The difference with the old chart is that this chart is discrete. This chart is discrete because the clients grouped by age group while the previous chart was continuous.

On this distribution (chart), each bar corresponds to an age range. For example, this bar corresponds to the 25-29 age group.

tableau, bins, bar, chart, distribution, age, data, science

Now, we’ll change the colors.

In « Row », move « SUM(Number of Record) » while holding down the « Ctrl » or « Command » key on your keyboard to « Colors ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

We get our distribution in blue but we’ll change the color to red. Click on « Colors » and click on « Edit Colors »

tableau, bins, bar, chart, distribution, age, data, science

In the window that appears, click on the blue square on the right to display the color pallet.

tableau, bins, bar, chart, distribution, age, data, science

Select the red color and click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

Click on the « OK » button of the « Edit Colors » window.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

To facilitate the reading of the bar chart, we’ll add the number of clients in each age group. In « Row », move « SUM (Number of Record) » while holding the « Ctrl » or « Command » key on your keyboard to « Label ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

That’s it, we can see how many clients there are in each age group.

We see that the dominant bar is the 35-39 age bracket and the second dominant bar is the 30-34 age bracket. Overall, we can see that most clients are between 25 and 40 years old, which seems consistent.

On our bar chart, we have absolute values. We’ll replace that with percentages. Click in the little arrow in « SUM(Number of Records) » in « Label » and you select « Add Table Calculation… » but I’ll show you another way to do it.

tableau, bins, bar, chart, distribution, age, data, science

Instead of clicking « Add Table Calculation… », click on « Quick Table Calculation » and select « Percent of total ».

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

It’s cool, we have the exact percentage of people in each age bracket. Now, we can see that in the 25 to 40 age group, we have 20 + 23 +17= 60% of clients.

I’ll show you one last thing.You can change the size of the slices easily, just click on « Age(bins) » and select « Edit ».

tableau, bins, bar, chart, distribution, age, data, science

In the windows, you can change the size of the slices (bins). Put « 10 » instead of « 5 » to get 10-years slices. Click on the « OK » button.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

Now, we have a distibution with fewer slices and the dominant slice is 30 to 39 years old.

Well, it was just to show you how to change the size of bins. To go back to the old distribution with the 5-years slices, click on « Back » button.

tableau, bins, bar, chart, distribution, age, data, science

tableau, bins, bar, chart, distribution, age, data, science

As you can see, the values on bars are in percentages but the values on the axis are in absolutes values. Here is an exercise that I ask you to do : « Put the values of the axis in percentage ». I’ll give you the answer the next article.

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

-Steph