Tutorialsplanet NET Udemy - Marketing Analytics Forecasting Models with Excel

1. 01 - Introduction/001 Introduction.mp414.37MB
2. 02 - Basics of Forecasting/001 Basics of Forecasting.mp425.29MB
3. 02 - Basics of Forecasting/003 This is a milestone_.mp420.67MB
4. 02 - Basics of Forecasting/004 Creating Linear Model with Trendlines.mp478.93MB
5. 03 - Getting Data Ready for Regression Model/001 Gathering Business Knowledge.mp421.9MB
6. 03 - Getting Data Ready for Regression Model/002 Data Exploration.mp420.11MB
7. 03 - Getting Data Ready for Regression Model/003 The Data and the Data Dictionary.mp478.57MB
8. 03 - Getting Data Ready for Regression Model/004 Univariate analysis and EDD.mp427.3MB
9. 03 - Getting Data Ready for Regression Model/005 Discriptive Data Analytics in Excel.mp4153.52MB
10. 03 - Getting Data Ready for Regression Model/006 Outlier Treatment.mp427.76MB
11. 03 - Getting Data Ready for Regression Model/007 Identifying and Treating Outliers in Excel.mp454.49MB
12. 03 - Getting Data Ready for Regression Model/008 Missing Value Imputation.mp427.55MB
13. 03 - Getting Data Ready for Regression Model/009 Identifying and Treating missing values in Excel.mp451.79MB
14. 03 - Getting Data Ready for Regression Model/010 Variable Transformation in Excel.mp454.11MB
15. 03 - Getting Data Ready for Regression Model/011 Dummy variable creation_ Handling qualitative data.mp440.64MB
16. 03 - Getting Data Ready for Regression Model/012 Dummy Variable Creation in Excel.mp4107.98MB
17. 03 - Getting Data Ready for Regression Model/013 Correlation Analysis.mp480.13MB
18. 03 - Getting Data Ready for Regression Model/014 Creating Correlation Matrix in Excel.mp4102.11MB
19. 04 - Forecasting using Regression Model/001 The Problem Statement.mp410.68MB
20. 04 - Forecasting using Regression Model/002 Basic Equations and Ordinary Least Squares (OLS) method.mp450.23MB
21. 04 - Forecasting using Regression Model/003 Assessing accuracy of predicted coefficients.mp4104.4MB
22. 04 - Forecasting using Regression Model/004 Assessing Model Accuracy_ RSE and R squared.mp449.73MB
23. 04 - Forecasting using Regression Model/005 Creating Simple Linear Regression model.mp431.11MB
24. 04 - Forecasting using Regression Model/006 Multiple Linear Regression.mp438.91MB
25. 04 - Forecasting using Regression Model/007 The F - statistic.mp464.13MB
26. 04 - Forecasting using Regression Model/008 Interpreting results of Categorical variables.mp427.14MB
27. 04 - Forecasting using Regression Model/009 Creating Multiple Linear Regression model.mp497.58MB
28. 05 - Handling Special events like Holiday sales/001 Forecasting in presence of special events.mp48.96MB
29. 05 - Handling Special events like Holiday sales/002 Excel_ Running Linear Regression using Solver.mp4111.65MB
30. 05 - Handling Special events like Holiday sales/003 Excel_ Including the impact of Special Events.mp4205.23MB
31. 06 - Identifying Seasonality & Trend for Forecasting/001 Models to identify Trend & Seasonality.mp439.13MB
32. 06 - Identifying Seasonality & Trend for Forecasting/002 Excel_ Additive model to identify Trend & Seasonality.mp489.62MB
33. 06 - Identifying Seasonality & Trend for Forecasting/003 Excel_ Multiplicative model to identify Trend & Seasonality.mp457.29MB
34. 06 - Identifying Seasonality & Trend for Forecasting/004 Moving Average Method.mp49.58MB
35. 06 - Identifying Seasonality & Trend for Forecasting/005 Excel_ Moving Average Method.mp4119.79MB
36. 07 - Handling Changing Trend & Seasonality over time/001 Winter's Method to accomodate changing Trend & Seasonality.mp437.27MB
37. 07 - Handling Changing Trend & Seasonality over time/002 Excel_ Winter's method.mp4126.75MB
38. 08 - Forecasting models for New Products/001 S-curve for New products.mp444.24MB
39. 08 - Forecasting models for New Products/002 Excel_ Using Logistic curve to model S-curve.mp462.33MB
40. 08 - Forecasting models for New Products/003 Excel_ Using Gompertz curve to model S-curve.mp435.98MB
41. 08 - Forecasting models for New Products/004 Bass Diffusion Model for New Products.mp446.16MB
42. 08 - Forecasting models for New Products/005 Excel_ Implementing Bass Diffusion Model.mp4101.55MB
43. 09 - Appendix 1_ Excel crash course/001 Mathematical Formulas.mp4109.5MB
44. 09 - Appendix 1_ Excel crash course/002 Textual Formulas.mp4109.06MB
45. 09 - Appendix 1_ Excel crash course/003 Logical Formulas.mp477.75MB
46. 09 - Appendix 1_ Excel crash course/004 Date-Time Formulas.mp448.82MB
47. 09 - Appendix 1_ Excel crash course/005 Lookup Formulas ( V Lookup, Hlookup, Index-Match ).mp464.32MB
48. 09 - Appendix 1_ Excel crash course/006 Data Tools.mp4127.94MB
49. 09 - Appendix 1_ Excel crash course/007 Formatting data and tables.mp4159.25MB
50. 09 - Appendix 1_ Excel crash course/008 Pivot Tables.mp473.17MB
51. 09 - Appendix 1_ Excel crash course/009 Excel Charts_ Categories of messages that can be conveyed.mp419.97MB
52. 10 - Bonus Section/001 The final milestone_.mp411.85MB