Udemy - Marketing Analytics: Forecasting Models with Excel

Category Other
Type Tutorials
Language English
Total size 3.3 GB
Uploaded By tutplanet

Downloads 401
Last checked 1 day ago
Date uploaded 4 years ago
Seeders 1
Leechers 2

Infohash : 77D184163EBD7D7C0F2071AF995D833E65CE6E3E

Udemy - Marketing Analytics: Forecasting Models with Excel

You're looking for a complete course on understanding Forecasting models and forecasting analytics to drive business decisions involving production schedules, inventory management, manpower planning, demand forecasting, and many other parts of the business., right?

You've found the right Marketing Analytics: Forecasting Models with Excel! This course teaches you everything you need to know about different forecasting models and how to implement these models for devising forecasting analytics in Excel using advanced excel tool.
After completing this course you will be able to:

Implement forecasting analytics and forecasting models such as simple linear, simple multiple regression, Ratio to Moving Average, Winter's method for exponential smoothing with trend and seasonality, famous Bass diffusion model and many more.
Increase revenue/profit of your firm by implementing accurate forecasting analytics using Excel solver Add-in
For more Udemy Courses: https://tutorialsplanet.net

                Files: 

                [Tutorialsplanet.NET] Udemy - Marketing Analytics Forecasting Models with Excel
- Introduction
Introduction.mp4 (14.4 MB)
Introduction_en.srt (3.7 KB)
18104846-00-INtro.pdf (455.0 KB)
[Tutorialsplanet.NET].url (0.1 KB)

- Basics of Forecasting
Basics of Forecasting.mp4 (25.3 MB)
Basics of Forecasting_en.srt (5.9 KB)
Course Resources.html (0.4 KB)
This is a milestone_.mp4 (20.7 MB)
This is a milestone__en.srt (3.8 KB)
Creating Linear Model with Trendlines.mp4 (78.9 MB)
Creating Linear Model with Trendlines_en.srt (7.9 KB)
18104840-01-reg-basics.pdf (195.2 KB)

- Getting Data Ready for Regression Model
Gathering Business Knowledge.mp4 (21.9 MB)
Gathering Business Knowledge_en.srt (3.5 KB)
Data Exploration.mp4 (20.1 MB)
Data Exploration_en.srt (3.7 KB)
The Data and the Data Dictionary.mp4 (78.6 MB)
The Data and the Data Dictionary_en.srt (7.8 KB)
Univariate analysis and EDD.mp4 (27.3 MB)
Univariate analysis and EDD_en.srt (3.4 KB)
Discriptive Data Analytics in Excel.mp4 (153.5 MB)
Discriptive Data Analytics in Excel_en.srt (10.3 KB)
Outlier Treatment.mp4 (27.8 MB)
Outlier Treatment_en.srt (4.5 KB)
Identifying and Treating Outliers in Excel.mp4 (54.5 MB)
Identifying and Treating Outliers in Excel_en.srt (4.3 KB)
Missing Value Imputation.mp4 (27.6 MB)
Missing Value Imputation_en.srt (4.1 KB)
Identifying and Treating missing values in Excel.mp4 (51.8 MB)
Identifying and Treating missing values in Excel_en.srt (3.9 KB)
Variable Transformation in Excel.mp4 (54.1 MB)
Variable Transformation in Excel_en.srt (3.8 KB)
Dummy variable creation_ Handling qualitative data.mp4 (40.6 MB)
Dummy variable creation_ Handling qualitative data_en.srt (4.9 KB)
Dummy Variable Creation in Excel.mp4 (108.0 MB)
Dummy Variable Creation in Excel_en.srt (6.8 KB)
Correlation Analysis.mp4 (80.1 MB)
Correlation Analysis_en.srt (10.6 KB)
Creating Correlation Matrix in Excel.mp4 (102.1 MB)
Creating Correlation Matrix in Excel_en.srt (8.3 KB)
18105126-03-01-PDE-Business-knowledge.pdf (153.9 KB)
18105144-03-03-PDE-Raw-Data-Analysis-Uni.pdf (332.0 KB)
18105152-03-04-PDE-Univariate-Analysis-Uni.pdf (333.4 KB)
18105162-04-06-PDE-Outlier-Treatment.pdf (355.1 KB)
18105164-04-05-PDE-Missing-value.pdf (315.7 KB)
18105166-04-11-Dummy-Var.pdf (163.0 KB)
18105170-04-10-Correlation.pdf (256.9 KB)
18105242-08-corr.xlsx (96.9 KB)
18105260-07-Dummy-variable.xlsx (98.1 KB)
18105270-07-Dummy-variable.xlsx (98.1 KB)
18105290-05-Miss-val.xlsx (104.9 KB)
18105300-05-Outlier.xlsx (104.9 KB)
18105320-04-House-Price.xlsx (104.8 KB)
18105324-05-Outlier.xlsx (104.9 KB)

- Forecasting using Regression Model
The Problem Statement.mp4 (10.7 MB)
The Problem Statement_en.srt (1.6 KB)
Basic Equations and Ordinary Least Squares (OLS) method.mp4 (50.2 MB)
Basic Equations and Ordinary Least Squares (OLS) method_en.srt (9.9 KB)
Assessing accuracy of predicted coefficients.mp4 (104.4 MB)
Assessing accuracy of predicted coefficients_en.srt (15.8 KB)
Assessing Model Accuracy_ RSE and R squared.mp4 (49.7 MB)
Assessing Model Accuracy_ RSE and R squared_en.srt (8.0 KB)
Creating Simple Linear Regression model.mp4 (31.1 MB)
Creating Simple Linear Regression model_en.srt (2.6 KB)
Multiple Linear Regression.mp4 (38.9 MB)
Multiple Linear Regression_en.srt (5.7 KB)
The F - statistic.mp4 (64.1 MB)
The F - statistic_en.srt (9.0 KB)
Interpreting results of Categorical variables.mp4 (27.1 MB)
Interpreting results of Categorical variables_en.srt (5.3 KB)
Creating Multiple Linear Regression model.mp4 (97.6 MB)
Creating Multiple Linear Regression model_en.srt (8.0 KB)
18105174-05-01-Intro.pdf (239.3 KB)
18105178-05-02-Simple-lin-reg.pdf (284.8 KB)
18105190-05-03-Simple-lin-reg-Accuracy.pdf (332.7 KB)
18105198-05-03-Simple-lin-reg-Accuracy.pdf (332.7 KB)
18105204-05-04-Multiple-lin-reg.pdf (219.8 KB)
18105206-05-05-F-stat.pdf (328.5 KB)
18105212-05-06-Cat-var.pdf (155.5 KB)
18105224-09-multiple.xlsx (100.5 KB)

- Handling Special events like Holiday sales
Forecasting in presence of special events.mp4 (9.0 MB)
Forecasting in presence of special events_en.srt (3.2 KB)
Excel_ Running Linear Regression using Solver.mp4 (111.6 MB)
Excel_ Running Linear Regression using Solver_en.srt (8.4 KB)
Excel_ Including the impact of Special Events.mp4 (205.2 MB)
Excel_ Including the impact of Special Events_en.srt (20.6 KB)
18104838-11-Special-Events.pdf (204.1 KB)
18105326-11-Solver-reg.xlsx (99.8 KB)
18105336-12-SpecialEvents.xlsx (54.2 KB)

- Identifying Seasonality & Trend for Forecasting
Models to identify Trend & Seasonality.mp4 (39.1 MB)
Models to identify Trend & Seasonality_en.srt (6.7 KB)
Excel_ Additive model to identify Trend & Seasonality.mp4 (89.6 MB)
Excel_ Additive model to identify Trend & Seasonality_en.srt (9.4 KB)
Excel_ Multiplicative model to identify Trend & Seasonality.mp4 (57.3 MB)
Excel_ Multiplicative model to identify Trend & Seasonality_en.srt (6.2 KB)
Moving Average Method.mp4 (9.6 MB)
Moving Average Method_en.srt (1.6 KB)
Excel_ Moving Average Method.mp4 (119.8 MB)
Excel_ Moving Average Method_en.srt (14.7 KB)
18104836-12-Seasonality.pdf (204.1 KB)
18105360-13-Seasonality.xlsx (20.3 KB)
18105366-14-Moving-Avg.xlsx (12.7 KB)
18105370-14-Moving-Average.pdf (119.3 KB)
18105378-14-Moving-Avg.xlsx (12.7 KB)

- Handling Changing Trend & Seasonality over time
Winter's Method to accomodate changing Trend & Seasonality.mp4 (37.3 MB)
Winter's Method to accomodate changing Trend & Seasonality_en.srt (6.8 KB)
Excel_ Winter's method.mp4 (126.8 MB)
Excel_ Winter's method_en.srt (11.3 KB)
18104828-15-Winters.pdf (159.1 KB)
18105382-15-winter.xlsx (56.5 KB)
[Tutorialsplanet.NET].url (0.1 KB)

- Forecasting models for New Products
S-curve for New products.mp4 (44.2 MB)
S-curve for New products_en.srt (8.0 KB)
Excel_ Using Logistic curve to model S-curve.mp4 (62.3 MB)
Excel_ Using Logistic curve to model S-curve_en.srt (7.8 KB)
Excel_ Using Gompertz curve to model S-curve.mp4 (36.0 MB)
Excel_ Using Gompertz curve to model S-curve_en.srt (4.2 KB)
Bass Diffusion Model for New Products.mp4 (46.2 MB)
Bass Diffusion Model for New Products_en.srt (9.2 KB)
Excel_ Implementing Bass Diffusion Model.mp4 (101.5 MB)
Excel_ Implementing Bass Diffusion Model_en.srt (12.9 KB)
18104830-16-S-Model.pdf (203.5 KB)
18104834-17-bass.pdf (209.5 KB)
18105390-16-S-curve.xlsx (45.5 KB)
18105400-16-S-curve.xlsx (45.5 KB)
18105418-17-Bass.xlsx (33.3 KB)

- Appendix 1_ Excel crash course
Mathematical Formulas.mp4 (109.5 MB)
Mathematical Formulas_en.srt (17.7 KB)
Textual Formulas.mp4 (109.1 MB)
Textual Formulas_en.srt (15.1 KB)
Logical Formulas.mp4 (77.8 MB)
Logical Formulas_en.srt (9.6 KB)
Date-Time Formulas.mp4 (48.8 MB)
Date-Time Formulas_en.srt (6.8 KB)
Lookup Formulas ( V Lookup, Hlookup, Index-Match ).mp4 (64.3 MB)
Lookup Formulas ( V Lookup, Hlookup, Index-Match )_en.srt (9.4 KB)
Data Tools.mp4 (127.9 MB)
Data Tools_en.srt (19.5 KB)
Formatting data and tables.mp4 (159.3 MB)
Formatting data and tables_en.srt (17.0 KB)
Pivot Tables.mp4 (73.2 MB)
Pivot Tables_en.srt (8.4 KB)
Excel Charts_ Categories of messages that can be conveyed.mp4 (20.0 MB)
Excel Charts_ Categories of messages that can be conveyed_en.srt (5.1 KB)
Popular Excel charts.html (0.6 KB)

- Bonus Section
The final milestone_.mp4 (11.9 MB)
The final milestone__en.srt (1.7 KB)
Congratulations & About your certificate.html (1.8 KB)

[Tutorialsplanet.NET].url (0.1 KB)

Comments

Code:

ahttp://0d.kebhana.mx:443/announce
udp://bigfoot1942.sektori.org:6969/announce
https://tracker.fastdownload.xyz:443/announce
https://opentracker.xyz:443/announce
http://open.trackerlist.xyz:80/announce
http://torrent.nwps.ws:80/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.tiny-vps.com:6969/announce
http://t.nyaatracker.com:80/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.vanitycore.co:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://retracker.lanta-net.ru:2710/announce
udp://retracker.hotplug.ru:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.uw0.xyz:6969/announce
udp://exodus.desync.com:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://explodie.org:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.iamhansen.xyz:2000/announce
udp://tracker.toss.li:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.justseed.it:1337/announce
https://2.track.ga:443/announce
udp://open.stealth.si:80/announce
udp://zephir.monocul.us:6969/announce
udp://open.demonii.si:1337/announce