> For the complete documentation index, see [llms.txt](https://cfrm.franco.biz/program/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cfrm.franco.biz/program/first-quarter/cfrm-506-financial-data-analysis.md).

# CFRM 506: Financial Data Analysis

> 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