|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ra-deep-dive-into-forecasting-excel-and-python/
课程评论:没有评论
课程名称:深入了解使用Excel和Python进行预测 课程概述: 本课程旨在帮助学习者掌握最新的统计预测技术和趋势,强调预测在规划中的重要性。预测技术不仅关乎资源的有效利用,还在各行各业内发挥着至关重要的作用,特别是在营销、运营、财务和供应链管理中。课程从基础知识开始,逐步深入,同时结合Excel和Python进行实际操作,确保即使没有Python基础的学员也能轻松跟上。 课程内容包括: 1. 使用Excel和Python进行时间序列分解。 2. 单变量时间序列分析。 3. 双变量分析和自相关性分析。 4. 时间序列平滑及趋势分析。 5. 季节性调整。 6. 使用Excel进行简单和复杂的预测。 7. 通过转换减少预测中的方差。 8. 在Excel中生成和校准预测。 9. 每日使用Python进行预测的基础知识。 10. 使用sktime包进行高级预测方法及聚合。 11. 使用statsmodels包进行ARIMA的网格搜索。 12. 用两行代码应用各种模型的工作流程。 13. 校准预测方法。 14. 应用分层时间序列的底层、中层和顶层方法。 15. 使用新的sktime协调方法进行聚合。 16. 使用Fable生成10,000个时间序列的预测。 17. 时间序列特征生成与重采样及预测的交叉验证。 课程最后,学员将掌握一套全面的技能和工具箱,以应对各种预测挑战。 本课程兼顾各个水平的学员,内容涵盖从基础到高级的预测技术,旨在提升学员的实用能力和数据分析水平。通过不断的练习与应用,帮助学员掌握有效的预测技能,为可持续发展贡献一份力量。希望大家在预测领域中收获快乐和成功!
Hello:)Forecasting has been around for 1000s of years. it stems from our need to plan so we can have some direction for the future. We can consider forecasting as the stepping stone for planning. and that's why it is as important as ever to have good forecasters in institutions, supply chains, companies, and businesses.With the ever-growing concerns of sustainability and Carbon-footprint. Would you believe it? a good forecast actually contributes to saving resources through the value chain and actually saving the planet. one forecaster at a time. needless to mention, forecasting is integral in marketing, operations, finance, and planning for supply chains, pretty much everythingThis course is aimed to orient you to the latest statistical forecasting techniques and trends. but first, we need to understand how forecasting works the reasoning behind statistical methods, and when each method is suitable to be used. that's why we start first with Excel and we scale with Python. "Don't worry if you don't know Python, Crash fundamental sections are included.The course is for all levels because we start from Zero to Hero in Forecasting.in this course we will learn and apply:1- Time Series Decomposition in Excel and Python.2- Univariate analysis for time series in Excel and Python..3- Bivariate analysis and auto-correlation in Excel and Python..4- Smoothing the time series and getting the Trend with Double and centered moving average.5- seasonally adjusting the time series.6- Simple and complex forecasts in Excel.7- Use transformations to reduce the variance while forecasting.8-Generating and Calibrating Forecasting in Excel.9- Learning Python and using it as an everyday tool for forecasting.10- Using the sktime Package for advanced forecasting methods and aggregations.11- Using statsmodels package for grid search on ARIMA.12- Applying a workflow of different models in two lines of code.13- Calibrating forecasting methods.14- Applying Hierarchical time series with Bottom-up, middle-out, and Top-down Approaches.16- Use the new sktime reconciliation method for aggregation.15- Using Fable to generate forecasts for 10000-time series and much more!!16- Time series feature Generation.17-Resampling and Forecasting cross-validation.Many of the concepts and analyses I explain first in Excel as I find Excel the best way to first explain a concept and then we scale up, improve, and generalize with Python. By the end of this course, you will have an exciting set of skills and a toolbox you can always rely on when tackling forecasting challenges.Happy Forecasting!HaythamRescale AnalyticsFeedback from Clients, Training and other online courses:"I attended this course with high expectations. And I was not disappointed. It´s incredible to see what is possible with Python in terms of supply chain planning and optimization. Haytham is doing a great job as a trainer. Starting with explanation of basics and ending with presentation of advanced techniques supply chain managers can apply in real life."Larsen BlockDirector Supply Chain Management at Freudenberg Home and Cleaning Solutions GmbH"In Q4 2018, I was fortunate to find an opportunity to learn R in Dubai, after hearing about it from indirect references in UK.I attended a Supply Chain Forecasting & Demand Planning Masterclass conducted by Haitham Omar and the possibilities seemed endless. So, we requested Haitham to conduct a 5-day workshop in our office to train 8 staff members, which opened us up as a team to deeper data analysis. Today, we have gone a step further and retained Haitham, as a consultant, to take our data analysis to the next level and to help us implement inventory guidelines for our business. The above progression of our actions is a clear indication of the capabilities of Haitham as a specialist in R and in data analytics, demand planning, and inventory management."Shailesh MendoncaCommercial lead-in Adventure AHQ- Sharaf Group" Haytham mentored me in my Role of Head of Supply Chain efficiency. He is extremely knowledgebase about the supply concepts, latest trends, and benchmarks in the supply chain world. Haytham's analytics-driven approach was very helpful for me to recommend and implement significant changes to our supply chain at Aster group"Saify NaqviHead of Supply Chain Efficiency"I participated to the training session called "Supply Chain Forecasting & Management" on December 22nd 2018. This training helped me a lot in my daily work since I am working in Purchase Dpt. Haytham have the pedagogy to explain us very difficult calculations and formula in simple way. I highly recommend this training."Djamel BOUREMIZPurchasing Manager at Mineral Circles Bearings