We are creating a benchmark analysis in Tableau for around 5000 employees. We have two sets of files, one for Actuals, another for the Benchmarks. I have attached a basic sample of the same. Let's say this file is for one employee. There would be another 4999 files in similar formats. My quetion is two-fold:
1. At present, I am creating a Union of two worksheets, and then doing the benchmark. Please see attached Tableau dashboard for reference. Is there a better way to do this?
2. Since this is for one employee, how will I feed in the data for another 4999 employees? These files are in .xlsx format. The individual files are not that heavy, however, in bulk they are simply not getting loaded into Tableau. How should I go about it? Will uploading to Big Query or likes help?
Hi Rajtilak,
This will be a nightmare to connect 5,000 worksheets (if this is even possible), I'm assuming that your Emp ID field is the primary key.
I'd suggest breaking off the benchmark (is this a KPI ?) into another sheet if this is fixed, otherwise you could just add the column to the Actual table as pictured.
Doing some quick calcs, the maximum row limit in Excel is 1,048,576 rows. If you put all of your staff in one worksheet (and had 7 day operations) you would fill the worksheet every 29 days.
Either break this up by Employee ID groups (e.g. Emp ID 1000-1500), or by their natural work groups.
As for databases, any of them will handle this data and you would lose the restriction on row limits.
HTH
Peter
