This Power BI tutorial provides a step-by-step guide to analyzing employee bonus payments and recoveries. Using a provided dataset, the video demonstrates how to create a comprehensive dashboard to track bonuses, active and exited employees, and net payments. Key steps include importing and preparing the data, creating multiple pages for payments and recoveries, and designing the dashboard with navigation buttons and visuals like card visuals, column charts, and donut charts.
The tutorial further explains how to use DAX formulas to create new columns for paid and recovered amounts, enabling a detailed analysis of the recovery process. The video shows how to build a second dashboard to track recovered bonuses, calculate a recovery percentage using a new measure, and visualize this data through various charts. This allows for a clear overview of total payments, recoveries, remaining recoverable amounts, and the overall recovery rate, helping to ensure that the joining bonus policy is effectively managed.
#PowerBI #DataAnalysis #Dashboarding #DAX #Tutorial
Download: https://drive.google.com/file/d/1lq0n3nEd4UGoz5AbU3Q5v-Q5YEpShpbl/view?usp=drive_link