Cognos interview questions – test yourself

Cognos is a popular business intelligence software, especially in the environment of big companies that can benefit from the full functionality. Featuring social collaboration and analytics for business users, and well known with an easy-to-use interface, Cognos has become very popular in recent years, and nothing suggests a change to this trend. With the popularity of Cognos grows the demand for people who can actually work with the software, for people help other employees to understand how Cognos works, and to get the best out of it.

Technical and non-technical questions

If you happen to apply for a system engineer, programmer, or desktop support specialist job in a company that uses Cognos, you can expect a few questions that relate to your knowledge of the software.

Keep in mind though that interviewing for any IT job, you will have to deal with many non-technical questions as well. The core of the interview will always consist in personal and behavioral questions, and unless you manage to answer these questions, your great technical skills won’t save you in an interview. Someone else will be selected at the end of the day.

This article is dedicated to technical questions, and questions related to Cognos. But you should study also the articles dedicated to personal and behavioral questions, if you want to succeed in your interview.

Interview questions related to Cognos

  1. How did you discover Cognos and when did you work with it for the first time? (Try to be precise in your answer, show them that you have been working with Cognos for a long time, and that you understand why businesses use it.)
  2. What do you consider the major benefits company gains from using Cognos? (Try to compare it with other BI solutions from Oracle or Microsoft, show the advantages, from your point of view.)
  3. If you should compare Cognos to other similar products and solutions, say how it is better and how it can improve. (Try to say both good and bad things, but do not criticize the software much.)
  4. What do you like the most on working with Cognos, and what does annoy you while working with it?
  5. Can you give us any practical example of how you utilized Cognos in a company to achieve better end results of the business? (everything is about results. Unless you understand how can a company benefit from using Cognos, bearing in mind the costs associated with implementing and running the software, you won’t make much of an impression in an interview.)
  6. When looking on different groups of stakeholders, how can they benefit from Cognos? (Similar question to the previous one, and you should explain how the BI soft helps each employee with their everyday tasks and productivity.)
  7. Name at least six main features of Cognos 10 BI, and define each feature with one sentence.
  8. Is it possible to apply certain filters on the list of values in the value prompt in Cognos?
  9. How would you convert crosstab into list?
  10. It is possible to create a dynamic column name in Cognos?
  11. What is the importance of framework manager in Cognos reporting?
  12. Is there any difference between aggregation and roll-up aggregation?
  13. Give an example when it is good to use a generated prompt.
  14. What are the components of Cognos connection?
  15. Why do they include tree prompt in Cognos 10? How did it improve from the previous versions?
  16. Is it possible to create various user permissions in Cognos? If yes, define the different levels and their permissions.

Download a full list of questions in .PDF format, and practice your interview answers later:

Not every interviewer is a technician

Various people can lead an interview with you. It can be a technical expert, CTO, HR manager, or an HR generalist. Needless to say, each of these people possesses a different level of technical skills, and their specialization will be reflected in the questions they will ask you.

You should always adjust your answers accordingly. If a person talking to you knows nothing about IT, or about Cognos specifically, it makes not sense to try to make an impression on them with plethora of technical terms, and with a language they can not understand.

Such terms and language makes sense only when you talk to a technician. Consider the situation carefully, and try to observe the gestures of the interviewer. If they look confused or irritated, they likely do not understand your language, and you should simplify it.

Small interview setting, the HR generalist lead an interview

Conclusion

Cognos is a specific software, and you won’t compete with ten other job seekers for the position that deals with it. You do not need to be better than anyone else–you just need to be good enough to get the job. Many times, you can actually be the only person applying.

Nevertheless, being alone doesn’t change nothing on a fact that you should still try your best to prepare for the interview. Unless you make a good impression on the people in the company, they will not hire you. Try to prepare for both technical and non-technical questions, and adjust your language to the technical skills of a person who leads the interview with you.

Continue your preparation with Interview Penguin:

Antony is the administrator of Interview Penguin. He is responsible for customer service and website maintenance. Posts and pages published by him are either generic posts (contact, privacy, etc), or posts from guest bloggers who do not have an account with Interview Penguin.