Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

  • Part of this assignment is locating the data on your own. You should use the IRS's Statistics of Income (SOI)
  • (regardless of whether you work in a group or solo) should upload the following to iCollege: 1) The Tableau


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.

Step by Step Solution

3.44 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

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... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discovering Advanced Algebra An Investigative Approach

Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke

1st edition

1559539844, 978-1604400069, 1604400064, 978-1559539845

More Books

Students explore these related Mathematics questions