The Walkthrough 30s 0.00/11:49 The phrase science est potentia is a Latin aphorism meaning "knowledge is power in a business sense, this might b paraphrased as information is moneyBetter information better business decisions. This is the keystone of data analytics Data analyties 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 data visualization software such as Tebleau. In each chapter of this textbook, you will have the opportunity to experience 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 you 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 three "Getting Started" Tableau videos. Future cases will build off what you learn in these videos, and additional videos will be suggested. All short training videos can be found here This case introduces you to data analysis in a very basic way by allowing you to quickly extract, visualize, and compare financial data over a span of ten years for two hypothetical publicly traded companies Discount Goods and Big Store For this case, assume you are an analyst conducting introductory research into the relativements of investing in these companies. For this initial look, you want to visualize the pattern of not income and of net operating cash flows over th past ten years for the two companies 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 avaliable. The one for use in this chapter is named "Discount Goods BioStoreCases. Download this file and save it to the computer on which you will be using Tableau 1. Open Tableau and connect to the Excel spreadsheet you downloaded. You should see the data in the canvas aren of Tableau 2. Click on the Sheet tab at the bottom of the canvas, to the right of the Data Source at the bottom of the screen Move "Account name into the Filters shell in the Fiter dialog box that opens, if all accounts are selected, un-check all accounts by selecting the "None" button 4. Select only the account "Net cash flows from operating activities. Click OK. Note: the accounts are listed alphabetically 5. From the Dimensions section on the top left side of the canvas, drag "Store" and "Measure Nomes into the Columns are at the top of the canvas 6. From the Measures section on the middle left side of the canvas, drag "Measure Values into "Rows" area 7 In the "Rows ares, remove "Number of Records from "Measure Values by clicking the pull-down menu arrow from the Measures Values dimension Select Edit Filter.unselect "Number of Records, and click "OK" 8 On the Show Me" menu in the upper right corner of the toolbar, select the side-by-side bars if they do not already appear in that chart format Add labels to the bats by clicking on "Label in the "Marks card and clicking the box "Show mark tabel". In the same box, format the labels to Times New Roman, bold, black, 10-point by selecting those options using "Font". 9. Change the title of the sheet to be "Operating Cash Flows: Discount Goods vs. Big Store" by night-clicking "Sheet1 and selecting "Edit Tio Then, format the title to Times New Roman, bold, black, and 15-point font of the color bars of your chart are all the same color change the colors of the bars by dragging "Measure Names onto Color in the "Markscard they are already multi-colored, then you can leave your chart as is. It Format the years by right clicking on any year in the chart, then select "Format from the menu. The "Format Measures Name window will open on the left. Change the Default Font dropdown box to Times New Roman, bold, options using "FOHC 9. Change the title of the sheet to be "Operating Cash Flows: Discount Goods vs. Big Store" by right-clicking "Sheet" and selecting "Edit Title Then, format the title to Times New Roman, bold, black, and 15-point font. O. If the color bars of your chart are all the same color, change the colors of the bars by dragging "Measure Names onto "Color in the "Marks card. If they are already multi-colored, then you can leave your chart as is. 11. Format the years by right-clicking on any year in the chart, then select "Format" from the menu. The "Format Measures Name window will open on the left. Change the Default Font dropdown box to Times New Roman, bold, black, and 10-point. This chart is now complete 2. To save time completing the next chart, right-click the "Sheet T tab at the bottom of the canvas and select "Duplicate 3. Click on the new Sheet 1(2/" tab. You should now see a duplicate of the "Sheet chart. Now, double-click on "Account name in the "Filters shelf. When the filter dialog box opens, un-check all accounts by selecting the "None" button. Note: The filter dialog box may open to the right of the canvas 4. While the Filter dialog box is still open, select only the account "Net income/lossy" and click "OK". Then, change the uitle to "Net Income /(Loss): Discount Goods vs. Big Store' by editing the title as instructed above. Required: Based upon what you find answer the following questions A. One of the companies reported a huge loss on its income statement related to a foreign expatriation of properties in one of the years. Which company, which year, and what was the amount of net income or net loss that resulted for that year? 3. What was the amount of net operating cash flow in the year of the loss for the company reporting the loss? c. Which company reported the largest percentage change in net operating cash flows between 2012 and 2021, and what was the percentage change for that company? D. Which company reported the largest percentage change in net income between 2012 and 2021, and what was the percentage change for that company? Complete this question by entering your answers in the tabs below. Reg A Reg C and B and D A. One of the companies reported a huge loss on its income statement related to a foreign expatriation of properties in one of the years. Which company, which year, and what was the amount of net income or net loss that resulted for that year? B. What was the amount of net operating cash flow in the year of the loss for the company reporting the loss? Show less A in 2014 reported a of million. B. Not operating cash flow million in ARIE ReqC and D > what was the percentage change for that company? Which company reported the largest percentage change in net income between 2012 and 2021, and what was percentage change for that company? Complete this question by entering your answers in the tabs below. Reg A Reqc and B and D C. Which company reported the largest percentage change in net operating cash flows between 2012 and 2021, and what was the percentage change for that company? D. Which company reported the largest percentage change in net income between 2012 and 2021, and what was the percentage change for that company? For all requirments, round your answers to the nearest whole percentage. Negative amounts shou be shown with a minus sign.) Show less C. For net operating cash reported the largest percentage % flows change of For net operating income D reported the largest percentage floss) change of