Page 205 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes 14.5 Keywords

Ad Hoc Reporting: Ad Hoc Reporting allows end users to easily build their own reports and
modify existing ones with little to no training.
Embedded Reporting: It enables organizations to embed reports directly into business applications
and web portals, enabling users to consume reports within the context of their business process.

Interactive Sorting: Applying sort capabilities to a report enable users to sort the data by any of
the columns the report contains in ascending or descending order.

Matrix: A format that supports row and column groups, and which can display aggregated
summary data in the cells where row groups and column groups intersect one another, similarly
to a pivot table or crosstab.
Report Designer: Report Designer is a graphical tool that is hosted within the Microsoft Visual
Studio IDE.
Table: A tabular format in which data is displayed in rows and columns. You can create a
hierarchy of rows to reflect groupings in your data and display group totals.
UDM: It provides an intermediate logical layer between the physical relational database used as
the data source and the proprietary cube and dimension structures that are used to resolve user
queries.

14.6 Review Questions

1. Discuss about reporting tool functionalities.
2. “After using SSRS, the architecture is just like a small operating system”. Elaborate.
3. Discuss about working with SQL Server Reporting Services.
4. Explain about the analysis Services Using SQL Server.

Answers: Self Assessment

1. Relationship database 2. Reporting software

3. True 4. True
5. True 6. Analysis Services
7. Memory and storage

14.7 Further Readings

Books Carlo Vercellis (2011). “Business Intelligence: Data Mining and Optimization for
Decision Making”. John Wiley & Sons.
David Loshin (2012). “Business Intelligence: The Savvy Manager’s Guide”. Newnes.
Elizabeth Vitt, Michael Luckevich, Stacia Misner (2010). “Business Intelligence”.
O’Reilly Media, Inc.

200 LOVELY PROFESSIONAL UNIVERSITY