Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 data visualization software such as Tableau. 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 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 three "Getting Started Tableau videos. Future cases will build off what you learn in these videos, and additional videos wit 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 relative merits of investing in these companies. For this initial look, you want to visualize the pattern of net income and of net operating cash flows over the 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 available. The one for use in this chapter is named Discount Goods_Big_Store Cose 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 area 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 3. Move "Account name into the Filters Shelt. In the Filter dialog box that opens, if all accounts are selected, un-check wil 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 Names" into the "Columnsarea at the top of the canvas 6. From the "Measures section on the middle loft side of the canvas, drag "Measure Values into "Rowsaren 7. In the "Rows area, 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 bars by clicking on "Label in the "Marks' card and clicking the box "Show maktabel 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 shoot to be "Operating Cash Flows: Discount Goods vs. Bg Store by night clicking "Sheet" and selecting 'Edit Title" 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 Marks card. If they are already multi-colored, then you can leave your chart as is 1 Format the years by right-clicking on any year in the chart, then select "Formar from the menu. The "Format Measures Name' window wil 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' 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 hors shelf. When the filter dialog box opens, un-check all accounts by selecting the "None bution. Note: The fiter dialog box may open to the right of the canvas. 4. While the Filter dialog box is still open select only the account "Net incomeblossy" and click "OK" Then, change the title 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? a. 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 urgent 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. ORA 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 data visualization software such as Tableau. 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 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 three "Getting Started Tableau videos. Future cases will build off what you learn in these videos, and additional videos wit 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 relative merits of investing in these companies. For this initial look, you want to visualize the pattern of net income and of net operating cash flows over the 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 available. The one for use in this chapter is named Discount Goods_Big_Store Cose 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 area 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 3. Move "Account name into the Filters Shelt. In the Filter dialog box that opens, if all accounts are selected, un-check wil 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 Names" into the "Columnsarea at the top of the canvas 6. From the "Measures section on the middle loft side of the canvas, drag "Measure Values into "Rowsaren 7. In the "Rows area, 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 bars by clicking on "Label in the "Marks' card and clicking the box "Show maktabel 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 shoot to be "Operating Cash Flows: Discount Goods vs. Bg Store by night clicking "Sheet" and selecting 'Edit Title" 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 Marks card. If they are already multi-colored, then you can leave your chart as is 1 Format the years by right-clicking on any year in the chart, then select "Formar from the menu. The "Format Measures Name' window wil 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' 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 hors shelf. When the filter dialog box opens, un-check all accounts by selecting the "None bution. Note: The fiter dialog box may open to the right of the canvas. 4. While the Filter dialog box is still open select only the account "Net incomeblossy" and click "OK" Then, change the title 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? a. 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 urgent 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. ORA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

BondsA Concise Guide For Investors

Authors: M. Choudhry

2nd Edition

0230006493, 9780230006492

More Books

Students also viewed these Accounting questions

Question

1. Walk slowly; then be as still as possible.

Answered: 1 week ago

Question

a. Did you express your anger verbally? Physically?

Answered: 1 week ago