def get_projects_lecture() -> LectureGroup:
lecture_index = 'PJ1'
title = f'Projects'
description = 'Overview of the course projects.'
resources = [
]
lectures = [
notes.get_project_overview_lecture(),
notes.get_project_1_lecture(),
notes.get_project_2_lecture(),
notes.get_project_3_lecture(),
notes.get_project_4_lecture(),
]
return LectureGroup(title, description, lectures, order=lecture_index, global_resources=resources)
def get_dynamic_salary_python_lecture() -> LectureGroup:
lecture_index = 5
title = LECTURE_5_NAME
description = 'Explores building a more complex and realistic model with Python. Here we focus on ' \
'extending the simple retirement model to have dynamic salary growth.'
resources = [
*RESOURCES.lectures.depth_python.resources(),
]
lectures = [
notes.get_jupyter_structure_lecture(),
notes.get_dynamic_salary_model_python_lecture(),
notes.get_wealth_python_lecture(),
notes.get_retirement_python_lecture(),
notes.get_retirement_python_lab_exercise_lecture(),
]
return LectureGroup(title, description, lectures, order=lecture_index, global_resources=resources)
def get_combining_excel_python_lecture() -> LectureGroup:
lecture_index = 9
title = LECTURE_9_NAME
description = 'Use Python from Excel and use Excel from Python. Learn to use the two tools together ' \
'flexibly to enable using the most effective tool for each portion of the model.'
resources = [
*RESOURCES.lectures.combining_excel_python.resources(),
]
lectures = [
notes.get_intro_combining_excel_python_lecture(),
notes.get_pandas_combining_excel_python_lecture(),
notes.get_xlwings_combining_excel_python_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)
def get_data_pipelines_lecture() -> LectureGroup:
lecture_index = 1
title = LECTURE_ADV_2_NAME
course = COURSES[CourseSelectors.ADVANCED]
description = "Covers how to collect, clean, and structure the data for your model in " \
"an automated way, using Python."
resources = [
*RESOURCES.lectures.data_pipelines.resources(),
]
lectures = [
notes.get_debt_details_pipeline_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources,
course=course)
def get_monte_carlo_lecture() -> LectureGroup:
lecture_index = 10
title = LECTURE_10_NAME
description = 'Assign probability distributions to inputs to be able to get probability distributions ' \
'of outputs. Enables a much deeper understanding of model results and especially the risk ' \
'of a result.'
resources = [
*RESOURCES.lectures.monte_carlo.resources(),
]
lectures = [
notes.get_intro_monte_carlo_lecture(),
notes.get_mc_investment_returns_lecture(),
notes.get_mc_ddm_lab_lecture(),
notes.get_formal_mc_lecture(),
notes.get_io_mc_lecture(),
notes.get_mc_retirement_python_lecture(),
notes.get_mc_retirement_excel_lecture(),
notes.get_mc_retirement_excel_io_analysis_lecture(),
]
return LectureGroup(title, description, lectures, order=lecture_index, global_resources=resources)
def get_dynamic_salary_excel_lecture() -> LectureGroup:
lecture_index = 3
title = f'{LECTURE_3_NAME}'
description = 'Explores building a more complex and realistic model with Excel. Here we focus on ' \
'extending the simple retirement model to have dynamic salary growth.'
resources = [
*RESOURCES.lectures.depth_excel.resources(),
]
lectures = [
notes.get_extending_simple_retirement_model_lecture(),
notes.get_relaxing_salary_assumption_lecture(),
notes.get_advanced_excel_functions_lecture(),
notes.get_implement_dynamic_salary_excel_lecture(),
notes.get_lab_excercise_lecture()
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)
def get_visualization_lecture() -> LectureGroup:
lecture_index = 6
title = LECTURE_6_NAME
description = 'Learn how to analyze and communicate complicated results using visualization.'
resources = [
*RESOURCES.lectures.visualization.resources(),
]
lectures = [
notes.get_visualization_intro_lecture(),
notes.get_visualize_retirement_excel_lecture(),
notes.get_intro_pandas_lecture(),
notes.get_styling_pandas_lecture(),
notes.get_pandas_graphing_lecture(),
notes.get_visualize_retirement_python_lecture(),
notes.get_visualization_lab_excercise_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)
def get_intro_lecture() -> LectureGroup:
title = LECTURE_1_NAME
lecture_index = 1
description = 'Introduces myself, the course structure, financial modeling, the tools we will use, ' \
'and how to set up Python.'
resources = [
*RESOURCES.course_materials.resources(),
*RESOURCES.lectures.intro.resources(),
]
lectures = [
notes.get_about_me_lecture(),
notes.get_syllabus_lecture(),
notes.get_what_is_financial_modeling_lecture(),
notes.get_tools_and_skills_lecture(),
notes.get_install_python_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)
def get_python_basics_lecture() -> LectureGroup:
lecture_index = 4
title = f'{LECTURE_4_NAME}'
description = 'Aimed at building a solid foundation of technical skills in Python to enable ' \
'creating complex financial models solely in Python'
resources = [
*RESOURCES.lectures.beyond_initial_python.resources(),
]
lectures = [
notes.get_intro_structure_lecture(),
notes.get_conditionals_lecture(),
notes.get_lists_lecture(),
notes.get_functions_lecture(),
notes.get_python_data_types_lecture(),
notes.get_python_classes_lecture(),
notes.get_python_error_handling_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)
def get_sensitivity_analysis_lecture() -> LectureGroup:
lecture_index = 7
title = LECTURE_7_NAME
description = 'Expand models to check the full range of inputs and see how it impacts the outputs.'
resources = [
*RESOURCES.lectures.sensitivity_analysis.resources(),
]
lectures = [
notes.get_parameter_exploration_intro_lecture(),
notes.get_sensitivity_analysis_intro_lecture(),
notes.get_sensitivity_analysis_excel_lecture(),
notes.get_python_dictionaries_lecture(),
notes.get_python_list_comprehensions_lecture(),
notes.get_python_imports_lecture(),
notes.get_python_sensitivity_analysis_lecture(),
notes.get_python_sensitivity_analysis_retirement_lecture(),
notes.get_python_sensitivity_analysis_lab_lecture(),
]
return LectureGroup(title,
description,
lectures,
order=lecture_index,
global_resources=resources)