Welcome to Xellux Tech Apex

A Xellux Technologies programme connecting you with tech excellence from June to December 2026.

XELLUX TECHNOLOGIES THE CHANGING ECONOMY
A NEW ERA OF PARTICIPATION

The future is being built. Where will you stand in it?

Technology changes how organisations work, how decisions are made and how value is created. Understanding these changes gives you more than awareness. It gives you a way to participate. The people who can interpret information, improve processes and build useful systems gain a greater ability to shape the work around them. As those abilities spread through teams, businesses and communities, they create new paths for contribution and opportunity.

ECONOMIC SIGNALS ACTIVE
01
Work is becoming digital

More processes depend on software and connected tools.

02
Decisions are becoming data-driven

Information has greater value when people can interpret it.

03
Ideas can become systems

People can build solutions that serve others at scale.

UNDERSTAND THE SHIFT DEVELOP THE CAPABILITY TAKE PART IN CREATING VALUE

Xellux Technologies

Top ICT Training For Global Students

Whether you are a working professional seeking to upskill, a recent graduate looking to kickstart your career in technology, or an organization aiming to empower your workforce with the latest digital skills, Xellux Technologies is your vision board to success.

We provide unmatched practical hands-on training on Data Analytics, Front-End Development Full-Stack Engineering, Data Science, Data & Financial, Business Analytics, Excel For Accountants and other practical skills need to be job-ready that are needed by individuals, companies and organizations in the digital age.
We offer flexible learning options, including both in-person and online classes, allowing you to choose the mode of learning that suits your schedule and preferences.

Register Now

Skill Up

Build A Career In Tech Today

Do you want to change jobs and take up an IT career? Are you a graduate who wants to build a career in IT? Do you have some skills in IT but you want to build a career path that can give you your dream job? Are you not sure of the IT training and skills you need to prepare for the career you want?

Our practical in Software Development and Analytical training in USA UK Canada Turkey Cyprus China & Nigeria can be tailored to meet your desire

CONTACT US TODAY
The Economic Power of Skills

A skill can change your position in the economy.

Learning gives you capability. Applying it produces work others can see. That work can build credibility, open access to valuable networks and give you the ability to create systems that generate value beyond your own hours.

Capability Proof Credibility Networks Systems Ownership

Each stage can expand your economic possibilities:

01

Capability

You gain the ability to solve problems that people and organisations need solved.

02

Proof

Projects turn your ability into visible evidence of what you can deliver.

03

Credibility

When people can examine your work, they have a stronger reason to trust you with responsibility, opportunities and resources.

04

Networks

Credibility can bring you into the rooms where collaborators, employers, clients and new opportunities meet.

05

Systems

Skills and relationships can help you build processes, products or organisations that create value beyond the hours you personally work.

06

Ownership

When you help build lasting systems, you can seek a stake in the value they continue to create.

The goal is bigger than learning a tool. It is building the capability, proof and credibility to access opportunity, create lasting value and participate in what you help build.

Training

The ICT landscape is constantly evolving, with new tools and technologies emerging regularly.
Our training program stays up-to-date with the latest industry trends and equips participants with proficiency in relevant tools and technologies. From programming languages and development frameworks to data analysis tools and Business Analytics software, participants learn to leverage cutting-edge tools to solve complex problems efficiently.


XELLUX TECHNOLOGIES

Courses & Curriculum

Learn a skill. Build the ability to use it.

Explore practical learning paths, projects and the work each course prepares you to undertake.

DATA & BUSINESS INTELLIGENCE / COURSE 01

Excel for Data Analysis

Learn to import, clean, analyse and present business data using Microsoft Excel. Develop your skills through practical exercises and two dashboard projects based on sales and product performance.

Suitable For

Beginners, graduates, career changers and professionals who need to analyse sales, customer, operational or financial data.

Starting Level

Beginner. No prior data analysis experience is required. The course progresses to practical intermediate Excel work.

Course Curriculum

MODULE 01 Excel Foundations and Business Data
  • Workbooks, worksheets, cells, ranges and Excel Tables
  • Entering text, numbers, dates, currencies and percentages
  • Number, currency, percentage and fraction formatting
  • Formatting values without changing the underlying data
  • Freezing rows and navigating large worksheets
  • Sorting by one or multiple columns
  • Filtering records using one or multiple criteria

Practical work: Organise an unstructured transaction worksheet into an Excel Table and identify sales records by date, product and region.

MODULE 02 Importing, Cleaning and Preparing Data
  • Importing CSV, tab-delimited and fixed-width data
  • Importing data from another workbook
  • Checking column names, data types and missing values
  • Finding duplicate and inconsistent records
  • Using Text to Columns and Flash Fill
  • Cleaning text with TRIM, CLEAN and SUBSTITUTE
  • Joining text using & and CONCAT
  • Counting characters and extracting parts of text
  • Changing case and standardising categories
  • Using data validation to reduce entry errors
  • Cleaning data with Power Query
  • Combining monthly files and refreshing the results

Practical work: Combine monthly sales files, remove duplicates, correct inconsistent product names and prepare a clean dataset for analysis. Add a new month's file and refresh the result.

MODULE 03 Formulas, Functions and Dates
  • Cell references, formulas and functions
  • Addition, subtraction, multiplication and division
  • Exponents and the order of operations
  • Relative, absolute and mixed references
  • Referencing cells on another worksheet
  • SUM, AVERAGE, MIN, MAX, COUNT and COUNTA
  • COUNTIF, COUNTIFS, SUMIF and SUMIFS
  • IF, AND, OR and IFERROR
  • Entering, formatting and calculating with dates
  • TODAY, YEAR, MONTH and EOMONTH
  • Calculating days, months and years between dates

Practical work: Calculate transaction values, monthly sales, customer counts and target variances. Build a report that updates when the underlying records change.

MODULE 04 Lookups and Connected Business Records
  • Matching transaction records to product information
  • VLOOKUP and XLOOKUP
  • Exact matches and approximate matches
  • INDEX and MATCH used together
  • HLOOKUP and when horizontal lookups arise
  • Comparing a lookup with a nested IF approach
  • Finding unmatched records and handling lookup errors
  • Checking matched values against the source table

Practical work: Connect a sales transaction table to product and pricing tables. Retrieve categories and prices, then identify products that could not be matched.

MODULE 05 Statistics and Business Performance Analysis
  • Counting, summing and averaging by business category
  • Identifying minimum and maximum values
  • Ranking products, regions or salespeople
  • Calculating growth, variance and percentage change
  • Comparing totals with rates, such as sales per customer
  • Comparing performance across months and quarters
  • Using conditional formatting to inspect patterns
  • Checking unusual results against source records
  • Separating observed results from possible causes

Practical work: Investigate why overall revenue increased while one region declined. Rank products by sales and identify the records behind the regional change.

MODULE 06 PivotTables, PivotCharts and Slicers
  • Creating a PivotTable from an Excel Table
  • Adding and rearranging PivotTable fields
  • Changing the summary calculation
  • Grouping dates and comparing reporting periods
  • Showing percentages, differences and rankings
  • Sorting, filtering and formatting PivotTables
  • Using slicers and timelines
  • Creating and filtering PivotCharts
  • Refreshing PivotTables when source data changes
  • Checking PivotTable results against source totals

Practical work: Build an interactive report that allows a manager to compare sales by month, product category and region.

MODULE 07 Excel Charts and Dashboard Design
  • Choosing a chart that fits the business question
  • Creating line, bar and column charts
  • Editing chart data, titles, legends and labels
  • Moving and resizing charts
  • Creating charts on a separate worksheet
  • Designing a readable one-page dashboard
  • Connecting slicers to relevant PivotTables and charts
  • Using appropriate scales and clear performance measures
  • Showing the reporting period on a dashboard

Practical work: Build a sales dashboard that shows revenue, growth, product performance and regional results.

PROJECT 01 Adidas Dashboard / Excel Slicer Dashboard

Analyse an Adidas sales dataset and build an interactive Excel dashboard using PivotTables, PivotCharts and slicers.

  • Prepare the sales data for analysis
  • Calculate and check key sales measures
  • Compare product, regional and period performance
  • Build PivotTables and connect dashboard slicers
  • Explain the strongest and weakest areas of performance

Project output: An interactive Excel Slicer Dashboard and a short explanation of the findings.

MODULE 08 Reporting Findings and Recommending Action
  • Identifying findings that matter to decision-makers
  • Explaining results in plain business language
  • Supporting conclusions with figures and charts
  • Communicating gaps and uncertainty in the data
  • Making recommendations supported by the findings
  • Presenting an analysis and answering questions

Practical work: Present a short performance review explaining what changed, where it changed, what the evidence shows and what the business should examine next.

PROJECT 02 McDonald's Dashboard / Sales & Product Dashboard

Use sales and product data to investigate business performance and present the results in an Excel dashboard.

  • Clean and organise the supplied records
  • Analyse sales by product and reporting period
  • Identify high and low-performing products
  • Build a sales and product dashboard
  • Present findings supported by the data
  • Recommend what management should investigate or do next

Project output: A Sales & Product Dashboard and a short presentation explaining the findings and recommendations.

Career Reach

Excel-based reporting and entry-level analytical work in sales, operations, administration, customer services, finance and business support teams across industries.

This course develops practical Excel analysis capability. Roles requiring SQL, Power BI, programming or specialist industry knowledge may require further training or experience.

DATA & BUSINESS INTELLIGENCE / COURSE 02

SQL for Data Analysis and Databases

Learn to retrieve, investigate and manage data in relational databases. Write SQL queries to answer business questions, connect related tables and build a database that supports a working application.

Suitable For

Beginners, aspiring analysts, software developers, graduates and professionals who need to work with structured business data.

Starting Level

Beginner. The course starts with database fundamentals and progresses to multi-table analysis and practical database design.

Course Curriculum

MODULE 01 Relational Databases and SQL Foundations
  • What SQL is and how relational databases work
  • Tables, rows, columns and data types
  • Primary keys and foreign keys
  • Understanding NULL and missing information
  • Reading a database schema
  • Using a SQL editor to run and inspect queries
  • Writing SELECT statements and choosing columns
  • Using aliases and DISTINCT

Practical work: Explore a business database containing customers, products and orders. Identify how its tables relate and retrieve your first records.

MODULE 02 Filtering, Sorting and Exploring Records
  • Filtering records with WHERE
  • Comparison and logical operators
  • Using AND, OR and NOT correctly
  • BETWEEN, IN and LIKE
  • Checking NULL values with IS NULL and IS NOT NULL
  • Sorting results with ORDER BY
  • Limiting returned rows
  • Combining conditions without changing their meaning

Practical work: Find orders within a date range, identify customers in selected locations and inspect products that meet specific price and category conditions.

MODULE 03 Calculations and Aggregated Reports
  • COUNT, SUM, AVG, MIN and MAX
  • Calculating values from existing columns
  • Grouping results with GROUP BY
  • Filtering groups with HAVING
  • Counting records and distinct values
  • Handling NULL values in calculations
  • Using CASE to create meaningful categories
  • Checking results against the underlying records

Practical work: Produce monthly sales totals, average order values and product rankings. Investigate differences between a record count and a distinct customer count.

MODULE 04 Joining Related Tables
  • Identifying the keys that connect tables
  • INNER JOIN
  • LEFT JOIN and RIGHT JOIN
  • Joining more than two tables
  • Finding unmatched records
  • Recognising duplicated rows caused by join relationships
  • Checking whether joined totals are correct

Practical work: Connect customers, orders, order items and products to calculate revenue by product and customer. Find orders with missing related records.

MODULE 05 Subqueries, CTEs and Set Operations
  • Using subqueries to answer multi-step questions
  • EXISTS and NOT EXISTS
  • Understanding ANY, SOME and ALL
  • Organising multi-step queries with common table expressions
  • Combining results with UNION and UNION ALL
  • Finding shared or excluded records with INTERSECT and EXCEPT
  • Understanding how set-operation names vary by database

Practical work: Identify customers who purchased from multiple categories, customers who have never ordered and products appearing in more than one sales period.

MODULE 06 Analytical SQL for Business Questions
  • Working with dates and reporting periods
  • Comparing current and previous periods
  • Ranking results with window functions
  • Calculating running totals
  • Finding each customer's first or most recent order
  • Investigating changes in product or regional performance
  • Explaining findings supported by query results

Practical work: Build a monthly performance report, rank products within each category and identify customers whose purchasing activity has changed.

MODULE 07 Creating and Changing Database Records
  • Creating tables with CREATE TABLE
  • Selecting appropriate column data types
  • Adding primary keys, foreign keys and constraints
  • Inserting records with INSERT
  • Changing records with UPDATE
  • Removing records with DELETE
  • Understanding TRUNCATE and DROP
  • Using ALTER TABLE to change a table structure
  • Renaming tables and columns
  • Reviewing affected rows before changing live data

Practical work: Create product and customer tables, add sample records, update incorrect entries and remove test records in a practice database.

MODULE 08 Database Design and Reliable Queries
  • Translating a business requirement into tables
  • Designing relationships between tables
  • Reducing duplicated data through basic normalisation
  • Protecting data with keys and constraints
  • Using transactions for related changes
  • Understanding indexes and why query performance matters
  • Reading a basic query execution plan
  • Writing queries that another team member can understand

Practical work: Improve a database design with duplicated customer information. Add appropriate relationships and test queries against the revised tables.

PROJECT 01 Design a Database for a Social Network

Design and implement a relational database for users, posts, comments and interactions.

  • Identify the information the application must store
  • Design tables, keys and relationships
  • Create the tables and insert sample records
  • Write queries to retrieve posts and interactions
  • Test how the database handles missing and related records

Project output: A working database schema and SQL queries that demonstrate how the application retrieves its data.

PROJECT 02 School Management Database

Design a school database that can organise students, classes, enrolments and results.

  • Design and create the required tables
  • Implement relationships between students and classes
  • Insert, update and retrieve records
  • Write queries for enrolment and results reporting
  • Demonstrate create, read, update and delete operations

Project output: A working school management database with reporting queries and demonstrated CRUD operations.

Career Reach

Entry-level SQL work in data analysis, reporting, business intelligence support, software development and database support across industries.

This course develops practical SQL querying and relational database foundations. Specialist database administration, advanced data engineering and senior analytical roles require further training and experience.

DATA & BUSINESS INTELLIGENCE / COURSE 03

Power BI for Business Intelligence

Connect business data, build a reliable data model, calculate meaningful measures and create interactive reports that help people understand performance and make decisions.

Suitable For

Aspiring BI analysts, reporting analysts, graduates, career changers and professionals who prepare business or management reports.

Starting Level

Beginner. Basic spreadsheet familiarity is useful, but prior Power BI experience is not required.

Course Curriculum

MODULE 01 Power BI Foundations and Report Workflow
  • What business intelligence is used for
  • Installing and opening Power BI Desktop
  • Understanding Report, Data and Model views
  • Adjusting essential Power BI Desktop settings
  • Understanding datasets, semantic models and reports
  • Following the workflow from source data to a finished report
  • Identifying the questions a report must answer

Practical work: Open a business dataset in Power BI Desktop, inspect its tables and define the questions a sales report should answer.

MODULE 02 Connecting and Shaping Data with Power Query
  • Connecting to Excel, CSV and database sources
  • Understanding connection options and source settings
  • Inspecting data in the Power Query Editor
  • Correcting data types and inconsistent values
  • Removing errors, duplicates and unnecessary columns
  • Working with numbers, text and dates
  • Creating index and conditional columns
  • Grouping and aggregating records
  • Appending tables with the same structure
  • Merging tables using matching fields
  • Refreshing data after the source changes

Practical work: Combine monthly sales files, correct inconsistent product categories, connect a product table and refresh the report when a new file is supplied.

MODULE 03 Tables, Relationships and Data Modelling
  • Understanding a Power BI data model
  • Identifying fact tables and lookup tables
  • Recognising repeated data and basic normalisation
  • Creating relationships between tables
  • Understanding one-to-many relationships
  • Choosing appropriate relationship direction
  • Finding missing or unmatched keys
  • Understanding when to relate tables or merge them
  • Creating a date table for period analysis
  • Creating useful hierarchies
  • Hiding technical fields from the report view
  • Checking that totals remain correct after relationships are added

Practical work: Connect sales, products, customers and dates in a model that supports accurate filtering and reporting.

MODULE 04 DAX Foundations and Business Measures
  • What Data Analysis Expressions (DAX) is used for
  • Calculated columns and measures
  • Implicit and explicit measures
  • DAX syntax, operators and basic functions
  • SUM, AVERAGE, COUNT, COUNTA and COUNTROWS
  • DISTINCTCOUNT for unique customers or products
  • IF, AND and OR for business rules
  • Working with dates and text in DAX
  • Using RELATED to retrieve values from related tables
  • Defining revenue, order count and average order value

Practical work: Create measures for revenue, orders, customers and average order value. Compare each result with the underlying records.

MODULE 05 Filter Context and Advanced DAX
  • Understanding how filters affect measures
  • Using CALCULATE to change filter context
  • Using FILTER and ALL where appropriate
  • Using SUMX for row-by-row calculations
  • Using RANKX to rank products or regions
  • Comparing current and previous reporting periods
  • Calculating growth and percentage contribution
  • Checking why a measure changes under a slicer
  • Organising and naming measures clearly

Practical work: Rank products by sales, calculate each region's share of revenue and compare performance across periods.

MODULE 06 Visual Reports and Interactive Exploration
  • Using the report canvas and page settings
  • Choosing visuals to answer business questions
  • Building cards, charts, tables and matrices
  • Using conditional formatting where it aids interpretation
  • Adding slicers and date filters
  • Understanding visual, page and report filters
  • Using drill-down and visual interactions
  • Creating maps when location data is suitable
  • Using treemaps where they help compare categories
  • Adding titles, definitions and context to visuals
  • Checking how a report behaves on a phone-sized layout

Practical work: Build an interactive report that allows a manager to examine sales by product, location and reporting period.

MODULE 07 Reporting Quality, Insights and AI Features
  • Checking measures against the source data
  • Finding missing records and unexpected totals
  • Using accessible labels and readable colour contrast
  • Avoiding misleading comparisons and chart scales
  • Identifying the findings most relevant to management
  • Exploring applicable AI-assisted features in Power BI
  • Checking AI-generated explanations against the data
  • Explaining limitations before recommending action

Practical work: Review a report containing an incorrect total and an unclear visual. Correct both, then present findings supported by the verified report.

MODULE 08 Publishing and Maintaining Reports
  • Preparing a report for publication
  • Understanding workspaces and the Power BI service
  • Publishing from Power BI Desktop
  • Understanding report access and sharing permissions
  • Refreshing a published semantic model
  • Recognising when an on-premises data gateway is needed
  • Checking the published report after a refresh
  • Understanding how licensing affects sharing options

Practical work: Prepare a report for a team, test the refresh process and explain how authorised colleagues would access it.

PROJECT 01 Coca-Cola Dashboard

Build a Coca-Cola-themed business intelligence dashboard using a supplied training dataset. The project follows the reporting process from raw records to management findings.

  • Import and prepare the supplied sales data
  • Connect product, location and date information
  • Create DAX measures for sales and performance
  • Build interactive product and regional visuals
  • Check key measures against source records
  • Present findings and recommended next steps

Project output: A Power BI dashboard and a short presentation explaining the results. The training dataset is used for learning and is not represented as Coca-Cola's internal data.

Career Reach

Entry-level business intelligence, reporting and analytical support roles in sales, operations, finance, customer services and other data-driven teams.

This course builds practical Power BI reporting capability. Roles that require advanced data engineering, database administration or specialist domain experience may require additional training and experience.

FINANCE & ACCOUNTING / COURSE 01

Excel for Accountants

Use Microsoft Excel to organise accounting records, prepare schedules, investigate balances and support financial reporting. Practise the work through journals, ledgers, reconciliations and statements.

Suitable For

Accounting students, accounts assistants, junior accountants, bookkeepers, auditors and finance staff who want practical Excel capability.

Starting Level

Beginner. The course starts with Excel fundamentals and progresses to accounting schedules and entry-level reporting work.

Course Curriculum

MODULE 01 Excel Foundations for Accounting Work
  • Workbooks, worksheets, cells and ranges
  • Entering dates, descriptions, amounts and references
  • Formatting currencies, dates and accounting values
  • Building a clear transaction list
  • Creating and using Excel Tables
  • Sorting on one or multiple fields
  • Filtering with AutoFilter and custom criteria
  • Using advanced filters where appropriate
  • Returning a list to its original order
  • Using data validation to reduce entry errors

Practical work: Turn an untidy transaction list into a usable accounting register and identify overdue customer balances.

MODULE 02 Formulas and Functions Accountants Use
  • Arithmetic formulas and order of operations
  • Relative, absolute and mixed cell references
  • SUM, AVERAGE, MIN, MAX, COUNT and COUNTA
  • IF, AND, OR and IFERROR
  • SUMIF, SUMIFS, COUNTIF and COUNTIFS
  • ROUND, ROUNDUP and ROUNDDOWN
  • VLOOKUP, XLOOKUP, INDEX and MATCH
  • HLOOKUP where data is arranged horizontally
  • TRIM for cleaning imported descriptions
  • EOMONTH, EDATE and WORKDAY
  • Using AGGREGATE and formulas across worksheets

Practical work: Match transaction records to a chart of accounts, calculate totals by account and period, and flag missing account codes.

MODULE 03 Chart of Accounts, Journals and Ledgers
  • Setting up a chart of accounts in Excel
  • Understanding assets, liabilities, equity, income and expenses
  • Recording debit and credit entries
  • Creating a general journal
  • Entering and correcting journal records
  • Maintaining sales and purchases journals
  • Posting transactions to ledger accounts
  • Checking that total debits equal total credits
  • Preparing a trial balance from ledger balances

Practical work: Record a month of sales, purchases, receipts and payments; post them to the ledger and prepare a trial balance.

MODULE 04 Customer Records, Sales and Purchasing Documents
  • Setting up customer and product lists
  • Preparing quotations and purchase orders
  • Creating sales invoices
  • Matching invoices to customer records
  • Tracking invoice dates, due dates and payments
  • Identifying unpaid and partially paid invoices
  • Checking sales and purchase records against the ledger

Practical work: Create a quotation, sales invoice and customer account record, then update the balance when a payment is received.

PROJECT 01 Debt Schedule and Receivables Ageing Report
  • Organise customer invoices and payment records
  • Calculate outstanding balances and days overdue
  • Group receivables into ageing bands
  • Identify customers requiring follow-up
  • Compare the schedule with the receivables control balance

Project output: A debt schedule and receivables ageing report that a finance team can use for credit control.

MODULE 05 PivotTables, Ageing Reports and Management Analysis
  • Building PivotTables from accounting records
  • Using multiple row fields and subtotals
  • Grouping amounts and reporting periods
  • Understanding PivotTable data caches and refresh
  • Using Excel Tables or named ranges as data sources
  • Creating static and dynamic named ranges
  • Building and refreshing an ageing report
  • Using GETPIVOTDATA when referencing report figures
  • Checking PivotTable totals against the ledger

Practical work: Produce a monthly expense analysis and a customer ageing report that update when new records are added.

MODULE 06 Reconciliation and Worksheet Auditing
  • Comparing two sets of accounting records
  • Finding missing, duplicated and unmatched entries
  • Investigating differences in account balances
  • Tracing formula precedents and dependants
  • Locating and correcting formula errors
  • Reviewing references before copying formulas
  • Protecting formulas and controlled input cells
  • Checking that corrected schedules agree with control totals

Practical work: Reconcile an account statement to the ledger, investigate differences and correct errors in a working paper.

MODULE 07 Financial Statements and Monthly Reporting
  • Preparing a trial balance for reporting
  • Mapping accounts to statement headings
  • Building an income statement
  • Building a statement of financial position
  • Understanding how profit affects equity
  • Preparing a basic cash flow summary
  • Comparing actual results with a budget
  • Using charts to show changes over time
  • Explaining material variances in plain language

Practical work: Use a trial balance to prepare monthly statements and explain the largest movements in income and expenses.

PROJECT 02 General Entries, Ledger and Financial Statements
  • Record transactions in the general journal
  • Post entries to ledger accounts
  • Prepare and review the trial balance
  • Build an income statement
  • Build a statement of financial position
  • Explain any adjustments made to the records

Project output: A connected accounting workbook containing journal entries, a ledger, trial balance and financial statements.

MODULE 08 Loan Schedules, Depreciation and Financial Functions
  • Building a loan repayment schedule
  • Understanding payment signs and cash flows
  • PMT, PPMT, PV, FV, NPER and RATE
  • Using IRR, XIRR, NPV, XNPV and MIRR appropriately
  • Setting cost, useful life and residual value assumptions
  • Calculating straight-line depreciation with SLN
  • Understanding SYD, DB, DDB and VDB methods
  • Recognising specialised depreciation functions
  • Posting depreciation to accounting schedules

Practical work: Build a loan repayment schedule and an asset depreciation schedule, then show how the results affect monthly reporting.

PROJECT 03 Loan Schedule and Cash Flow Statement
  • Calculate periodic loan payments
  • Separate principal and interest
  • Track the outstanding loan balance
  • Check the schedule against the original loan terms
  • Present relevant cash movements in a cash flow statement

Project output: A loan repayment schedule and supporting cash flow statement.

MODULE 09 Budgets, Scenarios and Accounting Tools
  • Comparing budgets with actual results
  • Charting budget variances over time
  • Testing multiple inputs with Scenario Manager
  • Using Goal Seek for a defined financial target
  • Introducing Solver for more complex constraints
  • Protecting scenario assumptions and formulas
  • Using custom lists and keyboard shortcuts
  • Introducing the macro recorder for repetitive tasks
  • Understanding imports from accounting systems
  • Reviewing file structures before importing data

Practical work: Compare actual expenses with a budget and test how changes in sales or costs would affect the result.

FINAL PROJECT Month-End Accounting Workbook

Work through a month of realistic transactions for a business and prepare the records an entry-level finance team would need to review.

  • Organise sales, purchases, receipts and payments
  • Record journal entries and update the ledger
  • Prepare a customer debt schedule
  • Investigate and correct unmatched entries
  • Prepare a trial balance
  • Produce an income statement and statement of financial position
  • Present key movements and unresolved questions

Portfolio output: A completed accounting workbook and a short month-end review explaining the results.

Career Reach

Practical Excel work in accounts assistant, junior accounting, bookkeeping, audit support, credit control and finance operations teams across industries.

This course develops spreadsheet and applied accounting capability. Professional accounting qualifications, local reporting requirements and role-specific experience may also be required.

FINANCE & ACCOUNTING / COURSE 02

Excel for Financial Analysis

Build financial models that connect historical results to forecasts, cash flow, funding decisions and valuation. Learn to test assumptions, explain outcomes and present analysis that another finance professional can review.

Suitable For

Finance and accounting graduates, junior financial analysts, FP&A trainees, auditors and professionals who work with financial statements or budgets.

Starting Level

Basic Excel and financial statement knowledge are recommended. The course progresses from modelling foundations to applied forecasting and valuation.

Course Curriculum

MODULE 01 Financial Modelling Foundations
  • Structuring inputs, calculations and outputs
  • Making a model flexible and easy to review
  • Working with historical and forecast periods
  • Using consistent units, dates and signs
  • Separating assumptions from calculated results
  • Finding #REF! errors and unintended circular references
  • Adding balance and reasonableness checks
  • Testing how the model responds when assumptions change

Practical work: Repair a financial workbook with broken references and inconsistent assumptions, then build a clear input and output structure.

PROJECT 01 Dynamic Personal Finance Budget Tracker
  • Set up income, expense and savings categories
  • Compare monthly actuals with a planned budget
  • Calculate variances and changing balances
  • Show how a changed assumption affects future cash flow

Project output: A dynamic budget tracker with a clear monthly summary and forecast.

MODULE 02 Excel Functions for Financial Models
  • SUM, SUMIF, SUMIFS and SUMPRODUCT
  • COUNT, COUNTA, COUNTBLANK and COUNTIF
  • IF and error handling in model logic
  • ROUND, ROUNDUP and ROUNDDOWN
  • CEILING, FLOOR, INT, TRUNC and MOD
  • VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH
  • Validating inputs and splitting imported fields
  • Calculating returns and discounting dated cash flows
  • NPV, XNPV, IRR and XIRR

Practical work: Retrieve historical results from a source table, calculate financial measures and compare two investments with differently timed cash flows.

MODULE 03 Financial Statements and Historical Analysis
  • Reviewing and preparing source data
  • Building an income statement output sheet
  • Building a statement of financial position
  • Linking reported figures to source records
  • Calculating margins and historical growth
  • Analysing working capital and liquidity
  • Investigating unusual movements in results
  • Checking whether assets equal liabilities plus equity

Practical work: Build linked statements from supplied historical figures and explain the largest changes in profitability and working capital.

PROJECT 02 Ledger / Balance Sheet
  • Organise account balances from a supplied ledger
  • Map accounts to statement headings
  • Prepare a statement of financial position
  • Investigate and correct any imbalance

Project output: A linked balance sheet with supporting account schedules.

MODULE 04 Forecasting and Three-Statement Modelling
  • Adding forecast periods to the income statement
  • Calculating historical ratios and growth drivers
  • Forecasting revenue, costs and operating expenses
  • Forecasting receivables using days sales outstanding
  • Forecasting payables using days payable outstanding
  • Forecasting inventory using days inventory outstanding
  • Building debt and depreciation schedules
  • Connecting forecasts to the balance sheet
  • Building a forecast cash flow statement
  • Checking that the forecast statements remain connected

Practical work: Forecast a company's next reporting periods and investigate why the balance sheet fails to balance under one assumption.

PROJECT 03 Startup Financial Model
  • Set revenue, hiring, cost and funding assumptions
  • Forecast the income statement and cash movements
  • Calculate monthly cash runway
  • Show the effect of slower sales or higher costs

Project output: A startup forecast model showing performance and funding needs.

MODULE 05 Budgets, Scenarios and Sensitivity Analysis
  • Comparing actual results with a budget
  • Creating base, upside and downside scenarios
  • Using Scenario Manager
  • Using Goal Seek to solve for a financial target
  • Building one-variable and two-variable data tables
  • Testing the effect of revenue and cost changes
  • Presenting outputs without hiding model risks

Practical work: Test how lower sales, higher costs or slower collections affect profit and cash. Produce an Automated Budget Tracker and a Sensitivity and Scenario Analysis workbook.

MODULE 06 Debt, Credit and Capital Structure
  • Building repayment and interest schedules
  • Understanding debt priority and maturity
  • Modelling a revolving credit facility
  • Comparing short-term and long-term borrowing
  • Calculating leverage and interest coverage
  • Analysing liquidity and working capital
  • Reviewing operating results from a credit perspective
  • Comparing book equity, preferred shares and debt
  • Testing whether projected cash can support repayments

x Practical work: Build a debt schedule and assess whether a business can meet its obligations under a lower-revenue scenario.

PROJECT 04 Capital Budgeting Analysis
  • Set out investment costs and expected cash flows
  • Calculate NPV, IRR and payback period
  • Test a change in project costs or expected returns
  • Explain what the model can and cannot establish

Project output: An investment appraisal workbook and a recommendation supported by its assumptions.

MODULE 07 Company Valuation
  • Understanding enterprise value and equity value
  • Estimating free cash flow to the firm
  • Estimating free cash flow to equity
  • Building a discounted cash flow model
  • Choosing and testing a discount rate
  • Estimating terminal value
  • Comparing valuation multiples
  • Testing how assumptions change the valuation
  • Checking conclusions against business realities

Practical work: Build a discounted cash flow valuation and compare it with results from comparable companies.

PROJECT 05 Comparable Companies Valuation
  • Select and compare relevant peer companies
  • Calculate suitable valuation multiples
  • Apply the multiples to a target company
  • Explain limitations in peer selection and data

Project output: A comparable companies valuation with a clear range and supporting assumptions.

MODULE 08 External Data, Review and Decision Tools
  • Importing and exporting financial data
  • Working with files and database extracts
  • Cleaning and validating imported values
  • Finding matches with INDEX and MATCH
  • Using PivotTables to inspect financial results
  • Using the Analysis ToolPak where appropriate
  • Introducing Solver for constrained decisions
  • Understanding recorded macros and their limitations
  • Tracing errors and testing a model before delivery

Practical work: Import a new reporting period, refresh the analysis, identify an incorrect source value and explain its effect on the forecast.

MODULE 09 Investments and Portfolio Analysis
  • Calculating investment gains and losses
  • Comparing absolute and percentage returns
  • Measuring returns over different holding periods
  • Understanding basic risk measures
  • Comparing securities without ignoring risk
  • Tracking portfolio values and cash movements

Practical work: Build the existing Xellux Stock Portfolio Tracker and prepare a Client Financial Analysis showing returns, exposures and questions for review.

MODULE 10 Reporting and Portfolio Presentation
  • Summarising a model for a decision-maker
  • Showing historical results beside forecasts
  • Building a readable sales and performance dashboard
  • Explaining key assumptions and sensitivities
  • Presenting findings supported by model outputs
  • Identifying limitations and unresolved questions

Practical work: Produce the existing Xellux Dynamic Sales Dashboard and organise selected work into a Data Analysis Projects Portfolio.

FINAL PROJECT Financial Performance and Forecast Review

A business provides historical financial statements, operating information and proposed growth plans. Assess its performance and build a forecast for management review.

  • Organise and check the supplied financial data
  • Analyse historical revenue, margins and cash flow
  • Build connected financial forecasts
  • Test alternative operating assumptions
  • Assess debt and liquidity implications
  • Present the model's findings and limitations

Portfolio output: A financial model and a short presentation explaining the forecast and the decisions it informs.

Career Reach

Financial analysis and modelling work in FP&A, corporate finance, investment research, credit, consulting, audit support and finance teams.

The course develops modelling and analytical capability. Entry requirements vary by role; valuation, investment and senior finance positions may require relevant qualifications and professional experience.

SOFTWARE ENGINEERING / COURSE 01

Python Programming & Practical Automation

Learn Python by building programs that solve everyday work problems. Progress from the language foundations to files, APIs, databases and tested automation that another person can run and understand.

Suitable For

Beginners, graduates, career changers and professionals who want to write software or automate repetitive tasks with Python.

Starting Level

Beginner. No programming experience is required. Learners progress to practical junior-level Python development tasks.

Course Curriculum

MODULE 01 Python Setup and Programming Foundations
  • Installing Python and setting up VS Code
  • Running a Python file from the terminal
  • Understanding Python syntax and indentation
  • Variables, names and basic operators
  • Strings, numbers and Boolean values
  • Input, output and type conversion
  • Reading error messages and fixing syntax errors

Practical work: Build a small invoice calculator that receives quantities and prices, calculates totals and handles invalid input.

MODULE 02 Decisions, Loops and Data Collections
  • Using if, elif and else
  • Comparing values and combining conditions
  • Repeating tasks with for and while loops
  • Lists and list operations
  • Tuples and sets
  • Dictionaries and nested records
  • Looping through business records
  • Choosing a data structure that fits the task

Practical work: Process a list of customer orders, calculate each total and identify records that require review.

MODULE 03 Functions and Maintainable Python
  • Defining and calling functions
  • Parameters, arguments and return values
  • Breaking a task into reusable functions
  • Variable scope
  • Using modules and importing code
  • Writing useful docstrings
  • Introducing type hints
  • Handling expected errors with try and except

Practical work: Refactor the order-processing program into functions that calculate totals, validate records and produce a summary.

PROJECT 01 Customer Orders and Inventory Tracker
  • Add products and starting stock
  • Record customer orders
  • Prevent orders that exceed available stock
  • Calculate sales and remaining quantities
  • Show low-stock products

Project output: A working terminal-based Python program that manages orders and inventory.

MODULE 04 Files, CSV, JSON and Regular Expressions
  • Reading and writing text files
  • Using file paths safely
  • Reading and writing CSV files
  • Working with JSON records
  • Processing files with context managers
  • Searching and cleaning text with regular expressions
  • Handling missing files and malformed records
  • Producing an output file another person can use

Practical work: Read a folder of transaction files, identify incomplete records and export a clean CSV report.

MODULE 05 Practical Automation and Command-Line Tools
  • Identifying tasks suitable for automation
  • Working with folders and files using pathlib
  • Combining, renaming and organising files
  • Accepting command-line arguments with argparse
  • Using logging to record what a script does
  • Preventing accidental overwrites
  • Running a script repeatedly with new inputs
  • Writing instructions for another user

Practical work: Automate a recurring weekly report from several input files and produce a log showing which files were processed or rejected.

PROJECT 02 Automated Sales Report Generator
  • Read monthly sales CSV files
  • Reject incomplete or invalid records
  • Calculate totals by product and month
  • Export a report and an error file
  • Run the program with a new month's files

Project output: A reusable Python reporting script with sample input, output and run instructions.

MODULE 06 Classes and Object-Oriented Programming
  • Creating classes and objects
  • Attributes and methods
  • Initialising objects
  • Encapsulation and controlled state changes
  • Inheritance and when it is useful
  • Using special methods where appropriate
  • Recognising when a function is simpler than a class

Practical work: Represent customers, products and orders with classes, then use them to calculate an order total and update stock.

MODULE 07 APIs, Databases and Connected Programs
  • Understanding requests and responses
  • Reading JSON returned by an API
  • Handling connection and response errors
  • Storing records in a relational database
  • Creating, reading, updating and deleting records
  • Using parameterised queries for user-supplied values
  • Keeping connection details out of shared code
  • Checking that saved and retrieved records agree

Practical work: Retrieve information from an API and store selected records in a database for later reporting.

MODULE 08 Intermediate Python and Code Quality
  • List comprehensions
  • map, filter and lambda expressions
  • Generators for processing records
  • Recursion and where an iterative solution is clearer
  • Queues and an introduction to concurrent tasks
  • Reading about sockets and network communication
  • Separating program logic from input and output
  • Writing tests for calculations and error cases
  • Using type hints, docstrings and consistent naming
  • Introducing common design patterns without overcomplicating code

Practical work: Improve an existing automation script so it handles faulty inputs, produces clear errors and passes tests for its key calculations.

PROJECT 03 Business Operations Automation

A small business receives orders in files and needs a reliable way to process them, track inventory and prepare a daily summary.

  • Read and validate incoming order files
  • Store customer, product and order records
  • Update stock when valid orders are processed
  • Report rejected records without losing them
  • Generate a daily sales and stock summary
  • Test normal cases and expected failures
  • Provide clear instructions for running the program

Portfolio output: A working Python application, sample data, tests and a short demonstration of its workflow.

Career Reach

Entry-level Python development, software support, business process automation, technical operations and data processing work across industries.

This course builds programming and automation foundations. Specialist back-end engineering, data science and machine learning roles require additional skills and experience.

SOFTWARE ENGINEERING / COURSE 02

Back-End Engineering with Django & Node.js

Build the server-side systems behind websites and applications. Learn how to design APIs, store data, manage users and deliver working services using Python with Django and JavaScript with Node.js.

Suitable For

Aspiring back-end developers, junior programmers, graduates and developers who want practical experience building web services.

Starting Level

Basic Python and JavaScript knowledge is recommended. Learners use both languages to build and compare working back-end applications.

Course Curriculum

MODULE 01 Web and Back-End Foundations
  • How browsers, servers and databases work together
  • HTTP requests, responses, status codes and methods
  • URLs, routes, query parameters and request bodies
  • How HTML, CSS and JavaScript use back-end services
  • JSON as a format for exchanging data
  • Setting up Python, Django, Node.js and a code editor
  • Using separate development environments and configuration

Practical work: Send requests to a sample API, inspect its responses and explain what the browser needs from the server.

MODULE 02 First Django Application
  • Creating a Django project and application
  • Understanding settings and project structure
  • Starting the development server
  • Creating a first view and URL route
  • Returning a response from a view
  • Linking pages with URLs
  • Passing values from a URL to a view
  • Using templates to display data

Practical work: Complete Xellux's Basic Hello Web App and Displaying Hyperlinks assignments. Create pages that respond to different URLs and display supplied values.

MODULE 03 Django Models, Data and Administration
  • Designing models and selecting field types
  • Creating and applying migrations
  • Creating related records with foreign keys
  • Using the Django shell to inspect data
  • Creating, retrieving, filtering and sorting records
  • Updating and deleting records
  • Using and customising the Django admin
  • Managing staff access and permissions

Practical work: Create product and customer models, add records through the admin, then retrieve and filter them in views.

MODULE 04 Django Templates, Forms and User Workflows
  • Template inheritance and shared page layouts
  • Template tags, filters, loops and conditions
  • Passing database records into templates
  • Working with static files and uploaded images
  • Creating and validating forms
  • Building a contact form
  • Configuring and sending application email
  • Understanding sessions and cookies
  • Integrating a responsive front-end layout

Practical work: Complete the existing Xellux Creating a Website, Contact Us Form and Functional Email assignments.

PROJECT 01 Django Website and Administration Panel
  • Create a multi-page Django website
  • Store content in database models
  • Display records using templates
  • Accept and validate user input
  • Configure an administration panel
  • Set permissions for staff users

Project output: A functional Django website with database-backed content, forms and a managed admin interface.

MODULE 05 REST APIs with Django
  • What makes an API useful to another application
  • Creating API routes with Django REST Framework
  • Serialising and validating data
  • Creating, reading, updating and deleting records
  • Using appropriate HTTP status codes
  • Filtering, ordering and pagination
  • Protecting endpoints with authentication and permissions
  • Testing requests and error responses

Practical work: Build and test a product API that supports CRUD operations and rejects invalid records.

MODULE 06 Node.js and Express Foundations
  • Running JavaScript outside the browser
  • Using npm and managing packages
  • Creating an Express server
  • Defining routes for GET, POST, PATCH and DELETE
  • Reading parameters and JSON request bodies
  • Using middleware
  • Validating input and returning clear errors
  • Organising routes, controllers and services
  • Using async and await for asynchronous work

Practical work: Rebuild the product API using Node.js and Express, then compare its behaviour with the Django version.

MODULE 07 Databases in Django and Node.js
  • Using SQLite during local development
  • Connecting an application to a relational database
  • Understanding database tables and relationships
  • Using Django models and migrations
  • Using parameterised queries or a maintained data layer in Node.js
  • Creating and retrieving related records
  • Handling failed database operations
  • Keeping connection credentials out of source code
  • Recognising database-specific configuration differences

Practical work: Store customers, orders and products in a relational database and retrieve an order with its associated records.

MODULE 08 Authentication and Application Security
  • Registering and signing in users
  • Understanding password hashing
  • Sessions, cookies and token-based authentication
  • Restricting actions by user role
  • Validating inputs on the server
  • Preventing common injection risks
  • Understanding CORS and cross-site request forgery
  • Managing environment variables and secrets
  • Protecting personal data and limiting exposure

Practical work: Restrict order management to authorised staff while allowing customers to view only their own records.

MODULE 09 Testing, Deployment and Maintenance
  • Testing API routes and database operations
  • Checking validation and permission failures
  • Using Git to track application changes
  • Configuring development and production settings
  • Preparing an application for deployment
  • Handling static files and database migrations
  • Adding basic application logging
  • Checking the deployed application after changes
  • Writing setup and API usage instructions

Practical work: Test a back-end application locally, deploy a working version and verify its main routes and permissions.

FINAL PROJECT Business Orders Platform

Build a back-end system for a business that manages products, customers and orders. Implement the core workflow with Django, then build a matching API workflow in Node.js.

  • Design the database and its relationships
  • Create and validate product and order records
  • Build API endpoints for the main workflow
  • Give staff and customers appropriate access
  • Handle invalid requests and missing records
  • Test the core business operations
  • Deploy and demonstrate a working application

Portfolio output: A Django application, a Node.js API implementation, documented endpoints and a demonstration of the working business workflow.

Career Reach

Internship and junior back-end development, API development and web application support roles in software teams across industries.

The course develops practical foundations in Django and Node.js. Production systems require ongoing work in testing, security, deployment and team development practices.

AI & MACHINE LEARNING / COURSE 01

Machine Learning

Learn to turn a real question into a testable machine learning problem. Prepare data, train models, evaluate their results and explain when a prediction is useful or unreliable.

Suitable For

Learners with basic Python knowledge who want to develop practical skills in prediction, classification and data-driven modelling.

Starting Level

Introductory machine learning. Learners should be comfortable with Python functions, data structures and reading tabular data.

Course Curriculum

MODULE 01 Machine Learning Foundations
  • What machine learning can and cannot do
  • Supervised and unsupervised learning
  • Classification, regression and clustering
  • Identifying features and target labels
  • Understanding a predictive modelling workflow
  • Choosing a measurable business or research question
  • Recognising data leakage before training

Practical work: Examine three real-world questions and decide whether each calls for classification, regression, clustering or a simpler non-ML solution.

MODULE 02 Exploring and Preparing Data
  • Loading CSV and Excel data with Python
  • Inspecting rows, columns and data types
  • Summarising numerical and categorical variables
  • Finding missing, duplicated and unusual records
  • Visualising distributions and relationships
  • Encoding categorical variables
  • Scaling numerical variables when needed
  • Splitting training and test data correctly
  • Using pipelines to apply preparation consistently

Practical work: Prepare a customer dataset containing missing fields, inconsistent categories and numerical values on different scales.

MODULE 03 Regression and Numerical Prediction
  • Training a first Scikit-Learn model
  • Linear regression and its basic assumptions
  • Predicting a continuous outcome
  • Creating a simple baseline for comparison
  • Measuring error with MAE and RMSE
  • Interpreting residuals and poor predictions
  • Understanding when a forecast requires time-aware validation

Practical work: Predict sales revenue from supplied business data, compare the model with a simple baseline and explain where its errors are largest.

PROJECT 01 Predict Sales Revenue
  • Define the value to predict
  • Prepare numerical and categorical inputs
  • Train and compare a baseline and regression model
  • Measure prediction error on held-out data
  • Explain when the forecast should not be used

Project output: A working prediction notebook and a short report interpreting its accuracy and limitations.

MODULE 04 Classification and Decision Thresholds
  • Training a classification model
  • Logistic regression versus linear regression
  • k-nearest neighbours and support vector machines
  • Decision trees and tree-based models
  • Using confusion matrices
  • Precision, recall and F1 score
  • Choosing a decision threshold
  • Understanding class imbalance
  • Relating false positives and false negatives to the use case

Practical work: Compare classification models for an employee turnover dataset. Explain which errors matter most for the stated business question.

PROJECT 02 Predict Employee Turnover
  • Inspect the available employee data
  • Identify unsuitable or potentially leaky features
  • Train and compare classification models
  • Evaluate results beyond overall accuracy
  • Discuss privacy and limits on using employee predictions

Project output: A classification model and an evaluation explaining its usefulness, risks and limitations.

MODULE 05 Model Selection and Reliable Evaluation
  • Overfitting and underfitting
  • Bias and variance
  • Training, validation and test sets
  • Cross-validation
  • Learning and validation curves
  • Comparing models against a baseline
  • Tuning parameters without using the test set repeatedly
  • Keeping preprocessing inside a pipeline
  • Checking whether the model generalises to new data

Practical work: Improve a model that performs well during training but poorly on unseen records. Show what changed and whether the improvement holds.

MODULE 06 Clustering and Unsupervised Learning
  • When clustering is useful
  • Preparing features for K-Means
  • Choosing and interpreting the number of clusters
  • Checking whether groups have practical meaning
  • Understanding how K-Means can compress image colours
  • Explaining why a cluster is not a verified category

Practical work: Segment customer records and compare the groups using measures that matter to the business.

PROJECT 03 Image Compression with K-Means Clustering
  • Load an image and represent its pixels as data
  • Group colours using K-Means
  • Rebuild the image using fewer colours
  • Compare output quality and file size

Project output: A working image-compression demonstration and an explanation of the quality trade-off.

MODULE 07 Text Classification and Neural Network Foundations
  • Preparing labelled text for classification
  • Turning text into model features
  • Training a baseline sentiment classifier
  • Checking errors caused by ambiguous language
  • Understanding neural network inputs and outputs
  • Introducing loss functions and gradient descent
  • Recognising the role of backpropagation
  • Introducing convolutional networks for image tasks
  • Understanding where a handwritten-digit classifier fits

Practical work: Train a small text classifier and review examples it gets wrong. Explore a guided handwritten digit recognition demonstration.

PROJECT 04 Sentiment Analysis
  • Prepare a labelled text dataset
  • Train a baseline sentiment classifier
  • Evaluate performance on unseen text
  • Inspect misclassified examples
  • Explain the effect of context and ambiguous wording

Project output: A sentiment classification workflow with a clear evaluation and error review.

MODULE 08 Saving, Presenting and Monitoring a Model
  • Saving and loading a trained model
  • Saving preprocessing with the model pipeline
  • Running predictions on new records
  • Validating new inputs before prediction
  • Presenting a model through a simple application or API
  • Recording the model version and evaluation results
  • Recognising changes in incoming data over time
  • Knowing when a model needs review or retraining

Practical work: Save a model, load it in a separate program and test it with new inputs, including invalid values.

FINAL PROJECT Predicting Possible Loan Default

Use a supplied training dataset to investigate whether a model can identify patterns associated with loan default. Treat the output as a modelling exercise, not an automatic lending decision.

  • Define the prediction target and available features
  • Check missing values, data quality and possible leakage
  • Build a baseline and compare suitable models
  • Evaluate precision, recall and other relevant measures
  • Investigate false positives and false negatives
  • Explain limitations and potential fairness concerns
  • Demonstrate predictions on new sample records

Portfolio output: A working modelling pipeline and a presentation explaining its evaluation, limitations and appropriate use.

Career Reach

Junior-level support work in applied machine learning, predictive analytics, data science teams and software products that use trained models.

This course builds practical modelling foundations. Specialist machine learning engineering and production-scale AI systems require additional software engineering, mathematics and experience.

AI & MACHINE LEARNING / COURSE 02

AI Engineering

Build applications that use AI to work with information, answer questions and support real workflows. Learn to connect models to software, ground answers in trusted content and test whether the system performs reliably.

Suitable For

Python developers, aspiring AI application developers and technical professionals who want to build useful AI-enabled software.

Starting Level

Basic Python programming and API knowledge are recommended. This course focuses on engineering applications with existing models.

Course Curriculum

MODULE 01 How AI Applications Work
  • Identifying a task worth solving with AI
  • Understanding inputs, model responses and application logic
  • Comparing a model with the complete system around it
  • Choosing when a rule or database query is more suitable
  • Understanding model limits and uncertain outputs
  • Designing a clear user workflow before coding

Practical work: Map the steps of a document-question application, including where it obtains information and how a user checks its answer.

MODULE 02 Model APIs and Application Integration
  • Making model requests from a Python application
  • Passing user input safely to an application back end
  • Managing API credentials with environment variables
  • Handling errors, timeouts and unavailable services
  • Managing conversation context
  • Requesting structured outputs where useful
  • Validating output before saving or displaying it
  • Tracking usage, response time and cost

Practical work: Build a small application that accepts a question, returns an AI response and handles invalid input or a failed model request.

MODULE 03 Instructions and Reliable Outputs
  • Writing clear task instructions
  • Defining what information the model may use
  • Separating user input from application instructions
  • Requesting a consistent response structure
  • Testing unclear, incomplete and conflicting inputs
  • Handling cases where the system lacks evidence
  • Comparing responses against expected outcomes

Practical work: Create an information-extraction workflow that turns varied customer requests into structured records and flags missing fields for review.

MODULE 04 Retrieval and Answers from Documents
  • Preparing documents for search and retrieval
  • Dividing long documents into useful sections
  • Understanding embeddings and semantic search
  • Retrieving passages relevant to a question
  • Providing retrieved context to a model
  • Showing the source passages behind an answer
  • Handling questions the documents cannot answer
  • Checking when retrieval returns the wrong passage

Practical work: Build a question-answering application over supplied training documents. Require it to show supporting passages or state when it cannot find an answer.

PROJECT 01 Document Intelligence Assistant
  • Load a collection of supplied documents
  • Search for relevant sections
  • Answer questions using retrieved evidence
  • Display supporting sources
  • Test questions with and without answers

Project output: A working document assistant that can explain where its answers came from.

MODULE 05 AI Tools and Business Workflows
  • Connecting an AI application to defined tools
  • Letting software perform calculations or database lookups
  • Validating tool arguments before execution
  • Restricting which actions the application may take
  • Separating read-only actions from changes to records
  • Requesting user review before consequential actions
  • Handling failed tools without inventing results
  • Recording what the application did

Practical work: Build a customer-support workflow that retrieves an order's status from a test database and explains the result to the user.

MODULE 06 Evaluation and Error Investigation
  • Creating representative test questions
  • Checking answer accuracy against supplied sources
  • Evaluating retrieval and final answers separately
  • Testing unsupported and ambiguous questions
  • Recording failure cases for improvement
  • Comparing a change with an earlier version
  • Reviewing response time and cost alongside quality

Practical work: Test the document assistant with a set of known questions. Find failures, improve one part of the workflow and check whether the results improve.

MODULE 07 Security, Privacy and Responsible Operation
  • Protecting API keys and application secrets
  • Controlling access to private documents
  • Limiting sensitive information in logs
  • Recognising prompt injection in retrieved content
  • Preventing untrusted text from changing tool permissions
  • Handling unsafe or unauthorised requests
  • Defining when a human must review the result
  • Testing access rules with different user accounts

Practical work: Test whether an unauthorised user can retrieve a protected document or persuade the application to ignore its instructions. Correct the application behaviour.

MODULE 08 Deployment and Monitoring
  • Separating front-end, back-end and model services
  • Preparing environment settings for deployment
  • Setting request limits and handling service failures
  • Monitoring errors, latency and usage
  • Reviewing new failure cases after release
  • Updating source documents without breaking retrieval
  • Retesting important workflows after a change
  • Documenting how to run and maintain the application

Practical work: Deploy a small AI application, test its main workflows and review logs from both successful and failed requests.

FINAL PROJECT AI-Powered Business Knowledge Platform

A business needs staff to find reliable answers across its operating guides and retrieve approved information from a test system.

  • Prepare the supplied knowledge documents
  • Build a searchable retrieval workflow
  • Show source passages with each supported answer
  • Connect one controlled database lookup tool
  • Restrict private content by user access
  • Test answer quality and unsupported questions
  • Deploy and demonstrate the working application

Portfolio output: A working AI application, documented test cases and a demonstration showing how it answers, retrieves and handles uncertainty.

Career Reach

Internship and junior work in AI application development, software engineering teams building AI features, workflow automation and technical product development.

This course builds the ability to integrate and evaluate existing AI models in applications. Training large models and specialist machine learning research require additional study and experience.

XELLUX TECHNOLOGIES

Flagship Career Programmes

Choose the professional direction you want to build towards.

Each programme connects foundational skills, applied training, substantial projects and portfolio development into a structured career pathway.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 01

Data Intelligence & Analytics Engineering

Learn to turn organisational data into reliable analysis, decision-ready reporting and reusable data systems.

Suitable For

Graduates, career changers, business professionals and learners who want to work in data analysis, business intelligence or analytics engineering.

Starting Level

Beginner. The programme progresses from spreadsheet and business-data foundations to SQL, Power BI, Python, statistics and analytics engineering.

Programme Pathway

  1. Data Analytics Foundations
  2. SQL and Business Data
  3. Business Intelligence
  4. Advanced Analytics with Python
  5. Statistics and Business Analysis
  6. Analytics Engineering
  7. Portfolio and Career Readiness

Programme Curriculum

STAGE 01 Data Analytics Foundations
  • Translate business questions into measurable analytical tasks
  • Understand records, fields, data types and reporting periods
  • Structure, clean and validate datasets in Microsoft Excel
  • Use formulas, logical functions, lookups and Excel Tables
  • Build PivotTables, PivotCharts and interactive slicer reports
  • Calculate revenue, growth, margin and variance correctly
  • Check calculations against source records
  • Explain findings and the limits of the available data

Applied project: Build an executive sales and profitability dashboard from transaction-level data.

Evidence of capability: A working Excel dashboard, defined measures, checked totals and a concise explanation of the business decisions the report supports.

STAGE 02 SQL and Business Data
  • Read relational schemas, keys and table relationships
  • Retrieve, filter and sort data with SQL
  • Join customer, product, sales and operational tables
  • Use aggregations, GROUP BY and HAVING
  • Write subqueries, common table expressions and window functions
  • Investigate missing matches and duplicated join results
  • Build reusable queries for recurring reporting questions
  • Document query logic and validate outputs

Applied project: Investigate customer and product performance using related database tables.

Evidence of capability: SQL queries, documented assumptions, verified measures and an explanation of the findings.

STAGE 03 Business Intelligence and Power BI
  • Connect spreadsheet and database sources
  • Clean and transform data with Power Query
  • Design fact tables, dimension tables and relationships
  • Create a date table and consistent business measures
  • Write DAX measures for KPIs, period comparisons and variance
  • Build accessible, interactive reports with clear visual hierarchy
  • Test filters, drill-through behaviour and reported totals
  • Understand publishing, scheduled refresh and access control

Applied project: Build a customer or product performance report using SQL and Power BI.

Evidence of capability: A documented data model, tested DAX measures and a dashboard that answers specific management questions.

STAGE 04 Advanced Analytics with Python
  • Use Python and notebooks for analytical work
  • Load and inspect files with pandas
  • Clean inconsistent values, missing records and duplicates
  • Join datasets and calculate grouped measures
  • Use NumPy for numerical analysis
  • Investigate trends, segments and unusual observations
  • Create charts that support a clear analytical question
  • Automate repeatable preparation and reporting steps
  • Check outputs and record assumptions before sharing results

Applied project: Create a Python-based data cleaning and automated reporting workflow.

Evidence of capability: Reusable code, documented input requirements, output checks and a report that can be updated when new data arrives.

STAGE 05 Statistics and Business Analysis
  • Frame stakeholder requests as answerable questions
  • Define measures, denominators and comparison groups
  • Use descriptive statistics and distributions appropriately
  • Understand probability, sampling and uncertainty
  • Interpret confidence intervals and hypothesis tests
  • Examine correlation and introductory regression
  • Separate association from evidence of causation
  • Compare alternative explanations for a business change
  • Present findings with practical limitations and recommendations

Applied investigation: Determine whether a decline in customer activity is widespread or concentrated in particular products, locations or periods.

Evidence of capability: A clearly stated question, defensible method, checked results and a recommendation that does not claim more than the evidence supports.

STAGE 06 Analytics Engineering
  • Separate raw, cleaned and reporting-ready data
  • Design reusable analytical tables and reporting models
  • Write clear SQL transformations
  • Define shared metrics so reports use consistent calculations
  • Test uniqueness, missing values and table relationships
  • Document fields, definitions and data limitations
  • Use Git and GitHub to track analytical work
  • Update reporting models as new data arrives
  • Investigate failed data-quality checks before publication

Applied project: Build a tested, reusable sales and customer reporting model that supports multiple dashboards.

Evidence of capability: SQL transformations, data-quality checks, metric definitions, version history and documentation for the next analyst.

STAGE 07 Professional Portfolio and Career Readiness
  • Select and improve at least three substantial projects
  • Document the question, source data, method and findings
  • Present Excel, SQL, Power BI and Python work clearly
  • Explain errors discovered and how they were corrected
  • Prepare project summaries for a professional portfolio
  • Practise business presentations and project defence
  • Prepare for junior analyst technical tasks and interviews
  • Position a CV and professional profile for suitable roles

Portfolio standard: Each selected project must demonstrate independent problem-solving, checked results, clear documentation and the ability to explain its business value.

CAPSTONE From Raw Business Data to an Executive Decision

A growing organisation holds sales, customer, product and operational data across spreadsheets and database tables. Its leadership needs to understand what is changing, what may be driving the change and where to act.

  • Agree on the business questions and success measures
  • Assess source quality and document limitations
  • Clean, combine and validate the data
  • Build reusable SQL transformations and analytical tables
  • Use Python to investigate patterns and automate repeatable steps
  • Apply appropriate statistical reasoning
  • Build and check an executive Power BI report
  • Write a recommendation memo supported by evidence
  • Present the work and defend the analytical choices

Final portfolio output: A documented analytical workflow, tested SQL assets, Python analysis, executive dashboard, recommendation memo and project presentation.

Career Opportunities

Internship and junior entry points: Data Analyst, Reporting Analyst, Operations Analyst, MIS Analyst and junior Business Intelligence Analyst.

Further career directions: Business Analyst, Financial Data Analyst, Marketing Analyst, Product Analyst and Analytics Engineer. Senior analytical roles require relevant professional experience.

Career Reach

Banking, fintech, telecommunications, retail, FMCG, consulting, healthcare, insurance, logistics, technology, energy, government and remote or international analytics teams.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 02

Full-Stack AI Engineering

Design and build complete software products, from accessible interfaces and reliable back-end systems to deployed applications with useful AI features.

Suitable For

Aspiring developers, graduates, career changers and learners who want to build web applications, software products and AI-enabled services.

Starting Level

Beginner. Learners begin with web and programming fundamentals, then progress through application engineering, deployment and applied AI.

Programme Pathway

  1. Web Engineering Foundations
  2. Modern Front-End Engineering
  3. Back-End and API Engineering
  4. Databases and Application Architecture
  5. Cloud and Production Engineering
  6. AI Application Engineering
  7. Full-Stack AI Product Capstone

Programme Curriculum

STAGE 01 Web Engineering Foundations
  • Understand how browsers, servers, URLs and HTTP work together
  • Write semantic HTML for readable page structure
  • Build responsive layouts with CSS, Grid and Flexbox
  • Apply accessibility foundations to navigation, forms and content
  • Use JavaScript fundamentals to add meaningful interaction
  • Work with the command line, Git and GitHub
  • Inspect and debug pages with browser developer tools
  • Organise code and document a small web project

Applied project: Build a responsive business website with accessible navigation and a working enquiry form.

Evidence of capability: A deployed website, source code, responsive layouts and a clear project README.

STAGE 02 Modern Front-End Engineering
  • Use modern JavaScript and TypeScript in applications
  • Handle asynchronous code, API requests and errors
  • Build reusable components with React
  • Manage forms, state, navigation and user feedback
  • Connect interfaces to documented APIs
  • Handle loading, empty, success and failure states
  • Test critical interactions and accessibility
  • Consider performance on slower devices and connections

Applied project: Create an interactive client portal that retrieves records, filters results and lets users complete a defined workflow.

Evidence of capability: A usable React application with tested interactions and clear handling of API errors.

STAGE 03 Back-End and API Engineering
  • Understand request handling and server-side application structure
  • Build APIs using Node.js and a suitable web framework
  • Build Python back-end services with Django
  • Understand where Django REST APIs fit in a product
  • Design routes, request validation and consistent responses
  • Implement authentication and role-based authorisation
  • Handle errors, configuration and application secrets safely
  • Write tests for routes, business rules and failure cases
  • Add useful logging without exposing private information

Applied project: Build and document an API for a booking or inventory system, including user roles, validation and automated tests.

Evidence of capability: A working API, test results, endpoint documentation and a short explanation of its security choices.

STAGE 04 Databases and Application Architecture
  • Model users, products, transactions and relationships
  • Use SQL and PostgreSQL for persistent application data
  • Define keys, constraints and data integrity rules
  • Work with database migrations and ORM concepts
  • Use transactions for operations that must succeed together
  • Separate interface, application logic and data access
  • Understand caching and common performance bottlenecks
  • Protect sensitive data and apply least-privilege access

Applied project: Build an authenticated full-stack platform with React, an API and PostgreSQL. Users must be able to create, view, update and manage records.

Evidence of capability: A working application, schema diagram, database migrations, tests and documented design decisions.

STAGE 05 Cloud and Production Engineering
  • Understand the difference between development and production
  • Deploy a front end, API and managed database
  • Use environment variables and secret management
  • Apply Linux and container foundations
  • Set up basic continuous integration and deployment
  • Monitor errors, health and application performance
  • Plan backups and recovery for important data
  • Review access, dependencies and common security risks
  • Estimate and control hosting costs

Applied project: Deploy an API-backed application with a database, automated checks, monitoring and a documented release process.

Evidence of capability: A live application, deployment documentation, passing checks and a demonstration of how a failure is detected and investigated.

STAGE 06 AI Application Engineering
  • Identify product problems where an AI feature is useful
  • Connect an application to an AI model through an API
  • Design instructions, structured outputs and error handling
  • Understand embeddings and vector search
  • Build retrieval-augmented generation from approved documents
  • Show users the sources supporting retrieved answers
  • Evaluate answer quality with representative test cases
  • Handle incorrect, uncertain and unsupported responses
  • Protect user data and defend against prompt injection
  • Set usage limits and monitor latency and cost
  • Introduce controlled tool use and agent workflows

Applied project: Build a knowledge assistant that answers questions from a defined document collection, cites the retrieved material and declines questions it cannot support.

Evidence of capability: A working application, retrieval design, evaluation cases, documented limitations and basic security and cost controls.

STAGE 07 Product Engineering and Career Readiness
  • Turn a user problem into product requirements
  • Prioritise a feasible first release and future improvements
  • Review interface usability and accessibility
  • Document architecture, endpoints and deployment steps
  • Maintain at least three substantial portfolio projects
  • Explain technical choices and trade-offs in a project defence
  • Practise junior software engineering tasks and interviews
  • Prepare a CV, GitHub profile and project demonstrations

Portfolio standard: Projects must demonstrate functioning software, readable code, tests, documentation and the ability to explain what was built and why.

CAPSTONE A Deployed Full-Stack AI Product

Design a useful software product for a defined group of users. Build its core workflow first, then add an AI feature that helps users complete a real task within that product.

  • Define users, needs and measurable product outcomes
  • Build a responsive, accessible front end
  • Implement a documented API and business rules
  • Store application data reliably in PostgreSQL
  • Add authentication and appropriate permissions
  • Integrate and evaluate a focused AI capability
  • Test normal use, failure cases and security boundaries
  • Deploy the application and monitor basic health
  • Document architecture, limitations and operating costs
  • Demonstrate the product and defend engineering choices

Final portfolio output: A live full-stack AI application, source repository, architecture diagram, tests, evaluation results, deployment guide and product demonstration.

Career Opportunities

Internship and junior entry points: Junior Front-End Developer, Junior Back-End Developer, Junior Full-Stack Developer, Web Application Developer and Software Engineering Intern.

Further career directions: Full-Stack Engineer, Cloud Application Developer, AI Application Developer, AI Integration Engineer and Technical Product Engineer. Specialised production roles require further experience.

Career Reach

Software product companies, fintech, e-commerce, EdTech, HealthTech, telecommunications, enterprise technology, start-ups, consultancies and international or remote software teams.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 03

Applied Data Science & Predictive Intelligence

Learn to investigate uncertainty, build predictive models and test whether those models are reliable enough to inform real decisions.

Suitable For

Learners interested in mathematics, statistics, research, forecasting, machine learning and evidence-based prediction.

Starting Level

Foundational Python and mathematics are taught before advanced modelling. Learners should be prepared to practise quantitative reasoning throughout the programme.

Programme Pathway

  1. Python for Data Science
  2. Statistics and Probability
  3. Predictive Modelling
  4. Machine Learning
  5. Advanced Predictive Applications
  6. Production Data Science
  7. Research Portfolio and Career Readiness

Programme Curriculum

STAGE 01 Python for Data Science
  • Write Python using variables, functions and clear program structure
  • Work with notebooks and version-controlled project files
  • Use NumPy arrays and pandas DataFrames
  • Import, join, clean and validate datasets
  • Explore distributions, missing values and unusual records
  • Visualise patterns with appropriate charts
  • Document data sources, transformations and assumptions
  • Produce analysis another person can inspect and repeat

Applied work: Investigate a customer dataset containing incomplete records, inconsistent categories and changing behaviour over time.

Evidence of capability: A documented notebook, cleaned dataset, validation checks and an exploratory report.

STAGE 02 Statistics and Probability
  • Understand populations, samples and sampling bias
  • Describe central tendency, spread and distributions
  • Use probability to reason about uncertain outcomes
  • Understand common probability distributions
  • Estimate uncertainty with confidence intervals
  • Frame and interpret hypothesis tests
  • Distinguish statistical significance from practical importance
  • Identify confounding factors and limits to causal claims
  • Introduce controlled experiments and test design

Applied investigation: Assess whether a change in customer response is credible or could reasonably be explained by sampling variation.

Evidence of capability: A written analysis stating the question, assumptions, method, uncertainty and decision implications.

STAGE 03 Predictive Modelling
  • Turn a decision problem into a measurable prediction target
  • Prepare features while preventing data leakage
  • Separate training, validation and test data correctly
  • Build baseline regression and classification models
  • Use cross-validation where appropriate
  • Choose metrics that reflect the cost of different errors
  • Interpret model behaviour and important predictors
  • Compare results against a simple baseline
  • Explain uncertainty and limits before recommending use

Named project: Customer churn prediction with an explicit business definition of churn and a comparison against a baseline model.

Evidence of capability: A tested modelling pipeline, evaluation report and explanation of where predictions may be unreliable.

STAGE 04 Machine Learning
  • Use scikit-learn pipelines for repeatable training
  • Apply linear and tree-based supervised models
  • Compare ensemble methods with simpler alternatives
  • Address missing values and categorical variables correctly
  • Investigate overfitting, underfitting and generalisation
  • Use clustering for exploratory segmentation
  • Introduce dimensionality reduction where useful
  • Check subgroup performance and potential unfairness
  • Record experiments and explain model selection

Named project: Develop a segmentation or recommendation prototype, explain its assumptions and demonstrate how its output would be used.

Evidence of capability: Comparative experiments, a selected model or method, evaluation results and a defensible explanation of the choice.

STAGE 05 Advanced Predictive Applications
  • Build time-aware validation for forecasting
  • Compare forecasts with seasonal and simple baselines
  • Evaluate errors across periods and business segments
  • Investigate anomalies using suitable detection methods
  • Separate suspicious records from verified incidents
  • Explore recommendation and natural-language foundations
  • Understand when specialised methods are justified
  • Account for drift, changing behaviour and uncertainty

Named projects: Build a demand or revenue forecast, then complete a separate fraud or anomaly investigation using labelled outcomes where available.

Evidence of capability: Time-aware evaluation, error analysis and a report explaining the cost and limits of the proposed decisions.

STAGE 06 Production Data Science
  • Package preprocessing and modelling into a repeatable workflow
  • Serve selected predictions through an API
  • Validate requests and handle invalid inputs
  • Track model versions and experiment results
  • Test predictions, data assumptions and API responses
  • Monitor input changes and model performance where outcomes exist
  • Set retraining and human-review criteria
  • Consider privacy, security and responsible use
  • Document the model’s intended purpose and limitations

Applied project: Turn a tested predictive model into a small, documented service with an API and monitoring plan.

Evidence of capability: Model code, test results, API demonstration, model documentation and an explanation of when the system should not be relied upon.

STAGE 07 Research Portfolio and Career Readiness
  • Present at least three substantial analytical projects
  • State each project’s decision context and target outcome
  • Show how data was obtained and prepared
  • Explain baseline selection, validation and evaluation
  • Report errors, limitations and alternative explanations
  • Prepare clear technical reports and project READMEs
  • Practise explaining models to non-technical audiences
  • Prepare for junior data science and analytical interviews

Portfolio standard: A reviewer should be able to inspect the method, reproduce the main results and understand the practical value and limits of each project.

CAPSTONE Predict, Evaluate and Demonstrate

Choose a decision with a measurable outcome, such as customer retention, demand planning or operational risk. Build a predictive approach and test whether it performs well enough to support that decision.

  • Define the real-world decision and prediction target
  • Assess the available data and ethical constraints
  • Create a simple, defensible baseline
  • Prepare features without leaking future information
  • Train and compare suitable statistical or ML models
  • Evaluate errors and results across relevant groups
  • Investigate uncertainty and failure cases
  • Demonstrate a usable prediction workflow
  • Present the findings and defend the modelling choices

Final portfolio output: A documented dataset and modelling workflow, evaluation report, working demonstration, technical write-up and presentation explaining whether the model should be used.

Career Opportunities

Internship and junior entry points: Data Science Intern, Junior Data Scientist, Research Data Analyst, Statistical Analyst and Junior Predictive Analyst.

Further career directions: Data Scientist, Forecasting Analyst, Risk Modelling Analyst, Machine Learning Analyst and Applied AI Specialist. Machine Learning Engineer roles usually require deeper production engineering experience.

Career Reach

Banking, fintech, insurance, telecommunications, retail, healthcare, energy, logistics, research, consulting and international or remote teams working on prediction and experimentation.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 04

Financial Analytics & Accounting Intelligence

Connect accounting records, financial models and analytical tools to explain performance, investigate risk and support better financial decisions.

Suitable For

Accounting and finance students, accountants, auditors, banking professionals, finance graduates and professionals who work with financial records or management reports.

Starting Level

Begins with professional Excel and accounting-data foundations. Financial statements and modelling are developed progressively through applied work.

Programme Pathway

  1. Professional Excel for Finance
  2. Accounting Analytics and Controls
  3. Financial Modelling and Forecasting
  4. Advanced Excel Intelligence
  5. Finance Business Intelligence
  6. Finance Data and Automation
  7. Professional Finance Portfolio

Programme Curriculum

STAGE 01 Professional Excel for Finance
  • Structure financial workbooks for clarity and review
  • Use tables, cell references and controlled inputs
  • Apply conditional, date, lookup and aggregation functions
  • Use PivotTables to examine financial records
  • Build checks that identify incomplete or inconsistent entries
  • Separate source data, assumptions, calculations and outputs
  • Work with interest, growth and time-value calculations
  • Document formulas and reduce avoidable spreadsheet errors

Applied work: Prepare a structured monthly finance workbook from sales, expense and payment records.

Evidence of capability: A reviewable workbook with controlled assumptions, verified totals and a management-ready summary.

STAGE 02 Accounting Analytics and Controls
  • Understand general ledger and trial balance structures
  • Analyse revenue, expenses, assets and liabilities
  • Review journal entries and account movements
  • Perform reconciliations and investigate unmatched items
  • Build receivables and payables ageing schedules
  • Identify duplicate payments and unusual transactions
  • Document exceptions and distinguish errors from risk indicators
  • Trace reported figures back to supporting records

Named project: Build an accounts receivable and payable ageing analysis with an exception register and follow-up recommendations.

Evidence of capability: Ageing schedules, reconciled totals, investigated exceptions and documented checks for the reviewer.

STAGE 03 Financial Modelling and Forecasting
  • Read the income statement, balance sheet and cash-flow statement together
  • Identify operating drivers behind financial results
  • Build linked three-statement financial models
  • Forecast revenue, costs and working capital
  • Prepare budgets and rolling forecasts
  • Analyse cash conversion and liquidity needs
  • Test scenarios and sensitivity to key assumptions
  • Check whether model statements reconcile
  • Explain assumptions and avoid unsupported precision

Named project: Build a three-statement financial model with a cash-flow forecast and scenarios for changing sales and payment terms.

Evidence of capability: An integrated model, reconciled statements, documented assumptions and a short explanation of financial risks.

STAGE 04 Advanced Excel Intelligence
  • Import and transform recurring finance data with Power Query
  • Combine files and standardise reporting categories
  • Build refreshable financial reporting workflows
  • Use Power Pivot and relationships across finance tables
  • Introduce DAX measures for finance reporting
  • Validate source-to-report totals after each refresh
  • Track changes and investigate failed checks
  • Document inputs, refresh steps and reporting definitions

Applied project: Replace a manual monthly reporting process with a refreshable Excel and Power Query workflow.

Evidence of capability: A working refresh process, measure definitions, reconciliation checks and handover instructions.

STAGE 05 Finance Business Intelligence
  • Model financial data for Power BI reporting
  • Define revenue, margin, cost and working-capital measures
  • Compare actual results against budgets and forecasts
  • Investigate volume, price and cost drivers where data permits
  • Build profitability and cash-flow views
  • Show period movements without misleading comparisons
  • Design reports for finance teams and senior management
  • Apply suitable access controls to sensitive reports
  • Write clear variance commentary supported by figures

Named project: Build a budget-versus-actual dashboard with variance commentary and a cash-flow management view.

Evidence of capability: A checked financial data model, interactive Power BI report and management commentary explaining material movements.

STAGE 06 Finance Data and Automation
  • Retrieve finance records from databases with SQL
  • Join ledger, customer, supplier and transaction data correctly
  • Investigate missing, duplicated and inconsistent records
  • Automate repeatable extraction and reporting steps
  • Use data tests to protect reporting accuracy
  • Apply audit analytics to exception identification
  • Understand data privacy and access responsibilities
  • Document the process for review and continuity

Named project: Create a finance reporting workflow that uses SQL, Power Query and Power BI to produce a checked monthly management pack.

Evidence of capability: Queries, transformation steps, controls, refresh instructions and verified outputs.

STAGE 07 Professional Finance Portfolio
  • Present at least three substantial finance projects
  • Explain source records and reconciliation methods
  • Defend modelling assumptions and forecast drivers
  • Show how dashboards support management decisions
  • Discuss controls, limitations and unresolved exceptions
  • Write a concise recommendation memo
  • Practise finance case presentations and interviews
  • Position prior accounting experience alongside analytical skills

Portfolio standard: Each project must show traceable figures, documented assumptions, professional judgement and an explanation of its practical financial value.

CAPSTONE The Finance Intelligence Management Pack

A growing organisation needs an integrated view of performance, working capital and future cash needs. Its accounting records, budgets and operational data are held in different systems.

  • Extract and reconcile the relevant source records
  • Investigate receivables, payables and material exceptions
  • Build an integrated financial model
  • Prepare budget-versus-actual variance analysis
  • Forecast cash flow using stated assumptions
  • Create a Power BI finance dashboard
  • Check each reported measure against its source
  • Write a management recommendation memo
  • Present findings, risks and limitations to a review panel

Final portfolio output: A reconciled financial model, cash-flow forecast, variance report, finance dashboard, controls record and management presentation.

Career Opportunities

Internship and junior entry points: Finance Analyst Intern, Junior Financial Analyst, Accounting Analyst, Junior Budget Analyst, Finance Reporting Analyst and Audit Data Analyst.

Further career directions: FP&A Analyst, Commercial Finance Analyst, Finance BI Analyst, Treasury Analyst and management accounting roles. Some positions require professional accounting qualifications or additional experience.

Career Reach

Banking, accounting and audit firms, fintech, insurance, FMCG, manufacturing, energy, telecommunications, corporate finance, consulting and international finance teams.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 05

Database Engineering & Data Infrastructure

Build the systems that store, protect, move and deliver reliable data for applications, analysts and organisations.

Suitable For

Learners interested in databases, SQL, back-end systems, cloud technology, data pipelines and the reliability of organisational information.

Starting Level

Beginner. The programme begins with relational data and SQL, then progresses to database operations, performance, warehousing and cloud data systems.

Programme Pathway

  1. SQL and Relational Databases
  2. Database Design and Engineering
  3. Administration and Security
  4. Performance and Reliability
  5. Data Integration and Warehousing
  6. Cloud Database Engineering
  7. Data Platform Foundations
  8. Infrastructure Capstone

Programme Curriculum

STAGE 01 SQL and Relational Databases
  • Understand tables, records, keys and relationships
  • Retrieve, filter, sort and aggregate data with SQL
  • Join tables without unintentionally multiplying records
  • Use subqueries, common table expressions and window functions
  • Write insert, update and delete operations safely
  • Understand PostgreSQL and other common relational platforms
  • Check query results against business and data rules
  • Use Git to track database scripts

Applied work: Query a multi-table order system to answer customer, product and fulfilment questions.

Evidence of capability: Documented SQL scripts, checked outputs and clear explanations of joins and calculations.

STAGE 02 Database Design and Engineering
  • Translate system requirements into a data model
  • Draw entity-relationship diagrams
  • Apply appropriate normalisation
  • Define primary keys, foreign keys and constraints
  • Use views, functions and stored routines where appropriate
  • Understand transactions and data integrity
  • Plan schema changes and database migrations
  • Test rules with valid and invalid example records

Named project: Design and build a normalised enterprise database for customers, orders, products and payments.

Evidence of capability: An ER diagram, schema scripts, sample records, constraint tests and a documented explanation of design choices.

STAGE 03 Database Administration and Security
  • Install, configure and inspect a database instance
  • Create users, roles and least-privilege permissions
  • Protect credentials and sensitive records
  • Plan full and incremental backup approaches
  • Restore data and verify the restored system
  • Understand logging, auditing and routine maintenance
  • Introduce replication and recovery objectives
  • Document incidents, changes and administrative procedures

Named project: Secure a database for different user roles, then perform a documented backup and recovery exercise.

Evidence of capability: Permission tests, backup files, restore results and a recovery runbook.

STAGE 04 Performance and Reliability Engineering
  • Investigate slow queries using execution plans
  • Understand indexes and their costs
  • Compare performance before and after a change
  • Monitor storage, connections and query behaviour
  • Understand locking, concurrency and transaction isolation
  • Recognise common causes of contention
  • Introduce capacity planning and scaling options
  • Understand high availability and failover concepts
  • Record evidence before changing a live system

Named project: Diagnose a slow transactional database workload and improve it without breaking correct results.

Evidence of capability: Original and revised query plans, timed comparisons, correctness checks and a change report.

STAGE 05 Data Integration and Warehousing
  • Understand ETL and ELT workflows
  • Extract data from databases, files and APIs
  • Separate landing, staging and curated data
  • Validate row counts, keys and required fields
  • Handle late, changed and duplicated records
  • Design dimensional models for analytical reporting
  • Understand warehouse and data-lake foundations
  • Document lineage from source to reporting output

Named project: Build a repeatable pipeline that moves operational records into a warehouse model for sales and customer analysis.

Evidence of capability: Pipeline code, quality checks, a dimensional model and source-to-output documentation.

STAGE 06 Cloud Database Engineering
  • Understand managed database services
  • Configure connectivity and access controls
  • Plan backups, retention and recovery
  • Understand availability zones and resilience options
  • Monitor storage, performance and service health
  • Review encryption and secure data transfer
  • Estimate costs and recognise avoidable spend
  • Document operational responsibility and escalation

Applied project: Deploy a small managed database environment with secure access, monitoring and a tested recovery plan.

Evidence of capability: Configuration record, access tests, recovery results and a cost-aware operating guide.

STAGE 07 Data Platform Engineering Foundations
  • Use Python to build and maintain data ingestion tasks
  • Work with API responses and scheduled batch jobs
  • Introduce orchestration and dependency management
  • Understand Airflow concepts for scheduled pipelines
  • Introduce dbt concepts for warehouse transformations
  • Test source freshness, transformations and data quality
  • Monitor failures and investigate pipeline incidents
  • Use version control and clear technical documentation

Applied project: Build a scheduled pipeline that ingests new records, transforms them and alerts the operator when a quality check fails.

Evidence of capability: Pipeline code, tests, a run log, failure investigation and an operational handover document.

STAGE 08 Professional Portfolio and Career Readiness
  • Select at least three substantial infrastructure projects
  • Show schema design and database administration evidence
  • Present measured performance improvements
  • Document backup, recovery and security decisions
  • Explain pipeline checks and incident response
  • Prepare architecture diagrams and project READMEs
  • Practise SQL and junior database engineering interviews
  • Defend design choices and discuss trade-offs

Portfolio standard: A reviewer should be able to inspect the design, run the core workflow, understand its controls and see evidence that recovery was tested.

CAPSTONE A Reliable Data Platform from Source to Reporting

Design a data environment for an organisation that processes transactions and needs dependable analytical reporting.

  • Design and implement the transactional database
  • Protect access with suitable roles and permissions
  • Plan and test backup and restoration
  • Investigate and improve a slow query
  • Ingest operational data into a staging layer
  • Build transformations and quality checks
  • Deliver a reporting-ready warehouse model
  • Document monitoring and response to failures
  • Present architecture, costs, limitations and recovery plans

Final portfolio output: A working database, documented schema, secure access configuration, tested recovery process, data pipeline, analytical model and technical architecture presentation.

Career Opportunities

Internship and junior entry points: SQL Developer Intern, Junior SQL Developer, Junior Database Developer, Database Support Analyst and Junior ETL Developer.

Further career directions: Database Administrator, Database Engineer, Data Engineer, Cloud Database Engineer, Data Platform Engineer and Database Reliability Engineer. Senior infrastructure positions require operational experience.

Career Reach

Banking, fintech, telecommunications, enterprise IT, government, e-commerce, healthcare technology, energy, cloud services and international data teams.

XELLUX TECHNOLOGIES / FLAGSHIP CAREER PROGRAMME 06

AI-Enabled App Development & Mobile Product Engineering

Build useful mobile products that work for real people: intuitive on a phone, dependable on changing networks and ready to improve after release.

Suitable For

Aspiring app developers, designers moving into development, career changers and learners who want to build mobile products for consumers, organisations or their own ventures.

Starting Level

Beginner. Learners develop programming and interface foundations before progressing to mobile architecture, device features, AI integration and product release.

Programme Pathway

  1. Programming and Mobile Foundations
  2. Mobile Interface Engineering
  3. Application State and Data
  4. Device Features and Offline Use
  5. Services, Security and Reliability
  6. AI Features for Mobile Products
  7. Testing, Release and Product Growth
  8. Professional Portfolio

Programme Curriculum

STAGE 01 Programming and Mobile Foundations
  • Understand mobile platforms and the application lifecycle
  • Learn JavaScript and TypeScript fundamentals
  • Use functions, objects, modules and asynchronous operations
  • Work with Git and a documented project repository
  • Build and run a React Native application
  • Understand the role of Expo in development and builds
  • Debug errors on an emulator and a physical device
  • Identify a user problem suitable for a mobile solution

Applied work: Build a small mobile utility that accepts user input, saves a result and handles invalid or incomplete entries.

Evidence of capability: A working app, readable code and a short demonstration on a real device.

STAGE 02 Mobile Interface Engineering
  • Translate user needs into screens and task flows
  • Build reusable React Native components
  • Create navigation between screens
  • Design forms, lists, search and useful feedback states
  • Support different screen sizes and orientations
  • Make touch targets, text and contrast usable
  • Support screen readers and accessible labels
  • Test a task with users and improve the flow

Applied project: Design and build a mobile service app through which a user can find information and complete a defined task.

Evidence of capability: Screen flow, working navigation, accessibility checks and documented changes made after user feedback.

STAGE 03 Application State and Data
  • Manage component and shared application state
  • Retrieve and update data through APIs
  • Handle loading, empty, error and retry states
  • Store suitable data locally on the device
  • Separate interface components from data operations
  • Validate user input and prevent duplicate submissions
  • Understand synchronisation and conflicting changes
  • Design predictable behaviour when data is unavailable

Applied project: Build a mobile records app in which users create, edit, search and retrieve their information across sessions.

Evidence of capability: A functioning data workflow with tests for saving, retrieval, error handling and recovery.

STAGE 04 Device Features and Offline Use
  • Request device permissions only when a feature needs them
  • Use the camera, image selection or location where appropriate
  • Explain clearly why the app needs each permission
  • Store essential information for use without a connection
  • Queue appropriate changes for later synchronisation
  • Resolve failed uploads and conflicting updates safely
  • Test weak networks, interruptions and device restarts
  • Consider battery, storage and data consumption

Named project: Build a field-work app that records a report and photo offline, then sends the record when connectivity returns.

Evidence of capability: A working offline workflow, synchronisation tests and a demonstration of how the app handles an interrupted upload.

STAGE 05 Services, Security and Reliability
  • Connect a mobile app to a documented back-end API
  • Understand authentication and user permissions
  • Store credentials using appropriate secure mechanisms
  • Protect personal data in transit and in the app
  • Validate inputs on the client and the server
  • Design reliable notifications where they add value
  • Record errors without exposing private information
  • Test service failures and recovery behaviour

Applied project: Extend the records app with user accounts, role-aware access and a secure API.

Evidence of capability: Authentication tests, documented permissions, privacy decisions and working recovery from an API failure.

STAGE 06 AI Features for Mobile Products
  • Choose a mobile task that genuinely benefits from AI
  • Connect the app to an AI service through a protected back end
  • Design useful input and structured output
  • Build a human-review step for consequential results
  • Show uncertainty, source material or limitations where needed
  • Test incorrect, unsafe and incomplete responses
  • Protect personal data sent to AI services
  • Control latency, usage and operating costs
  • Keep core app tasks usable when the AI service is unavailable

Named project: Add an AI-assisted feature that helps a user summarise a field report, categorise an issue or find relevant guidance.

Evidence of capability: A working feature, representative evaluation cases, human-review flow and documented failure behaviour.

STAGE 07 Testing, Release and Product Growth
  • Write unit and interface tests for critical behaviour
  • Test end-to-end tasks on physical devices
  • Check accessibility, performance and battery impact
  • Prepare development and production builds
  • Understand app signing and release versioning
  • Prepare privacy information and product descriptions
  • Review current platform publication requirements
  • Plan staged releases and rollback responses
  • Use crash reports and user feedback to prioritise fixes

Applied work: Prepare a release candidate and run a structured test with users on supported devices.

Evidence of capability: Test record, release build, known-issues list, privacy notes and an improvement plan.

STAGE 08 Professional Portfolio and Career Readiness
  • Present at least three substantial mobile projects
  • Demonstrate each project on a physical device
  • Explain user needs, screen flows and design choices
  • Show offline, security and accessibility considerations
  • Document tests, limitations and improvements
  • Prepare repository READMEs and short demo videos
  • Practise junior mobile engineering interviews
  • Explain how feedback shaped the finished product

Portfolio standard: Each app must solve a defined user problem and demonstrate working software, sound decisions, tested behaviour and clear documentation.

CAPSTONE An AI-Enabled Mobile Product Built for Real Use

Identify a real problem faced by a specific group of people. Build a mobile app they can use to complete an important task, including when connectivity is unreliable.

  • Interview potential users and define their core task
  • Map screens and design an accessible mobile flow
  • Build the app and connect its essential data services
  • Support appropriate local storage and offline behaviour
  • Use device capabilities only where they improve the task
  • Add a focused AI feature with human review
  • Test security, accessibility and failure cases
  • Prepare a release build and operational documentation
  • Demonstrate the app with real task scenarios
  • Explain what user feedback changed and what remains to improve

Final portfolio output: A working mobile app, source repository, user-flow documentation, test record, AI evaluation, release build and product demonstration.

Career Opportunities

Internship and junior entry points: Mobile Development Intern, Junior React Native Developer, Junior Mobile App Developer, Junior Application Developer and Mobile Product Engineering Intern.

Further career directions: Mobile Software Engineer, Cross-Platform Developer, AI-Enabled App Developer, Mobile Product Engineer and Technical Product Builder. Specialist roles require additional delivery experience.

Career Reach

Consumer applications, fintech, healthcare, education, logistics, field operations, commerce, enterprise mobility, start-ups and international mobile product teams.

XELLUX TECHNOLOGIES / BEYOND THE CURRICULUM

What could change in your life if you became someone others could depend on to do this work?

The work that carries your name.

One day, the question will no longer be which course you studied. Someone will place a real problem in front of you and ask what you can do.

A business may need to understand where its money is going. A patient may need an application that works when the connection fails. A team may need information it can trust before making a decision. Behind every project is a person affected by whether the work is done well.

That is why the exercises matter. Each time you investigate an error, improve a design, check a result or try again, you are preparing for work that extends beyond the classroom.

THE MOMENT THAT MATTERS

You can explain the problem. You can show what you built. You can demonstrate that it works. You can say what still needs improvement.

Your ability has become visible.

That ability can become an entry point into a career, a better position at work, a service people need or the foundation of something you build yourself. Over time, it may help you earn more, make steadier choices and support the people who rely on you.

None of those outcomes begins with a title. They begin with the decision to practise until you can take responsibility for the result.

The future does not need you to know everything today. It asks what you are willing to learn, build and become capable of doing well.

Why Choose Us?

At the heart of Xellux's ethos lies a relentless pursuit of excellence, fueled by a passion for harnessing technology to solve complex challenges and enhance lives.

  • Comprehensive Training
  • Hands-on Data Experience Project
  • Adapting To Individual Differences
  • Our classes base on your personal schedule and free time
Learn More

Where Our Students Work

Xellux Technologies is a Top ICT Training Company For Global Students. Our Students Work in Top International Companies in Canada, USA, UK, Cyprus, Turkey and Nigeria.