Business Analytics Report for New-Peth Shoes Ltd

Company And Dataset Background

The New-Peth Shoes Ltd. is an SME, based in Morpeth Northumberland, that operates online by selling, both, locally produced and imported branded shoes. The business has ambitious growth plans in rivalling some of the high street shoe stores, but due to lack of internal expertise in analytics and data driven decision making, the owner is struggling to make informed business decisions.

You have been contracted as a Business Analyst in the company and your first assignment is to produce a 2000 word comprehensive analytics report addressing the following:

Dashboard: providing an ‘on message’ overview of the business performance, highlighting what you consider are key performance indicators (KPI’s) for this business. The actual dashboard should be capable of fitting onto one page in either portrait or landscape. [10%]
Data driven Business Intelligence (BI) Insights, visualisations and analysis: You are required to use your knowledge and data analysis skills to develop a range of business insights, with accompanying visualisations and narrative. Your choice of the most significant elements to analyse will be driven by what you consider the New-Peth shoes could do to be successful in terms of their growth aim. There needs to be clear evidence of the rationale (reason) for including a particular insight and key visuals must be integrated into the main body of the report. [40%]
Recommendations: as part of this section, you are expected to develop strategic forward thinking recommendations for New-Peth Shoes based on your previous analyses (in parts a) & b) above) and orientated towards the strategic intent of growth. Any recommendation made must be based on data analysis. [30%]
Organisation & Presentation: 10% is dedicated towards the executive summary, overall structure, organisation, and professional presentation of the report. A clear and organised report structure along with professional presentation standards will determine the level of mark awarded under this section. [10%]
Data cleaning and/or data preparation steps adopted in the production of the report to ensure the integrity of the data. This should be submitted as Appendix A of the report. [10%