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

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