I have a potential use-case for QuickSight Q at my job, but unfortunately there is a dealbreaker.
Q is primarily marketed at Business decision makers, who want to query their data but are not familiar with BI reporting, or SQL syntax.
I live in Germany, and while Q offers me the possibility to quickly formulate querys, this just is not going to happen for the primary audience of this tool.
Many decisionmakers don’t know English, and if they do they find it exhausting to write complex statements like “Give me the average cost sorted by the product group”, as they would probably have to Google a few things each time, which totally negates the sweet “everyone can query via written text in seconds” user experience.
So I have a quick proposal for adding new languages without making this a year long product:
I have tested out that writing my querys in German, translating them via AWS Translate into English, and then piping this into QuickSight Q works surprisingly well.
So maybe you could add a setting to Q for adjusting the default language, the logic behind it could look like this:
So if you submit a query, it checks if your config has a language selected other than default English, if so it sends a query with your Query, your custom language to AWS Translate.
The Action TranslateText (see AWS Translate docs) supports TerminologyLists, you can feed in special cases where you want to define the translation. The documentation has a great example with
Amazon Familywhich in French shall be translated to “Amazon Familie” not “Familie Amazon”.
This should fit well with the Visual Data Labels in QuickSight which make querying in Q so much easier.
So each label value shall not be translated, and left as it is, so Q can do its magic.
The TerminologyList shall be compiled each time the user modifies the Data Labels, as this may not happen that often that speeds up things and prevents unnecessary reads at each inference.
I hope my proposal may help you to implement this, I really want this and think it would add a huge value to QuickSight Q.
PS: I am willing to be billed for the use of AWS Translate, please just make this happen