Business intelligence

Cubes allow to store larges amounts (usually track history) of data and get very good performance. Security is very detailed and it can be applied on "member level" which is an individual value in a column. Cubes usually track history so user get access to "point in time" data and accurate data. My favorite example is top 1 customer that moves its location from London to Bristol with cubes (or more data warehouses) historic data will not move to Bristol and it will remain in London which is very often not the case in providing reporting information from operational systems.

The following are the standard Business Intelligence tools in the market:

☛ Business object crystal reports

☛ Micro strategy

☛ MS-Olap services

☛ Cognos report net

1:M

Batch processing can be used to schedule reports. Objects can be also be used for batch processing. Batch processing can be used to also select the objects to be processed.

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.

Some of the standard Business Intelligence tools in the market According to there performance

1)MICROSTRATEGY

2)BUSINESS OBJECTS,CRYSTAL REPORTS

3)COGNOS REPORT NET

4)MS-OLAP SERVICES

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.

☛ JasperSoft:- BI tool used for reporting, ETL etc.

☛ Pentaho:- Has data mining, dashboard and workflow capabilities.

☛ Openl:- A web application used for OLAP reporting.

Slicing and dicing of business objects is used for a detailed analysis of the data. It allows changing the position of data by interchanging rows and columns.

That is more self-explanatory than previous questions. Ability to view or create report by users is the short answer but usually reporting tools like SSRS are much more powerful and they allow to set up subscriptions, provider reports in different usable for users format, secure reports and so on.

Object qualification is an attribute of an object that helps to determine how it can be used in multidimensional analysis.

☛ 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.

A BOMain.key file contains all relevant information about the repository. It contains the address of the repository security domain.

This is open question and answers will vary but the candidate might say ETL (SSIS), Data Warehouse and Cubes (SSAS) and Reporting (SSRS). This list can be longer and can include data mining, master data management, data profiling, data cleansing, analysis and data gathering also can be added here.

► Business Objects Reporter

► Reporting & Analyzing tool

► Designer

► Universe creation

► database interaction

► connectivity

Supervisor - For Administrative purposes

Webintelligence - Access of report data through internet

BroadCast Agent - For scheduling the reports

Data Integrator - The ETL tool of Business Objects, designed to handle huge amounts of data