|
|
1. Basics of Forecasting.mp4
|
MP4
|
25.3 MB
|
|
|
1. Basics of Forecasting.srt
|
SRT
|
5.9 KB
|
|
|
1. Bonus Lecture.html
|
HTML
|
1.5 KB
|
|
|
1. Forecasting in presence of special events.mp4
|
MP4
|
9 MB
|
|
|
1. Forecasting in presence of special events.srt
|
SRT
|
3.2 KB
|
|
|
1. Gathering Business Knowledge.mp4
|
MP4
|
21.9 MB
|
|
|
1. Gathering Business Knowledge.srt
|
SRT
|
3.5 KB
|
|
|
1. Introduction.mp4
|
MP4
|
14.4 MB
|
|
|
1. Introduction.srt
|
SRT
|
3.7 KB
|
|
|
1. Mathematical Formulas.mp4
|
MP4
|
109.5 MB
|
|
|
1. Mathematical Formulas.srt
|
SRT
|
17.7 KB
|
|
|
1. Models to identify Trend & Seasonality.mp4
|
MP4
|
39.1 MB
|
|
|
1. Models to identify Trend & Seasonality.srt
|
SRT
|
6.7 KB
|
|
|
1. S-curve for New products.mp4
|
MP4
|
44.2 MB
|
|
|
1. S-curve for New products.srt
|
SRT
|
8 KB
|
|
|
1. The Problem Statement.mp4
|
MP4
|
10.7 MB
|
|
|
1. The Problem Statement.srt
|
SRT
|
1.6 KB
|
|
|
1. Winter's Method to accomodate changing Trend & Seasonality.mp4
|
MP4
|
37.3 MB
|
|
|
1. Winter's Method to accomodate changing Trend & Seasonality.srt
|
SRT
|
6.8 KB
|
|
|
1.1 00_INtro.pdf
|
PDF
|
455 KB
|
|
|
1.1 01_reg_basics.pdf
|
PDF
|
195.2 KB
|
|
|
1.1 03_01_PDE_Business_knowledge.pdf
|
PDF
|
153.9 KB
|
|
|
1.1 05_01_Intro.pdf
|
PDF
|
239.3 KB
|
|
|
1.1 11_Special Events.pdf
|
PDF
|
204.1 KB
|
|
|
1.1 12_Seasonality.pdf
|
PDF
|
204.1 KB
|
|
|
1.1 15_Winters.pdf
|
PDF
|
159.1 KB
|
|
|
1.1 16_S_Model.pdf
|
PDF
|
203.5 KB
|
|
|
10. Assignment 1 Regression based Forecasting.html
|
HTML
|
204.8 B
|
|
|
10. Elements of charts.mp4
|
MP4
|
29.4 MB
|
|
|
10. Elements of charts.srt
|
SRT
|
5.7 KB
|
|
|
10. Variable Transformation in Excel.mp4
|
MP4
|
54.1 MB
|
|
|
10. Variable Transformation in Excel.srt
|
SRT
|
3.8 KB
|
|
|
10.1 07_Dummy variable.xlsx
|
XLSX
|
98.1 KB
|
|
|
11. Dummy variable creation Handling qualitative data.mp4
|
MP4
|
40.6 MB
|
|
|
11. Dummy variable creation Handling qualitative data.srt
|
SRT
|
4.9 KB
|
|
|
11. The Easy way of creating charts.mp4
|
MP4
|
21.7 MB
|
|
|
11. The Easy way of creating charts.srt
|
SRT
|
3.4 KB
|
|
|
11.1 04_11_Dummy_Var.pdf
|
PDF
|
163 KB
|
|
|
12. Dummy Variable Creation in Excel.mp4
|
MP4
|
108 MB
|
|
|
12. Dummy Variable Creation in Excel.srt
|
SRT
|
6.8 KB
|
|
|
12.1 07_Dummy variable.xlsx
|
XLSX
|
98.1 KB
|
|
|
13. Correlation Analysis.mp4
|
MP4
|
80.1 MB
|
|
|
13. Correlation Analysis.srt
|
SRT
|
10.6 KB
|
|
|
13.1 04_10_Correlation.pdf
|
PDF
|
256.9 KB
|
|
|
14. Creating Correlation Matrix in Excel.mp4
|
MP4
|
102.1 MB
|
|
|
14. Creating Correlation Matrix in Excel.srt
|
SRT
|
8.3 KB
|
|
|
14.1 08_corr.xlsx
|
XLSX
|
96.9 KB
|
|
|
2. Basic Equations and Ordinary Least Squares (OLS) method.mp4
|
MP4
|
50.2 MB
|
|
|
2. Basic Equations and Ordinary Least Squares (OLS) method.srt
|
SRT
|
9.9 KB
|
|
|
2. Course resources.html
|
HTML
|
102.4 B
|
|
|
2. Data Exploration.mp4
|
MP4
|
23.4 MB
|
|
|
2. Data Exploration.srt
|
SRT
|
3.6 KB
|
|
|
2. Excel Additive model to identify Trend & Seasonality.mp4
|
MP4
|
89.6 MB
|
|
|
2. Excel Additive model to identify Trend & Seasonality.srt
|
SRT
|
9.4 KB
|
|
|
2. Excel Running Linear Regression using Solver.mp4
|
MP4
|
111.7 MB
|
|
|
2. Excel Running Linear Regression using Solver.srt
|
SRT
|
8.4 KB
|
|
|
2. Excel Using Logistic curve to model S-curve.mp4
|
MP4
|
62.3 MB
|
|
|
2. Excel Using Logistic curve to model S-curve.srt
|
SRT
|
7.8 KB
|
|
|
2. Excel Winter's method.mp4
|
MP4
|
126.8 MB
|
|
|
2. Excel Winter's method.srt
|
SRT
|
11.3 KB
|
|
|
2. Textual Formulas.mp4
|
MP4
|
109.1 MB
|
|
|
2. Textual Formulas.srt
|
SRT
|
15.1 KB
|
|
|
2.1 03_02_PDE_Data_exploration.pdf
|
PDF
|
322.9 KB
|
|
|
2.1 05_02_Simple_lin_reg.pdf
|
PDF
|
284.8 KB
|
|
|
2.1 11_Solver_reg.xlsx
|
XLSX
|
99.8 KB
|
|
|
2.1 13_Seasonality.xlsx
|
XLSX
|
20.3 KB
|
|
|
2.1 15_winter.xlsx
|
XLSX
|
56.5 KB
|
|
|
2.1 16_S_curve.xlsx
|
XLSX
|
45.5 KB
|
|
|
2.1 Files_forecasting.zip
|
ZIP
|
2.9 MB
|
|
|
3. Assessing accuracy of predicted coefficients.mp4
|
MP4
|
104.4 MB
|
|
|
3. Assessing accuracy of predicted coefficients.srt
|
SRT
|
15.8 KB
|
|
|
3. Creating Linear Model with Trendlines.mp4
|
MP4
|
78.9 MB
|
|
|
3. Creating Linear Model with Trendlines.srt
|
SRT
|
7.9 KB
|
|
|
3. Excel Including the impact of Special Events.mp4
|
MP4
|
205.2 MB
|
|
|
3. Excel Including the impact of Special Events.srt
|
SRT
|
20.6 KB
|
|
|
3. Excel Multiplicative model to identify Trend & Seasonality.mp4
|
MP4
|
57.3 MB
|
|
|
3. Excel Multiplicative model to identify Trend & Seasonality.srt
|
SRT
|
6.1 KB
|
|
|
3. Excel Using Gompertz curve to model S-curve.mp4
|
MP4
|
36 MB
|
|
|
3. Excel Using Gompertz curve to model S-curve.srt
|
SRT
|
4.2 KB
|
|
|
3. Logical Formulas.mp4
|
MP4
|
77.8 MB
|
|
|
3. Logical Formulas.srt
|
SRT
|
9.6 KB
|
|
|
3. The Data and the Data Dictionary.mp4
|
MP4
|
78.6 MB
|
|
|
3. The Data and the Data Dictionary.srt
|
SRT
|
7.8 KB
|
|
|
3.1 03_03_PDE_Raw_Data_Analysis_Uni.pdf
|
PDF
|
332 KB
|
|
|
3.1 05_03_Simple_lin_reg_Accuracy.pdf
|
PDF
|
332.7 KB
|
|
|
3.1 12_SpecialEvents.xlsx
|
XLSX
|
54.2 KB
|
|
|
3.1 16_S_curve.xlsx
|
XLSX
|
45.5 KB
|
|
|
4. Assessing Model Accuracy RSE and R squared.mp4
|
MP4
|
49.7 MB
|
|
|
4. Assessing Model Accuracy RSE and R squared.srt
|
SRT
|
8 KB
|
|
|
4. Bass Diffusion Model for New Products.mp4
|
MP4
|
46.2 MB
|
|
|
4. Bass Diffusion Model for New Products.srt
|
SRT
|
9.2 KB
|
|
|
4. Date-Time Formulas.mp4
|
MP4
|
48.8 MB
|
|
|
4. Date-Time Formulas.srt
|
SRT
|
6.8 KB
|
|
|
4. Moving Average Method.mp4
|
MP4
|
9.6 MB
|
|
|
4. Moving Average Method.srt
|
SRT
|
1.6 KB
|
|
|
4. Univariate analysis and EDD.mp4
|
MP4
|
27.3 MB
|
|
|
4. Univariate analysis and EDD.srt
|
SRT
|
3.4 KB
|
|
|
4.1 04_House_Price.xlsx
|
XLSX
|
104.8 KB
|
|
|
4.1 05_03_Simple_lin_reg_Accuracy.pdf
|
PDF
|
332.7 KB
|
|
|
4.1 14_Moving_Avg.xlsx
|
XLSX
|
12.7 KB
|
|
|
4.1 17_bass.pdf
|
PDF
|
209.5 KB
|
|
|
4.2 03_04_PDE_Univariate_Analysis_Uni.pdf
|
PDF
|
333.4 KB
|
|
|
4.2 14_Moving_Average.pdf
|
PDF
|
119.3 KB
|
|
|
5. Creating Simple Linear Regression model.mp4
|
MP4
|
31.1 MB
|
|
|
5. Creating Simple Linear Regression model.srt
|
SRT
|
2.6 KB
|
|
|
5. Discriptive Data Analytics in Excel.mp4
|
MP4
|
153.5 MB
|
|
|
5. Discriptive Data Analytics in Excel.srt
|
SRT
|
10.3 KB
|
|
|
5. Excel Implementing Bass Diffusion Model.mp4
|
MP4
|
101.6 MB
|
|
|
5. Excel Implementing Bass Diffusion Model.srt
|
SRT
|
12.9 KB
|
|
|
5. Lookup Formulas ( V Lookup, Hlookup, Index-Match ).mp4
|
MP4
|
64.3 MB
|
|
|
5. Lookup Formulas ( V Lookup, Hlookup, Index-Match ).srt
|
SRT
|
9.4 KB
|
|
|
5. Quiz.html
|
HTML
|
204.8 B
|
|
|
5.1 05_Outlier.xlsx
|
XLSX
|
104.9 KB
|
|
|
5.1 17_Bass.xlsx
|
XLSX
|
33.3 KB
|
|
|
6. Data Tools.mp4
|
MP4
|
127.9 MB
|
|
|
6. Data Tools.srt
|
SRT
|
19.5 KB
|
|
|
6. Excel Moving Average Method.mp4
|
MP4
|
119.8 MB
|
|
|
6. Excel Moving Average Method.srt
|
SRT
|
14.7 KB
|
|
|
6. Final Course Quiz.html
|
HTML
|
204.8 B
|
|
|
6. Multiple Linear Regression.mp4
|
MP4
|
38.9 MB
|
|
|
6. Multiple Linear Regression.srt
|
SRT
|
5.7 KB
|
|
|
6. Outlier Treatment.mp4
|
MP4
|
27.8 MB
|
|
|
6. Outlier Treatment.srt
|
SRT
|
4.5 KB
|
|
|
6.1 04_06_PDE_Outlier_Treatment.pdf
|
PDF
|
355.1 KB
|
|
|
6.1 05_04_Multiple_lin_reg.pdf
|
PDF
|
219.8 KB
|
|
|
6.1 14_Moving_Avg.xlsx
|
XLSX
|
12.7 KB
|
|
|
7. Assignment 2 Identifying Trend and Seasonality.html
|
HTML
|
204.8 B
|
|
|
7. Assignment 3 Bass Model.html
|
HTML
|
204.8 B
|
|
|
7. Formatting data and tables.mp4
|
MP4
|
159.3 MB
|
|
|
7. Formatting data and tables.srt
|
SRT
|
17 KB
|
|
|
7. Identifying and Treating Outliers in Excel.mp4
|
MP4
|
64.4 MB
|
|
|
7. Identifying and Treating Outliers in Excel.srt
|
SRT
|
4.3 KB
|
|
|
7. The F - statistic.mp4
|
MP4
|
64.1 MB
|
|
|
7. The F - statistic.srt
|
SRT
|
9 KB
|
|
|
7.1 05_05_F_stat.pdf
|
PDF
|
328.5 KB
|
|
|
7.1 05_Outlier.xlsx
|
XLSX
|
104.9 KB
|
|
|
8. Interpreting results of Categorical variables.mp4
|
MP4
|
27.1 MB
|
|
|
8. Interpreting results of Categorical variables.srt
|
SRT
|
5.3 KB
|
|
|
8. Missing Value Imputation.mp4
|
MP4
|
27.6 MB
|
|
|
8. Missing Value Imputation.srt
|
SRT
|
4.1 KB
|
|
|
8. Pivot Tables.mp4
|
MP4
|
73.2 MB
|
|
|
8. Pivot Tables.srt
|
SRT
|
8.4 KB
|
|
|
8.1 04_05_PDE_Missing_value.pdf
|
PDF
|
315.7 KB
|
|
|
8.1 05_06_Cat_var.pdf
|
PDF
|
155.5 KB
|
|
|
9. Creating Multiple Linear Regression model.mp4
|
MP4
|
97.6 MB
|
|
|
9. Creating Multiple Linear Regression model.srt
|
SRT
|
8 KB
|
|
|
9. Excel Charts Categories of messages that can be conveyed.mp4
|
MP4
|
20 MB
|
|
|
9. Excel Charts Categories of messages that can be conveyed.srt
|
SRT
|
5.1 KB
|
|
|
9. Identifying and Treating missing values in Excel.mp4
|
MP4
|
51.8 MB
|
|
|
9. Identifying and Treating missing values in Excel.srt
|
SRT
|
3.9 KB
|
|
|
9.1 05_Miss_val.xlsx
|
XLSX
|
104.9 KB
|
|
|
9.1 09_multiple.xlsx
|
XLSX
|
100.5 KB
|
|
|
Readme.txt
|
TXT
|
921.6 B
|
|
|
[GigaCourse.com].url
|
URL
|
0 B
|
![Udemy - Marketing Analytics Forecasting Models with Excel [GC]](/static/img/no-torrent-image.png "Udemy - Marketing Analytics Forecasting Models with Excel [GC]")
