The specific scope of work for this assignment are as follows:$1.$ Data preparation:a$.$ Identify at least five major data related issues and data preparation needs fromthe data sets given. You are required to provide a comprehensive discussion onthe data quality issues and data preparation needs identified as well as includethe step$($s$)$ taken to address them.b$.$ Prepare the final data analytical sandbox using appropriate data wranglingtechniques$\mathrm{.}2.$ Data analysis:a$.$ Discover at least ten major insights from the analytics sandbox by usingappropriate IDEA techniques.b$.$ With reference to the findings from $2$a$,$ formulate hypothesis and performappropriate confirmative data analysis to validate the exploratory data analysisresults$\mathrm{.}3.$ Interpretation of analysis results:a$.$ Relate and discuss the results of the analysis in providing valuable understandingto the questions provided at The Task section$\mathrm{.}4.$ Managerial Communicationa. Prepare an executive summary to help the franchisor to understand the marketpotential in the Philippines.