Predictive Analytics for Excel
Predictive Analytics for Excel
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 5 Hours | 11 GB
Genre: eLearning | Language: English
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 5 Hours | 11 GB
Genre: eLearning | Language: English
Companies of all sizes are turning to exponential smoothing to accurately forecast trended data such as sales, demand, and other key business indicators. In this video course, world-class analytics expert Conrad Carlberg shows you how to use smoothing to forecast trends with a tool you already know: Microsoft Excel. Carlberg illuminates each technique through easy-to-follow video, with crystal-clear explanations reflecting his decades of experience solving complex analytical problems with Excel. You’ll learn how smoothing works and how to prepare data; quantify a forecast’s accuracy; use Excel Solver to reduce forecast error; interpret smoothing analyses; work with baselines; support your forecasts with regression analyses; diagnose trends using autocorrelation; detrend and forecast from a trended baseline; initialize forecast values; and backcast beyond the start of your baseline. You’ll learn hands-on through practice workbooks provided for your own use and adaptation. By the time you’re done, you’ll have mastered one of today’s most valuable predictive analytics skillsetsone you can use in nearly any field of business.
Predictive Analytics for Excel
