Search This Blog

Tuesday, July 15, 2008

Business Intelligence Interview Questions

I have got these queries from someone and I would like to share my views. I dont claim my answers to be correct and hence wherever you dont agree, please let me know and share your views.
If you have any questions or comments, please post them.
Question:How you generally Approach to ur Analytics Project?
Answer: Any project should start from defining the scope of the project and the approach
should be not to deviate from the scope.
Then the project should be functionally divided into smaller modules generally done by
project managers alongwith technical and functional leads.
The functional leads then decide on majorly three things:
1. According to the defined scope of the project they start gathering requirements while
interacting with the clients.
2. They had a discussion with the technical leads and try to reach a solution.
3. Technical leads decides what schemas to create and what requirements are going to
fulfill by that schema.
Technical leads discuss all this with the developers and try to close requirements.
Simultaneously testing and deployment is planned in a phased manner.

Question: How we are going to decide which schema we are going to implement in the data warehouse?
Answer: One way is what is mentioned in Question above.
If you ask me to blindly create schemas for the warehouse without knowing any requirements,
I will simply first divide the schemas on the basis of functional areas of an Organisation
which are similar to the modules in an ERP like sales, finance, purchase, inventory,
production, HR etc.
I will broadly describe the expected analysis an organisation would like to do in every
module. I think this way you would be able to complete at least 40-50 % of the
requirements. To move ahead, study the data and business and you can create few more
schemas.

Question: What are the Challenges You Faced while making of Reports?
Answer: Making of an report has never been a difficult task. But problem comes when users
are reluctant to adopt a new system. I have experienced that if you are not able to create
the report in exactly the way they used to see, they will keep asking for the changes. Your
approach should be to first show them what they want to see and then add more information
in the report.

Question: What you will do when your Report is not Fetching Right Data?
Answer: this is the biggest problem in report creation and verification. There could be two
reasons for report not fetching the right data.
1. Mostly clients do not have correct data in their database and on top of that to correct
the results they make some changes at the report level to bring the desired result which
you may not e aware of while creating the reports. Clients try to match the data with their
existing reports and you never get the correct results. you try to discover the things and
at later stage come to know of all these problems and you are held responsible for this
delay. Hence always consult the SPOC(Single Point of Contact) and try to understand the
logic they have used to generate their reports.
2. If the database values are correct, there there could be a problem with the joins and
relations in the schema. You need to discover that analysing and digging deep into the
matter.

There are more questions which I will try to answer later.
The questions are very specific to OBIEE and I dont have much experience in that. Hence you may not agree to my answers, but wherever please post a comment and let me know too.


Question: How analytics Process Your Request When you Create your Requests.
Answer: If the Question means how does Oracle BI Analytics Server processes the user requests, the answer is- Oracle BI server converts the logical SQL submitted by the client into optimised physical SQL which is then sent to the backend database. Also in between it performs various tasks like converting the user operations like user selections to form a logical SQL, checking and verifying credentials, breaking the request into threads(as Oracle BI is a multi threaded server), processes the requests, manages the cached results, again converting the results received from the database into user presentable form etc.



Question: From where u Get the Logical Query of your Request?
Answer: The logical SQL generated by the server can be viewed in BI Answers. If I have not understood the question, Please raise your voice.



Question: Major Challenges You Faced While Creating the RPD??????
Answer: Every now and then there are problems with the database connections but the problem while creating the repository RPD files comes with complex schemas made on OLTP systems consisting of lot of joins and checking the results. Th type of join made need to be checked. By default it is inner join but sometimes the requirement demands other types of joins. There are lot of problems with the date formats also.


Question: What are Global Filter and how thery differ From Column Filter?
Answer: Column filter- simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.
Global filter- Not sure. I understand this filter will have impact on across the application but I really dont understand where and how it can be user. I heard of global variables but not global filters.


How to make the Delivery Profilers Work?



When we are Use SA System how Does SA Server understand that It needs to use it For Getting

the User Profile information?



Where to Configure the Scheduler?
Answer: I am not sure if Iam correct but we configure the OBIEE schedular in database.



Question: How to hide Certain Columns From a User?
Answer: Application access level security- Do not add the column in the report, Do not add the column in the presentation layer.




Question:How can we Enable Drills in a Given Column Data?
Answer: To enable Drill down for a column, it should be included in the hirarchy in OBIEE. Hyperion IR has a drill anywhere feature where dont have to define and can drill to any available column.



Question: Is Drill Down Possible without the attribute being a Part of a Hierarchical Dimension?
Answer: No


Question: How do u Conditional Format.?
Answer: while creating a chat in BI Answers, you can define the conditions and can apply colour formatting.



Question: What is Guided Navigation?
Answer: I think it is just the arrangement of hyperlinks to guide the user to navigate between the reports to do the analysis.

How is Webcat File Deployed Across Environment?



Question: How the users Created Differs From RPD/Answers/Dashboards Level?????
Answer: RPD users can do administrator tasks like adding new data source, create hirarchies, change column names where as Answers users may create new charts, edit those charts and Dashboard users may only view and analyse the dashboard or can edit dashboard by adding/removing charts objects.


Question: Online/Offline Mode how it Impact in Dev and Delpoyment????
Answer: Online Mode- You can make changes in the RPD file and push in changes which will be immediately visible to the users who are already connected. This feature we may use in production environment.
Offline mode- can be useful in test or development environment.


Questions: Explan me the Schema in Your Last Project???????



DB What happens if u Reconcile/Sync Both????

15 comments:

Ravi Kiran Jakka said...

Thanx Boss,

injected sum in my brain.

Reg,

Ravi

Ravi Kiran Jakka said...

If you could post some Faq's on Hyperion I would be grateful to you!

thank you for all the info sharing...

Manohar Rana said...

Hi Ravi,

I have posted some interview questions on Hyperion Essbase.
http://businessintelligencedw.blogspot.com/2008/09/hyperion-essbase-interview-questions.html

Let me know your views.

Regards
Manohar Rana

Unknown said...

Hi Manohar,

I would like to have the pdf for the hyperion planning and Hyperion financial reporting.plz..........

anki.hyperion said...

Hi Manohar,
Can u plz tell me what r the different types of reports we generated thru web analysis.wt are canned reports & ad hoc reports..
thnx

Anonymous said...

hi Manohar,
Can you send me installation steps for hyperion essbase,planning,shared services,IR and web analysis..pls reply me as soon as possible

Regars,
Soundar

Sagar Saiboyani said...

Hi Manohar.

thanks for publishing these question for new learners.
i would like to know more questions on Oracle Business Intelligence (OBI). if you publish this it would be great help for all of us.
please send me the link to saisagar55@gmail.com

Regards
Sagar

Unknown said...

Hi Manohar,
the material is very useful, thx.
could u send any interview material on OBI.
Reg,
Sridevi

Shahzad said...

tomorrow is my interview for BI post this post would definitely help me. Thanks

krishna reddy said...

good questions thanks for support,try to post more if possible

Anonymous said...

could you add some more questions on obiee cache ,purging, dashboards etc

Unknown said...

Where to Configure the Scheduler?

my answer is BI devilers.

Sridhar Sunchu said...

Job Manager
File-> Configure

Pls go through this
http://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/

Siva Kumar Budagam said...
This comment has been removed by the author.
Siva said...

Thanks for sharing this Manohar.
In Business Objects if filter is applied on one report block its called local filter and if the filter is applied to all the report blocks its called global filter.