Analytics Recommendation


(1) Your deliverable will be in Powerpoint. Practicing your style and skills in communicating messages and stories via Powerpoint is important as this remains the primary presentation tool in US business environment.

(2) Select from the same companies as assignment 3: Disney, Bio Rad Laboratories, Albertsons, Williams-Sonoma, Invitae, Seer, Air B&B.

(3) Perform the following steps and analysis and communicate the results in your Powerpoint slides. Read the most recent 10-K and

(a) Identify and list the primary competitors of your company

(b) Identify and develop a recommendation of an area where the company would benefit from allocating budget (time and funds) to developing an analytics project. This should be an analytics project that is repeatable, has a cost-benefit ratio of supporting the allocation of budget, and you will explain the reasons why in your Powerpoint. This should be based on financial data (recall from our course that all financial data is not directly from the face of the financial statements. See also the BDO presentation on Power BI). Consider for example high volume transactions, cash needs, risk of fraud, or other factors. Include in your explanation who the audience/users would be of the output (Internal Audit as users, sales department, executives, Controller’s group, etc). The analytics should be based on INTERNAL data.

(c) Include in your rationale why this matters in the competitive landscape. Come up with an analytic that is EXTERNAL to the company (comparing to competitors or economic data) for the same financial statement data.

(d) State in the presentation whether there is significant focus on this area in the financials (is it identified in the Auditor’s opinion as a CRITICAL AUDIT MATTER? Is it clearly a line item in the nonGAAP EBITDA presented in the 10-K? Is there a discussion of this area? If not, point out that while not specifically discussed or disclosed in the 10-K, why your assessment in (b) remains critical).

(e) Include in the recommendation a software tool that can be used and why you believe it is the best choice to use for the analysis.