Data Analytics Practice With Tableau
(I) Getting Tableau Program; Download/Upload Real Business Data
a) Open the website of the real business that we are working with at:
http://www.citibikenyc.com/system-data
b) View and make a note for the default system data properties the website provided
c) Download the needed data of 201501-citibike-tripdata.csv from Canvas-Assignment–
Data Analytics Exercise with Tableau to a preferred folder at your local computer
d) Open Landing Page: https://sbus-vdi.montclair.edu ; select: SBUS_Lab – Go through Chrome-
User Authentication with your MSU-NetID, then, Tableau app should be available
e) Upload the needed data from your local computer to Document folder at the Virtual desktop (Follow the guided directions attached below)
f) Verify if the data now can be found at the Document folder from the Virtual Lab computer
g) From Start menu, type Tableau, then you are ready to run the program
(II) Analyze the following 6 questions with Tableau worksheets respectively:
1. Create a Calculated Field named ‘Males-Females’ as a new dimension on your worksheet.
(Noted: you need to filter ‘Null’ when use Gender to measure the following steps)
2. Show trips taken by males versus females during the month as a horizontal-bar table.
3. Show total hours and minutes traveled by males versus females during the month as a stacked-bar table. Customize with your preferred colors for male and female
4. Create a micro-viewable chart of total trips for the system by hour of each day over January 2015.
5. Create an animated and visualized view with hourly departures during the month in New York area. It now reflects any number of departures from each station at each time point.
6. Based on the results of Question-4 or Question-5, with open resources, analyze the reasons why there were low biking activities on Jan. 27th, 2015?
Provide your brief answers with the related web-link on a fresh worksheet
Important attention before submit your work:
Your work should NOT be a screenshot or by photos/videos. Nor duplicate the answers learned from professor’s Demo. It should be a fresh, self-created Tableau program package file
Each question should be answered in a clean worksheet. Submit your answers with total 6 corresponding worksheets and saved in 1 package
Your completed working package should be saved as ‘Your-name-Tableau.twbx’ format. Submitting without the required *.twbx format will be unreadable remotely for professors, and your work won’t be count.
Important: Attach your work to your Gmail, or Google-drive BEFORE logout the Virtual Lab. Or, your work will be deleted AFTER logout your session.
How to upload the needed data from your local computer to SBUS-virtual-Lab
Before start, download the needed data 201501-citibike-tripdata.csv from Canvas Assignment to your local computer folder
1) Login SBUS-Virtual Lab, and click the notch at the desktop
3) Upload the needed Data from your local computer
4) When upload completes, open File Explore to verify if the data can be found from the Document folder
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
