Explore your databases with English Query

Problem:
Your organization has created a database system to monitor your business, but, for each new report, you have to wait a few months for the IT staff to produce it.

Solution:
Empower your business analysts and managers. They do not have to know SQL or some complicated reporting tool to be able to query a database. You can give them access to English Query, which is a tool that allows your analysts to ask questions in plain English.

Select StoreID, Store.Name Sum(Quantity)
from SalesFacts inner join Store 
    on SalesFacts.Storeid = Store.StoreId
 inner join Time 
 on SalesFact.TimeId = Time.TimeId
group by StoreId
Where Time.Month = 2 and Time.Year = 1999

Versus:

How much did each Store sell in February 1999?

For more information, check the following link:

SQL Server Insider: English Query