Audit Analytics using Power BI- Advanced

Training Date: October  02-03,   2024

Course Description

The Audit Analytics Using Power BI - Advanced course aims to equip professionals with advanced techniques for analysing large datasets, automating data preparation, and creating compelling visualisations using Power BI.

Course Summary

Course Type

Fundamentals

Course Duration

2 days (Onsite)

Time

9 AM to 4 PM

Pre-requisites

Power BI I: Fundamentals Training

Includes

Classroom training with hands-on activities, PDF copy of training material

Course Expectation

At the end of the training, you will learn to:

Acquire a comprehensive understanding of Power Query Editor

  • Automate data cleaning and transformation using the Prep module
  • Interpret the Power Query M language
  • Create conditional columns
  • Manage field formatting and types
  • Handle blank values and zero values
  • Execute queries, merging, appending, and conditional column operations
  • Manage relationships between different data tables
  • Gain insights through Table and Matrix visuals
  • Utilize Table Tools and Column Tools
  • Connect to API Services, SharePoint, and SQL Databases and manage credentials
  • Perform dashboard performance evaluation and management
  • Utilize Q&A feature (Desktop & Web Services)
  • Publish dashboards
  • Implement Row Level Security and manage access sharing
  • Build a customised dashboard using a curated dataset tailored to your specific needs

    Apply for this position

    Request A Demo