This course is perfect for business analysts, finance professionals, Python developers, and Power BI and Excel users who are interested in time series analysis and forecasting. Students will learn about the forecasting models available in Power BI, and gain hands-on experience in advanced error handling techniques in Power Query. They will be able to manipulate the forecast line efficiently for daily, monthly, and yearly predictions of univariate data, and tune parameters efficiently for cyclical and seasonal datasets. A basic understanding of Power BI is recommended, but prior experience with Power Query or writing M scripts is not required.

This course on Demand Forecasting will provide students and professionals with the knowledge and skills to accurately forecast demand. Through 28 lectures, you will learn the different methods of forecasting, including qualitative methods such as Delphi method, Sales force forecasting, Executive opinion and Customer survey/market research. You will also learn how to find the forecast when the historical data has a trend, as well as the fundamentals of simple moving average, weighted moving average, exponential smoothing, and seasonal influence in forecasting. Finally, you will learn how to measure forecasting error using Mean Squared error (MSE), Standard deviation (sigma), Mean absolute deviation (MAD) and Mean absolute percent error (MAPE). This course is ideal for those studying operations management or working in the IT industry.

Demand forecasting is an essential tool for businesses to plan, set goals, and budget for the future. This course provides a beginner's guide to understanding demand forecasting and its importance. Learn how to use historical data and other information to anticipate customer demand, optimize inventory levels, increase inventory turnover rate, and identify and rectify any issues in the sales pipeline. Plus, gain insight into upcoming cash flow and when to increase staff and allocate resources. Get the skills you need to make informed decisions and ensure your business runs smoothly.

This course is designed to help data analysts, business practitioners, and students build a broad range of forecasting models in Excel. It covers topics such as simple models, advanced models, regression analysis, seasonality, and ARIMA models. With this course, you can learn the fastest and easiest way to build models in Excel, even if you have only basic Excel skills. You can apply the forecasting models to different fields of business administration, biology, chemistry, medicine, project management, budgeting, finance, marketing, engineering, and pricing. Practical Forecasting with Excel is the perfect course for anyone looking to gain a better understanding of forecasting and Excel.