Description

WEEK 3: Data Visualizations Using Tableau 1

Topic Overview 

Tableau is a business intelligence software that helps in transforming data into actionable insights. In this course, we are using it for analytics that requires great data visuals to help us provide conclusions and suggest optimally decision making on business endeavors.

Learning Objectives

By the end of this week, you will be able to: 

• Access Tableau DESKTOP;
• Learn Tableau using videos and datasets provided in the Course Information.

Schedule of Activities

This section contains all the resources and links to activities you need to complete. Use this checklist to create your to-do list.

• Step 1: Review the Learning Materials listed below;
• Step 2: Complete the Vista Beans Coffee Shop Assignment. 

Learning Materials

• Reading: Tableau Your Data;
• Reading: Chapter

Access Tableau DESKTOP

1. Download Tableau Desktop and Tableau Prep here
2. Select each product download link to get started. When prompted, enter your school email address for Business E-mail and enter the name of your school for Organization.
3. Activate with your product key:  TCL3-902E-68F0-AE2F-B424 

Are you new to Tableau? Here is the free Data Analytics for University Students guide to help you get started.

You can continue using Tableau after the class is over by individually requesting your own one-year license through the Tableau for Students program.

Vistabeans Coffeeshop Assignment (Week 3)

The attached instructions specify the creation of a report with 3 or more visualizations.  Read the solution memo carefully to understand how it relates to the dataset provided.  Think of a continuum of the visualization abilities as you decide how you will complete this assignment.  If this is your first experience with Tableau try to replicate the visualizations on pages 5, 6 and 8 (just three).  If you are feeling more confident then try all 6.  If you don't need training wheels then make your own visualizations based on your analysis and interpretation.  Make sure you include well-written explanations of your visualizations.  Upload the completed file by clicking on the link for this assignment. 

Please use either the Vistabeans with Access file imported twbx second attempt.twbx or the Vistabeans with Access file imported.twb file to complete this assignment.

Submit this assignment by 11pm EST on Sunday of Week 3.

Workarounds For Vistabeans Assignment

After you watch the Tableau videos listed in the "Course Information" you will complete the Vistabeans assignment.  When you try to open the Access file for this assignment you may get this error message:

This message takes you in a totally wrong direction.  Do not try to rectify the situation using the link in this error message.  Use this link instead, https://www.microsoft.com/en-us/download/details.aspx?id=13255

Click on the red download button

You have to find out whether your computer is 32 or 64 bit.  Here is the link to help you with that step if you are running Windows 10

Click the Next button, opt to save the file, then choose a location for saving the file.

Navigate to the file you downloaded (I downloaded the AccessDataEngine_x64.exe file), click the file and follow the wizard instructions to install the file.

MAC USERS

One of my Spring 2018 students found another strategy for solving the Tableau/Access problem.  She found this by looking around on the internet.  I have created the factTable+ (CoffeeChain  Cor).hyper file and uploaded it to the Vistabeans assignment.  My former student told me that the .hyper file works perfectly with Tableau on Mac.  If you are a Mac user please try to complete the assignment using the .hyper file. 

 Here is the link: http://onlinehelp.tableau.com/current/pro/desktop/en-us/environ_workbooksandsheets_workbooks.html

If you have any questions or insights about the assignment please send me messages via the survey I created:https://baruch.az1.qualtrics.com/jfe/form/SV_8lanVStnBes6gfP

or via the Q and A Discussion forum or send me an email.

Open a workbook that has an unsupported data connection on the Mac

When working in Tableau Desktop on the Mac, you might need to open a Windows workbook that contains data sources that are not supported in Tableau Desktop on the Mac. To do so, follow the steps below:

1.       In Tableau Desktop on Windows, save the workbook as an extract. To create and save an extract, on the Data menu, select a data source, and then select Extract Data

2.       Open the extract file (.hyper) you saved in Tableau Desktop on your Mac.  factTable+ _CoffeeChain Cor_.hyper