Assignment task: Texas Tax Revenues
1. Follow the instructions on Canvas for instzlling Tableau on your laptop or PC. Then download the Excel data file called State tax revenue 1998 2018.xlsx. Save it to a folder on your laptop or USB drive.
2. If you have no previous experience with Tableau, watch the Getting Started video using the link on Canvas.
Assignment:
Using the Excel data file downloaded from Canvas, create a visual story in Tableau that answers the following 3 questions. Each question should be supported by one visual and companion story point. Submit a saved copy of your Tableau workbook online via Canvas. Please clearly identify the story sheet by placingit last in the workbook and labeling it as Texas story.
Ql: Interms of total per capita sales tax revenue collected by each state from 1998 through 2018, where does Texas rank? Show the state names and ranked order numbers on your visual.
Q2: What percentage of the total tax revenue collected by Texas in 2018 was derived from sales tax? Show the total tax revenue and percentage on your visual.
Q3: How has the population of Texas grown between 1998 and 2018 as compared to the state's tax revenues from all sources? Use a dual combination visual with two vertical axes.