Project 1 Let's suppose that you are working as a travel agent and you want to design the tourism campaign for the year 2024 for the Kingdom of Saudi Arabia, in order to increase the number of tourist visits to 50,000 thousands of visits.. 2 More specifically, you should: - download tourist visits data for the year 2018 (https://open.data.gov.sa). - create a forecast of this data for the year 2024. - assess the forecast results in order to formulate an optimization problem. - use Excel Solver to get information on how you will design your tourism campaign. - make suggestions for a tourism campaign based on the Excel Solver results. 3 Create a PowerPoint presentation using suitable Excel charts, illustrating your forecast and Excel Solver results. Explain your charts and present your suggestions for the tourism campaign. وزارة التعليم Ministry of Education 2024-1446 205

Project

Project

حل Project

Wrap up Now you have learned: > what predictive modeling is. > the difference between parametric and non-parametric modeling. > the different types of predictive models. > the process of creating a predictive model. > the benefits and challenges of predictive modeling. > the applications of predictive modeling. > what forecasting is. > the different types of forecast charts. > how forecasting is applied to specific data. > what a confidence interval is. > what an optimization problem is. > how to perform optimizations using Excel Solver. > how to assess Excel Solver results. KEY TERMS Classification Model Clustered Column Chart Clustering Model Column Chart Confidence Interval Constraints Data Collection Data Transformation Decision Tree Excel Solver Forecast Forecast Model General Linear Model Gradient Boosted Model Line Chart Linear Regression Lower Confidence Bound Model Formulation Neural Network Non-Parametric Objective Cell Optimization Problem Outlier Detection Model Parametric Predictive Data Modeling Prophet Model Quality Enhancement Risk Assessment Stacked Column Chart Time Series Model Upper Confidence Bound Variable Cells وزارة التعليم Ministry of Education 206 2024-1446

Project

Now you have learned: what predictive modeling is.

KEY TERMS Classification Model