Building and Implementing Business Intelligence Systems for bookshops

For making decisions about issues such as the time and number of orders for replenishing bookstores, assessing customerʹs interests in different regions and reducing maintenance time of books in stock, many decision makers send their queries manually to databases. This is a time consuming process as well as the probability of error in writing the queries. This research addresses the issue of making fast and complex reporting on massive amount of data in bookstores databases. For this purpose a Business Intelligence system has been designed to collect data from information systems in different bookshops and through "Extract, Transform, Load" process stores them to a Data Warehouse. After a report is requested by a user the system automatically generates the query and sends it to the Data Warehouse to display requested report in real-time. Which in comparison with databases, multidimensional reporting is done more quickly. In order to design the Data Warehouse, SQL Server Data Tools is used. It should be mentioned that due to unavailability of thousands of actual data we used SQL Server Data generator to generate unique data. This limitation has decreased somewhat the accuracy of the results. The comprehensive and accurate reports which the system provides help decision makers to adopt precise, timely and effective decisions.