Special Highlights of the Program:
- Fully live instructor led classes
- Recordings of the classes available
- Class files, working notes and dashboards created in the classes are provided
- Practical assignments + Live Projects
- Certificate of completion
Program Curriculum:
- Module 1: Data Extraction and Power query for Internal Auditors
Use 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 and audit red flag monitor dashboard
About Power BI:
Power BI has quickly become one of the world's most powerful self-service business intelligence platform, and an essential tool for data professionals and beginners. Power BI is a robust business analytics and visualization tool from Microsoft that helps data professionals bring their data to life and tell more meaningful stories.
With Power BI you can connect to hundreds of data sources, build complex data models using simple and intuitive tools, with stunning design, interactive dashboards from scratch.
- Power BI is a Microsoft tool.
- There is a free desktop version of Power BI available as well that can be used for the training if you don’t have an enterprise license.
Course Requirements:
- Windows Laptop/Computer (Power BI free version is only available on Windows)
- Basic level MS Excel understanding
Please call Biplab SenGupta on 8130826342 for more details.