Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. If you havent completed any of the prior data analytics cases, follow the instructions listed in the Chapter 1 Data Analytics case to get set up. You will need to watch the videos referred to in the Chapters 1 - 3 Data Analytics cases. No additional videos are required for this case. All short training videos can be found here. Data Analytics Case Deferred Taxes and the Tax Cuts and Jobs Act of 2017 In the Data Analytics Cases in the previous chapter, we applied Tableau to examine a data set and create charts to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. as to their pattern of leasing facilities, their transition to the new lease accounting standard in 2019, and the effect of that transition on debt covenants. In this case, we examine the effect of the Tax Cuts and Jobs Act of 2017 on these companies operations and financial positions. Resources: Download the "GPS_Tru_Financials.xlsx" Excel file and save it to the computer on which you will be using Tableau. For this case, you will create a calculations to produce the effective tax rate to allow you to compare and contrast the effect of the 2017 Tax Act on the two companies. After you view the training videos, follow these steps to create the charts you'll use for this case: Open Tableau and connect to the Excel spreadsheet you downloaded. Starting on the Sheet 1 tab, drag Company and Year under Dimensions to the Columns shelf. Change Year to discrete by right-clicking and selecting Discrete. Drag Provision for income tax and Deferred income taxes under Measures into the Rows shelf. Click on the Show Me and select side-by-side bars. Add labels to the bars by clicking on "Label" under the "Marks card and clicking the box "Show mark labels." Format the labels to Times New Roman, bold, black and 10-point font. Edit the color of the years on the Color marks card if desired by dragging Year on to the color card. Change the title of the sheet to be Provision for Income Taxes and Deferred Tax Liability Trend 2012-2021 by right-clicking and selecting "Edit title." Format the title to Times New Roman, bold, black and 15-point font. Change the title of Sheet 1 to match the sheet title by right-clicking, selecting Rename and typing in the new title. On the Sheet 2 tab, follow the procedure above for the company and year. Drag Provision for income tax and Income from continuing operations under Measures into the Rows shelf. Change each to Discrete data and uncheck Show Header. Create a calculated field by clicking the Analysis tab at the top of the screen and selecting Create Calculated field. Name the calculation Effective Tax Rate. In the calculation box, drag the following from the Rows shelf: Provision for income taxes," type a division sign and open parenthesis, "Income from continuing operations, type an addition sign, Provision for income taxes, and type a closed parenthesis. Make sure the window says that the calculation is valid and click OK. Drag the newly created Effective Tax Rate to the Rows shelf. Click on the Show Me and select side-by-side bars. Add labels to the bars by clicking on "Label" under the "Marks card and clicking the box "Show mark labels." Format the labels to Times New Roman, bold, black and 10-point font. Edit the color on the Color marks card if desired. Change the title of the sheet to be Effect of the Tax Cuts and Jobs Act of 2017 by right-clicking and selecting "Edit title." Format the title to Times New Roman, bold, black and 15-point font. Change the title of Sheet 2 to match the sheet title by right-clicking, selecting Rename and typing in the new title. Format all other labels to be Times New Roman, bold, black and 12-point font. Once complete, save the file as DA16_Your initials.twbx. Required: For each of the two companies in the ten-year period, 2012-2021, use Tableau to calculate and display the trends for: (a) the provision for income taxes (b) the deferred tax liability, and (c) effective tax rate. Based upon what you find, answer the following questions: Is Tru, Inc.s provision for income tax (a) higher, (b) lower, or (c) roughly the same over the period 2018-2021 than in previous years? Did Tru, Inc.s deferred tax liability appear to benefit from the Tax Act? What is the effective tax rate for GPS (provision for income tax divided by [net income plus provision for income tax]) in 2017? (Enter your answer as a whole percentage.) What is the effective tax rate for GPS (provision for income tax divided by [net income plus provision for income tax]) in 2018? (Enter your answer as a whole percentage.)