Hotline 0703 824 3668 Chat on WhatsAppSuite 2011/2020, Anbeez Plaza, Wuse Zone 5, Abuja
DMC Business School

Accounting Skills · Online course

Data Analysis for Finance

Accountants who must turn large transaction files into findings and recommendations.

  • Self-paced, on demand
  • 6 months access
  • 24 lessons
  • Certificate on completion
₦70,000
Enrol now
  • 6 months from confirmed payment
  • Study on your phone, tablet or computer
  • Certificate when you complete the course

Secure online payment. Your login link arrives by email as soon as payment is confirmed. 48-hour refund policy

Course content

9 modules · 24 lessons

Video 1 · The Data Analysis Workflow2 lessons
  1. Part A · From question to data to finding: how an analysis engagement is structured
  2. Part B · Data sources in a finance function and what each can and cannot tell you
Video 2 · Getting and Cleaning Data3 lessons
  1. Part A · Importing from CSV, PDF, bank portals and accounting packages
  2. Part B · Cleaning: duplicates, blanks, text-as-number, dates and inconsistent codes
  3. Part C · Structuring a flat table that can be analysed
Video 3 · Power Query3 lessons
  1. Part A · The query editor: steps, applied transformations and refresh
  2. Part B · Appending and merging queries; unpivoting reports back into data
  3. Part C · Building a repeatable monthly refresh
Video 4 · Data Modelling and Power Pivot3 lessons
  1. Part A · The data model, tables and relationships
  2. Part B · Fact and dimension tables for finance data
  3. Part C · Introduction to DAX measures
Video 5 · PivotTables and Analytical Measures3 lessons
  1. Part A · PivotTables for financial analysis: grouping, sorting and calculated fields
  2. Part B · Common measures: variance, percentage of total, running total and year on year
  3. Part C · Slicers, timelines and interactive summaries
Video 6 · Analytical Techniques3 lessons
  1. Part A · Variance and trend analysis
  2. Part B · Ratio and common-size analysis on transaction data
  3. Part C · Segmenting by customer, product, branch and period
Video 7 · Visualisation and Dashboard Design3 lessons
  1. Part A · Choosing the right chart for the message
  2. Part B · Building a finance dashboard in Excel
  3. Part C · Design rules: clarity, labelling and avoiding chart junk
Video 8 · Audit and Forensic Analytics2 lessons
  1. Part A · Duplicate payments, round-sum entries, weekend and out-of-hours postings
  2. Part B · Benford’s Law, outlier detection and sampling for testing
Video 9 · Reporting, Automation and Refresh2 lessons
  1. Part A · Writing up findings: what was tested, what was found, what to do
  2. Part B · Automating the pack so next month is a refresh, not a rebuild

Who this is for

Practitioners, students and business owners who want practical skills they can use straight away.

48-hour refund window

Apply within 48 hours of payment if you have watched no more than 10% of any video and have not downloaded course materials. Read the refund policy

Before you enrol

How do I get access?

Pay securely online. As soon as your payment is confirmed, we email you a link to set your password and start learning. Existing learners can sign in with their account.

How long can I study?

6 months from confirmed payment

Will I receive a certificate?

A certificate is available only for courses marked as certificate-bearing, after their completion requirements are met. Professional-exam courses do not issue certificates.

What if I need help or a refund?

Contact support for course or payment questions. Refund eligibility depends on the payment and your learning activity; review the refund policy before paying.

DMC Business SchoolYour pathway to professional exam success and practical business skillsICAN · ATSWA · CITN exam preparationLearn from chartered accountantsStudy at your own pace on any deviceIn partnership with Topnotch Learning Centre