Harnessing Knowledge From Ad Hoc Queries by Creating a Zone of Standardization
Business Intelligence drives strategic business decisions by providing timely and accurate information. Beneath the demand for constantly changing information-needs usually lay a highly complex entangled mesh of business rules, data sets, query logic and custom-ad hoc Reports. The discrete nature of ad hoc reports may lead to inefficiencies in processing times and also valuable business knowledge is being lost. If the ad hoc queries are viewed within a context of larger collection of queries the authors could derive meaningful information worthy of reuse. Expert Query System (EQS) is an approach that drives ad hoc queries towards standardization, structure and documentation to reuse, recycle queries, harness knowledge and reduce the foot prints of the subsequent ad hoc queries.