Pushing data analytics beyond the capabilities of excel.
Automating mundane tasks to utilize time on more critical work and generate end reports including visuals.
Target audience
Participants working in excel operations on regular basis Financial / risk analysts
Portfolio managers
Quant research team
Economist in financial domains
MIS teams
Data analytics
Forecasting teams
Course Structure
Day 1 (duration 4 hrs)
Session 1: Basics of R Security ReturnsPortfolio Returns
Participants will be able to understand the various data types in R. Additionally you will be able to apply logical structure to the code and make R to repeat certain task multiple times.
Participants will be able to make modular codes. Learn good practices and efficient ways to code using functions. They would be able to learn data manipulations which includes pivots, merge and many other excel like tasks. Data cleaning concepts would be introduced
Day 3 (duration 4 hrs)
Session 4: Fixed Income
Participants will be able to visualize the database.
Participants would be required to install R and R studio in your system.
Trainer Profile
Trainer has a rich experience in data science and financial modelling areas. He is a versatile trainer equipped to handle topics like machine learning, programming languages in Python and R and market risk analysis. He is a engineer and MBA by education.
