Can you use the sql query to exclude those APAC data from query level directly?
Yes, I was going to exclude APAC from the region filter in sql data source. I want to instead include APAC data from my 8 or so spreadsheets in the various Tableau worksheets.
To include APAC data from my Excel spreadsheets into the original region filter in sql would I be using one calculation to say include this APAC region pill instead?
Also I will be receiving 8 new APAC data Excel Spreadsheets each month. How difficult to you anticipate this process will be for me each month? I'm hoping it will be as simple as just clicking edit data source & bring in each of the new Excel data sources.
Since you are a self-proclaimed "new to Tableau" and you want to exclude a certain portion of your data before integrating Excel and SQL data sources for reporting and analytics, I suggest you look into Tableau Prep, the new data preparation application from Tableau. You can download a trial for free trial these days here. It is ideal for cleaning, joining - or excluding - data, then shaping and saving into a packaged flow that you can open in Tableau Desktop. The best thing is that it is all drag and drop and visual manipulation, no coding needed.
Get started here:
I hope you will be happy you gave it a test run!
Could someone please advise the easiest way to data blend Microsoft SQL with Excel spreadsheets? I don't have the funds to use the paid data prep service.