[GigaCourse.com] Udemy - Marketing Analytics Forecasting Models with Excel

File Name

Size

1. Introduction/1. Introduction.mp4

14 MB

1. Introduction/1. Introduction.srt

3.7 kB

1. Introduction/1.1 00_INtro.pdf

455 kB

10. Bonus Section/1. Bonus Lecture.html

1.5 kB

2. Basics of Forecasting/1. Basics of Forecasting.mp4

25 MB

2. Basics of Forecasting/1. Basics of Forecasting.srt

5.9 kB

2. Basics of Forecasting/1.1 01_reg_basics.pdf

195 kB

2. Basics of Forecasting/2. Course resources.html

113 B

2. Basics of Forecasting/2.1 Files_forecasting.zip

2.9 MB

2. Basics of Forecasting/3. Creating Linear Model with Trendlines.mp4

79 MB

2. Basics of Forecasting/3. Creating Linear Model with Trendlines.srt

7.9 kB

3. Getting Data Ready for Regression Model/1. Gathering Business Knowledge.mp4

22 MB

3. Getting Data Ready for Regression Model/1. Gathering Business Knowledge.srt

3.5 kB

3. Getting Data Ready for Regression Model/1.1 03_01_PDE_Business_knowledge.pdf

154 kB

3. Getting Data Ready for Regression Model/10. Variable Transformation in Excel.mp4

54 MB

3. Getting Data Ready for Regression Model/10. Variable Transformation in Excel.srt

3.8 kB

3. Getting Data Ready for Regression Model/10.1 07_Dummy variable.xlsx

98 kB

3. Getting Data Ready for Regression Model/11. Dummy variable creation Handling qualitative data.mp4

41 MB

3. Getting Data Ready for Regression Model/11. Dummy variable creation Handling qualitative data.srt

4.9 kB

3. Getting Data Ready for Regression Model/11.1 04_11_Dummy_Var.pdf

163 kB

3. Getting Data Ready for Regression Model/12. Dummy Variable Creation in Excel.mp4

108 MB

3. Getting Data Ready for Regression Model/12. Dummy Variable Creation in Excel.srt

6.8 kB

3. Getting Data Ready for Regression Model/12.1 07_Dummy variable.xlsx

98 kB

3. Getting Data Ready for Regression Model/13. Correlation Analysis.mp4

80 MB

3. Getting Data Ready for Regression Model/13. Correlation Analysis.srt

11 kB

3. Getting Data Ready for Regression Model/13.1 04_10_Correlation.pdf

257 kB

3. Getting Data Ready for Regression Model/14. Creating Correlation Matrix in Excel.mp4

102 MB

3. Getting Data Ready for Regression Model/14. Creating Correlation Matrix in Excel.srt

8.3 kB

3. Getting Data Ready for Regression Model/14.1 08_corr.xlsx

97 kB

3. Getting Data Ready for Regression Model/2. Data Exploration.mp4

23 MB

3. Getting Data Ready for Regression Model/2. Data Exploration.srt

3.6 kB

3. Getting Data Ready for Regression Model/2.1 03_02_PDE_Data_exploration.pdf

323 kB

3. Getting Data Ready for Regression Model/3. The Data and the Data Dictionary.mp4

79 MB

3. Getting Data Ready for Regression Model/3. The Data and the Data Dictionary.srt

7.8 kB

3. Getting Data Ready for Regression Model/3.1 03_03_PDE_Raw_Data_Analysis_Uni.pdf

332 kB

3. Getting Data Ready for Regression Model/4. Univariate analysis and EDD.mp4

27 MB

3. Getting Data Ready for Regression Model/4. Univariate analysis and EDD.srt

3.4 kB

3. Getting Data Ready for Regression Model/4.1 04_House_Price.xlsx

105 kB

3. Getting Data Ready for Regression Model/4.2 03_04_PDE_Univariate_Analysis_Uni.pdf

333 kB

3. Getting Data Ready for Regression Model/5. Discriptive Data Analytics in Excel.mp4

154 MB

3. Getting Data Ready for Regression Model/5. Discriptive Data Analytics in Excel.srt

10 kB

3. Getting Data Ready for Regression Model/5.1 05_Outlier.xlsx

105 kB

3. Getting Data Ready for Regression Model/6. Outlier Treatment.mp4

28 MB

3. Getting Data Ready for Regression Model/6. Outlier Treatment.srt

4.5 kB

3. Getting Data Ready for Regression Model/6.1 04_06_PDE_Outlier_Treatment.pdf

355 kB

3. Getting Data Ready for Regression Model/7. Identifying and Treating Outliers in Excel.mp4

64 MB

3. Getting Data Ready for Regression Model/7. Identifying and Treating Outliers in Excel.srt

4.3 kB

3. Getting Data Ready for Regression Model/7.1 05_Outlier.xlsx

105 kB

3. Getting Data Ready for Regression Model/8. Missing Value Imputation.mp4

28 MB

3. Getting Data Ready for Regression Model/8. Missing Value Imputation.srt

4.1 kB

3. Getting Data Ready for Regression Model/8.1 04_05_PDE_Missing_value.pdf

316 kB

3. Getting Data Ready for Regression Model/9. Identifying and Treating missing values in Excel.mp4

52 MB

3. Getting Data Ready for Regression Model/9. Identifying and Treating missing values in Excel.srt

3.9 kB

3. Getting Data Ready for Regression Model/9.1 05_Miss_val.xlsx

105 kB

4. Forecasting using Regression Model/1. The Problem Statement.mp4

11 MB

4. Forecasting using Regression Model/1. The Problem Statement.srt

1.6 kB

4. Forecasting using Regression Model/1.1 05_01_Intro.pdf

239 kB

4. Forecasting using Regression Model/10. Assignment 1 Regression based Forecasting.html

164 B

4. Forecasting using Regression Model/2. Basic Equations and Ordinary Least Squares (OLS) method.mp4

50 MB

4. Forecasting using Regression Model/2. Basic Equations and Ordinary Least Squares (OLS) method.srt

9.9 kB

4. Forecasting using Regression Model/2.1 05_02_Simple_lin_reg.pdf

285 kB

4. Forecasting using Regression Model/3. Assessing accuracy of predicted coefficients.mp4

104 MB

4. Forecasting using Regression Model/3. Assessing accuracy of predicted coefficients.srt

16 kB

4. Forecasting using Regression Model/3.1 05_03_Simple_lin_reg_Accuracy.pdf

333 kB

4. Forecasting using Regression Model/4. Assessing Model Accuracy RSE and R squared.mp4

50 MB

4. Forecasting using Regression Model/4. Assessing Model Accuracy RSE and R squared.srt

8.0 kB

4. Forecasting using Regression Model/4.1 05_03_Simple_lin_reg_Accuracy.pdf

333 kB

4. Forecasting using Regression Model/5. Creating Simple Linear Regression model.mp4

31 MB

4. Forecasting using Regression Model/5. Creating Simple Linear Regression model.srt

2.6 kB

4. Forecasting using Regression Model/6. Multiple Linear Regression.mp4

39 MB

4. Forecasting using Regression Model/6. Multiple Linear Regression.srt

5.7 kB

4. Forecasting using Regression Model/6.1 05_04_Multiple_lin_reg.pdf

220 kB

4. Forecasting using Regression Model/7. The F - statistic.mp4

64 MB

4. Forecasting using Regression Model/7. The F - statistic.srt

9.0 kB

4. Forecasting using Regression Model/7.1 05_05_F_stat.pdf

328 kB

4. Forecasting using Regression Model/8. Interpreting results of Categorical variables.mp4

27 MB

4. Forecasting using Regression Model/8. Interpreting results of Categorical variables.srt

5.3 kB

4. Forecasting using Regression Model/8.1 05_06_Cat_var.pdf

156 kB

4. Forecasting using Regression Model/9. Creating Multiple Linear Regression model.mp4

98 MB

4. Forecasting using Regression Model/9. Creating Multiple Linear Regression model.srt

8.0 kB

4. Forecasting using Regression Model/9.1 09_multiple.xlsx

100 kB

5. Handling Special events like Holiday sales/1. Forecasting in presence of special events.mp4

9.0 MB

5. Handling Special events like Holiday sales/1. Forecasting in presence of special events.srt

3.2 kB

5. Handling Special events like Holiday sales/1.1 11_Special Events.pdf

204 kB

5. Handling Special events like Holiday sales/2. Excel Running Linear Regression using Solver.mp4

112 MB

5. Handling Special events like Holiday sales/2. Excel Running Linear Regression using Solver.srt

8.4 kB

5. Handling Special events like Holiday sales/2.1 11_Solver_reg.xlsx

100 kB

5. Handling Special events like Holiday sales/3. Excel Including the impact of Special Events.mp4

205 MB

5. Handling Special events like Holiday sales/3. Excel Including the impact of Special Events.srt

21 kB

5. Handling Special events like Holiday sales/3.1 12_SpecialEvents.xlsx

54 kB

6. Identifying Seasonality & Trend for Forecasting/1. Models to identify Trend & Seasonality.mp4

39 MB

6. Identifying Seasonality & Trend for Forecasting/1. Models to identify Trend & Seasonality.srt

6.7 kB

6. Identifying Seasonality & Trend for Forecasting/1.1 12_Seasonality.pdf

204 kB

6. Identifying Seasonality & Trend for Forecasting/2. Excel Additive model to identify Trend & Seasonality.mp4

90 MB

6. Identifying Seasonality & Trend for Forecasting/2. Excel Additive model to identify Trend & Seasonality.srt

9.4 kB

6. Identifying Seasonality & Trend for Forecasting/2.1 13_Seasonality.xlsx

20 kB

6. Identifying Seasonality & Trend for Forecasting/3. Excel Multiplicative model to identify Trend & Seasonality.mp4

57 MB

6. Identifying Seasonality & Trend for Forecasting/3. Excel Multiplicative model to identify Trend & Seasonality.srt

6.1 kB

6. Identifying Seasonality & Trend for Forecasting/4. Moving Average Method.mp4

9.6 MB

6. Identifying Seasonality & Trend for Forecasting/4. Moving Average Method.srt

1.6 kB

6. Identifying Seasonality & Trend for Forecasting/4.1 14_Moving_Avg.xlsx

13 kB

6. Identifying Seasonality & Trend for Forecasting/4.2 14_Moving_Average.pdf

119 kB

6. Identifying Seasonality & Trend for Forecasting/5. Quiz.html

160 B

6. Identifying Seasonality & Trend for Forecasting/6. Excel Moving Average Method.mp4

120 MB

6. Identifying Seasonality & Trend for Forecasting/6. Excel Moving Average Method.srt

15 kB

6. Identifying Seasonality & Trend for Forecasting/6.1 14_Moving_Avg.xlsx

13 kB

6. Identifying Seasonality & Trend for Forecasting/7. Assignment 2 Identifying Trend and Seasonality.html

164 B

7. Handling Changing Trend & Seasonality over time/1. Winter's Method to accomodate changing Trend & Seasonality.mp4

37 MB

7. Handling Changing Trend & Seasonality over time/1. Winter's Method to accomodate changing Trend & Seasonality.srt

6.8 kB

7. Handling Changing Trend & Seasonality over time/1.1 15_Winters.pdf

159 kB

7. Handling Changing Trend & Seasonality over time/2. Excel Winter's method.mp4

127 MB

7. Handling Changing Trend & Seasonality over time/2. Excel Winter's method.srt

11 kB

7. Handling Changing Trend & Seasonality over time/2.1 15_winter.xlsx

56 kB

8. Forecasting models for New Products/1. S-curve for New products.mp4

44 MB

8. Forecasting models for New Products/1. S-curve for New products.srt

8.0 kB

8. Forecasting models for New Products/1.1 16_S_Model.pdf

204 kB

8. Forecasting models for New Products/2. Excel Using Logistic curve to model S-curve.mp4

62 MB

8. Forecasting models for New Products/2. Excel Using Logistic curve to model S-curve.srt

7.8 kB

8. Forecasting models for New Products/2.1 16_S_curve.xlsx

46 kB

8. Forecasting models for New Products/3. Excel Using Gompertz curve to model S-curve.mp4

36 MB

8. Forecasting models for New Products/3. Excel Using Gompertz curve to model S-curve.srt

4.2 kB

8. Forecasting models for New Products/3.1 16_S_curve.xlsx

46 kB

8. Forecasting models for New Products/4. Bass Diffusion Model for New Products.mp4

46 MB

8. Forecasting models for New Products/4. Bass Diffusion Model for New Products.srt

9.2 kB

8. Forecasting models for New Products/4.1 17_bass.pdf

210 kB

8. Forecasting models for New Products/5. Excel Implementing Bass Diffusion Model.mp4

102 MB

8. Forecasting models for New Products/5. Excel Implementing Bass Diffusion Model.srt

13 kB

8. Forecasting models for New Products/5.1 17_Bass.xlsx

33 kB

8. Forecasting models for New Products/6. Final Course Quiz.html

160 B

8. Forecasting models for New Products/7. Assignment 3 Bass Model.html

164 B

9. Appendix 1 Excel crash course/1. Mathematical Formulas.mp4

110 MB

9. Appendix 1 Excel crash course/1. Mathematical Formulas.srt

18 kB

9. Appendix 1 Excel crash course/10. Elements of charts.mp4

29 MB

9. Appendix 1 Excel crash course/10. Elements of charts.srt

5.7 kB

9. Appendix 1 Excel crash course/11. The Easy way of creating charts.mp4

22 MB

9. Appendix 1 Excel crash course/11. The Easy way of creating charts.srt

3.4 kB

9. Appendix 1 Excel crash course/2. Textual Formulas.mp4

109 MB

9. Appendix 1 Excel crash course/2. Textual Formulas.srt

15 kB

9. Appendix 1 Excel crash course/3. Logical Formulas.mp4

78 MB

9. Appendix 1 Excel crash course/3. Logical Formulas.srt

9.6 kB

9. Appendix 1 Excel crash course/4. Date-Time Formulas.mp4

49 MB

9. Appendix 1 Excel crash course/4. Date-Time Formulas.srt

6.8 kB

9. Appendix 1 Excel crash course/5. Lookup Formulas ( V Lookup, Hlookup, Index-Match ).mp4

64 MB

9. Appendix 1 Excel crash course/5. Lookup Formulas ( V Lookup, Hlookup, Index-Match ).srt

9.4 kB

9. Appendix 1 Excel crash course/6. Data Tools.mp4

128 MB

9. Appendix 1 Excel crash course/6. Data Tools.srt

20 kB

9. Appendix 1 Excel crash course/7. Formatting data and tables.mp4

159 MB

9. Appendix 1 Excel crash course/7. Formatting data and tables.srt

17 kB

9. Appendix 1 Excel crash course/8. Pivot Tables.mp4

73 MB

9. Appendix 1 Excel crash course/8. Pivot Tables.srt

8.4 kB

9. Appendix 1 Excel crash course/9. Excel Charts Categories of messages that can be conveyed.mp4

20 MB

9. Appendix 1 Excel crash course/9. Excel Charts Categories of messages that can be conveyed.srt

5.1 kB

Readme.txt

962 B

[GigaCourse.com].url

49 B