Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone please tell me how to do number 3 in tableau. what should be my rows and columns on multiple sheets. tables are shown

can someone please tell me how to do number 3 in tableau. what should be my rows and columns on multiple sheets. tables are shown as well. Please help in detail!
Thank You!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Tables \# Short Term Investment Cash \# Total Assets \# Total Current Assets \# Total Depreciation \# Total Liabilities \# Total Other Assets \# Total Shareholder Equity Income Statement Data \# Claim And Loss \# Cost of Goods Sold \# Depreciation And Amortization Expense * Diluted Earnings Per share \# Discontinued Operations \# Earnings Per Share \# Equity in Earnings \# Extraordinary lterns \# General Expenses \# Gross Income \# Income Tax Expense \# Interest Expense On Debt \# Interest Expense Total \# Interest Income \# Loan Loss Provision \# Minority interest \# Net income \# Net Revenues \# Non-Interest Expense \# Non-Interest Income Total 4 Operating Incorne \# Other Non-Operating Expenses \# Other Operating Expenses \# Other Operating income \# Pre-Tax Equity Earnings \# Pre-Taxincome \# Preferred Dividend \# Premiums Earned = Rosearch And Development Expense Data Analytics Balance Sheet Data+ (Analytics_mindset_case_studies_DuPont) Search Tables Balance Sheet Data Aoc Financial Statement Abe Industry Abc Name Abc Ticker \# Year Iili Income Statement Data Abe Extraordinary Charge Abo Extraordinary Credit. Abc. Financial Statement (Income Statement Data) Abc Ticker (Income Statement Data) \# Year (Income Statement Data) Abc Measure Names Balance Sheet Data \# Accounts Payable \# Accounts Receivables \# Accrued Expenses (Liability) \# Cash \# Cash \& Short Term Investments \# Cash Due From Banks (Asset) \# Common Equity \# Common Shares Outstanding \# Deferred Taxes (Liability) \# Gross Property. Plant and Equipment \# Intangible Assets \# Inventories \# Long Term Debt \# Minority Interest (Equity) \# Other Current Assets \# Other Current Liabilities * Other Liabilities * Other Liabilities 1 \# Preferred Stock (Equity) \# Prepaid Expenses \# Short-Term Dobt * Short Term Imvestment Cash \# TotalAssets Analytics mindset Implementing the DuPont Method Part III: Apply appropriate data analytic techniques You are now ready to analyze the data. Previously, you identified five questions that you thought would provide relevant insights of the data. Before answering those questions, answer the questions that are listed below. For each question: Identify the type of the analysis to perform Identify which data elements are needed to perform the analysis Create the analysis using Tableau Assume you want to invest in one of the industries included in the dataset (i.e., buy stock in all companies in one industry). Which industries do you think will offer the highest and lowest return in 2016? Which industries will provide the safest and riskiest return in 2016? Does removing outliers change your opinion? \# Earnings Per Share \# Equity In Earnings \# Extraordinary Items \# General Expenses \# Gross Income \# Income Tax Expense \# Interest Expense On Debt \# Interest Expense Total \# Interest Income \# Loan Loss Provision \# Minority Interest \# Net Income \# Net Revenues \# Non-Interest Expense \# Non-Interest Income Total \# Operating Income \# Other Non-Operating Expenses \# Other Operating Expenses \# Other Operating Income \# Pre-Tax Equity Earnings \# Pre-Tax Income \# Preferred Dividend \# Premiums Earned \# Research And Development Expense \# Shares To Calculate EPS \# Shares To Calculate EPS Diluted \# Total Operating Expenses \# Underwriting Expenses \# Asset Turnover (Sales/Total Assets) \# Financial Leverage (Total Assets/Total Shareholders Equity) \# Profit Margin (Net Income/Sales) \# ROE (Net Income/ Total Shareholders Equity) \# Bafance Sheet Data (Count) \# Measure Values Tables \# Short Term Investment Cash \# Total Assets \# Total Current Assets \# Total Depreciation \# Total Liabilities \# Total Other Assets \# Total Shareholder Equity Income Statement Data \# Claim And Loss \# Cost of Goods Sold \# Depreciation And Amortization Expense * Diluted Earnings Per share \# Discontinued Operations \# Earnings Per Share \# Equity in Earnings \# Extraordinary lterns \# General Expenses \# Gross Income \# Income Tax Expense \# Interest Expense On Debt \# Interest Expense Total \# Interest Income \# Loan Loss Provision \# Minority interest \# Net income \# Net Revenues \# Non-Interest Expense \# Non-Interest Income Total 4 Operating Incorne \# Other Non-Operating Expenses \# Other Operating Expenses \# Other Operating income \# Pre-Tax Equity Earnings \# Pre-Taxincome \# Preferred Dividend \# Premiums Earned = Rosearch And Development Expense Data Analytics Balance Sheet Data+ (Analytics_mindset_case_studies_DuPont) Search Tables Balance Sheet Data Aoc Financial Statement Abe Industry Abc Name Abc Ticker \# Year Iili Income Statement Data Abe Extraordinary Charge Abo Extraordinary Credit. Abc. Financial Statement (Income Statement Data) Abc Ticker (Income Statement Data) \# Year (Income Statement Data) Abc Measure Names Balance Sheet Data \# Accounts Payable \# Accounts Receivables \# Accrued Expenses (Liability) \# Cash \# Cash \& Short Term Investments \# Cash Due From Banks (Asset) \# Common Equity \# Common Shares Outstanding \# Deferred Taxes (Liability) \# Gross Property. Plant and Equipment \# Intangible Assets \# Inventories \# Long Term Debt \# Minority Interest (Equity) \# Other Current Assets \# Other Current Liabilities * Other Liabilities * Other Liabilities 1 \# Preferred Stock (Equity) \# Prepaid Expenses \# Short-Term Dobt * Short Term Imvestment Cash \# TotalAssets Analytics mindset Implementing the DuPont Method Part III: Apply appropriate data analytic techniques You are now ready to analyze the data. Previously, you identified five questions that you thought would provide relevant insights of the data. Before answering those questions, answer the questions that are listed below. For each question: Identify the type of the analysis to perform Identify which data elements are needed to perform the analysis Create the analysis using Tableau Assume you want to invest in one of the industries included in the dataset (i.e., buy stock in all companies in one industry). Which industries do you think will offer the highest and lowest return in 2016? Which industries will provide the safest and riskiest return in 2016? Does removing outliers change your opinion? \# Earnings Per Share \# Equity In Earnings \# Extraordinary Items \# General Expenses \# Gross Income \# Income Tax Expense \# Interest Expense On Debt \# Interest Expense Total \# Interest Income \# Loan Loss Provision \# Minority Interest \# Net Income \# Net Revenues \# Non-Interest Expense \# Non-Interest Income Total \# Operating Income \# Other Non-Operating Expenses \# Other Operating Expenses \# Other Operating Income \# Pre-Tax Equity Earnings \# Pre-Tax Income \# Preferred Dividend \# Premiums Earned \# Research And Development Expense \# Shares To Calculate EPS \# Shares To Calculate EPS Diluted \# Total Operating Expenses \# Underwriting Expenses \# Asset Turnover (Sales/Total Assets) \# Financial Leverage (Total Assets/Total Shareholders Equity) \# Profit Margin (Net Income/Sales) \# ROE (Net Income/ Total Shareholders Equity) \# Bafance Sheet Data (Count) \# Measure Values

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

Step: 3

blur-text-image

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

Financial Accounting Tools For Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

4th Edition

0471730513, 978-0471730514

More Books

Students also viewed these Accounting questions