Sales Forecasting in Excel with Machine Learning and Python Automation

Tired of manually creating a sales forecast each month?

Over copying and pasting last year's estimate?

Just want to do stuff faster?

Say no more, in this video you'll learn how to automate sales forecasting in Excel with AutoAI and python automation.

You'll learn how to
- How to build a machine learning pipeline to forecast sales using Watson AutoAI
- Deploying the machine learning pipeline to integrate into other apps
- Write Python scripts to automate the forecasting process from your desktop!

Other Resources

Oh, and don't forget to connect with me!

Happy coding!
Nick

P.s. Let me know how you go and drop a comment if you need a hand!

Music by Lakey Inspired

[sunnykeerthi]

Hey Brother,
Can you please make a playlist on python? Your way of explaining is very Intrigue 😊

[gayudearest]

This tutorial is awesome but unfortunately IBM changed the IAM authorization since Sep 1 so I had to follow diffenet steps to generate the IAM token. But that token generated was only for 60 minutes. Can you please put a tutorial on how to generate IAM token if u have the API key. I tried to follow the documentation but it was not that useful.

[Uswithbandana]

hi, i tried and able to create the forecasting sales model but unable to deploy it....Could you please guide if i need upgrade/buy software to do that ?

[Mulugetaalemu]

hey brother can you please make short term load forecasting for 24 hours electrical consumption using ANN and GA using python programming.

[savagestation]

is it possible to do this with demand instead of sales?

[AkshayRaikar]

Hey @Nicholas, I have Technical Support Calls related data. How many years of data is required to train the model and predict accurate data?

[thelifecompany]

I can use this model to plan expenses, cost of revenue and other indicators?

[is_that_aniket]

Hi Nicholas, your videos are helping me in understanding the concepts in Watson Analytics. From past 2 days I am stuck in one issue while trying the exercise from above video. I was wondering, if you could spare some time to help me in it

[wilfredocasinojr.]

is there any alternative for IBM Watson Studio?

[saylexwow]

Hi, when saving the best Pipeline the "Deployment" Tab is gone.. How do I access the generated python code?

[willgillingham]

Having some issues getting the response scoring post request to execute. Can you help?

Subscribed btw, love your content!

[NigelBurkeMelbourne]

Hi Nicholas, trying to follow this after watching your presentation at the cubewise conference this week. One question, how does the model identify dates? I think you mentioned you had to change the date field in Store Sales to a string does this mean it's not looking at monthly trends?

[prathamkhurana]

I am getting this error - "Instance in v2 plan should use v4 API.

[shuaibahmed]

I want to design the same model for my excel data for the Telecom Operators.. Can it be done??

[nobledhump]

Great Video, just wanted to know if the data (train/test) is saved somewhere on IBM servers, I don't want to happen this due to data privacy policy of my company

[AlexPjz]

Hi! Is there any way I can run the AutoAI on my own PC?

[haminhman]

Hi Nicholas, how can I get instance_id with Watson Machine Learning "V2". Can you give a guideline. Thank you. Man

[josegajardo]

How would you implement this with Google Sheets?

[mohitupadhayay]

Starting with the V2 machine learning service, introduced on September 1, 2020, you no longer need service credentials to authenticate with the apps and services that use the IBM Watson Machine Learning service.

-IBM documentation
time stamp : 10:00

[samirelzein]

you could ve started with explaining the intuition of how your methods can reveal INFOrMATION about sales. that s what you missed!