Financial Analytics
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.
0 Course instructors
Instructor led course
6 month duration
2 or 6 Month Internship
Course Duration
6 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
Week 0 : Introduction
The Week 0 : Introduction is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Installations
How To Download And Install Microsoft Office
How To Download And Install Power BI On Windows
How To Download And Install Power BI On Mac Book
How To Download And Install PostgreSQL
Module 2: Module 0: Introduction To Problem Solving
Welcome Address
Introduction To The Programme
Stages In Learning Data Analytics
Data & Big Data
Data Analytics & Career Paths
Intro To Problem Solving & CRISP DM Methodology
Root Cause Analysis
Decision Tree
Adjusting Your Decison Tree In Draw.Io
Pareto Principle
DMAIC Framework
SWOT Analysis
Prioritization Matrix
Creating A Prioritization Matrix Using Excel & Power Point
Module 3: Portfolio Creation
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Week 1
Week 1: Microsoft Excel and Data Cleaning
The Week 1: Microsoft Excel and Data Cleaning is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 1: Introduction To Excel
Overview Of Excel For Data Analytics
Introduction To Microsoft Excel
Cell Referencing
Module 2: 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: 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
Week 2: Excel For Data Analytics
The Week 2: Excel For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 4: 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
Week 3: Dashboarding Using Excel
The Week 3: Dashboarding Using Excel is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 5: 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
Week 4: Getting Started With Power BI
The Week 4: Getting Started With Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 6: Getting Started With Power BI
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
Building A Data Model
Week 5
Week 5: Building your Dashboard In Power BI
The Week 5: Building your Dashboard In Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 7: Build your Dashboard in Power BI
Writing DAX Measures
Creating a Dashboard Template in Your report view
Building your first Dashboard Part 1
Creating Slicers in Power BI
Building your first Dashboard Part 2
Week 6
Week 6: Power BI Service
The Week 6: Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 8: Power BI Service
Introduction To Power BI Service
Loading The Dataset In Power BI
Creating A Simple Dashboard In Power BI
Defining Roles For RLS (Row-Level Security)
Saving Your Work & Signing In PBI Service
Signing In On PBI Desktop & Publishing Your Report
Row Level Security (RLS) In PBI Service
Creating Apps In Pbi Service For Sharing Report
Creating Scorecards In PBI Service
Creating & Working With Dataflows
Week 7
Week 7: SQL For Analytics
The Week 7: SQL For Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 9: SQL (Structured Query Language)
Introduction to SQL
Restore your NorthWind Database
SQL Syntax 1
SQL Syntax 2
SQL Syntax 3
SQL Syntax 4 & Save your work
Week 8
Week 8: SQL Joins
The Week 8: SQL Joins is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 10: SQL JOINS
Inner Join
LEFT JOIN
RIGHT JOIN 1
RIGHT JOIN 2
FULL JOIN & ALIASES
Week 9
Week 9: SQL Functions
The Week 9: SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 11: SQL Functions
Introduction To The Case Study
Download And Extract The Database
Restore The Database
CASE & WHEN
COALESCE
CAST
Combining COALESCE, CAST & SUBQUERIES -1
Combining COALESCE, CAST & SUBQUERIES -2
Week 10
Week 10: Accounting Fundamentals and Financial Statements
The Week 10: Accounting Fundamentals and Financial Statements is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 12: Introduction to Accounting and Financial Analytics
Introduction to Accounting and Financial Analytics
Accounting Equation and Double Entry Principle
Accounting Concepts and Conventions
Module 2: Module 13: Introduction to Financial Statement
Introduction to Financial Statement fundamental
Review of the financial statements
Further explanation of the financial statements
Other elements of the financial statement and conclusion
Module 3: Module 14: Financial statement Analysis and Interpretation
Financial Statement Analysis and Interpretation-Introduction
Introduction to quantitative analysis
Introduction to financial ratios and Dupont Analysis
Ratio analysis - Profitability and Leverage
Ratio analysis - Efficiency and Liquidity
Trend analysis and dupont analysis
Week 11
Week 11: DEPRECIATION AND AMORTIZATION
The Week 11: DEPRECIATION AND AMORTIZATION is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 15: Depreciation and Amortisation
Depreciation and Amortisation PRT 1
Depreciation and Amortisation PRT 2
Depreciation and Amortisation PRT 3
Week 12
week 12: Financial Modeling PRT 1
The week 12: Financial Modeling PRT 1 is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 16: BUILDING FINANCIAL MODELLING PART 1
Introduction to Financial Modelling
Formatting your Workbook Part 1
Formatting your Workbook Part 2
Building the Assumptions
Building the Assumptions II
Building the Assumptions III
Building your Financial Model I
Building your Financial Model II
Building your Financial Model III
Building your Income Statement
Building your Balance Sheet
Building your Cashflow Statement
Week 13
week 13: Financial Modeling PRT 2
The week 13: Financial Modeling PRT 2 is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 17: BUILDING FINANCIAL MODELLING PART 2
Scenario analysis
FCFF & FCFE
Calculation of WACC
DCF Valuation
Financial Ratio and Summary
Building dashboard 1
Building Dashboard 2
Building Dashboard 3
Building dashboard 4
Week 14
EXTRA - BUILDING A FINANCIAL MODEL FOR AN EXISTING BUSINESS
The EXTRA - BUILDING A FINANCIAL MODEL FOR AN EXISTING BUSINESS is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 18: BUILDING A FINANCIAL MODEL FOR AN EXISTING BUSINESS
Extracting Microsoft Financial Statement
WORKING ON THE INCOME STATEMENT I
WORKING ON THE INCOME STATEMENT II
WORKING ON THE BALANCE SHEET I
WORKING ON THE BALANCE SHEET II
WORKING ON THE CASH FLOW STATEMENT I
WORKING ON THE CASH FLOW STATEMENT II
VALUATION
Sensitivity Analysis
Week 15
Microsoft Fabrics & ChatGPT
The Microsoft Fabrics & ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 19 : Microsoft Fabrics
Introduction to Microsoft Fabrics
Download a copy of the dataset
Set up your Microsoft developer Account
Activating Fabric items
Creating a Fabric Workspace, Lakehouse and upload data into your lakehouse
Writing SQL Queries in Fabric
Building a quick Power BI report in Fabric
Writing python codes in Fabric (Data Science)
Module 2: Module 20 : Using ChatGPT for Data Analytics
Using ChatGPT for Data Analytics Part 1
Using ChatGPT for Data Analytics Part 2
Using ChatGPT for Data Analytics Part 3
Using ChatGPT for Data Analytics Part 4
Meet Your Instructor
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
Completed the 10Alytics Financial Analytics program. Got a job as a Financial Analyst at Kegoz Oil and Gas Limited
Ilodigwe Solomon
Completed the 10Alytics Financial Analytics program. He got a job as a Financial Analyst at Nichole Finance Company Ltd.
Victor Bolajoko
While undergoing the 10Alytics Financial Analytics program got a job as a Market Data Analyst at Neona Finance Company Ltd.
Bunmi Obidigbo
Completed the 10Alytics Financial Analytics program. Got a job as a Financial Analyst at Koolboks
Afolabi Adebara
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.
