Module 1: Data Extraction and Power query for Internal AuditorsUse cases: Reading bank statement, statutory returns and records for audit
Module 2: Fundamentals of Power BI in context of Internal Audit
Use cases: Purchase price variance analysis, Open PO aging, PO to Invoice TAT analysis
Module 3: Key audit tests using Power BI
Use Cases: Duplicate master records (Vendor/customer/price/employee), tracing duplicate payments
Module 4: Implementing audit techniques in Power BI
Use cases: JE testing, Benford, relative size factor, chord diagram for money trail
Module 5: Data modelling and Dashboarding in Power BI
Uses cases: 3-way match & Audit red flag monitor dashboard