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

Explanation Of The Challenge And Data

challenge

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

This is the 1st challenge. Use your web browser to go to superdatascience website  to download a data set. In the « Part 1 Visualization » section, click on « Offices Supplies » to download the file « OfficeSupplies.csv ».

data csv file

To organize myself, I created a folder « Visualization » with 3 subfolders. Each subfolder corresponds to the section of « Visualization ». I put the data set « OfficeSupplies.csv » in the 1st subfolder.

data csv file

« OfficeSuplies.csv » is a CSV file. A CSV file is a text file that represents an table but the elements separated by comma.

You can open this CSV file with NotePad++  for PC or with Sublime Text  for Mac.

On the 1st line (column title), we see that we have 6 columns. Each column separated by a comma and the file contains 44 lines.

data csv file

You can also open a CSV file with Excel, OpenOffice  or LibreOffice  to have a table, which is easier to read.

To open a CSV file with Excel, here are the instructions :

  • Open a blank workbook

  • Go to Data tab

  • Click button « From Text » in the general external data section

  • Select your CSV file

  • Follow the Text Import Wizard (in step 2, select the delimiter of your text).

data csv file

This data set contains data from a store that sells office equipment :

  • Order date – date of sale

  • Region – The store is in 3 region (East, Central and West)

  • Rep – salesperson’s first name

  • Item – product’s name

  • Units – product’s quantity

  • Unit Price – price per unit

Each line shows how many sales there were for a product.

The challenge is to help the manager to know who made the most sales per region in the period of this data set. The period of this data set is from July 2014 to June 2015.

The person who made the most sales in each region has a bonus and there are 3 bonus so 1 bonus per region.

It’s will this challenge that we’ll use Tableau Public.

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

-Steph

Back To The Source Of Equipment (Part 2)

source water river

I read a Nerd Fitness articles  and I learned good stuff.

If you didn’t read the part 1, click here

Racks Et Machines

To do squat, there are differents equipements, we name it « racks ». Let’s go.

Squat stands

squat stands

It’s 2 pieces standing, next to each other to hold the Olympic bar. It’s handy because it’s portable and you can do squat outside. But in a gym, it’s not great because you can’t put heavy weights, it’s too fragile.

Squat rack

squat rack

It’s 2 bars that are standing tied with horizontal bars. With the Squat racks, you can put heavy weights.

Power rack

power rack

It’s my favorite. It looks like a large rectangle with poles in vertical and horizontal. The Power racks have holes for placing J-hooks to adjust the height of Olympic bar. What is cool is that you can do several exercices with like pull-up, bench press, overhead press and dips.

Smith machine

smith machine

Smith machine looks like Squat racks except that the bar is guided.

Gym staff will tell you that it’s a machine to do squat safe. I don’t advise to use this machine because it forces your body to make unnatural movements. This scientific study (https://www.ncbi.nlm.nih.gov/pubmed/19855308 ) shows that you have better results with a squat with free weights.

The difference between Squat racks and Smith machine is that the bar where you put weights is fixed on Smith machine.

Weight machine

plate loaded machine weight pin loaded stack machine weight

Weight machines are in 2 categories : Pin loaded (stack machine) and Plate loaded. Pin machines have a rectangular weight stack with a hole to put the pin. More the pin is low, more the weight is heavy to lift. What is cool with this machines is that you don’t need to look for weights anywhere in the gym.

With Plate loaded, there is no weights attached to the machine. You put weights on the machine yourself. Plate loaded machines have a wider range of motion than Pin loaded.

Cable machine

cable machine

No matter the size or design of the cable machie, it will always be a pin loaded (stack machine). A handle is at the end of the cable and you can pull or push in different directions. Cable machine can be an alternative for some exercices you do with dumbbells or barbells. Cable machine has a wider range of motion.

Pull-up Bar

pull up bar

You know in most gyms, there is no real pullup bar (like in my gym). If you don’t find a freestanding bar, there are several alternatives like power rack, smith machine or the top of the cable machine.

Dips station

dips station

Usually dips station is integrated into the power rack or the cable machine. You can find some that are freestanding.

Assisted Pullup /Dip station

assisted pull up

It’s a Pin loaded (stack machine). You choose a weight and you put yourself on the platform. The weight you choose will help you to do pullups or dips. For pullups, I advise you to do Lat pulldown and the day where you can lift your bodyweight, you do freestanding pullup.

Bench

adjustable bench

Ajustables benches and standard flat benches are types of benches you will see in a gym. To do incline and decline exercices, ajustable bench is perfect. Benches are the equipement the most use in a gym, especially on Monday. I don’t know why but Monday is the international chest’s day and it’s hard to find a bench that day.

Bench press

bench press

Squat stand and Squat rack are use to do bench press in small gyms and Crossfit. In big gyms, there are special bench press with a stand attached.

Equipement items

Now you know the main gym’s equipment, I will show you small equipement items.

Collars/Clips

collar clip

There are several collars/clips designs but they have the same purpose that is to keep weights safe on the bar.


Weight plates

weight plate

There are several type of plates :

  • Standard metal plates/ rubber encased weight plates

    They’re made of metal and they shouldn’t be thrown to the ground. There are circle with the denomination of weight on. Depending on the weight, they have different diameters.

  • Bumper plates

    They’re made of rubber and can be thrown to the ground for above your head (clean and jerk).

Plates can have a denomination in kilograms or pounds :

Kilogramme : 1, 1.5, 2, 2.5, 5, 10, 15, 20 et 25kg

Pound : 2.5, 5, 10, 25 ou 45lbs.

You can also find plates with a combination of metal and rubber that can be thrown to the ground but not from aboe you head.

Kettelbells

kettelbell

This is looks like a cannon balls with handles. Most gym don’t have the same weight repertoire than dumbells but it’s possible to find kettelbells of 24kg (53lbs) and 31.75 (70lbs) and more.

GHR/GHD Machine

ghr ghd machine glute ham raise developer

The translation is « Glute Ham Raise » or « Glute Ham Developer ». With this you can do glute ham raise, back extension or sit ups.

Prowler/Dragging sled

prowler dragging sled

Put weights on a prowler and push or pull while you run.

Strongman equipment

strongman kegs yokes hammers tires atlas stone

If you don’t intend to make a strongman competition, kegs, yokes, hammers, tires and atlas stones are good to do from time to time.

Plyo Boxes

plyo Boxe

These boxes have several size. You jump on and off of.

Bands

band

Those are big rubber bans to work mobility and speed lifts.

Gear

It’s funny because people ask me often : « What do I wear ? ». I noticed in gyms, it’s often a fashion show. It’s for this reason beginners are impressed. Unless you have an injury, clothes don’t matter. When I started, I took some clothes that I rarely used and I always do that. Sometimes I see people with cool clothes and I say to myself : « Wow, I have to buy it » and when I see theirs performances I say to myself : « Pffff, show-off ! ».

Clothing

Gym isn’t a fashion show. You’re not going to win a prize because you’re well dressed. We’re here to sweat so wearing comfortable clothes. You know, my clothes and shoes are torn and the funny thing is that people ask me, if they can train with me because they see my body evolve.

Shoes

squat deadlift shoes classic converse chuck taylor all star

It’s important to have a good pair of shoes to do deadlift and squat. A good pair of shoes allows you to put your weight on your heels to be as stable as possible. Running shoes don’t allow you to do this because their soft soles. If you don’t have the budget for this type of shoes, the classic Converse Chuck Taylor All Star works well and is what many top powerlifters still wear.

Personally I use my Converse Chuck Taylor All Star for my strenght training and my Puma to run.

Gloves

Gloves are used to protect hands from callouses. At the beginning, I wore gloves and I still had callouses and sometimes my hands slipped inside gloves because of the sweat. I notices that gloves could also mess up your grip and technique. I don’t use gloves and I don’t recommand to have gloves.

Knee/Wrist wraps

knee wrist wraps

Wraps allow you to have support and stability when you lift heavy weights (squat/deadlift).

Straps

straps

Straps allow you to hold the bar longer in your hands. Straps are wrapped around the bar which relives your grip. It’s excellent for intermediate and advanced lifters. Beginners don’t need to use it.

Weightlifting Belt

weightlifting belt leather weightlifting belt velcro

There are 2 type of weightlifting belt : leather or velcro. It’s very usefull for intermediate and advanced lifters. I use my weightlifting belt only for deadlift and squat.

Stop, stop, stop, I see you start to worry about buyiing all this. Don’t panic, the most important thing to have is a good pair of shoes to get started. It’s simple, let’s go my friend.

Whats’s the biggest mistake you made when you started lifting ?

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

-Steph