Answered step by step
Verified Expert Solution
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!
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 Thank You!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started