Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. Data analytics is widely used in business to enable organizations to make better-informed business decisions. Increasingly, this is accomplished with the aid of specialized software such as Tableau. In each chapter of our textbook, you will have the opportunity to glimpse the power and efficacy of data analytics in the context of that chapter's topics, using Tableau as a tool. To prepare for this case-and those in subsequent chapters-using Tableau, you will need to download Tableau to your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. You will receive further information on setting up Tableau from your instructor. Once you are set up with Tableau, watch the first few training videos on the Tableau website. If you completed the first Data Analytics Case, you already have watched the three "Getting Started" videos. Now to prepare for this case you should view the "Ways to Filter," "Using the Filter Shelf," and "The Formatting Pane" videos listed under "Visual Analytics." Future cases will build off of your knowledge gained from these, and additional videos will be suggested. All short training videos can be found here. In the Chapter 1 Data Analytics Case, you applied Tableau to examine a data set and create bar charts to compare ten-year trends in operating cash flows and net income for our two (hypothetical) publicly traded companies: Discount Goods and Big Store. In this case you continue in your role as an analyst conducting introductory research into the relative merits of investing in one or both of these companies, this time comparing the proportional composition of the assets, liabilities, and stockholders' equity of the two companies. You want to create pie charts to visualize the relative size of the components of the balance sheets for each of the two companies to garner some initial insights. Tableau Instructions: You have available to you an extensive data set that includes detailed financial data for Discount Goods and Big Store and for 2012- 2021. The data set is in the form of an Excel file available to download from Connect, or under Student Resources within the Library tab. There are four Excel files available. The one for use in this chapter is named "Discount Goods Big StoreCase1.xlsx". Download this file and save it to the computer on which you will be using Tableau. For this case, you will need to review the raw data in the Excel file for both companies before beginning. Review the Required questions below to determine which account classifications, like "Total current assets," to include in your pie charts. These will be the items you include in what's called "Account name". Notice that the two companies have somewhat different names for their accounts, but the major groups are the same. After you view the training videos, follow these steps to create the charts you'll use for this case: 1. Open Tableau and connect to the Excel spreadsheet you downloaded. Starting on the "Sheet 1" tab, at the bottom right side of the canvas, double click on "2021" under "Measures" to add it to the canvas Rows shelf. 2. Click the pull-down menu arrow on "Store" under "Dimensions" and click "Show Filter." The filter box will appear on the right side of the canvas. Un-click the "(All)" button and click only Discount Goods. 3. Move "Account name" into the Filter shelf. In the Filter dialog box that opens, click all Discount Goods' account classifications you've identified as needed for the case. You can determine this information by checking the raw data as instructed above. Hint: You should have selected a total of 5 account classifications. 4. Drag "Account name" from the Dimensions area on the left side of the canvas to "Color" in the "Marks" card to add more colors to the chart. On the "Show me" tab in the upper right corner of the toolbar, select the pie chart. 5. Enlarge the pie chart by holding down the shift-control-and-clicking the "B" key several times until your pie chart fills most of the screen. 6. Add "Labels" to the pie sections by clicking on "Label" in the "Marks" card and clicking the box "Show mark label" 7. Format the label amounts to Times New Roman, bold, black, 12-point font. 8. Change the title of the sheet to be "Discount Goods 2021 Balance Sheet" by right-clicking and selecting "Edit title." Format the title to Times New Roman, bold, black and 15-point font. 9. To save time completing the next page, right-click the "Sheet 1" tab at the bottom of the canvas and select "Duplicate." 10. Click on the "Sheet 1 (2)" tab. You should now see a duplicate of the "Sheet 1" canvas. In the filter box on the right-hand side, click only the Big Store checkbox. 11. Change the title of the sheet to be "Big Store 2021 Balance Sheet" by right-clicking and selecting "Edit title." Format the title to Times New Roman, bold, black and 15-point font. 12 Once complete ran the file se "DA? Vour initiale huu" Fitnes New Roman, black and 15-point font. 12. Once complete, save the file as "DA2 Your initials.twbx." Required: Based upon what you find, answer the following questions: A. For Discount Goods, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? B. For Big Store, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? C. Which of the two companies has the highest ratio of current liabilities to total liabilities? What is the ratio for that company? (Round your answer to the nearest whole percent.) D. Which of the two companies has the highest ratio of current assets to current liabilities? What is the ratio for that company? (Round your answer to the nearest whole percent.) Answer is complete but not entirely correct. A. For Discount Goods B. For Big Store liabilities liabilities C. For current liabilities to total liabilities Big Store provide the greater proportion of the company's assets. provide the greater proportion of the company's assets. reported the highest ratio of 7% D. For current assets to current liabilities Discount Goods reported the highest ratio of 8% 16 15 Next ALLY MIN 11M LA www MIN G Ch C T Le " 3,340 .. THE Tow A De X LI 9 L AL Ow 21/1 BAY ZUM 100 LP ME LA 3017 JAMI 33 154 N AME 30300 TOM 31MY 430 2140 A Ber 124 " " SIN 2 17 4477 L T " LM a DIE W . . . W APE 4347 137 LA W M LAST A AIR AM O "W " W ALTH KAT " E . . " " " . . " " AR " W * LE 34217 AMI w L L M ANY A ar . K K 116 L L A ww THR 40 AM M A SA KAY K S ALONE TAW 17 THE AN TIM ANY () ALIE 100 TAW LI LAM N HE TWO 14090 LA L P N SINP So La Du 1300 ATM A rar W] L MA M LOW TAM M LE un A MY authe WH 04 L LIM C "AIL 44 L 410 25 KING W E AT Am TEM Man M4 www ww Sai M 10 100 U IN M KAN SAM 43 MAM MA KN AIM " www Stre St Teh float Can Ten flae Cad Cash Mows Cash Flow Call F pital lease and fratong ilipatan SURE www BUISE 14310 395 MUSE BJAR 305 ... E RAIL LOVE AN BERPER GREBERNA LIF www B LAN www