Hi everyone
I was exploring how to use Tableau for HR and payroll analytics, especially for UAE-based businesses.
I came across a UAE gratuity computation API that calculates end-of-service benefits based on salary and years of service.
Now Iām curious has anyone here tried connecting such external APIs (like HR or financial calculators) directly into Tableau dashboards?
Iām thinking about using it for visualizing total gratuity liability per department or employee group, but Iām not sure whatās the best way Web Data Connector or Tableau Prep script?
Would love to know how others here have handled API-based data visualization in Tableau .
Iāve worked with similar API-based data flows, and Iād probably use Tableau Prep to pull and clean the API data before bringing it into Tableau. That way, you can refresh the gratuity calculations regularly and build dashboards around departments, employee groups, or overall liability without making the workbook too complicated.