Reference no: EM132986224
Assignment One: Bike Share Homework Activity Guidelines
Overview: The purpose of the Bike Share Homework Activity is to give students the chance to practice analyzing given data and to begin the process of forming data visualizations.
Prompt: You have been assigned as the data analyst for a new bike share project for the city of Columbus (Ohio). You have been asked to analyze the data from an existing bike share program in Washington, D.C. and present planning recommendations for the number of bikes needed for the city. Using the supplied information, you will write a data visualization plan for your manager.
Resources: The final project and supporting homework activities require the use of different technologies. Prerequisite courses introduced students to database and data mining technologies that can be utilized in this course.
Students taking this course should be capable of working in a range of database tools and data analysis tools.
This course does not require any specific data analysis or visualization tool. There are many options available and students have used these tools in prerequisite courses or are using the tools at their workplace. This is the student's choice.
The course is standardized on both Microsoft Excel and CSV files to provide data. The visualization tool is Tableau Public.
If Tableau Public will be used for visualization, it will need to be installed. There is a Windows and a Mac version. The install requires an email address to be entered on Tableau Public. This is a cloud-based visualization tool application, so files are saved to a Tableau Public account, which requires creating an account with Tableau Public. The course homework and final project do not require submission of a visualization file. The course instead requires screenshots of the visualizations. The account creation is not required for the class unless students want to save their work to return to it later.
To install Tableau Public, go to and click Download the App. On the left panel, enter your email and select Download Tableau Public. Follow the detailed installation instructions from Tableau Public. Once installed, you can open the software from your desktop by going to Programs (Windows) or Applications (Mac). The software is a fully functional visualization tool. There is no reason to save files or workspaces for this course, however, it is available by creating an account on Tableau Public.
The coursework outlines steps on how to use Tableau Public for the specific activities performed. Students are encouraged to perform more independent analysis. Training videos for Tableau Public.
Specifically, the following critical elements must be addressed:
• Define the problem you have been asked to analyze.
• Identify the purpose for the analysis.
• Share your vision of the final visualization presentation.
• Describe what data/fields that you will use from the datasets provided.
• Explain your analysis approach using the provided datasets to meet the goals of your data visualization presentation.
Assignment Two: Bike Share Program Analysis
Overview: The purpose of the Bike Share Homework Activity is to give students the chance to practice analyzing given data and to begin the process of forming data visualizations.
Prompt: Using the bike share case defined in task 2-1, perform the data analysis outlined in the document Homework 2 Analysis Steps.
Resources: The final project and supporting homework activities require the use of different technologies. Prerequisite courses introduced students to database and data mining technologies that can be utilized in this course.
Students taking this course should be capable of working in a range of database tools and data analysis tools.
This course does not require any specific data analysis or visualization tool. There are many options available and students have used these tools in prerequisite courses or are using the tools at their workplace. This is the student's choice.
The course is standardized on both Microsoft Excel and CSV files to provide data. The visualization tool is Tableau Public.
If Tableau Public will be used for visualization, it will need to be installed. There is a Windows and a Mac version. The install requires an email address to be entered on Tableau Public. This is a cloud-based visualization tool application, so files are saved to a Tableau Public account, which requires creating an account with Tableau Public. The course homework and final project do not require submission of a visualization file. The course instead requires screenshots of the visualizations. The account creation is not required for the class unless students want to save their work to return to it later.
On the left panel, enter your email and select Download Tableau Public. Follow the detailed installation instructions from Tableau Public. Once installed, you can open the software from your desktop by going to Programs (Windows) or Applications (Mac). The software is a fully functional visualization tool. There is no reason to save files or workspaces for this course, however, it is available by creating an account on Tableau Public.
The coursework outlines steps on how to use Tableau Public for the specific activities performed. Students are encouraged to perform more independent analysis. Training videos for Tableau Public.
Specifically, the following critical elements must be addressed:
• Proper use of visualization tool.
• Generated correct visualizations.
• Precise descriptions for each visualization generated.
Homework: Data Visualization
After completing the guided analysis plan in Homework Assignment One: Data Prepping and Planning, you will capture the results in a visual form for items 1-5.
For this assignment: Submit a Microsoft Word document in which you have captured the results of items 1-5 from Homework One in a visual way. With each visualization, include the actual question the visualization is addressing from Homework One and any notes or thoughts regarding the findings. Additionally, consider questions a lay person might have when viewing one of the visualizations and answer those questions as part of the story in an ordering that does not cause confusion.
Although you can choose other visualization tools, the following are step-by-step instructions using
Tableau Public. Some other options are JMP, Power BI, and Excel. If you choose to use Power BI or PMP Pro, please use the virtual desktop by following these instructions.
Tableau Public Prep: To start the analysis, open Tableau Public from your Programs (Windows) or Applications (Mac) folder. See installation steps in the technical information document in Module One if Tableau Public is not yet installed.
When the application opens, go to the top toolbar and click DATA » Connect or click the Data tab located to the left of the home tab (shown in Figure 1).
In the Connect tab, on the left menu bar, select In A File » Microsoft Excel. Using the file explorer that opens, navigate to the directory where you save the HOMEWORK2_DATA_DAY.xlsx file and select it.
On the left panel, there will be the day and temp sheet listed. Drag and drop the day sheet to the box on the top that says Drag Sheet Here. Your screen should look similar to Figure 2.
Repeat these steps for HOMEWORK2_DATA_HOUR.xlsx. Note that this is a large file and could take about three to five minutes to upload and display depending on your connection speed.
You will be able to switch between data files by clicking the file you want to use in the top left corner of the worksheet, as shown in Figure 3.
Q1-Visualization: For an initial visualization, select the HOMEWORK2_DATA_DAY.xlsx dataset at the top right of the worksheet in the Data area. In the worksheet, drag CNT to the larger data square. Click on down arrow and change Measure to Average. Drag DteDay to Columns and set to YEAR by right clicking and using the dropdown menu. Drag Season to Rows.
On the right graph options, click on the bar graph.
From this view, select Side by Side Graph to get the visualization.
Practice is the only way to learn. Continue using these three variables and select other graphs. Move the variables to different arrangements of columns, rows, and markers. Continue this and capture a visualization(s) you would use to present to a decision maker in support of this posed question. Note: While you are practicing, you can go to the top menu and select WORKSHEET»CLEAR»SHEET and simply start over.
Q2-Visualization
Go to the top menu and select WORKSHEET»CLEAR»SHEET to begin. Select the HOMEWORK2_DATA_DAY.xlsx dataset at the top right of the worksheet in the Data area. Drag DAY to Columns and CNT to Rows. Make sure bar chart is selected. Using the down arrow for CNT, change Measure to MAX. Drag CNT to Rows again and using the down arrow, change Measure to AVG. Drag CNT to Rows again and using the down arrow, change Measure to MIN. The visualization in Figure 7 is produced and provides all three MAX, AVG, MIN by day in one chart.
Next, select packed bubbles chart and drag DayType to Columns and Season to Rows. On the left in the Marks area, include AvgCnt-make sure it is set to Size. Include Weather and Day and set to Label. Include Weather again and set as Color. The visualization in Figure 8 is generated.
Continue using these variables to practice and try different types of charts and variable combinations.
Capture your visualization(s) that you would provide to the decision makers.
Q3-Visualization: Go to the top menu and select WORKSHEET»CLEAR»SHEET to begin. Select the HOMEWORK2_DATA_HOUR.xlsx dataset at the top right of the worksheet in the Data area. Right click on Hour in the bottom left measure panel and change Convert to Dimension. Drag Hour to Rows. Drag Day to Columns. Drag CNT to Grid. Click the down arrow on CNT to change Measure to Average.
To begin to visualize, click on the stacked column chart. This visual shows a quick distribution of average count by hour for all days stacked.
Go to the top menu and select WORKSHEET»CLEAR»SHEET. Drag Hr to Columns. Drag Day Type to Rows. Double click on Casual. Double click on Registered. Click the down arrow on each Casual and Registered and change Measure to Average. Drag Measure Values from Marks to Rows. Drag Measure Names from Rows to Marks. Move mouse to left of Measure Names in Marks. Click the down arrow and select Color. The visualization result in Figure 11 shows a stacked bar of average counts of Registered (orange) and Casual (blue) over each hour and further segmented by weekend and weekday groupings.
Continue using these to practice and try different types of charts and variable combinations.
Capture your visualization(s) that you would provide to the decision makers.
Q4-Visualization
Go to the top menu and select WORKSHEET»CLEAR»SHEET to begin. Drag DteDay to Columns and CNT to Marks. Using the dropdown arrow on DteDay, select MONTH. Using the down arrow of CNT, select Quick Table Calculation»Rank. Using the down arrow of CNT, select COMPUTE USING»Table(Down). The table will be sorted by month. To sort by rank descending, select the highlighted icon as shown in the Figure 12.
To perform a visualization of this data, select a bar graph and move the Month to Columns and the Rank of Cnt to Rows. Sort the data as before using the icon in the toolbar.
You further want to understand how the temperature overlays on the rank ordering of months. Drag TEMP into the chart with the blue bars and on the left panel, use the dropdown arrow on TEMP to change MEASURE to Average. Ensure that Color is selected for the AVG(Temp). The chart will change the color gradation to go from light to dark for cold to hot. The higher ranked months are the darkest and therefore the hottest.
Make sure to capture the visuals you want to include for the decision makers.
Q5-Visualization: Go to the top menu and select WORKSHEET » CLEAR » SHEET to begin. Select the HOMEWORK2_DATA_HOUR.xlsx dataset at the top right of the worksheet in the Data area. Drag Day to Row. Double click Casual. Double click Registered. Using the down arrow for each Casual and
Registered, select Measure » Average. The table in Figure 16 is generated.
Add Hour to the table. Drag Day to Columns before Measure Names. Drag Hr to Rows. The table in Figure 17 is generated. It provides percentages in a day by hour grid for each registered and casual users. The users are split to provide percentages for planning and extrapolations.
To visualize the information, Go to the top menu and select WORKSHEET»CLEAR»SHEET. Drag Hr to Columns. Drag Day to Rows. Double click Cnt. Double click Registered. Moving mouse to the left of Cnt, use the dropdown to select Size. Move the mouse to the left of Registered, use the dropdown to select Color. The visualization in Figure 18 represents the Cnt in size of squares by day across hours and is colored darker where registered users are larger and lighter where registered users are smaller by day and by hour.
To further visualize, drag Hr out of Columns and off Chart to remove it from the view. Drag Season to Columns. Click the Bullet Graph on the Show Me menu on the right. The resulting visualization shows the total Cnt and overlays the registered users by showing black bars as Average and the grey bars as Registered Percent of Average. Specifically, the longer grey bar shows 80% of Registered User Average and the shorter grey bar shows 60% of Registered User Average.
Continue using these variables to practice and try different types of charts and variable combinations.
Capture your visualization(s) that you would provide to the decision makers.
Attachment:- Bike Share Program Analysis.rar