Companies Home Search Profile

Advance Forecasting With Excel - Time Series Models

Focused View

Akshay Yewale

1:09:06

218 View
  • 1. Introduction.mp4
    00:53
  • 1. Naive Forecating.mp4
    05:48
  • 2. Moving Average.mp4
    11:32
  • 3. Exponential Smoothing.mp4
    13:29
  • 4. AR Model Theory.mp4
    04:24
  • 5. AR Model.mp4
    15:44
  • 6. ARIMA Model.html
  • 1. Optimizing.mp4
    04:31
  • 2. Training & Testing Dataset.mp4
    12:45
  • Description


    Become Expert Forecasting Professional Using Excel

    What You'll Learn?


    • Become Expert Forecasting Professional Using Excel
    • Moving Average & Weighted Moving Average Model
    • Learn to Calculate Forecasting KPIs - MAD , MAPE & RMSE
    • AR Model
    • ARIMA Model

    Who is this for?


  • Want to learn Demand Forecasting - You are the right place.
  • Demand Planning Managers
  • Supply Chain Managers
  • Data Scientist
  • More details


    Description

    “There are two kinds of forecasters: those who don't know, and those who don't know they don't know.”


    Wouldn’t it be nice to see into the future of your business?

    With business forecasting, this is a reality; by using current and historical data you are able to have accurate predictions for future trends and forecasts. With this increased visibility you can analyze your business as a whole with the utmost confidence in the data.

    The course will start with the basic principles of forecasting and take you to advance industry practices.

    You will learn to build the following Time Series models.

    1. Naive Forecasting

    2. Moving Average

    3. Weighted Average

    4. Exponential Smoothing

    5. AR ( Auto Regressive )  Model

    6 . ARIMA (Auto Regressive Integrated Moving Average ) Model

    7. Causal Models ( Coming Soon )

    Not everyone is an expert in programming languages so excel can be good alternative or good start to build models.

    Learning forecasting in excel is the foundation of learning forecasting in programming languages like Python and R.

    Practice assignments for all the models forecasting and KPI calculation is part of the course. Get ready to make your hands dirty.


    Demand forecasting is an essential business process that helps organizations plan and prepare for the future by predicting consumer demand for products and services. Excel is a powerful tool that can be used to create accurate demand forecasts and assist in decision-making processes. Here are some reasons why you should learn demand forecasting with Excel:

    1. Widely Used: Excel is a widely used spreadsheet program and is readily available in most organizations. Learning demand forecasting with Excel can help you use a tool that is accessible to you and your colleagues.

    2. Easy to Learn: Excel is relatively easy to learn, and many online resources provide tutorials and courses to learn the basics of using Excel for demand forecasting.

    3. Cost-Effective: Excel is a cost-effective solution for demand forecasting compared to other more expensive software tools.

    4. Versatile: Excel is a versatile tool that can handle large data sets and can be used to create a wide range of models and visualizations.

    5. Integrates with other tools: Excel can be used in conjunction with other business tools such as ERP systems, CRM systems, and BI software.

    By learning demand forecasting with Excel, you can improve your forecasting accuracy, save time, and make more informed business decisions.


    Hurry Up !! Enroll

    Who this course is for:

    • Want to learn Demand Forecasting - You are the right place.
    • Demand Planning Managers
    • Supply Chain Managers
    • Data Scientist

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Akshay Yewale
    Akshay Yewale
    Instructor's Courses
    Currently working as Senior Demand Planning Analyst in General MillsI have done Mechanical Engineering from Pune University. I have done APICS CPIM certification, Supply Chain & Demand Analytics course from NITIE, and currently pursuing Micromasters in SCM from MIT. My career path so far has been as a Demand Planner, Production Planner, Inventory Planner, and Demand Management Analyst with  MNCs like Micron( Fortune 500), Tata Motors(Fortune 500), and General Mills(Fortune 500 & The Gartner Supply Chain Top 25 for 2022 ).My passion for supply chain brings me here to share my learnings with all of you.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 8
    • duration 1:09:06
    • Release Date 2023/04/25