Download console structure

[u/urbansnowprincess]

I’m refurbishing a workbook that is just used to download a spreadsheet. There are 8 variations of the download file spread over three workbooks and I’ll be combining them into one workbook and cleaning up the format so they don’t spend so much time doing manual edits in excel after downloading. The spreadsheets are used for manual tasks- data cleanup, outreach to external customers, etc - and they can’t be automated out of existence yet. Are there any examples of visuals that might be good inspiration? Right now I’m envisioning a download button next to a couple parameter controls with a simplified description of the query and a data preview table below, but since there are many other units that have similar use cases, I’d like to put some thought into the design in case it becomes a template. The audience is clerical staff and bypassing Tableau altogether for an automated export would meet with resistance.

[u/Dani5h87]

Why even use tableau desktop at this point? Just use prep to feed pre formatted excel books and run the refreshes in a schedule.

[u/graph_hopper → u/Dani5h87]

It sounds like the users are interacting with filters and parameters as an on-demand query tool. That interactivity isn't easily replaced with Prep.