Financial Analytics - 2025
The Financial Analytics Programme is designed for individuals with a passion for problem-solving and process improvement, whether they are completely new to the field or looking to expand their existing skills. Over the course of 3 months, students are immersed in practical and theoretical lessons aimed at equipping them with the tools to excel in Business Analysis. A 2-month virtual internship follows, allowing for hands-on experience in real-world scenarios.
2 Course instructors
Instructor led course
8-12 month duration
2 or 6 Month Internship
Course Duration
8-12 Months of Instructor-led classes with an option of 2 or 6 Months Internship
Projects
8 Projects
(20% Discount ongoing - Limited slots)
Program fee payment can be in instalments
Course Description
The Financial Analytics Programme is a comprehensive, hands-on training designed to equip both beginners and experienced professionals with the essential skills needed to thrive in today’s dynamic business environments. Whether you're starting from scratch or looking to transition into a Business Analyst role, this course will transform you into a catalyst for change.
Through an engaging blend of live classes, real-world projects, and a two-month virtual internship, you’ll develop a deep understanding of how to analyze and optimize business processes. You'll learn to dissect complex workflows, identify inefficiencies, and design strategic solutions that drive business success. With each module, you'll gain practical experience in key areas such as Data Analytics, Process Mapping, Requirements Engineering, and Stakeholder Management.
The programme goes beyond technical skills, fostering a mindset of innovation and critical thinking. You’ll learn to approach business challenges with analytical rigor and creative problem-solving, ensuring that you can not only address current issues but also anticipate future opportunities for growth.
The hands-on internship allows you to apply your knowledge in real-world scenarios, bridging the gap between theory and practice. By the end of the programme, you will have a robust portfolio of projects and the confidence to step into a variety of Business Analyst roles.
```⬤Course Curriculum
Week 0
Introduction to Financial Analytics
The Introduction to Financial Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Tools and software Installation
How to Download Excel
How to Download Power BI (Windows) I
How to Download Power BI (Windows) II
How to Download PostgreSQL
Module 2: Introduction to Financial Analytics
Welcome Address
Financial Analytics Learning Structure and Roadmap
Stages of learning Financial Analytics
Introduction to Financial Analytics I
Introduction to Financial Analytics II
Introduction to Financial Analytics III
Module 3: Introduction to Data Analytics
What is Data?
Types of Data
What is Big Data?
Data Analytics and Its Types
Differences between Data Analytics and Data Analysis
Careers in Data Analytics and its relevance
Module 4: Problem Solving
What is a problem?
Types of problems in data analytics
Problems in real-life as a Data Analyst
The problem-solving phase
Seven problem solving techniques
Crisp-DM Framework
KDD - Knowledge Discovery in Databases
Root Cause Analysis
Decision Trees
Pareto Principle
DMAIC Methodology
SWOT Analysis
Mental Maths
Module 5: Building a Portfolio
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Module 6: Optimize your LinkedIn Profile
Introduction
Creating your LinkedIn Profile
Uploading your Profile Picture and Cover
Crafting your headline
Your About Section
Work Experience
Education
Skills - Endorsements - Recommendations
Always Refer to your LinkedIn Pack
LinkedIn X JobAlytics
UK Visa Sponsorship LinkedIn Extension
Modifying LinkedIn Settings
Week 1
Excel for Analytics I
The Excel for Analytics I is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Excel
Overview of Excel for Data Analytics
Introduction to Microsoft Excel
Cell Referencing
Module 2: Excel Operations
Excel Shortcuts
Paste Specials
Move or Copy Data
Hiding and Unhiding Rows/Columns
Freeze Panes
Grouping and Ungrouping Data
Module 3: Data Cleaning Functions
Introduction to Data Cleaning in Excel
TRIM Function
CLEAN and VALUE Function
UPPER, LOWER, PROPER and CONCATENATE
SUBSTITUTE Function
LEFT, RIGHT and SEARCH Function
UNIQUE and Remove Duplicate
Week 2
Excel for Analytics II
The Excel for Analytics II is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Data Analyst Toolkit
Data Validation and Conditional Formatting
Referencing, Data Validation and Conditional Formatting
Aggregate Function
Aggregate Function Vs Subtotal
IF, NestedIF and IFS
IF & And, IF & OR and IFERROR
Excel Table, Structured Referencing and COUNTIF
SUMIF(S) and AVERAGEIF(S)
Lookup Functions
Module 2: Extras - Excel Functions
Formulas and Functions in Excel 1
Formulas and Functions in Excel 2
Formulas and Functions in Excel 3
Index and Match
Vlookup
Xlookup
Text Manipulation in Excel
Week 3
Data Presentation, Storytelling and Dashboarding
The Data Presentation, Storytelling and Dashboarding is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Dashboarding Using Microsoft Excel
Dashboard Introduction
Exercise Intro
Data Analytics
Pivot Tables and Dashboard
Dashboard and Slicers
Module 2: Extra: Dashboarding Exercise
Pivot Table 1
Pivot Table 2
Pivot Table 3
Building your Dashboard 1
Building your Dashboard 2
Week 4
Introduction to Power BI & Data Modelling
The Introduction to Power BI & Data Modelling is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Power BI
Introduction to Power BI
Why Power BI and not Excel
Understanding the Power BI Workflow
Types of Data Connector
Power Query Editor
Dax functions and M Language
Case Study - Dax functions and M Language
building your first dashboard PRT 1
building your first dashboard PRT 2
Module 2: Introduction to Data Modelling
What is Data Modelling?
Why Data Modelling?
Concept of Primary and Foreign keys
Concept of Fact and Dimension Table
Types of Relationships in a data model
Types of Schemas
Build your first Data Model using Draw.io PRT 1
Build your first Data Model using Draw.io PRT 2
Export Draw.io Data Model
Write your first Calendar DAX
Week 5
Intermediate Power BI
The Intermediate Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Intermediate Power BI (DAX and Dashboarding)
Week 6
Power BI Service
The Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Power BI Service
Week 7
Introduction to SQL
The Introduction to SQL is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to SQL
Week 8
SQL For Data Analytics
The SQL For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL For Data Analytics
Week 9
SQL Functions
The SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL Functions
Week 10
Fundamental of Accounting & Financial Analysis
The Fundamental of Accounting & Financial Analysis is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Accounting and Financial Analytics
Module 2: Introduction to Financial Statement
Module 3: Financial statement Analysis and Interpretation
Week 11
Depreciation and Amortisation
The Depreciation and Amortisation is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Depreciation and Amortisation
Week 12
Financial Modeling I
The Financial Modeling I is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Building Financial Modeling Part 1
Week 13
Financial Modeling II
The Financial Modeling II is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Building Financial modeling part 2
Module 2: CASE STUDY - BUILDING A FINANCIAL MODEL FOR AN EXISTING BUSINESS
Week 14
Microsoft Fabric and ChatGPT
The Microsoft Fabric and ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Microsoft Fabric
Module 2: ChatGPT
Meet Your Instructor
Fanama Priscilla
Data Associate
Data Associate
Blessed Uyoyovwioghene Erhijakpor
Data Associate
Blessed Erhijakpor is a driven Data Associate at 10Alytics, passionate about using data to solve real-world problems and drive meaningful change. With years of experience in administration, customer relations and operations across education, real estate and health sectors, she applies data-driven approaches to optimize processes and enhance decision-making.
Job Opportunities
With our Data Analytics Cerificate, you get to work as any of the following:
Financial Analyst
Data Analyst
Investment Analyst
Commercial Analyst
Credit Analyst
Treasury Analyst
Financial Planning and Analysis (FP&A) Analyst
Pricing Analyst
Portfolio Analyst
Corporate Financial Analyst
Course Reviews
Select your preferred pricing plan
As an edu-tech brand, we specialize in providing the essential skills and knowledge you need to unlock high-paying opportunities in the dynamic world of technology. Our mission is simple: to empower individuals to pursue their dreams and excel in high-demand tech roles through intensive, hands-on training.
8-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 2 months of internship.
Payment Plan: $150 per month for 5 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
12-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 6 months of internship.
Payment Plan: $125 per month for 8 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
