Q. What Is Business Intelligence?

Transcription

Business Intelligence Interview Questions with AnswersQ. What is Business Intelligence?A1. Business intelligence (BI) is a broad category of applications and technologies for gathering,storing, analyzing, and providing access to data to help enterprise users make better businessdecisions.A2. Business Intelligence is process of exploring data inorder to take strategic decisionswhether to drive profitability or to manage costsA3. Business intelligence (BI) is a broad category of application programs and technologies forgathering, storing, analyzing, and providing access to data to help enterprise users make betterbusiness decisions. BI applications include the activities of decision support, query andreporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining.A4. Business Intelligence is a technology based on customer and profit oriented models thatreduces operating costs and provide increased profitability by improving productivity, sales,service and helps to make decision making capabilities at no time.Q. What is a Universe?A1. Universe is a symantec layer between database and the actual user useing the objects forquery. It hides the typical database structure from the user.A2. A "universe" is a "Business object" terminology. Business objects also happens to be thename of the company. The universe is the interfacing layer between the client and thedatawarehouse . The universe defines the relationship among the various tables in thedatawarehouse.A3. Universe is ann layer between the backend Database and Front end tool of reports. In ThisWe have an Metadat about the database and connection,Classes, and Objects.In The Universethe dta structure will be modified as Business Terminology and user can easily understand .A4. A universe is a business-oriented mapping of the data structure found in databases: tables,columns, joins, etc. It can represent any specific application, system, or group of users. Forexample, a universe can relate to a department in a company such as marketing or accounting.In the BusinessObjects User module, universes enable end users to build queries from whichthey can generate and perform analysis.1/6

Business Intelligence Interview Questions with AnswersQ. Name some of the standard Business Intelligence toolsin the market?A1. Some of the standard Business Intelligence tools in the market According to thereperformance1)MICROSTRATEGY2)BUSINESS OBJECTS,CRYSTAL REPORTS3)COGNOS REPORT NET4)MS-OLAP SERVICESA2.1. Seagate Crystal report2. SAS3. Business objects4. Microstrategy5. Cognos6. Microsoft OLAP7. Hyperion8. Microsoft integrated servicesQ. What is OLAP?A1. OLAP stands for Online Analytical Processing. It is used for Anaytical reportingA2. OLAP: online analytical processThis helps to do Business analysis of you data, but normal reporting tools are not supporting toBusiness analysis. This is the major difference between reporting tool and OLAP tool.A3. OLAP is an Online Analytical Process, Which used especially for analysis purpose but notfor reporting. It is a GateWay between the Business user and DWH.Q. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP?Examples?2/6

Business Intelligence Interview Questions with AnswersA1.Cubes in a data warehouse are stored in three different modes. A relational storage model iscalled Relational Online Analytical Processing mode or ROLAP, while a Multidimensional OnlineAnalytical processing mode is called MOLAP. When dimensions are stored in a combination ofthe two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP.MOLAPThis is the traditional mode in OLAP analysis. In MOLAP data is stored in form ofmultidimensional cubes and not in relational databases. The advantages of this mode is that itprovides excellent query performance and the cubes are built for fast data retrieval. Allcalculations are pre-generated when the cube is created and can be easily applied whilequerying data. The disadvantages of this model are that it can handle only a limited amount ofdata. Since all calculations have been pre-built when the cube was created, the cube cannot bederived from a large volume of data. This deficiency can be bypassed by including onlysummary level calculations while constructing the cube. This model also requires hugeadditional investment as cube technology is proprietary and the knowledge base may not existin the organization.ROLAPThe underlying data in this model is stored in relational databases. Since the data is stored inrelational databases this model gives the appearance of traditional OLAP’s slicing and dicingfunctionality. The advantages of this model is it can handle a large amount of data and canleverage all the functionalities of the relational database. The disadvantages are that theperformance is slow and each ROLAP report is an SQL query with all the limitations of thegenre. It is also limited by SQL functionalities. ROLAP vendors have tried to mitigate thisproblem by building into the tool out-of-the-box complex functions as well as providing the userswith an ability to define their own functions.HOLAPHOLAP technology tries to combine the strengths of the above two models. For summary typeinformation HOLAP leverages cube technology and for drilling down into details it uses theROLAP model.Comparing the use of MOLAP, HOLAP and ROLAPThe type of storage medium impacts on cube processing time, cube storage and cubebrowsing speed. Some of the factors that affect MOLAP storage are:Cube browsing is the fastest when using MOLAP. This is so even in cases where noaggregations have been done. The data is stored in a compressed multidimensional format andcan be accessed quickly than in the relational database. Browsing is very slow in ROLAP about3/6

Business Intelligence Interview Questions with Answersthe same in HOLAP. Processing time is slower in ROLAP, especially at higher levels ofaggregation.MOLAP storage takes up more space than HOLAP as data is copied and at very low levels ofaggregation it takes up more room than ROLAP. ROLAP takes almost no storage space as datais not duplicated. However ROALP aggregations take up more space than MOLAP or HOLAPaggregations.All data is stored in the cube in MOLAP and data can be viewed even when the original datasource is not available. In ROLAP data cannot be viewed unless connected to the data source.MOLAP can handle very limited data only as all data is stored in the cube.A2.OLAP – Online analytical ProcessesMOLAP – Multidimensional Online analytical Processes (Cubes)ROLAP – Relational Online analytical Processes (RDBMS)HOLAP – Combination of MOLAP & ROLAPDOLAP – Desktop Online analytical Processes (Cubes are stored in desktop also)Q. How to Import universes and user from business object6.5 to XI R2, it is showing as some ODBC error is there anysetting to change?A1. You can import universes through import option in file menu.if ur odbc driver is notconnecting then u can check ur database driverQ. What are the various modules in Business Objectsproduct Suite?4/6

Business Intelligence Interview Questions with AnswersA1.SupervisorSupervisor is the control center for the administration and security of your entireBusinessObjects deployment.DesignerDesigner is the tool used to create, manage and distribute universe for BusinessObjects andWebIntelligence Users. A universe is a file that containe connection parameters for one or moredatabase middleware and SQL structure called objects that map to actual SQL structure in thedatabase as columns,tables and database.BusinessObjects Full client Reporting toolHelps to create businessobjects reports based on the universe and also from the other datasources.BusinessObjects Thin client Reporting toolHelps to querry and analysis on the universe and also share the report among other users. Itdoesn't require any software, just need a webbrowser and the system connected to thebusinessobjetcs server.AuditorTool is used for monitor and analysis user and system activity.Application FoundationThis module covers a set of products which is used for Enterprise Performance Management(EPM). The tools areDashboard managerScorecardPerformance Management ApplicationsQ. What is Hyperion? Is it an OLAP tool? what is thedifference between OLAP and ETL tools? What is the futurefor OLAP and ETL market for the next five years?5/6

Business Intelligence Interview Questions with AnswersA1.What is Hyperion?- Its an Business Intelligence tools. Like Brio which was an independent product bought overmy Hyperion has converted this product name to Hyperion Intelligence.Is it an OLAP tool?- Yes. You can analyse data schemas using this tools.OLAP: Its an online analytical processing tool. There are various products available for dataanalysis.ETL: Extract , Transform and Load. This is a product to extract the data from multiple/singlesource transform the data and load it into a a table,flatfile or simply a target.There is a quite a bit compitation in the market with regard to the ETL product as well as theOLAP products. These tools would definately be widely used for data load and data analysispurpose.A2.What is Hyperion?- Its an Business Intelligence tools. Like Brio which was an independent product bought overmy Hyperion has converted this product name to Hyperion Intelligence.Is it an OLAP tool?- Yes. You can analyse data schemas using this tools.OLAP: Its an online analytical processing tool. There are various products available for dataanalysis.ETL: Extract , Transform and Load. This is a product to extract the data from multiple/singlesource transform the data and load it into a a table,flatfile or simply a target.There is a quite a bit compitation in the market with regard to the ETL product as well as theOLAP products. These tools would definately be widely used for data load and data analysispurpose.6/6

Business Intelligence Interview Questions with Answers Q. Name some of the standard Business Intelligence tools in the market? A1. 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 A2. 1. Seagate Crystal report 2. SAS 3. Business