MBA 540 Module Four User Manual: Working with Tableau
The Tableau Public software is a free tool for presenting data in easy graphical formats for analyses. Refer to this user manual for doing the Tableau assignment.
Accessing Tableau Public via the Virtual Desktop Infrastructure (VDI)
1. Open the virtual desktop infrastructure (VDI) on your machine and then open the Tableau Public 2020.4 software.
The Open screen of Tableau Public is displayed.
Importing Files into Tableau Public
1. Open the Tableau Public software on your machine. The Open screen of Tableau Public is displayed.
NOTE: For steps to access the Tableau Public software via the virtual desktop infrastructure (VDI), refer Accessing Tableau Public via the VDI.
2. In the left pane, in Connect, under To a File, click Open.
3. The File Explorer window is displayed. Go to Desktop, then the Business Analytics Course Content Folder, and then MBA-540. Select the CSV file to be imported and click Open.
4. The imported CSV file is displayed in Tableau Public.
Note: In Tableau Public, the imported file is displayed under the Data Source tab. You will find this tab at the bottom left corner of the screen.
Performing Data Analysis
To answer the questions, you have been asked in the Module Four assignment, follow these steps:
1. Start a new Tableau Project and import the CSV file.
2. In the bottom left corner of the Tableau project, click on Sheet 1.
A new sheet title, Sheet 1, is displayed.
Note: To create new sheets, click the following icon in the bottom left corner of the screen:
Analyzing Question 1
1. In a new sheet, in the left pane under Tables, drag Q1: Gender, given in qualitative data format (signified as Abc), and drop it in the right pane in Columns.
2. Similarly, in the left pane under Tables, drag Q5: What is your current level of burnout at work? (Qualitative Data), given in qualitative data format (signified as Abc), and drop it in Columns.
3. To get the numerical data in the table, under Tables, drag Q5: What is your current level of burnout at work? (Quantitative Data), given in quantitative data format (signified as # ), and drop it in the right pane in Rows.
On dropping Q5: What is your current level of burnout at work? (Quantitative Data) in Rows, a graph is displayed.
4. In the right pane in Rows, point your cursor to SUM Q5: What is your current level of burnout at work? (Quantitative Data). A green drop-down arrow is displayed.
5. Select the green drop-down arrow.
6. In the options displayed, select Measure (Sum), and then select Count.
The graph is now ready to perform analysis of question 1.
7. Point to a bar in the graph to get details regarding the same. For example, place your cursor over the fifth bar from the left. The data that is displayed signifies. 21 females are experiencing this burnout level: Pretty wiped out almost every day.
Using step 6, find the number of males and females for the different burnout levels and answer question 1.
Analyzing Question 2
1. Create a new sheet.
2. In the left pane under Tables, drag Q1: Gender, Q2: Age, and Q6: How stressed are you at home? (Qualitative Data), given in qualitative data format (signified as Abc), and drop it in the right pane in Columns.
3. In the left pane under Tables, drag Q6: How stressed are you at home? (Quantitative Data), given in quantitative data format (signified as #), and drop it in the right pane in Rows. The graph is displayed.
4. In the right pane in Rows, for Q6: How stressed are you at home? (Quantitative Data), change Measure (Sum) to Count.
Note: For detailed steps on how to change the measure to Count, in Analyzing Question 1, refer to steps 4 and 5.
The graph is now ready to perform analysis of question 2.
5. Point to a bar in the graph to get details regarding the same. For example, place your cursor over the fourth bar from the left. The data that is displayed signifies 20 females of the age group 40–45 years are experiencing the stress level A little stress that would be expected with the ups and downs of life at home.
Using step 5, find the number of males and females belonging to a particular age group who experience the different stress levels at home and answer question 2.
Analyzing Question 3
1. Create a new sheet.
2. In the left pane under Tables, drag Q4: Leadership Level and Q8: I love what I do. (Qualitative Data), given in qualitative data format (signified as Abc), and drop it in the right pane in Columns.
3. In the left pane under Tables, drag Q8: I love what I do. (Quantitative Data), given in quantitative data format (signified as #), and drop it in the right pane in Rows. The graph is displayed.
4. In the right pane in Rows, for Q8: I love what I do. (Quantitative Data), change Measure (Sum) to Count.
Note: For detailed steps on how to change the Measure to Count, in Analyzing Question 1, refer to steps 4 and 5.
5. Point to a bar in the graph to get details regarding the same. For example, place your cursor over the fifth bar from the left. The data that is displayed signifies 7 Executives Agree that they love what they do.
Using step 5, find out the different number of leaders who love what they do and answer question 3.
Analyzing Question 4
1. Create a new sheet.
Note: For the steps to create a new sheet, refer the note given in Performing Data Analysis.
2. In the left pane under Tables, drag Q1: Gender, Q3: Tenure, and Q5: What is your current level of burnout at work? (Qualitative Data), given in qualitative data format (signified as Abc), and drop it in the right pane in Columns.
3. In the left pane under Tables, drag Q5: What is your current level of burnout at work? (Quantitative Data), given in quantitative data format (signified as #), and drop it in the right pane in Rows. The graph is displayed.
4. In the right pane in Rows, Q5: What is your current level of burnout at work? (Quantitative Data), change Measure (Sum) to Count.
Note: For detailed steps on how to change the Measure to Count, in Analyzing Question 1, refer steps 4 and 5.
5. Point to a bar in the graph to get details regarding the same. For example, place your cursor over the fifth bar from the left. The data that is displayed signifies that 7 females with the tenure of 2–5 years are experiencing the burnout level A bit worn out at the end of the day, several days a week.
Using step 5, find the number of males and females with a particular tenure experiencing the different burnout levels and answer question 4.
For all questions, please take screenshot of your final work (the bar charts) and add them to your solution for the assignment.