New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
data analytics accounting
ISE Data Analytics For Accounting 3rd Edition Ryan A. Teeter, Vernon Richardson, Katie L. Terrell - Solutions
(LO 8-1) What type of ratios measure a firm’s operating efficiency?a. DuPont ratiosb. Liquidity ratiosc. Activity ratiosd. Solvency ratios
(LO 8-1) The DuPont analysis of return on equity (ROE) includes all of the following component ratios except:a. asset turnover.b. inventory turnover.c. financial leverage.d. profit margin.
Using Exhibit 8-14 as the source of data and using the raw accounts, show the components of profit margin, operating leverage, and financial leverage and how they are combined to equal ROE for Q1 2014 for DuPont (Ticker = DD).
Assuming XBRL-GL is able to disseminate real-time financial reports, which real-time financial elements (account names) might be most useful to decision makers? And which information might not be useful?
How might standardized XBRL metrics be useful in comparing the financial statements of General Motors, Alphabet, and Alibaba?
How does XBRL facilitate Data Analytics by analysts?
Why would you guess the results between the proportion of negative words and the stock market reaction to the 10-K issuance differ between the Fin-Neg and the H4N-Inf dictionary?
Which do you predict would have more positive sentiment in a 10-K, the footnotes to the financial statements or the MD&A (management discussion and analysis) of the financial statements?
How might sparklines be used to enhance the DuPont analysis? Would you show the sparklines for each component of the DuPont ROE disaggregation, or would you propose it be shown only for the total?
What would a horizontal trend tell you about a firm’s performance?
Which ratios would a financial institution be most interested in when determining whether to grant a loan to a business?
Describe how XBRL tags financial reporting data and how it facilitates financial statement analysis.
Describe the value of text mining and sentiment analysis of financial reporting.
Explain how to create and read visualizations of financial statement data.
Understand different types of financial statement analysis that are performed.
Compare and contrast the treemap produced by Tableau Desktop with the one produced by Power BI Desktop. Which one is easier to interpret?
Compare and contrast the stacked bar chart produced by Tableau Desktop with the one produced by Power BI Desktop. Which one is easier to interact with?
Compare and contrast the cluster model produced by Tableau Desktop with the one produced by Power BI Desktop. What do you notice about the clusters?
If you exclude the city from the previous question from analysis, what sales rank does Arkansas fall to?
Which city has the highest volume of sales for the two weeks of analysis?
Which three states had the lowest sales volume for the two weeks of analysis?
Which three states had the top sales volume for the two weeks of analysis?
How would you collect those additional data?
What additional data would you want to gather to help explain why sales transactions decrease on the days with the lowest sales?
Given this pattern, would you expect the next day after this analysis to be higher or lower than the last day?
Look up these dates on a calendar. What do you notice about the days with higher transaction amounts?
Which two days appear to have the lowest transaction amounts?
Which two days appear to have the highest transaction amounts?
Look at the cluster of low-performing stores. What do you think are some of the drivers for their poor performance?
Look at the cluster of high-performing stores. What do you think are some of the drivers for their good performance?
What would happen to the cluster of high-performing stores if you had chosen fewer clusters to analyze?
What is the store number of the lowest-performing store?
If management is interested in lowperforming stores, where would they locate the cluster on this graph?
What is the store number of the highest-performing store by volume?
If management is interested in high-performing stores, where would they locate that cluster on this graph?
What additional available measures or calculated fields might you use to evaluate store performance?
In Tableau, the benchmark colors show below 60 percent as red, below 80 percent as yellow, and below 100 percent as green. Why might a manager consider 80–100 percent of the previous year’s results acceptable?
How many stores are missing benchmark data from 2016?
How many stores failed to exceed the average transaction amount from the previous year?
What do you notice about the automatic color selections for the graph? What colors would you choose to make the chart more readable?
If you were the division manager, what might you do with this KPI information?
What might explain the change in the number of stores that met the KPI target from 2015 to 2016?
How many stores exceeded the KPI target in March 2015?
How many stores exceeded the KPI target in 2015?
How many stores exceeded the KPI target in 2016?Hint: Filter out stores that don’t meet the threshold.
Which state(s) exceeded the KPI target for average transaction amount in 2016?
Why do you need to create measures in Power BI and/or calculated fields in Tableau?
What is the purpose of a parameter?
What is the purpose of creating hierarchies of date fields?
When comparing the current value to the previous value or the target KPI, what is the expected output of the calculation?
What is the KPI target value for average sales?
What is the current year you are evaluating?
How does having KPI analysis in addition to time series analysis (what you created in Parts 1 through 3 of this lab) help make the analysis more robust?
We know that the Dillard’s database includes much more information than what we loaded into Excel through the SQL query, including product hierarchy data. How would including product category or SKU data help Dillard’s plan future promotions or future purchases? What would you recommend that
How does the ability to drill down into the state and store data give management critical information and help them identify issues that are occurring or opportunities that might be available?
Remove all filtering (it may be easier to temporarily remove the Store and State Hierarchy from the field list to answer this question). What is the overall Current Year Status for 2015?
Remove all filtering (it may be easier to temporarily remove the Store and State Hierarchy from the field list to answer this question). What is the overall Current Month Status for September 2016?
What is the Current Month Status for December 2015 in Georgia (GA)?
What additional analysis would you include to dig deeper into these results (adding additional data, filters, hierarchies, etc.)?
What would you recommend that Dillard’s do regarding the past performance exhibited in the Day of the Week Dashboard?
Which day strikes you as the most interesting and why?
Which mid-week day (non-weekend day) has the best sales?
Which week day is consistently the best-selling day across each year?
Which year had the best Monday sales?
What is the general trend across weekdays (Sunday to Saturday)?
How do you think each different chart (Highlight Table, Sparklines/Cycle Plot, Multi-Line Chart, or Single Line Chart) provide different value to your analysis?
What would you recommend that Dillard’s do regarding the past performance exhibited in the Monthly dashboard?
Which month strikes you as the most interesting and why?
Which month has the best sales performance in 2014 and 2015?
Which year had the best March sales?
Which month is consistently the lowest performing in terms of sales?
Why do you think October 2016 has such a comparatively low sales amount?
Which trends stand out the most to you? What next steps would be interesting to take?
In which year did March have the lowest sales amount(round to the dollar)?
What was the sales amount in July 2016?
Which month and year had the highest sales amount?
What additional visualizations might you include on your dashboard?
What category of visualizations did you produce in this lab?
How does the balanced scorecard dashboard help management quickly identify issues?
Which product(s) has (have) fallen below the profit goal of 13 percent in February 2020?
Which customer is our best customer in February 2020?
Which salesperson is leading the rest for overall sales in February 2020?
Which state takes the most time to ship to in February 2020?
Are there any KPIs you selected that don’t have supporting data fields?
Using the available fields, identify some calculations or relationships that would support your KPIs from AQ1 to AQ4?
For each KPI, identify a benchmark value or KPI goal that you think management might use.
What KPIs would you consider using to evaluate customer relationships?
What KPIs would you consider using to evaluate employee growth?
What KPIs would you consider using to evaluate process efficiency?
What KPIs would you consider using to evaluate sales financial performance?
What color should you use to show favorable metrics?
What is the average revenue threshold for our best customers?
What is management’s expected profit margin for each product?
For the job(s) with negative profit, are all variances unfavorable? What is (are) the biggest driver(s) for the loss?
Look at Job 3217 and comment on the cost and profit variances. What might explain these variances?
What do you notice about the variances for direct labor cost and overhead cost? What might explain the similarities or differences?
On average, what is the largest revenue component measure?
On average, do the Premium jobs make more profit or less profit than the Standard jobs?
Which job has the highest profit?
Which job has negative profit?
Showing 300 - 400
of 1576
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last
Step by Step Answers
Get 50% OFF
Claim Now
