Econometrics For Business

Learn Causal Inference & Statistical Modeling to solve finance and marketing business problems. Code templates included.

Last updated 2022-01-10 | 4.5

- Econometric use cases in the business world
- Difference-in-differences
- Google's Causal Impact

What you'll learn

Econometric use cases in the business world
Difference-in-differences
Google's Causal Impact
Granger Causality
Propensity Score Matching
CHAID
R for Econometrics
Python for Econometrics
Regressions and t-tests

* Requirements

* Basic high school math
* Basic statistics: mean
* median
* mode

Description

Econometrics has horrible fame. The complex theorems, combined with boring classes where it feels like you are learning Greek, give every student nightmares. This course stays away from that. It will focus on (1) giving you the intuition and tools to apply the techniques learned, (2) making sure everything that you learn is actionable in your career, and (3) offer you a tool kit of peer-reviewed econometric causal inference techniques that will make you stand out and give you the ability to answer the tough questions.

WHY ECONOMETRICS FOR BUSINESS IN R AND Python?

In each section, you will learn a new technique. The learning process is split into three parts. The first is an overview of Use Cases. Drawing from business literature and my own experience, I will show examples where each Econometric technique has been applied. The goal here is to show that Econometric methods are actionable. The second part is the Intuition tutorials. The aim is for you to understand why the technique makes sense. All intuition tutorials are based on business situations. The last part is the Practice tutorials, where we will code and solve a business or economic problem. There will be at least one practice tutorial per section.

Below are 4 points on why this course is not only relevant but also stands out from others.

1| THOROUGH COURSE STRUCTURE OF MOST IMPACTFUL ECONOMETRIC TECHNIQUES

The techniques in this course are the ones I believe will be most impactful in your career. Like HR, Marketing, Finance, or Operations, all company departments can use these causal techniques. Here is the list:

  1. Difference-in-differences

  2. Google's Causal Impact

  3. Granger Causality

  4. Propensity Score Matching

  5. CHAID

2| BUSINESS EXAMPLES TO FOSTER INTUITION

Each section starts with an overview of business cases and studies where each econometric technique has been used. I will use examples that come from my own professional experience and business literature. The aim is to give you the intuition where to apply them in your current job. By the end of each intuition tutorial, you will be able to easily explain the concepts to your colleagues, manager, and stakeholders.

One of the benefits of giving actual business problems as examples is that you will find similar or even equal issues in your current company. In turn, this enables you to apply what you have learned immediately. Here are some examples:

  1. Impact of M&A on companies.

  2. Understanding how weather influences sales.

  3. Measuring the impact of brand campaigns.

  4. Whether Influencer or Social Media Marketing results in sales.

  5. Investigating the drivers of customer satisfaction.

3| CHALLENGING AND INTERESTING PROBLEMS TO APPLY WHAT YOU LEARNED

For each section, we will have at least one real business or economic dataset. We will apply what we learned during the intuition tutorials.

Here are some examples of problems we will solve and code together:

  1. Measuring the impact of the Cambridge Analytica Scandal on Facebook's stock price.

  2. Assessing the results of giving training to employees.

  3. Challenge the idea that increasing the minimum wage decreases employment.

  4. Ranking the drivers on why people quit their jobs.

  5. Solving the thousand-year-old riddle of who came first: "Chicken or the egg?".

4| HANDS-ON CODING

We will code together. In every single practice tutorial, we will start from scratch, building the code line by line. As also an online coding student, I feel this has been the easiest way to learn.

On top, the code will be built so that you download it and apply the causal inference techniques in your work and projects. Additionally, I will explain what you have to change to use in your dataset and solve the problem you have at hand.

Econometrics for Business in R and Python is a course that naturally extends into your career.

***SUMMARY

The course is packed with use cases, intuition tutorials, hands-on coding, and, most importantly, is actionable in your career.

Feel free to reach out if you have any questions, and I hope to see you inside!

Diogo

Who this course is for:

  • Students or recent graduates interested in Econometrics and Data Science
  • Data Scientists that would like to learn econometrics
  • Business Analysts wanting to make a difference in their current job
  • People curious about Econometrics and Data Science
  • People who would like to know more about analytics

Course content

19 sections • 146 lectures

Course introduction and structure Preview 07:30

Course content Preview 03:57

Installing R and RStudio Preview 02:56

Installing Python and Spyder Preview 03:55

Future of this course and reviews Preview 01:35

Difference-in-differences use cases Preview 03:17

Difference-in-Differences framework Preview 06:21

Modelling Difference-in-differences Preview 04:03

Difference-in-differences assumptions Preview 04:13

Difference-in-differences step by step guide Preview 04:36

Linear Regression crash course Preview 04:50

Linear Regression output summary Preview 05:39

Dummy variable trap Preview 02:38

Getting dataset and code templates folder Preview 00:19

Intro to RStudio and data loading Preview 07:40

Dealing with NAs part 1 Preview 08:05

Dealing with NAs part 2 Preview 02:11

First linear regression model Preview 08:12

Second linear regression model and dummy variable trap Preview 05:37

Last linear regression Preview 02:52

Presenting results Preview 09:38

Getting datasets and code templates folder Preview 00:19

Intro to Spyder and loading data Preview 10:33

Dealing with NAs Preview 08:07

Isolating X and Y variables Preview 04:06

First linear regression model Preview 08:29

Second linear regression model and dummy variable trap Preview 08:43

Last linear regression Preview 07:34

Introducing second case study Preview 03:32

Logistic Regression crash course Preview 04:00

Placebo test mechanics Preview 03:14

Getting datasets and code templates folder Preview 00:19

Loading data and inspecting it Preview 03:23

Defining variables Preview 04:44

First Logistic Regression in R Preview 05:09

Second Logistic Regression Model Preview 02:37

Visualizing results Preview 04:41

Preparing variables and dataset for placebo experiment Preview 04:13

Logistic Regression and Placebo experiment Preview 02:57

Getting datasets and code templates folder Preview 00:19

Loading data and inspecting it Preview 04:18

Creating dummy variables Preview 05:27

Splitting X and Y variables Preview 02:37

First Logistic Regression in Python Preview 06:50

Second Logistic Regression Preview 05:21

Preparing dataset for placebo experiment Preview 04:06

Logistic Regression and Placebo experiment Preview 03:44

Introducing Causal Impact Preview 03:53

Value added of Causal Impact Preview 04:41

Step by step application guide Preview 02:23

Case study briefing Preview 03:02

Getting dataset and code templates folder Preview 00:19

Loading Facebook's stock price Preview 05:40

Loading more stock prices Preview 02:29

Plotting stock prices Preview 04:17

Correlation Matrix Preview 04:28

Choosing control group Preview 05:01

Preparing dataset to run Causal Impact Preview 04:12

Calculating the impact Preview 04:08

Interpreting Causal Impact results Preview 04:57

Getting datasets and code templates folder Preview 00:19

Loading Facebook's stock price Preview 07:46

Preparing stock price dataset Preview 05:08

Plotting stock prices Preview 02:11

Correlation Matrix Preview 03:59

Finishing up the control groups Preview 06:21

Preparing dataset to run Causal Impact Preview 03:02

Running Causal Impact Preview 04:18

Interpreting Causal Impact results Preview 05:24

Granger Causality use cases Preview 01:45

Problem statement Preview 03:24

Correlation is not causality! Preview 02:37

Granger Causality framework Preview 02:20

Stationarity Preview 03:46

Granger Causality step by step guide and case study briefing Preview 03:00

Getting dataset and code templates folder Preview 00:19

Loading and inspecting data Preview 03:56

Plotting time series Preview 02:58

Stationarity check Preview 05:36

Applying Granger Causality Preview 05:12

Optimal number of lags and for loop part 1 Preview 09:29

Optimal number of lags and for loop part 2 Preview 04:36

Getting datasets and code templates folder Preview 00:19

Loading data and inspecting it Preview 02:28

Isolating eggs and chickens Preview 02:14

Plotting time series Preview 02:38

Stationarity check for eggs Preview 04:22

Stationarity check for chickens Preview 01:13

Making time series stationary Preview 05:18

Preparing dataset for Granger Causality Preview 04:36

Granger Causality Preview 04:55

Propensity Score Matching use cases Preview 02:55

Problem statement Preview 02:14

Propensity Score Matching framework Preview 02:43

Unconfoundness and Common Support Region Preview 06:55

Propensity Score Matching step by step guide Preview 02:12

T-test crash course Preview 02:40

Case study briefing Preview 00:56

Getting dataset and code templates folder Preview 00:19

Loading data Preview 02:57

Average income in 78 per group Preview 04:25

Summary of Confounders' averages Preview 06:35

T-Test function Preview 09:48

Logistic Regression Preview 04:50

Creating dataframe for common support region Preview 05:15

Common Support Region Preview 05:49

Propensity Score Matching Preview 04:41

Propensity Score Matching Summary Preview 03:36

T-Test on the matched groups Preview 03:36

Impact assessment Preview 04:04

Robustness check Preview 03:25

Getting datasets and code templates folder Preview 00:19

Loading and inspecting data Preview 03:53

Summary of Confounders' averages Preview 03:14

For loop and t-tests Preview 10:38

Isolating treat and confounder variables Preview 02:21

Logistic Regression Preview 03:42

Creating dataset with propensities Preview 03:59

Preparing dataset for Common Support Region Preview 05:18

Common Support Region Preview 03:54

Isolating Y, treat and confounders Preview 01:59

Propensity Score Matching Preview 11:38

CHAID use cases Preview 03:02

Problem statement Preview 05:01

CHAID Framework Preview 05:00

How CHAID works Preview 03:06

Confusion Matrix Preview 04:51

CHAID step by step guide Preview 02:32

Case study briefing Preview 01:01

Getting dataset and code templates folder Preview 00:19

Loading data and analysis Preview 03:07

Data structure and summary statistics Preview 04:47

Forming factor only dataset Preview 01:50

On installing CHAID Preview 00:41

First CHAID model Preview 04:28

Plotting CHAID Preview 04:15

Chi-square test Preview 02:43

Accuracy, sensitivity and specificity Preview 04:29

Driver Importance Preview 03:36

Transforming numeric into factors part 1 Preview 07:31

Second CHAID model Preview 06:41

Density plot for numerical variables Preview 06:15

Transforming numeric into factors part 2 Preview 03:42

Transforming numeric into factors part 3 Preview 02:59

Third CHAID model Preview 05:41