In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual.
I am using the same data set for customer feedback. In the customer data set, we have a column name as Country-Region, if the manager instead of Country-Region using Branch. what branch has more ticket count
The branch column name is not defined in data set, so it has been shown as Red color.
The branch is not identified, so it is in red color. we need to add this word to the Q&A dictionary. Click on the setting icon at the top right corner.
In the new page, click on the Teach Q&A , in the text box you can see the question.
Click on the submit and under the refer, choose the column that is a synonym , In this example Branch, is refer to Country-Region
Then after define it, just save it.
After saving the definition, you will see the there is no red color in the question, and the Q&A able to identify the branch as a known column,
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.