Createa Case Analysis based off this information and include the Excel Sheet along with the word document on the Case Analysis. Follow the Guideline provided to complete the case analysis and include

Analytics Individual Case Analysis Consulting Report

Drout Advertising research Project

Attention: Ms. JamieDrout

Supporting Documents for this Learning Assignment

• Structure of a Data Analysis Report PDF Document

• Consulting Is More Than Giving Advice

https://hbr.org/1982/09/consulting-is-more-than-giving-advice

• Data Analysis Steps

https://www.r-bloggers.com/data-analysis-steps/

• The Difference Between Reporting and Analysis and Why it Matters

https://datahero.com/blog/2017/08/14/data-reporting-and-analysis/

• How to Write a Data Report

https://smallbusiness.chron.com/write-data-report-61330.html

• The Seven Key Steps of Data Analysis

https://rizkashifs.wordpress.com/2015/09/03/the-seven-key-steps-of-data-analysis/

Table of Contents

1. Executive Summary

1. Overview Case Analysis – What’s this case analysis about?

1. Scope of Consulting Work and Report –

• Detailed List of Assignments this case analysis is requesting.

1. Introduction

1. Analysis and Findings

For EVERY Case Analysis ASSIGNMENT

• 5.1 Assignment(s) 1 – Statement

• • Identify Business Problem -

“Define Problem statement [aka Case Analysis Assignment]”

• • Analytics Tools and Models used and results

• • Interpretation, Discussion, and Analysis of Findings and Results –

Interpretation, Discussion, and Analysis of outcomes and results of Analytics Tools and Models used

• • • Tip: Support your Interpretation, Discussion, and Analysis of Results with the numbers you developed in your:

      • Analytics Tools and Models used results

      • Business Analytics Case Analysis EXCEL model(s) and outcomes and results

• • Recommendations

• 5.2 Assignment(s) 2 – Statement

• • Identify Business Problem -

“Define Problem statement [aka Case Analysis Assignment]”

• • Analytics Tools and Models used and results

• • Interpretation, Discussion, and Analysis of Findings and Results –

Interpretation, Discussion, and Analysis of outcomes and results of Analytics Tools and Models used

• • • Tip: Support your Interpretation, Discussion, and Analysis of Results with the numbers you developed in your:

      • Analytics Tools and Models used results

      • Business Analytics Case Analysis EXCEL model(s) and outcomes and results

• • Recommendations

• 5.n Assignment(s) n – Statement

• • Identify Business Problem -

“Define Problem statement [aka Case Analysis Assignment]”

• • Analytics Tools and Models used and results

• • Interpretation, Discussion, and Analysis of Findings and Results –

Interpretation, Discussion, and Analysis of outcomes and results of Analytics Tools and Models used

• • • Tip: Support your Interpretation, Discussion, and Analysis of Results with the numbers you developed in your:

      • Analytics Tools and Models used results

      • Business Analytics Case Analysis EXCEL model(s) and outcomes and results

• • Recommendations

1. Overall Case Analysis Findings Discussion

1. Overall Case Analysis Recommendations

1. Overall Case Analysis Conclusion(s)

1. Appendix/Appendices

1. Bibliography and References