Page 194 - DCAP606_BUSINESS_INTELLIGENCE

Sartaj Singh, Lovely Professional University
Unit 14: Reporting Tools

Unit 14: Reporting Tools Notes

CONTENTS
Objectives

Introduction
14.1 Reporting Tool Functionalities

14.2 Reporting Services Using SQL Server
14.2.1 Architecture
14.2.2 Working with SQL Server Reporting Services

14.3 Analysis Services Using SQL Server
14.4 Summary
14.5 Keywords

14.6 Review Questions
14.7 Further Readings

Objectives

After studying this unit, you will be able to:

Identify the functionalities of reporting tools
Discuss the reporting services using SQL Server
Explain the analysis services using SQL Server

Introduction

Reporting software is used to generate human-readable reports from various data sources.
Business operations reporting and dashboard are the most common applications for a reporting
tool. Market share-leading reporting solution is from Microsoft Microsoft SQL Server Reporting
Services is the solution of choice for many businesses that require enterprise reporting capabilities.
In this unit, you will learn about functionalities of reporting tools. Later on in this unit, reporting
services using SQL server will be discussed with appropriate screenshots. Finally, analysis
services using SQL server will be introduced.

14.1 Reporting Tool Functionalities

Following are the reporting tool functionalities:
1. Front End: Data is ineffective if all it does is sitting in the data warehouse. As an outcome,
the production layer is of very high significance.

2. Data source connection capabilities: There are two types of data sources:
The relationship database

The OLAP multidimensional data source

LOVELY PROFESSIONAL UNIVERSITY 189