—Business intelligence (BI), which has proven to be a key strategy to improve business benefits and performance, is a crucial need for information and communications technology (ICT) industry. Data warehousing and reporting are two concepts that BI provides to create meaningful information from integrated data. Microsoft offers SQL server reporting services (SSRS) as a reporting solution to provide a ready to use, scalable, versatile platform to create, deploy and manage reports. There are numerous studies that define data warehouse and reporting, their components, usage and benefits in the literature. In addition to such studies, this paper presents implementation scenarios of taking reports from different data sources to show difference between taking report from operational database and data warehouse by using Adventureworks database.
—Adventureworks, business intelligence, data warehouse, reporting examples, SQL server reporting services.
D. Gunduz and E. Arslan is with the Department of Computer Engineering, Faculty of Engineering, Istanbul University, 34320, Avcilar, Istanbul, Turkey (e-mail: firstname.lastname@example.org, email@example.com).
M. E. Azizler is with Business Information Systems, Bogazici University, Hisar Campus, 34342, Bebek/İstanbul (e-mail: firstname.lastname@example.org).
Cite: Derya Gunduz, M. Ergul Azizler, and Emel Arslan, "Implementation Scenarios of Reporting from Data Warehouse for Business Intelligence," International Journal of Modeling and Optimization vol. 5, no. 3, pp. 211-215, 2015.