Open The Fingal Dublin Census Data Excel File Using Tableau: Business Analytics And IT Assignment, DBS, Ireland

Questions

Section 1

1. Open the Fingal Dublin Census Data Excel file using Tableau. Paste the post-import screen into this document as your answer.

2. Develop six calculated fields to calculate the difference in population between each census. For example, the difference between 1981 and 1986 is one calculation.

3. Develop a table showing the location and population change from each census from 1981 to 2011

4. Add a total to the end of each period showing the total increase for the complete region.

5. Graph the table in the most suitable graph type and explain your choice of the graph).

6. Graph the data from question c above into a pie chart with the location names as labels.

7. Develop two further graphs based on the available data and explain your reasons for choosing these graphs.

Section 2 

1. Open a new data connection to the tableau Large DatasetExcel file using Tableau and develop a table with the product categories on the Y-axis and the Day of the Week on the X-axis. Populate the values with a count of items sold.

2. Develop a bubble graph using the product item and filter our nonsense items. The Bubble graph should have multiple colors and labels as part of the graph.

3. Using the bubble graph, create a regression chart using rainfall and max temperature.

4. Extract the month from the date and use it to create a motion graph for each month that the above regression runs for. Note: You must screengrab at least 4 of the months and paste as part of this answer.

5. Explain the findings from the graph in question 2d.

6. Develop a heat map of the table in 2a.

7. What does the heat map from question 2f tell us?

8. Using the same table from 2a, add in the product/item name as a subheading of the category.

9. Explain what added value the product/item name adds to the person reading the graph.

Section 3 

1. Take any two graphs from question 1 and interpret them. Provide details of what the graphs tell us and how this information could be used to drive business decisions.

2. Drill down into any two graphs from question 2 above and interpret the drilled down graphs. Provide details of what the drilled-down graphs tell us and how this information could be used to drive business decisions.

3. Take Graphs that you developed for question 1 and put them into a dashboard.

4. Demonstrate that the other graphs in the dashboard changed as a result of the filter you applied in point an above.