Financial Analytics & Modelling
The Financial Analytics Programme is tailored for professionals who are eager to enhance their analytical capabilities and drive data-informed decisions. Whether you’re new to analytics or looking to build on your current skills, this 2-month program offers a comprehensive blend of practical tools and theoretical insights designed to optimize financial processes and improve decision-making. Upon completion, participants will engage in a 2-month virtual internship, providing valuable, real-world experience in applying financial analytics to solve business challenges.
2 Months
₦125,000/month
₦250,000
NB: Payment can be made monthly or in Two installments
Curriculum Breakdown
- Introduction to Financial Analysis & Modelling Fundamental
- Financial Analyst Tools & Software
- Trends & Future of Financial Analyst
- AI in Financial Analytics & Modelling
- Introduction to Financial Modelling
- Building Financial Models
- Building the Assumptions
- Building your Income Statement
- Building your Balance Sheet
- Building your Cash Flow Statement
- Advanced Microsoft Excel and Data Cleaning
- Introduction To Excel
- Excel Operations
- Data Cleaning Functions
- Data Analyst Toolkit
- Excel Functions
- Dashboarding Using Microsoft Excel
- Scenario analysis
- FCFF & FCFE
- Calculation of WACC
- DCF Valuation
- Financial Ratio and Summary
- Building dashboard
- Introduction To Power BI
- The Architecture Of Power BI
- Concept Of Primary Keys And Foreign Keys
- Concept Of Fact And Dimension Tables
- Understanding Facts And Dimension In Data Modelling
- Data Importation
- Data Transformation In Power Query
- Creating A Calendar Dimension Table
- Writing DAX Measures
- Creating a Dashboard Template in Your report view
- Building your Dashboard
- Creating Slicers in Power BI
- Building your first Dashboard
- Creating & Working With Dataflows
- Building a Financial Model for an Existing Business
- Extracting Microsoft Financial Statement
- Work on Income Statement
- Work on the balance sheet
- Work on the cash flow statement
- Valuation
- Sensitivity Analysis
- Microsoft Fabrics
- Introduction to Microsoft Fabrics
- Creating a Fabric Workspace, Lakehouse and upload data into your lakehouse
- Writing SQL Queries in Fabric
- Building a quick Power BI report in Fabric
- Using ChatGPT for Data Analytics
- Introduction to SQL
- Restore your NorthWind Database
- SQL Syntax 1, 2, 3, 4 & Save your work
- SQL Functions
- Introduction To The Case Study
- Restore The Database
- Accounting Fundamentals and Financial Statements
- Introduction to Accounting and Financial Analytics
- Accounting Equation and Double Entry Principle
- Accounting Concepts and Conventions
- Introduction to Financial Statement
- Financial statement Analysis and Interpretation
- Depreciation & Amortization
- Depreciation and Amortisation (Part 1 - 3)
Course Benefits
- Two Months Internship Placement
- Build an online portfolio with 6 high-end project
- One on one mentorship and coaching session
- Recommendation/reference letter
- Job interview Preparation
- Gain online presence for job prospect visibility
Job Opportunities
- Financial Analyst
- Data Analyst
- Investment Analyst
- Commercial Analyst
- Credit Analyst
- Treasury Analyst
- Financial Planning and Analysis (FP&A) Analyst
- Pricing Analyst
- Portfolio Analyst
Contact Evolve HQ
Enroll for Financial Analytics by Evolve HQ
Meet Our Faculty
Meet our world class, competent and ever dedicated tutors who will be guiding you through the journey
Tolu Awoyemi
Lead Business Analyst at Enterprise Route Solutions
Tolu is a Highly skilled Business and Financial Analyst, Pricing for Profit professional, and Marketing and Sales Strategist, with a Creative and Analytical mindset and a Keen Interest in Positive Transformation and Outcomes in People and Business Development Processes. He has unique blend of expertise in Technology Management, Project Management, Marketing, Training, and Consulting..
Busayo Michael
Busayo is a passionate IT Business Solutions Specialist driven by automating tedious processes and crafting user-centric products that fuel business growth.
Leveraging his expertise in business analysis, data analysis, and agile software product management, Busayo bridges the gap between users, technology, and business objectives, he has delivered impactful solutions across Telecoms, SaaS, Fintech, and Insurance.
Know More about evolve HQ Courses
Lorem ipsum dolor sit amet, consectetur elit. Ut elit tellus, luctus nec adipiscing
Explore Other Courses from Evolve HQ
All programs are designed to prepare you for the future in the tech world
Excel Mastery for Human Resources
Ethical Hacking & Penetration testing
Governance, Risk & Compliance (GRC)
Security Operations Centre (SOC)
Artificial Intelligence Automation
