Predictive Analytics in excel | Types of Data analytics in excel

This video is about how to do Predictive Analytics in MS Excel Spreadsheet 2016. Analytics drives business in efficient way. Four types of analytics are there currently. Predictive Analytics is part of four types of analytics. Predictive Analytics is not traditional analytics. Business people are using Predictive Analytics to know what will it happen, when will it happen, why will it happen in the business through historical data.

In this video, Two examples showed for Predictive Analytics. The first example is forecasting next year sales from last year sales using forecast techniques in MS Excel. The second example is creating regression analysis to find relationship between sales and incentive data and checking this data is statistically significant or not.

#excel
#exceltutorial
#learnexcel

[tshegangchipeya]

Thank you very much for this tutorial :)!

[somedude]

Is there are 4 salesman and each selling 4 different products, can I
predict how they would perfom if they were only selling their preffered
product - I have previosu sales for each product?

[jaswal]

very nice tutorial. If we have only one variable what predictive analysis can we do out of it Say if we want to measure rain in next month based on last 12 months data.

[Vision]

4:53 what kind of actions can be taken based on this prediction?

[sharathrpa]

can I do prediction on employee promotion?