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.