ยฉ 2024 SKILLAHEAD

LIIGFB

Finance Data Analytics: from raw transactions to automated dashboards

Stop rebuilding the same reports every month. In two days, your finance team learns to clean messy exports, combine data from multiple systems, reconcile transactions and build an invoice ageing dashboard that refreshes itself.

Close 2026 with a receivables dashboard ready for 2027.

๐Ÿ“… Online: 8โ€“9 Dec๐Ÿ“… Lagos: 15โ€“16 Dec๐Ÿ“… Port Harcourt: 21โ€“22 Dec
Sample receivables and invoice ageing dashboard: total receivables, overdue debt, ageing buckets, DSO trend and top overdue customers

Your capstone: an invoice ageing dashboard like this one, built on a realistic Lagos dataset. Sample shown with fictional data.

Organisations whose teams we have trained and supported

From leading industrial conglomerates and insurers to state healthcare commissions.

AltradPipeline Infrastructure Nigeria LimitedPrudential Zenith Life InsuranceLagos State Health Service CommissionNigerian Sinotrucks LimitedGreen Pacific Insurance BrokersCobbs Engineering TechnologyAVN Global LimitedSorties LogisticsGeo TravelUltimum
Sound familiar?

Your finance team knows finance. The spreadsheets are what slow them down.

Messy exports

Data from the ERP, bank and billing system never lines up, so hours go into copy and paste.

Slow reconciliation

Mismatches are found by eye, late, and sometimes not at all.

Month-end pressure

The same reports are rebuilt by hand every period, under deadline.

Unseen overdue debt

Management asks who owes what and for how long, and the answer takes days.

Who it's for

Built for the people who produce the numbers

โœ“Accountants and finance officers
โœ“Financial and management analysts
โœ“Credit control and receivables teams
โœ“Reconciliation and audit support staff
โœ“Treasury and reporting officers
โœ“Comfortable with basic Excel. No coding needed.
Curriculum

Two days. One real case study: invoice ageing.

Every session is hands-on in Excel and Power BI. You work on the same dataset from the first export to the final dashboard.

Day 1Clean and combine
  • Clean messy system exports with Power Query
  • Merge invoices, payments and bank data from different systems
  • Reconcile transactions and flag mismatches automatically
  • Spot unusual patterns that point to control gaps or leakage
Day 2Analyse, visualise, automate
  • Ageing buckets and days sales outstanding (DSO)
  • Build an interactive invoice ageing dashboard in Power BI
  • Set up refresh so recurring reports update themselves
  • Document sources and KPIs so reports are auditable
You leave with a working dashboard

Not just notes. A finished invoice ageing dashboard and a reusable template you can point at your own company's data on Monday, plus a Skillahead certificate of completion.

Reserve your seat
Your facilitators

Data skills and finance expertise in one room

Anietie Etuk
Anietie Etuk, MCPN
Lead Facilitator ยท Data Analytics

Lead Data Analytics Consultant at Skillahead. Builds Excel and Power BI reporting systems for finance teams.

  • Chartered Member, Computer Professionals (Registration Council of Nigeria)
  • Certified AI Training of Trainers Professional (KOICA, SMEDAN and UNDP)
Sheriff Olashinde, FCA
Sheriff Olashinde, FCA
Lead Facilitator ยท Finance

Fellow of the Institute of Chartered Accountants of Nigeria (ICAN) and Head of Finance at an oil and gas company. Expertise in corporate finance and auditing; brings the finance lens on reconciliation, controls and month-end reporting.

JAN 2026

Trained financial executives to build an Excel payroll system for Nigeria's new tax law.

FEB 2026

Invited by the Lagos State Health Service Commission to train its accountants on revenue leakage analysis and Power BI dashboards.

FEB to MAR 2026

Trained an oil and gas company's finance staff in Port Harcourt on invoice ageing analysis and reporting in Power BI.

๐Ÿ›ก๏ธ Official Recognition

Registered, Licensed and Accredited

Independent standing with federal regulatory commissions, statutory councils, and professional associations.

Corporate Affairs Commission

Registered with the Corporate Affairs Commission: Skillahead Systems Ltd, RC 9266290

Computer Professionals Registration Council of Nigeria

Licensed by the Computer Professionals Registration Council of Nigeria (CPN), 2026

Institute of Analytics Endorsed Course

Skillahead group: IoA (UK) Endorsed Data Analytics course (Skillahead Solutions Ltd)

Information Technology Association of Nigeria

Skillahead group: member, Information Technology Association of Nigeria (ITAN)

Dates & fees

Two cities, online, and two months to choose from

Two days, 9:00am to 4:00pm. Limited seats per class so everyone gets hands-on support. December is year-end close: if your team cannot attend in December, choose a January class or book in-house on dates that suit you.

Online
December:Tue 8 โ€“ Wed 9 Dec 2026
January:Mon 11 โ€“ Tue 12 Jan 2027
Time:9:00am to 4:00pm, both days
Platform:Live on Zoom (link sent after registration)
Lagos
December:Tue 15 โ€“ Wed 16 Dec 2026
January:Mon 25 โ€“ Tue 26 Jan 2027
Time:9:00am to 4:00pm, both days
Venue:Skillahead Lagos office, 6 Ashabi Cole Street, by Agidingbi, Ikeja
Port Harcourt
December:Mon 21 โ€“ Tue 22 Dec 2026
January:Mon 18 โ€“ Tue 19 Jan 2027
Time:9:00am to 4:00pm, both days
Venue:Skillahead Port Harcourt office, 8 Old Aba Road, by Customary Court, Rumuogba
Standard
โ‚ฆ200,000
per participant, VAT inclusive
BEST VALUE
Group (2 or more)
โ‚ฆ150,000
per participant, same company, VAT inclusive

All fees include VAT, with nothing added later. The fee covers live training, materials, practice datasets, the dashboard template, a certificate of completion, a 1-hour online follow-up session and, for in-person classes, lunch and tea break on both days. Bring a Windows laptop with Excel and Power BI Desktop (free) installed. Setup instructions are sent after registration.

In-house option

Train your whole finance team at your office, or an approved venue

We bring the full programme to your team, using a dataset shaped around your business. Duration, timing and location are flexible, so training fits around your month-end and year-end close. Year-end training budget still open? We can invoice the same day.

From โ‚ฆ1,500,000 for up to 10 staff (VAT inclusive), โ‚ฆ120,000 per extra person.

Plus an administrative fee for venue, travel and logistics, quoted in writing before you book.

Talk to Mrs. Love
+234 806 619 9860
Register

Reserve your seat for December or January

Seats are capped so every participant gets hands-on support. Registering for a team? Add the number of participants and we'll send a group invoice.

Register in 2 minutes

Fill the short registration form. We will confirm your seat and send the invoice and setup instructions.

Open registration form

Questions

Do I need to know Power BI already?

No. If you can use basic Excel formulas and filters, you can follow. We build everything step by step.

Will this work with our accounting software?

Yes. The methods work with exports from any system that produces Excel or CSV files, including common ERP and accounting packages.

Can I use a Mac?

Power BI Desktop runs on Windows only. Please bring a Windows laptop, or contact us before registering.

Do participants get a certificate?

Yes. Every participant who completes both days receives a Skillahead certificate of completion.

How do I pay?

Bank transfer to Skillahead Systems Ltd, Polaris Bank, account 4092280653. Companies can request an invoice for staff registrations.