Financial Data Analytics: Comprehensive Guide to Collecting, Extracting, and Interpreting Data TGS-2024041805

In the financial industry, the ability to collect, extract, and interpret data in alignment with defined requirements to derive valuable business insights is of paramount importance. Statistical thinking serves as the foundation for achieving this goal, focusing on the comprehension, control, and reduction of process variations. In this context, it becomes essential to familiarize yourself with process maps and various problem-solving tools that aid in the precise definition and scoping of your financial projects. Equally vital is gaining an in-depth understanding of the data required to address the specific challenges unique to the finance sector.

Across all sectors, including finance, the process of extracting meaningful insights from data holds central importance in driving effective problem-solving, fostering innovation, and facilitating sustainable growth. However, the key lies in not only comprehending the various approaches available but also mastering the skills to interpret and communicate your findings effectively. This is where Statistical Thinking for Business Problems emerges as a critical competency for individuals seeking to enhance their practical abilities in using data to excel at problem-solving within the financial realm.

To accomplish this, you will harness the power of widely recognized tools like Excel, SQL, and Tableau, enabling you to conduct in-depth analysis and derive actionable insights. In the dynamic financial landscape of Singapore, data analytics has evolved into an integral component of every business operation. Succeeding in today's competitive business environment necessitates the acquisition of skills that empower you to leverage data for making informed, strategic decisions. This comprehensive workshop equips you with proficiency in industry-standard tools, including Excel, SQL, and Tableau. You will gain the competence to analyze extensive datasets and create impactful dashboards and visualizations, which are highly relevant and applicable across a spectrum of financial roles. This, in turn, instills in you the confidence and credibility required to apply this versatile skill set to a myriad of job opportunities within the finance industry.

Over the course of this 2-day workshop, you will delve into the practical application of SQL for descriptive statistics. This will empower you to effectively summarize datasets, extract meaningful insights, and make well-informed predictions—a skill set indispensable for advanced data analysis within the financial domain. Additionally, you will acquire advanced Excel techniques and Tableau proficiency, further augmenting your capabilities in conducting advanced financial data analysis and extracting crucial business insights.

What is the IBF funding?

There are two main schemes provided under the IBF funding – IBF Standards Training Scheme (IBF-STS) and IBF Financial Training Scheme (FTS). Under these schemes, eligible individuals may receive up to 70% funding support off course fees on IBF funded courses in Singapore.

Upon completion of this 2-Day course, learners will be able to:

• Problem-Solving Overview - Understand Process & Identify Root Causes
• Compiling, Qualifying, and Collecting Data, understanding the core, steps in preparing your data for analysis
• Importing Data for Analysis: Describe the importance of data, and the steps needed to compile and prepare data for analysis 
• Exploratory Data Analysis: Compare methods for summarizing, exploring, and analyzing data, and describe when to, apply these methods 
• Define and use the various data types. 
• Describe relational databases and database management systems. 
• Use the different SQL command types and install SQLite Studio.
• Apply various Microsoft excel functions (Count, Average, CountBlank) to sort & clean, remove duplicates and consolidate data.

Note: Learners are required to bring an internet-enabled laptop

This course is tailor-made for professionals in the financial industry who aspire to cultivate a practical skill set for effectively collecting, extracting, and interpreting data in accordance with specific requirements to glean critical business insights.

• Data Analysts: If you are a data analyst in the financial sector, this course is a perfect fit. You'll learn how to gather and harmonize data from diverse sources, conduct comprehensive analyses, and derive meaningful insights that inform crucial decisions regarding business strategies, products, and solutions. You'll also gain the expertise to construct analytical tools and collaborate with business units to align with their reporting and visualization needs.
• Data Engineers: For data engineers in finance, this course offers valuable knowledge and skills. It supports you in comprehending the design, implementation, and maintenance of data flow pathways and data processing systems that underpin the consolidation, storage, batch processing, and real-time analysis of financial information in a scalable, systematic, and secure manner. Your focus will be on integrating these systems into the internal infrastructure of financial institutions.
• Individuals Seeking Proficiency in Excel, SQL, and Tableau: If you are an individual looking to harness the power of Excel, SQL, and Tableau for robust analysis and insights, this course is an excellent choice. You will gain the expertise needed to leverage these industry-standard tools for data-driven decision-making, a skill set that holds immense value and applicability especially within the financial domain.

Learners need to possess basic information and communication technology (ICT) skills. 

Director of Operations and Enablement ByteDance: Mr. Andeed Ma

Andeed Ma is the Director of Operations and Enablement ByteDance. He has been a cloud business and risk management leader for more than 13 years with major SaaS enterprises such as ServiceNow and Ivanti. He is currently the Director of Operations and Enablement for ByteDance, and an adjunct lecturer at the Singapore University of Social Sciences (SUSS) teaching Hyperautomation, Artificial Intelligence (AI), Machine Learning, and AI Ethics. 

He serves as the President and Chairman of Governing Council of Risk and Insurance Management Association of Singapore (RIMAS), a non-profit enterprise risk management association. Andeed leads the AI Risk Chapter in RIMAS as well. 

He is also appointed as Chairman of the Programme Advisory Committee (PAC) for the Graduate Diploma Analytics and Visualisation programme of SUSS, a Board Director in an EdTech (Ripplecreate), and Board of Advisors to NUS Alumni Ventures (NAV), supports the start-up ecosystem through regular mentoring, judging, instructing, speaking, and coaching founders on areas relating to market, team, and technology risk management. 

Andeed also sits in the SEA-NZ-AUS committee as a contributor to a UK non-profit organization focusing on audits for AI-Trust-Ethics known as ForHumanity, and an expert member in an AI leaders think tank known as AIII (Artificial Intelligence International Institute).

CPE-Registered Adjunct Lecturer & Experienced Data Analyst: Gary Goh

Gary is an experienced data analyst with a demonstrated history of working in leading software and biotechnology companies; CPE-Registered adjunct lecturer at multiple private education institutions to teach and examine courses for diploma to postgraduate levels. He holds an MBA in Finance from University of Nottingham (UK), BSc in Finance from University College of Dublin (Ireland), Specialist Diploma in Big Data Analytics from Temasek Polytechnic (Singapore), Microsoft Professional Program for Data Science and Advanced Certificate in Training and Assessment (ACTA). 

As a staunch supporter of lifelong learning, he is currently working towards a Master of Science in Analytics from Georgia Tech, which is one of the top-ranking universities in the world for Computer Science. He is always curious in understanding how things work under the hood and identifying hidden business opportunities with help of data. Exploring effective ways to communicate findings with the stakeholders through data storytelling. Skilled in SQL, Python, Tableau, Power BI, EDA.