Latest News
What are Choropleth Maps used for?
A choropleth map represents numerical values over geographical areas by using color, shading, and other patterns. To distinguish between high and low values, these representations use a progression of color (or shading) on a spectrum.
Viewers can observe how a variable change from one region to the next using choropleth maps. The fact that the colors represent a range of values makes it difficult to access the precise numerical values, which could be a drawback to this style of display. However, you may add interactivity to your map using natural language question to NLSQL bot so that you can get the precise values.
With NLSQL you can create the Choropleth Maps by asking a question in plain English (you can check how we did it on the pictures or start our 30 days free trial to try it on your data by yourself with a link below)
What is a Bar Chart used for?
A bar or line chart can be your first choice if you wish to compare one thing to another. Line charts work better for portraying longitudinal data (data collected repeatedly over time, on a periodic, or rolling basis) than bar charts do for cross-sectional data (data acquired only once and showing the status of the data at that point in time).
In this type of visualisation, the categories being compared are shown on one axis of the chart, and a measured value is shown on the other. How each group performs in relation to the value is shown by the length of the bar. One negative is that when there are too many categories present, labeling and clarity can become difficult.
With NLSQL you can make the Line graph by asking a question in plain English (you can check how we did it on the pictures or start our 30 ...
More:
Make Your Bar Chart Now

How can I connect NLSQL to the on-premise database?
My company is using both on-premise and cloud services like Microsoft Teams and Azure. How can I connect NLSQL to the on-premise database?
Your on-premise database is located in your private on-premise network, so NLSQL App on Azure can connect to it via Virtual Network Integration, IPsec or Hybrid Connection
It is possible through the Azure marketplace, as NLSQL offers virtual network integration from Azure to on-premise networks.
Jake Zborowski, General Manager, Microsoft Azure Platform at Microsoft Corp. said, “We’re pleased to welcome NLSQL to the Microsoft Azure Marketplace, which gives our partners great exposure to cloud customers around the globe. Azure Marketplace offers world-class quality experiences from global trusted partners with solutions tested to work seamlessly with Azure.”
The Azure Marketplace is an online market for buying and selling cloud solutions certified to run on Azure. The Azure Marketplace helps connect companies seeking innovative, cloud-based solutions with partners ...
NLSQL better fits for Data Lake or Data Warehouse?
NLSQL perfectly fits on TOP of any data lake within your corporate data infrastructure, we support most of the data connectors and can significantly
increase usage of your data from the existing data lakes for making better business decisions by managers.
The evolution of data analytics provides managers with an endless number of dashboards with a significant increase in available data. For non-technical employees, it might be even more confusing as a result of a lower understanding variety of data in dashboards. However, NLSQL provides non-technical employees the ability to ask their questions directly to data and get back with calculated responses.
To gain insights from data, it has to be processed in a timely manner and put into a form that will be useful for managers mindset.
Empowered business decisions drive businesses forwards faster.
Does NLSQL support database queries caching?
There are various benefits to caching. You can speed up slow queries and reduce the demand on your database server's memory and CPU same time. Most of the modern database engines support database query caching, or you can do your own in-memory or cache with Redis.
NLSQL relies on database engine query caching capabilities and SQL query speed optimisation. NLSQL brings to our end-users the best in class in memory calculation speed.
NLSQL is a Microsoft Teams App that empowers employees with instant access to prescriptive analytics, that provides decision-makers with sufficient information such as sales history, real-time payments statistics, price, EBITDA, or cost of production at any level to clearly determine the best course of action.
With NLSQL Teams App can drill down into data with their questions to find out the root causes and gain new insights about any problem before making decisions.