Trick To Have Really More Energy

energy

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

Often, during the day, we have a loss of energy. There is a trick I learned at my first karate class when I was 6 years old- At each class our Sensei (teacher) taught us how to breathe. There are 2 types of breaths :

Breathing with the upper body

This is the breathing that most people do. We can recognize a person who breathes from the top of the body because the shoulders rise with each inhalation . This type of breathing is not good because it reduces your performance, your well-being and your energy.

Diaphragmatic (abdominal ) breathing

diaphragmatic breathing

It’s diaphragm breathing. For simplicity, it’s abdominal breathing. This type of deep breathing calm down immediately, improves your well-being, increases your performances and your energy.

Here are some scientific studies on the beneficial effects of diaphragmatic breathing because the list is long. Scientific study Aa , Bb , Cc , Dd , Ee . It’s this type of breathing that is taught for fighting sports, singing, meditation, yoga, public speaking, etc.

Try during these next days to identify what type of breathing you do. You can put a reminder on your smartphone because it’s a test to be done over several days. The principle is that every time you realize that you’re breathing from top, made deep breaths to do the diaphragmatic (abdominal) breathing. You’ll quickly notice that you feel much better after that with a better state of mind.

The idea is that you’re more used to breathing with the diaphragm to have more energy in the day.

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.

Mistake To Avoid During A Presentation

mistake presentation the family oussama ammar

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

2-3 years ago, I participated in Robert Kiyosake’s « Rich Dad Workshop » , it’s the author of « Rich Dad, Poor Dad ». I returned to this workshop a few months ago and the speakers were less dynamic than the last time. Besides, there is one person who made a classic mistake that we make during a presentation. This error is to display a text on a big screen and read it. It’s really boring.

People read fast

speed reading

Reading a text that is displayed on a large screen in front of everyone is a bad idea because it breaks the presentation’s dynamism. This creates a moment of flutter because you’re disconnected from your audience. But, there is an even more scandalous reason that this one. Typically, people read between 250 and 500 words per minute while the average speech rate is approximately 150 words per minute. This means that people have already understood the text before you have read the half aloud. The bottom line is that people have to wait for you to finish reading the text aloud when they have already read everything and that is awful, pffffffff.

Most difficult thing in a presentation is to keep the audience’s attention and reading aloud a text that is displayed doesn’t create any surprise’s effects. If you absolutely have to read a text during a presentation, read this text without displaying it on the big screen. It will not be the most excellent thing in the world but people will discover the content as you speak. In this way, the audience will be more likely to be attentive to what you say.

I don’t know if you know but there is a little trick when we make a presentation with PowerPoint. In PowerPoint, it’s possible to see the text before it appear on the big screen, it’s Presenter View . With this configuration, there is a private monitor (your laptop) and a public monitor (big screen). This allows you to see in advance what the audience will see.

To improve the quality of my presentation, there is a very interesting book by Garr Reynolds « Presentation Zen » . With this book, you’ll make cool presentation.

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.

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

The Important Things To Delegate In Your Company

delegate

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

Here are the most important things to delegate in your company

Accountability

accoutant

I often meet entrepreneurs who do their own accounting and they say it’s a nightmare. Here are the 2 reasons why I advise them to stop :

  1. Accounting requires a lot of time.

  2. It’s extremely easy to make a mistake. Even certified public accountants make mistakes. The problem when there is an error in your accounting is that all the numbers are wrong. And when all the numbers are wrong, you tax return is false and when your tax return is false, you are in a long-term nightmare.

It’s possible to find a good accountant for around $1 200 a year when you start a company. It’s always better to pay that than to be in a financial nightmare for 5 years because of a mistake in your tax return.

Technique

it provider

What’s cool is that with WordPress and its free plugins and themes, it’s easy to install and manage a blog / website. There are also other platforms that allow you to do the same thing.

On the other hand, when there is a major problem that exceeds your skills, it can be negative for your company. For example,your blog / website no longer responds. If you don’t know how to do, you can spend 2-3 days trying to understand the problem and it’s been 2-3 days since your audience no longer has access to your blog / website.

At that moment, you need an IT provider. This is not a person you will hire as an employee but it’s a person to whom you can entrust all the technical tasks that you don’t knew how to do.

Yes, it will cost money but ask yourself this question : « Is it better to spend 2-3 says repairing your blog / website is down or pay a IT provider who repairs it in 1 hour ? ».

I advise you to find a IT provider quickly when you start making money with your company before having a major problem. Maybe someone around you knows a good IT provider or maybe you need to find one on Upwork. Test this IT provider with a small task to find out if her is competent or not.

Customer support

customer service provider

It’s something to delegate but not as fast as the technique. At the beginning, it’s important to do customer support yourself to be in direct contact with the audience to see the problems in services or products, etc. But that doesn’t mean that customer support is the best added value task that the company’s founder can do.

With customer support, you will quickly see that there are often the same questions that are asked. To eliminate much of the customer support is to make a FAQ. A FAQ is the list of questions most frequently asked with a reply.

For other questions that are a little more complex that are are common, you can do a procedure to explain to the people who take care of your customer service how to solve the problem. And you can ask them to inform you when a question is frequently asked to have a permanent feedback. This allow you to stay in touch with reality.

Maybe someone around you knows a good customer support provider or maybe you need to find one on Upwork. Test this customer service provider with a small task to find out if her is competent or not.

Social media

social media provider

Since you have a blog or a website, you have an audience. This audience sends you messages when you create content. This is the same principle as for customer support, it’s important at the beginning that you answer the messages yourself to discover your audience. You will know the fears and the hopes of your audience. It’s important that you learn how to communicate with your audience.

To find out what things to delegate, you need to be aware of seeing where you bring the most added value to your company as a founder, it’s about innovation, strategy and setting up processes. This allows you to work on your company and not work in your company.

It’s important to know the difference between working on your company and working in your company (being a slave to your company).

Solution

solution

I told you there was a way to find IT provider, customer service provider and social media provider on internet. The best known platform for finding freelancers or outsourcing is Upwork . You will find providers from several different countries. Always test a provider with a small task that doesn’t have a huge impact on your company to make the selection.

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

-Steph

Stop A Bad Habit

self sabotage

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

You know, I had a lot of trouble stopping my worst bad habits. It was bad habits that sabotaged my life. Many people around me have the same difficulty I had because unfortunately nobody showed them a conscious step to stop these bad habits.

Think about it, eating healthier allows you to have better energy, better body weight and live longer. Just eating less pre-prepared meals and replacing that with healthy food allows you to avoid having hundreds of bad calories in your body and this make a huge difference in the long term.

It’s a concept that used in all fields of your life. I think you know the consequences of smoking and not playing sport ?

My old bad habits

Ok, I see you need to see concrete things so I’ll tell you the bad habits I stopped :

bong

  • When I was 15 years old, I started smoking weed (marijuana) and quickly I smoked bong or water pipe several times a day. I stopped smoking when I started to train to have a body like 50 Cent. And after, I realized that I was smoking weed (marijuana) to get away from my daily worries. It was like pressing the « Pause » button several times in a day.

    elric of melnibone michael moorcock

  • For several years, I have only read heroic fantasy’s books (Hawkmoon, Elric of Melnibone, etc) and no personal development’s books. It’s not a bad idea to read heroic fantasy’s books but read only that, it’s just entertainment. When I started reading personal development’s books, I realized that I had lost years of knowledge, references, tools, methods that today would be extremely useful to me. Fortunately, it’s never too late.

    fat food

  • For several years when I was doing Karate or Kung-Fu, I had a bad diet. I only ate pre-prepared meals, pizza, fat foods, sweet drink, candy and I didn’t like vegetables. Today, I have a better diet and I’m proud of the result. Since I have a tool that allows me to have my diet under control, it’s MyFitnessPal  on my smartphone (except for my Saturday’s cheat meal)

I like seeing the reaction of people when I explain to them what I eat at breakfast : rice(or pasta) with meat(of egg) and vegetables. I don’t know why breakfast is very emotionally loaded while this is the easiest meal of the day to change. When you only have healthy food in your fridge and in your closets, you have no choice to have a healthy breakfast.

It may be because of childhood memory that people like to have sweet things at breakfast but our bodies are evolving and we need to feed them differently. A child and an adult don’t eat the same amount of calories to be operational.

Wait here is another bad habit that I stopped. I used to play video games for hours. Sometimes with friends we played more than 8 hours non-stop. Once I invited many girls to my condo to do a « before » with my friends before going to the club. We decided to take the bus (public transport) because we wanted to drink a lot of alcohol.

The problem is that with my friends, we were too focused on the video game and we missed the last bus. The girls had gone crazy and they made us understand that it was the last time we (me and my squad) did this (especially an ex-girlfriend, it was sex versus video games). Since then, I haven’t completely stopped paying video games but I play much less because I don’t buy the new video game console.

I guarantee you that having stopped these bad habits had an incredible impact in my life.

Your future old bad habits

healthy food

Now I have a question for you. What bad habits you want ? What bad habits can you replace with a good habits ?

I advise you to make a list of bad habits you want to stop. When you have chosen the bad habit you want to stop, put in place a simple action to stop it. You can’t stop a bad habit in one night. You need to have a constant simple action to have excellent result.

For example :

  • If you want to eat more vegetables, you can use this grandmothers tactic that is to eat vegetables before dessert.

  • If you want to watch TV only for 1 hour, read a few pages of a personal development’s book.

Leave me a comment with a habit you want to stop and that simple action do you use to stop this ?

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

Install Tableau Desktop and Tableau Public

tableau desktop public data visualization

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

Today, I’ll show you how to install Tableau.

Use your web browser to go to https://www.tableau.com/ . On the homepage, there are several options of packages to be installed.

For the course that I do, there is the choice between 2 versions : Tableau Desktop and Tableau Public.

Tableau Public charged and of course, there is a trial version of 14 days. Tableau Public is free and is perfectly usable for this course because there are the same features as Tableau Desktop.

Install Tableau Desktop

Click on the « Try Now » button on the top right

tableau desktop public data visualization

Here there are 3 options : Tableau Desktop, Tableau Online and Tableau Server. What interests us is Tableau Desktop and for that we need to give an email. Once you gave your email, the installation file downloaded automatically.

tableau desktop public data visualization

Don’t worry, the download contains the correct version of the file. This will be a « xzy.EXE » file for Windows and a « xyz.DMG » file for Mac.

If this isn’t the right version that has been downloaded, you can always do this manually with these links.

tableau desktop public data visualization

As soon as the download is complete, you can watch tutorial videos in the « Get Started » area. It’s simple and intuitive.

Install Tableau Public

To install Tableau Public, it’s a little different because you have to go to another website. Use your web browser to go to https://public.tableau.com/s/.

Like for Tableau Desktop, you need to give an email to install the installation file automatically.

tableau desktop public data visualization

The majority of people who use Tableau Public are journalists or public organizations that do not have confidential data because Tableau Public data is on public servers. And as you know, data of a public server is freely accessible to everyone on internet.

Here the Tableau Public main graphic user interface.

tableau desktop public data visualization

Tableau Desktop and Tableau Public have the same structure, features and visualization layout.

But there are 3 differences :

  • With Tableau Public, you can’t extract data because your data is on a public server.

  • With Tableau Public, you need to make screenshots (printscreen) of your charts because you can’t export them.

  • With Tableau Desktop, you can connect to more file type and you can export your charts.

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

-Steph