Skip to main content

Natural Language Queries (NLQ)

Timbr offers a powerful Natural Language Query (NLQ) add-in for Microsoft Excel, allowing users to interact with their data using everyday language. This feature enables you to ask questions about your data based on your organization's ontology terminology.

Getting Started​

  1. Open Microsoft Excel
  2. Navigate to the "Add-ins" section above
  3. Search for "Timbr NLQ" in the Add-ins store
  4. Click Add to install the Timbr NLQ add-in

add ins

Once installed, you'll see the Timbr NLQ icon in the top right corner of your Excel ribbon.

ribbon

Connecting to Your Timbr Environment​

  1. Click on the Timbr NLQ icon in the Excel ribbon
  2. Enter your Timbr environment URL
  3. Input your user token (e.g., tk_123456789…..)
  4. Click Login

login

Using Natural Language Queries​

After logging in:

  1. Select your desired Knowledge Graph from the dropdown menu

kg

  1. Once selected begin typing your query in natural language in the search box beginning with 'Find'. Notice that Timbr will offer autocomplete suggestions to help with formulating the query.
  2. When Finished, click Run to execute the query

query

  1. The results will be displayed in a new Excel sheet, showing the relevant data based on your query

result

Additional Features​

  • You can refine your search by modifying the query and running it again. Each Additonal run will open the results in a new tab.
  • You can use the Resources button to access additional help and documentation

resources

Tips for Effective Queries​

  • Use natural language phrases that reflect your data structure and ontology
  • Be specific in your queries to get more precise results
  • Experiment with different phrasings if you don't get the expected results on the first try

By leveraging Timbr's NLQ functionality in Excel, you can quickly gain insights from your data without the need for complex formulas or programming knowledge.