1️⃣CFRM 506: Financial Data Analysis

The first of the more practical courses in the curriculum. Very specific to teaching me the tools of the trade. So many different ways to Ctrl+F.

Reading Material:

• VBA For Modelers, S. Albright, 2015.

• Advanced Modeling in Finance, M. Jackson, 2001.

• Microsoft SQL Server & T-SQL, B. Forta, 2008.

This course introduced me to applying the software Microsoft Excel, VBA, and SQL for financial data access and analysis.

1. Microsoft Excel

   1. Solver

   2. Goal Seek

   3. Pivot Tables

   4. Integration with R

2. VBA

   1. The Visual Basic Programming Language

   2. Goal Seek

   3. Dynamically Linked Libraries

3. Databases and SQL

4. In-Database Machine Learning Services with R