Most Asked Business Intelligence Interview Questions and Answers
What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?
OLAP – On-Line Analytical Processing.
Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.
MOLAP – Multidimensional OLAP.
This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.
Targeted at groups of users because it’s a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.
DOLAP – Desktop OLAP.
Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).
Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It’s like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.
ROLAP – Relational OLAP.
Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases.
Used for large departments or groups because it supports large amounts of data and users.
HOLAP:Hybridization of OLAP, which can include any of the above.
From where you Get the Logical Query of your Request?
Name some of the standard Business Intelligence tools in the market.
Business intelligence tools are to report, analyze and present data. Few of the tools available in the market are:
• Eclipse BIRT Project:- Based on eclipse. Mainly used for web applications and it is open source.
• Freereporting.com:- It is a free web based reporting tool.
• JasperSoft:- BI tool used for reporting, ETL etc.
• Pentaho:- Has data mining, dashboard and workflow capabilities.
• Openl:- A web application used for OLAP reporting.
Why an infocube has maximum of 16 dimensions?
Major Challenges You Faced While Creating the RPD?
Explain the Dashboard in the business intelligence.
What is BAS? What is the function?
The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft? Applications and consultation to customers with their computer-related tasks.
What are Global Filter and how they differ From Column Filter?
Column filter- simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.
Global filter- Not sure. I understand this filter will have impact on across the application but I really don’t understand where and how it can be user. I heard of global variables but not global filters.
Explain the SQL Server 2005 Business Intelligence components.
• SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.
• SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.
• SQL Server Reporting Services:- Used for Data presentation and distribution access.
Name some of the standard Business Intelligence tools in the Market?
Some of the standard Business Intelligence tools in the market According to their performance
- BUSINESS OBJECTS,CRYSTAL REPORTS
- COGNOS REPORT NET
- MS-OLAP SERVICES
- Seagate Crystal report
- Business objects
- Microsoft OLAP
- Microsoft integrated services