Certificate in Data Analysis Fundamentals (With SQL & Python)
Whether you are in banking, risk management, portfolio management, or any other field of finance, your role either already requires or will soon require you to be able to program in at least one programming language. As the industry becomes more automated and technology driven, finance professionals with programming/technical skills are going to be more in demand and can help you stay relevant and competitive for the current job market.
The purpose of data analysis is to turn raw data into actionable insights. Much of the world’s raw data, in particular with financial data, exists in collections of tables called relational databases. Thus, in order to be an efficient finance professional, you must know how to extract and clean data from these databases using a programming language called SQL in different occasion like for the changing trend of stock market, comparison of a large amount of statistics and create complicated graph easily for more clear presentation.
Once you got the financial data you need, you would then use Python and various Python-related tools to harvest insights from your data to get a competitive edge, whether it is in creating data-driven financial models for business valuation, business analysis, risk management or simply create beautiful data visualizations to represent your financial data.
Unlike any other Data Analysis courses, this course focuses on SQL & Python specifically for finance professionals, helping you to be familiar with the most in demand tech skills in the 21st century and how you can apply these skills to your areas of expertise, whether it is portfolio analysis, financial trading, risk management or FinTech. You will learn the practical applications of the theoretical methodologies where you will blend technology and finance into construction of a model. This is a challenging course where you are expected to learn quickly.
Subjects and topics include:
Who Should Attend?
Course Details & Fee
Certificate in Data Analysis Fundamentals (With SQL & Python) For Finance Professionals – 16 hours
Class A (Sun & Sat) - 19 & 25 April 2020 (9am-12pm, 1pm-6pm)
Class B (Tue & Thu) - 14, 16, 21, 23, 28, 30 July 2020
7:30pm-10:30pm (14, 16, 21, 23 July)
7:30pm- 9:30pm (28 & 30 July)
Venue: Kaplan Campus
Trainers: Patrick Tsoi/ Simon Mok
For the Data Analysis course, you will learn how to collect, clean and analyze a data set to solve a real-world problem. You will obtain a real-world data set, form a hypothesis about it, clean, parse, and apply modeling techniques and data analysis principles to ultimately create a predictive model using Python and SQL.
Students present their results and each write a report that includes the following:
‣ Clearly articulated a financial problem statement
‣ Summary of data acquisition, cleaning, and parsing stage
‣ Clear presentation of your predictive model and the processes you took to create it
‣ Presentation style appropriate to both technical and non technical audience alike
As you complete stages of your final project, you may be required to present materials and receive feedback from your instructional team, classmates as well as industry experts.
*The final project should be financial related, for example a model which could clearly show that changing trend of the stock market.
FreshLinker has a strong value intention: to provide today’s outstanding graduates with an informative, experienced, one-stop podium of deep industry knowledge, and linking them to the dynamic world of work. From day 1, FreshLinker purposed on constructing a first-class firm that would benefits the finest and brightest talent in the market.
1. Why is this course useful?
It is apparent that data is now a vital part of every financial firm. That being said, to be successful in today’s competitive landscape, businesses could be making more data driven decisions if this vast amount of data was more deeply analyzed through the use of data science. This data analysis course provides the tools, methods, and best practices to enable you to make accurate predictions about data, which ultimately leads to making better decisions.
2. What practical skill sets can I expect to have upon completion of the course?
This course will teach you how to use large data sets to make decisions. Using SQL and Python, you will learn how to collect, clean and analyze data from multiple sources including the web, a local file and a relational database. You will be equipped with technical skills in algorithms and data modeling which allow you to make accurate predictions about your data.
3. What do I need?
Please come prepared with laptop equipped with Microsoft excel.
You may also like
Want to explore other Kaplan coursesCourse Finder