Data Science of Dynamic Pricing

Categories: Uncategorized

by Robert Hernandez

Current Status

Not Enrolled

Price

$1,295.00

Get Started

This course is currently closed

Course Content

Expand All

Intro to the Case Study 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Sub Optimal Hotel

Hotel Business Terms

RAW_DATA file 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Importing RAW Data

Excel Tables 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Format as Table

Table Column Sort

Filter Table Column

Multiple Criteria Table Filtering

Naming Excel Tables

Insert and Delete Table Rows and Columns

Excel Table Cell Reference

Excel Table Total Row

Data Transformation 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps

Add OTA_COMM Table

VLOOKUP function

IFERROR function

IFERROR for GROSS RATE

ROUND formulas

CEILING and FLOOR formulas

More ROUND and CEILING

Date and Time in Excel

LEFT and RIGHT functions

MID function

SUBSTITUTE and REPLACE functions

UPPER, LOWER, and PROPER text

Pivot Table and Pivot Chart 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

Introduction to Pivot Tables

A Simple Pivot Table

Adding More Pivot Dimensions

GROUP Pivot Labels

FILTER BY

Pivot Table Report Filter

Value Field Settings

More Value Field Settings

Calculated Fields

Slicers

Pivot Table Formatting

Simple Pivot Chart

Multi-Dimension Pivot Chart

Changing Pivot Chart Type

Formatting any Excel Chart

More Excel Chart Formatting

Slicers with Pivot Charts

Pivot Table Drill Down

Referencing a Pivot Table

Statistical Functions 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

AVERAGE function

SUM function

COUNT function

Standard Deviation function

Minimum and Maximum function

QUARTILE function

Nested and Criteria Functions 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Array Functions 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

MINIF Array function

MAXIF Array function

STDEV IF Array function

QUARTILE IF Array function

MINIFS and MAXIFS Array functions

STDEVIFS Array function

QUARTILEIFS Array function

Non-exact criteria filters

Databases 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

UI and Database

Relational Database

Simple PMS Schema

Important Definitions

PMS Vendors and Databases

ODBC

MS Query 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

MS Query Wizard

MS Query Table View

MS Query of Excel files

SQL Basics 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

SQL Formulas 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Frequency and Probability 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Randomness and Frequency

Frequency Table

Averages for the Frequency Table

The Probability of an Event

Probability with the PMS data

The Standard Deviation 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

The Standard Deviation

The Standard Deviation using PMS data

More Standard Deviation

Finding Outliers

The Normal Distribution 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

The Normal Distribution

The Normal Distribution Curve in Excel

The Normal Distribution Formula

Data Analysis 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

By Month Booking Probability Analysis

By Period Booking Probability Analysis

By Market Booking Probability Analysis

By Channel Booking Probability Analysis

By Days Out Booking Probability Analysis

Expected Value 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Expected Value Theory

EV of Hotel Revenue

EV of Revenue by Period

Mathematical RM Models 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Decision Models

Two Types of RM Models

Capacity Control 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

History of Capacity Control

Capacity Control Graphically

Capacity Control Variables

Rate Class in SOHO_PMS_DATA file

SOHO221_CC file Overview

Capacity Control: The Manual Way

Littlewood’s Rule

Littlewood’s Math Solution

Littlewood’s Rule in SOHO221_CC file

Expected Marginal Seat Revenue

Weighted Average Review

EMSR Class 1 Protection

EMSR Class 2 Protection

EMSR based forecast

Dynamic Pricing 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Capacity Control vs. Dynamic Pricing

Counting in Capacity Control vs. Dynamic Pricing

Rate Frequency in SOHO221_DP

Fundamental Model of Revenue Analysis

Core Assumption of Demand Analysis

Cumulative Frequency by Rate

Dynamic Pricing Optimization Manually

1 of 2