BUSINESS INTELLIGENCE INTERVIEW QUESTIONS

Most Important Frequently Asked Business Intelligence Interview Questions

Interview Quesions on Business Intelligence

1. Question 1. What Is Business Intelligence?

   Answer :

   Business Intelligence is a technology used for preparing the reports for multidimensional analyses.

2. Question 2. What Is Supervisor?

   Answer :

   Supervisor is the product is used to set up and maintain a secure environment for Business Objects products.

OLAP Interview Questions

3. Question 3. What Are The Various Business Objects Products?

   Answer :

   • User Module
   • Designer
   • Supervisor
   • Auditor
   • Set Analyzer
   • Info View (Web Intelligence)
   • Business Objects Software Development Kit (SDK)
   • Broadcast Agent etc.

4. Question 4. What Are The Different Multidimensional Analysis Methods Available In Business Objects?

   Answer :

   There are 2 Multidimensional analysis methods available in BO, they are:

   1. Slice and Dice.
   2. Drill Down.

OLAP Tutorial

5. Question 5. What Is Slice And Dice?

   Answer :

   Slice and dice mode enables you to switch the position of data in a report (for example, move data from columns to rows).

Data Warehousing Interview Questions

6. Question 6. What Are The Advantages Of Business Objects Over Other Dss?

   Answer :

   • User Friendly
   • Familiar Business Terms
   • Graphical Interface
   • Drag and Drop
   • Powerful reports in less time
   • Enterprise wide Deployment of documents using WebI
   • Customized dashboards using Application foundation and Business Objects SDK

7. Question 7. What Are The Different Schemas Supported By Bo Designer?

   Answer :

   • Star Schema
   • Snowflake Schema
   • Multistar Schema
   • Normalized production Schema
   • Data warehouse with aggregates

Data Warehousing Tutorial SAP BW Interview Questions

8. Question 8. What Are All The Data Providers Supported By Bo?

   Answer :

   • Queries on Universe
   • Stored procedure
   • Free hand SQL
   • Text files or Spread sheets
   • VBA Procedures
   • OLAP servers
   • SAP

9. Question 9. What Is A Hierarchy?

   Answer :

   • A hierarchy is an ordered series of related dimensions grouped together to perform multidimensional hierarchy.
   • The relationship between object in the hierarchy is one – to – many.

Business Ethics Interview Questions

10. Question 10. What Are The Types Of Hierarchy?

    Answer :

    There are two types of hierarchies:

    1. Default hierarchy: It contains the dimension objects in the order in which they are presented in the class.
    2. Custom hierarchy: A custom hierarchy is created from default hierarchy.

SAP BW Tutorial

11. Question 11. How Do You Create A Universe, Step-by-step Approach?

    Answer :

    Designing, Creating and maintaining a universe The phased in this include:

    • Planning: Break down the information system into functional areas.
    • Analysis: Analyze the information needs of users
    • Design: Design a conceptual schema
    • Design: The specification of a universe
    • Implementation: Create a universe with DESIGNER
    • Test the universe with BUSINESSOBJECTS/WEBINTELLIGENCE
    • Distribute the universe
    • Repeat the above steps for other universes
    • Maintenance: Update and maintain the universe
    • Notify end users of changes.

Business Development Interview Questions

12. Question 12. What Is Scope Of Analysis?

    Answer :

    • "Scope of analysis" means a subset of data, returned by a query that you will use for analysis in your report.
    • The data for your scope of analysis does not appear in the report until you decide that you want to use it in analysis.

OLAP Interview Questions

13. Question 13. What Is Join?different Types Of Joins?

    Answer :

    • Join is the relation that occurs between the two tables that helps to combine into one table.
    • The purpose of join is that to restrict the Cartesian product.
    • The join is specified in the Where clause of the sql statement.

    The different types of joins are:

    • Equi join - is based on the equality between the values in the column. Because the same column is present in both tables, the join synchronizes the two tables.
    • Outer join - An outer join links two tables, one of which has rows that do not match those in the common column of the other table.
    • Theta join - A theta join links tables based on a relationship other than equality between two columns.
    • Shortcut join - Shortcut joins can be used in schemas containing redundant join paths leading to the same result, regardless of direction.

Business Ethics Tutorial

14. Question 14. What Is A Data Provider?

    Answer :

    The data source (Query) is called as the data provider.

15. Question 15. Did You Do Metadata Reporting In Bo?

    Answer :

    Metadata reporting of BO is possible. BO provides a separate universe which actually contains repository tables, objects etc.Using this Universe one can do metadata reporting in BO.

DWBI Interview Questions

16. Question 16. What Are The Ways By Which U Can Distribute The Universe?

    Answer :

    There are two ways to distribute a universe:

    1. through the repository 
    2. through the file system.

17. Question 17. What Are The Main Components Of The Designer Interface?

    Answer :

    The main components that interact in the designing of universe are :

    • Table browser - The table browser is used to choose the tables and columns.
    • The Structure pane - The Structure pane refers the database structure of the universe.
    • The Universe pane - The Universe pane refers the components in which it is going to use in BO or WEBI documents.

Business administration Interview Questions

18. Question 18. What Are New In Bo 5.1?

    Answer :

    • Save business objects documents in Adobe Portable Document Format (PDF)
    • Add hyperlinks to reports such as mail addresses and web site addresses.
    • These hyperlinks are maintained when you save the report in HTML or PDF.
    • Zero Administration – Only the business objects client software installed on the windows pc; all middleware is stored and administered on the web intelligence web server and the server side processing is handled by the web intelligence system.

Data Warehousing Interview Questions

19. Question 19. What Is The Repository?

    Answer :

    The repository is the database in which the information about the users and data is present. It is created and maintained by the general supervisor. It is used to share resources of business objects.
    It comprises of three domains:

    • Universe domain – It holds all the exported universes and there may be more than one universe domain in the repository.
    • Document domain – It holds all exported documents, templates, scripts, and lists of values.
    • Security domain - secured connections are stored in this.

20. Question 20. What Are The Tasks Of The Universe Designer?

    Answer :

    The responsibilities that universe designer has: 

    • Designing, Creating and maintaining the Universe. 
    • Distributing the Created Universes.

Oracle BPM Interview Questions

21. Question 21. What Is The Difference Between Built-in-strategies And External Strategies?

    Answer :

    Built-In-Strategies:

    • Extracting the joins with tables
    • Detect cardinalities in joins
    • Create default classes and objects from the tables
    • Objects - In this we can set how the objects to be displayed in the universe pane
    • Joins - In this we can set how the joins between the tables has to be retrieved like matching column names or matching names etc.
    • Tables - In this it will reads the table structure from the database.

    The other strategies:

    • Setting the number of rows to be retrieved - default 100
    • The number of row retrieved from database
    • The execution time of the query based on the number of minutes specified.
    • The maximum size of the long text objects.

    External Strategies: External strategies are declared in STG section of .PRM file. We can create the external strategy using either sql or flat file.

22. Question 22. What Is Strategy?

    Answer :

    The strategy is the script that automatically extracts the structural information from the database or flat file.

    • Built-in-strategies
    • External strategies

Topic: Business Intelligence Interview Questions
Interview Quesions on Business Intelligence