FA582 Foundations of Financial Data Science
Course Catalog Description
This course will provide an overview of issues and trends in data quality, data storage, data scrubbing, and data flows. Topics will include data abstractions and integration, data management issues with collection, warehousing, pre-processing, and querying, similarity and distances, clustering methods, classification methods, text mining, and time series. Case studies will be presented in support of the theoretical concepts. Furthermore, the Hadoop based programming framework for big data issues will be introduced along with any governance and policy issues. These concepts will be applied to areas such as real estate, social media and social networks, and capital markets financial data. A one credit Hanlon lab course, FE-513: Practical Aspects of Database Design is co-requisite to this course in order to facilitate learning of the practical side of data management.
This course provides the theoretical and practical foundation for Financial Analytics. The main objective is to enable the students to create data-driven decision in the financial industry based on data science tools and analytics methods. The goal is to be enable effective business operations, enhanced customer services and product offerings, improved risk analysis, and risk management.
After taking this course, the students will be able to:
- Have a working knowledge of the issues of data quality, data storage, data scrubbing, data flows, and data
encryption and their potential solutions.
- Understand and design various schemas needed for the representation of financial data.
- Tackle problems dealing with data management issues such as collection, warehousing, preprocessing and
- Will get a primer on database management as well as advantages and disadvantages from the attached lab
course FE 513.
- Have a working understanding of all the databases available for them through the Hanlon lab.
- Apply the newly acquired data management and database skills to financial data from the capital markets,
social media, and the financial services sector.
No single textbook covers all the topics. Several references will be used and supplementary notes will be
provided whenever appropriate.
- CS1: Charu C. Aggarwal, Data Classification: Algorithms and Applications. CRC Press, 2015. (ISBN: 978-1-4665-8674-1)
- CS2: Charu C. Aggarwal, Data Mining. Springer, 2015. (ISBN: 978-3-319-14141-8)
- CS3: Deborah Nolan and Duncan T. Lang, Data Science in R: A Case Studies Approach to Computational Reasoning and Problem Solving, CRC Press, 2015. (ISBN: 978-1-4822-3481-7)
- NM: Norman Matloff, The Art of R Programming, No Starch Press, 2011. (ISBN: 978-1-59327-384-2)
- CO: Cathy O’Neil and Rachel Schutt, Data Science, O’Reilly, 2014. (ISBN: 978-1-449-35865-5)
||Introduction to Financial Data Science.
Data Science Process. Sample Data Processing.
Basic Data Types.
The Major Building Blocks: A Bird’s Eye View. Introduction to R.
Case Study: Exploratory Data Analysis (NYC Real Estate)
||Financial Data Quality Issues and Data Scrubbing.
Feature Extraction and
Data Reduction and Transformation. Handling Missing Entries.
Handling Incorrect and Inconsistent Entries.
Scaling and Normalization.
Data Reduction and
Sampling for Static Data and Data Streams.
Dimensionality Reduction Intro.
||Web page retrieval, scrapping, regular expression extraction, basic statistical techniques to
identify wrong data entries.
Case Study: Data and Web Technologies. Linear Model. Piecewise linear model.
||Similarity and Distances. Impact of High Dimensionality.
Generalized Minkovski Distance.
Match-Based Similarity Computation.
Impact of Data Distribution. ISOMAP.
Impact of Local
Similarity on Categorical Data.
Similarity on Mixed Quantitative and
Text Similarity Measures.
Time Series Similarity Measures.
||No Class (Spring Recess)
||Financial Time Series Data.
Using Decision Tree to Trade Stock. Building a Trading Strategy.
Handling Time-Dependent Data in R.
The Prediction Models.
||Mining Text Data.
Document Preparation and Similarity Computation.
Methods for Text.
||Case Study: Using Statistics to Identify Spam
||Outlier Analysis. (Extreme Values. Clustering Models. Distance-Based Models.
Probabilistic Models. Information-Theoretical Models).
||Hadoop. Hadoop Applications.
HDFS and MapReduce.
||Review and Catching up.