Event description
Join Sapling Financial for the FEI Canada Toronto Chapter Event — “Working with Datasets – How Finance instead of IT Can Lead the Charge.”
In this webinar, we provide practical guidance on how to work with large data sets. Topics we will tackle include:
- SQL (MySQL, etc.)
- Survey of products on the market and options for consumption (local vs cloud)
- How to upload data, and how to request data (e.g., CSV, Access files, etc.)
- How to index data for faster queries
- How to transform data
- Data Cleaning
- What it is
- How it can be performed, with focus on Excel string functions
- Fuzzy matching
- What it is
- Tools
- Staying organized
- Naming conventions
- Reconciliations
