无Tableau授权的电商用户批量上传Product ID过滤数据方案咨询

Hey there, let's walk through actionable, low-overhead solutions that fit your team's scenario—since you're new to Tableau and dealing with read-only users + multi-user data conflicts, these should work without needing constant help from the owner:

1. BigQuery User-Specific Temporary Tables + Tableau Custom SQL (Best for Large ID Lists) #

This eliminates conflicts entirely by giving each user their own dedicated space to upload daily Product IDs:

• Setup First: Have your BigQuery admin create a unique dataset for each user (e.g., user_raghav_daily_ids, user_priya_daily_ids) and grant them Data Editor access only to their own dataset. This keeps their data isolated from others.
• Daily Workflow for Users:
  1. Upload their daily Product ID CSV (or Google Sheet export) to their personal BigQuery dataset as a table (name it something consistent like daily_product_ids).
  2. In Tableau, use a pre-built custom SQL data source (you can create this template once for all users) that joins the sales table with their personal ID table:

     SELECT s.*
     FROM `your_project.sales_dataset.sales_table` s
     INNER JOIN `your_project.user_raghav_daily_ids.daily_product_ids` p
     ON s.product_id = p.product_id
     

     Note: Users just need to update the dataset name in the SQL if it's tied to their username, or you can use BigQuery's session variables to auto-populate it if you want to get fancy.
• Why This Works: No cross-user conflicts, users control their own data updates, and Tableau's read-only permission doesn't block using custom SQL against BigQuery (as long as the user has BigQuery access to their dataset).

2. Isolated Google Sheets + Tableau User Filters (Optimized Version of Your Original Idea) #

If you prefer sticking with Google Sheets instead of BigQuery tables, fix the conflict issue by isolating user data:

• Setup: Create a single Google Sheet with separate tabs for each user (e.g., UserRaghav_DailyIDs, UserPriya_DailyIDs). Share the sheet with all users, but instruct them only to edit their own tab.
• Tableau Configuration:
  1. Connect Tableau to the Google Sheet, bringing in all user tabs as separate tables.
  2. Create a user filter in Tableau that maps each logged-in user to their specific tab. This way, when a user opens the view, it automatically pulls only their tab's Product IDs.
  3. Build the sales data join using the filtered user tab data.
• Pro Tip: Lock all tabs except the user's own to prevent accidental edits—you can do this directly in Google Sheets.

3. Tableau Parameter with Bulk Paste (For Smaller ID Lists) #

This is a quick backup option if you need to handle occasional smaller batches (note: not ideal for 10k IDs due to string length limits):

• Create a string parameter Daily_Product_IDs in Tableau, set it to allow multiple values.
• Have users convert their Product ID list to a comma-separated string (e.g., in Excel, use TEXTJOIN(",", TRUE, A:A) to combine the column into one string).
• Paste the comma-separated string into the parameter, then use a calculated field like CONTAINS([Product_ID], [Daily_Product_IDs]) to filter the sales data.
• Limitations: Tableau has a character limit for parameters, so this works best for lists under 1k IDs.

Quick Notes for Your Team #

• Permissions Check: Make sure your BigQuery admin verifies that users only have access to their own datasets—this prevents accidental data leaks or overwrites.
• Training: Since your team is new to Tableau, start with either solution 1 or 2 (whichever feels more intuitive) and create a 1-page step-by-step guide for users to follow.
• Testing: Run a trial with 1-2 users first to iron out any kinks before rolling out to everyone.

内容的提问来源于stack exchange，提问作者Raghav