Wednesday, July 5, 2017

Slides, File and Recording of Webinar On Predictive Analysis Using Microsoft Excel

You can view the YouTube recording of the webinar here. I talked extensively about the different major levels of data analysis -- Descriptive, Exploratory, Predictive and Prescriptive analysis. Then I focused on predictive analysis and the ones possible to carry out in Excel.

Some of you may already know that you can do moving average, simple exponential smoothing and regression in Excel. Well, in the webinar I showed that you can also use Excel for double exponential smoothing, triple exponential smoothing, sentiment analysis (using Azure ML add-in), decision tree (using an add-in) and other predictive analysis methods.

Here is the download link for the practice file and below are the PPT slides (in image format).