1.What is BI?
A. Business Intelligence (BI) is the use of computing technologies for the identification,discovery and analysis of business data -like sales revenue,products,costs and incomes.
2.Difference b/w BI and DWH?
3.Explain the concepts and capabilities of Business Intelligence?
A. Business Intelligence helps to manage data by applying different skills,tecnologies,security and risks.This also helps in achieving a better understanding of data. Business intelligence can be considered...........
4.Explain the SQL server 2005 Business Intelligence components?
A. SQL Server Integration Services :-Used for data transformation and creation. Used in data aquisition from a source system.....
5.Explain the concepts and capabilities of Business object?
A. A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behaviour of the business associated with the entity.............
5.What is Universe?
A. A Universe connects client to the data warehouse. It is a file defining relationships amongest the tables in the warehouse ,classes and objects,database connection details.........
6.What is Security Domain in Business Objects?
A. Security Domain in Business Objects is a domain containing all security information like login credentials etc. It checks for users and privileges...........
7.What is Security Level used in BO?
A. Security level used in BO:- Row level,Coloumn level..........
8.What is Object Qualification?
A. Object Qualification is an attribute of an object that helps to determine how it can be used in multidimentional analysis.........
9.What is BOMain.Key?
A. A BOMain.Key file contains all relevant information about the repository. It contains the address of the repository security domain.........
10.Explain the functional differences b/w BO and COGNOS?
A. Business Objects in business intelligence are entities of the business. COGNOS makes BI and performance planning software............
11.What is Data Mart?
A. A Data Mart is the access layer of the data warehouse environment that is used to make data accessible to it's users.It is subset of Data Warehouse.
12.What is advantages and disadvantages of data warehouse?
A. Advantages of using data warehouse includes:
1.Integrating data from multiple sources.
2.Performing new types of analysis and reducing cost to access historical data.
3.Improving turn around time for reporting and analysis.
4.Supporting ad-hoc query and reporting.
Disadvantages:
1.Long initial implementation time and associated high cost.
2.Difficult to accommodate changes in data types and ranges,data source schema,indexes and queries.
3.Data owners lose control over their data,raising ownership,privacy and security issues.
4.Adding new data source takes time and associated high cost.
13.What are the tools associated with SSIS?
A. We use Business Intelligence Development Studio(BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Prijects.
We use SSMS to manage the SSIS Packages and Projects.
14.Share experienced working with data warehouses?
A. SSIS is in most cases used for data warehoudes so knowledge of Data wraehouses Designs
is very useful.
A. Business Intelligence (BI) is the use of computing technologies for the identification,discovery and analysis of business data -like sales revenue,products,costs and incomes.
2.Difference b/w BI and DWH?
3.Explain the concepts and capabilities of Business Intelligence?
A. Business Intelligence helps to manage data by applying different skills,tecnologies,security and risks.This also helps in achieving a better understanding of data. Business intelligence can be considered...........
4.Explain the SQL server 2005 Business Intelligence components?
A. SQL Server Integration Services :-Used for data transformation and creation. Used in data aquisition from a source system.....
5.Explain the concepts and capabilities of Business object?
A. A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behaviour of the business associated with the entity.............
5.What is Universe?
A. A Universe connects client to the data warehouse. It is a file defining relationships amongest the tables in the warehouse ,classes and objects,database connection details.........
6.What is Security Domain in Business Objects?
A. Security Domain in Business Objects is a domain containing all security information like login credentials etc. It checks for users and privileges...........
7.What is Security Level used in BO?
A. Security level used in BO:- Row level,Coloumn level..........
8.What is Object Qualification?
A. Object Qualification is an attribute of an object that helps to determine how it can be used in multidimentional analysis.........
9.What is BOMain.Key?
A. A BOMain.Key file contains all relevant information about the repository. It contains the address of the repository security domain.........
10.Explain the functional differences b/w BO and COGNOS?
A. Business Objects in business intelligence are entities of the business. COGNOS makes BI and performance planning software............
11.What is Data Mart?
A. A Data Mart is the access layer of the data warehouse environment that is used to make data accessible to it's users.It is subset of Data Warehouse.
12.What is advantages and disadvantages of data warehouse?
A. Advantages of using data warehouse includes:
1.Integrating data from multiple sources.
2.Performing new types of analysis and reducing cost to access historical data.
3.Improving turn around time for reporting and analysis.
4.Supporting ad-hoc query and reporting.
Disadvantages:
1.Long initial implementation time and associated high cost.
2.Difficult to accommodate changes in data types and ranges,data source schema,indexes and queries.
3.Data owners lose control over their data,raising ownership,privacy and security issues.
4.Adding new data source takes time and associated high cost.
13.What are the tools associated with SSIS?
A. We use Business Intelligence Development Studio(BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Prijects.
We use SSMS to manage the SSIS Packages and Projects.
14.Share experienced working with data warehouses?
A. SSIS is in most cases used for data warehoudes so knowledge of Data wraehouses Designs
is very useful.
Hello,
ReplyDeleteOne of the reason for MSBI is popular If you use effective business intelligence training in your organization, you can improve the decision making processes at all levels of management and improve your tactical strategic management processes.
The above article question and answers are useful MSBI job-seekers.All the Msbi Job-sekers compulsory read this article.