Originworld – Data Analytics of Dynamic Pricing and Revenue Modeling
Here’s what you’ll get:
Part 1: You Will Be Able To Extract Raw Transaction Data from Any System.
Knowledge that will make you an Elite Talent All concepts explored using our raw data set
- Databases
- Schemas
- POS Tables
- Relational Databases
- Facts, Dimensions, Granularity
- ODBC
- SQL Language
- Joins
- Group by
- SQL Functions
- Real-Time Reports
Part 2: You Will Understand How to Find Patterns using Probability and Statistics
Knowledge that will make you an Elite Talent All concepts explored using our raw data set
- Counting Random Events
- Frequency Tables
- Frequency Distribution
- Cumulative Distribution
- Inverse Distribution Function
- Expected Value
- The Normal Distribution
- Standard Deviation
- Outliers
Part 3: You Will Know How to Make Better Decisions using Data and Math.
Knowledge that will make you an Elite Talent All concepts explored using our raw data set
- Types of Optimization Models
- Modeling Best Practices
- Cumulative Demand
- Estimating Line Functions
- Demand Functions
- Elasticity
- Revenue Functions
- Price Functions
- Dynamic Pricing
- Revenue Optimization
- Dynamic Programming
Part 4: You Will Build Automated Pricing and Revenue Models in Excel.
Knowledge that will make you an Elite Talent All concepts explored using our real data set
- Excel Tables
- Excel Table Tools
- Date Formulas
- Text Formulas
- Nested Functions
- IF Function
- Lookup Functions
- Criteria Functions
- Array Functions
- OLAP
- Pivot Table
- Pivot Chart
- The Excel Solver
