31. 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.
32. Explain the Dashboard in the business intelligence.
A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.
33. 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.
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.
32. Explain the Dashboard in the business intelligence.
A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.
33. 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.
No comments:
Post a Comment