Lesson 1: Intro & basics
In the opening lesson the goals is to get to know each other and also outline how the course will work. Also we will start very light analysis of sample data set in Databricks.
Find here the slides from the lesson.
Find here all the code that is necessary to follow the lesson. Best practice is to copy/paste into the Databricks platform as we discuss the details and logic.
Homework scripts
Find the solution to the given task. Keep in mind this is only of the many possible solutions!
Lesson 2: Revenue Reporting & Analysis
In the first lesson we will take a look at revenue reporting and how to analyze trends, growth, drivers etc.
The slides from the session.
All the necessary code in Python to produce the desired outcomes for the report on revenue
Homework Scripts
TBD
Use this blank template as a guide to prepare revenue report.
Lesson 3a: Cost basics and pipeline
The slides from the session.
All the necessary code in SQL to produce the desired outcomes for the report on revenue
Homework Scripts
TBD
Lesson 3b: Cost by type P&L and allocating central cost
Template to structure P&L
All the necessary code in SQL to produce the desired outcomes for the report on revenue
Homework Scripts
TBD
Lesson 4: Application of ML models in finance
Lesson 5: Valuation of non-public company
Template to use as valuation model
All the necessary code to get the valuation necessary data out of Databricks
Homework Scripts
TBD