Retail Analytics In Microsoft Excel Diploma

" Course Introduction Introduction Part 1: Forecasting Basics of Forecasting Creating Linear Model with Trendlines 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge Data Exploration The Data and the Data Dictionary Univariate analysis and EDD Discriptive Data Analytics in Excel Outlier Treatment Identifying and Treating Outliers in Excel Missing Value Imputation Identifying and Treating missing values in Excel Variable Transformation in Excel Dummy variable creation: Handling qualitative data Dummy Variable Creation in Excel Correlation Analysis Creating Correlation Matrix in Excel 1.2 Forecasting Using Regression Model The Problem Statement Basic Equations and Ordinary Least Squares (OLS) method Assessing accuracy of predicted coefficients Assessing Model Accuracy: RSE and R squared Creating Simple Linear Regression model Multiple Linear Regression The F – statistic Interpreting results of Categorical variables Creating Multiple Linear Regression model 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events Excel: Running Linear Regression using Solver Excel: Including the impact of Special Events 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality Excel: Additive model to identify Trend & Seasonality Excel: Multiplicative model to identify Trend & Seasonality Market Basket Analysis Market Basket and Lift – Introduction Named Ranges – Excel Indirect Function – Excel 2-way lift calculation in Excel 2-way lift calculation – Dynamic 2-way lift data table creation 3-way lift calculation Store Layout optimization using Lift values RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis RFM Analysis in Excel- Part 1 RFM Analysis in Excel- Part 2 Part 2: Pricing Steps of setting a Pricing policy Different Pricing Objectives 2.1 Estimating Demand Estimating Demand Forms of Demand Curve Excel: Estimating Linear Demand Curve Excel: Estimating Power Demand curve with Elasticity Excel: Estimating Power Demand Curve with points Subjective Demand curve Excel: Estimating Subjective Demand Curve 2.3 Evaluating Pricing Strategies Price Bundling Types of Bundling The Bundling Problem Excel: Solving Bundling problem Part 1 Excel: Solving Bundling problem Part 2 Non-Linear Pricing Strategies Excel: Solving Bundling problem (Price Reversal) 3.1 Lifetime Customer Value Lifetime Customer Value – Key concepts Lifetime Customer Value – Excel model 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel Variations in finding customer value Appendix 1: Excel Crash Course Basics Worksheet Basics Entering values and Formulas Data Handling Basics – Cut, Copy and Paste Saving and Printing – Basics Basic Formula Operations Mathematical Formulas Textual Formulas Logical Formulas Date-Time Formulas Lookup Formulas ( V Lookup, Hlookup, Index-Match ) Data Tools Formatting data and tables Pivot Tables Advance Excel- Solver, Data tables"