Part of this assignment is locating the data on your own. You should use the IRS's...

• 
• 
  • 
    
    • 
      

Transcribed Image Text:

Part of this assignment is locating the data on your own. You should use the IRS's Statistics of Income (SOI) data to complete the Tableau visualizations. The SOI data is available at www.irs.gov and you should look for "SOI Tax Stats - Individual Income Tax Returns with Small Business Income and Losses" and then for the 2019 (which is the most recently available) data for "Individual Returns with Business Attributes: Selected Income Items, Adjustments, Credits, and Taxes." Your focus in analyzing the data should relate to "Partnerships & S- corporations" (columns BG-BJ) and the "Qualified Business Income Deduction" (columns DG DH). You may still use other information in the Excel, but at a minimum must include the QBI information for these pass- through entities. Please be sure you download the correct SOI data set. You'll see that 10% of the assignment's grade is "Data used is appropriate and sufficient for the analysis." Failure to use the correct data set is an automatic 10% grade loss (which equates to a full letter grade for the assignment). The grading rubric is attached here for your convenience. Once you download the data set you should proceed to open/import it to Tableau. Your objective is to produce 3 meaningful visualizations-the visuals should tell a story without the necessity of written words. However, you are not precluded from adding some narrative and/or a dashboard and/or a storyboard. You may work in groups (max of 3) and all syllabus stipulations apply (e.g., you should only be sharing files among your group members). EACH student (regardless of whether you work in a group or solo) should upload the following to iCollege: 1) The Tableau packaged workbook file (*.twbx) you created. You may need to use the drop down to see the *.twbx option for saving your Tableau file. The packaged version includes your data file. 2) PDFs of the 3 visualizations; and PDFs of your dashboard and/or storyboard. NOTE: You can "print to PDF" from Tableau to create the PDFs. I MUST have the PDFs to grade your projects. 3) All file names should include your name or all group members' names. For example IRS.IRA.data. Smith Mike; Tableau.Smith.Mike; Viz1.Smith Mike; Viz2.Smith Mike; Viz3.Smith Mike; Dash B.Smith.Mike; StoryB.Smith Mike Although the assignment is not due until near the end of the term, it is provided in Module 1 so you may begin to work on it as soon as your schedule permits. Part of this assignment is locating the data on your own. You should use the IRS's Statistics of Income (SOI) data to complete the Tableau visualizations. The SOI data is available at www.irs.gov and you should look for "SOI Tax Stats - Individual Income Tax Returns with Small Business Income and Losses" and then for the 2019 (which is the most recently available) data for "Individual Returns with Business Attributes: Selected Income Items, Adjustments, Credits, and Taxes." Your focus in analyzing the data should relate to "Partnerships & S- corporations" (columns BG-BJ) and the "Qualified Business Income Deduction" (columns DG DH). You may still use other information in the Excel, but at a minimum must include the QBI information for these pass- through entities. Please be sure you download the correct SOI data set. You'll see that 10% of the assignment's grade is "Data used is appropriate and sufficient for the analysis." Failure to use the correct data set is an automatic 10% grade loss (which equates to a full letter grade for the assignment). The grading rubric is attached here for your convenience. Once you download the data set you should proceed to open/import it to Tableau. Your objective is to produce 3 meaningful visualizations-the visuals should tell a story without the necessity of written words. However, you are not precluded from adding some narrative and/or a dashboard and/or a storyboard. You may work in groups (max of 3) and all syllabus stipulations apply (e.g., you should only be sharing files among your group members). EACH student (regardless of whether you work in a group or solo) should upload the following to iCollege: 1) The Tableau packaged workbook file (*.twbx) you created. You may need to use the drop down to see the *.twbx option for saving your Tableau file. The packaged version includes your data file. 2) PDFs of the 3 visualizations; and PDFs of your dashboard and/or storyboard. NOTE: You can "print to PDF" from Tableau to create the PDFs. I MUST have the PDFs to grade your projects. 3) All file names should include your name or all group members' names. For example IRS.IRA.data. Smith Mike; Tableau.Smith.Mike; Viz1.Smith Mike; Viz2.Smith Mike; Viz3.Smith Mike; Dash B.Smith.Mike; StoryB.Smith Mike Although the assignment is not due until near the end of the term, it is provided in Module 1 so you may begin to work on it as soon as your schedule permits.

Answer rating: 100% (QA)

I understand that you need to work on a data analysis assignment using Tableau specifically with IRS SOI data for partnerships Scorporations and the Q... View the full answer