Interview Questions

Q1 : Can you elaborate about Cognos Cube Designer and modelling workflow? A : The detailed steps in Cognos Cube Designer and modelling workflow are: For the First step model your cube definition in Cognos Cube Designer. choose the database schema. You can import the required metadata. You can define the dimensions and measures. You can create the Dynamic cube. Then Auto-generate cube. Then you can use primary-foreign key relationship to populate dimensions. You can manually model the cube. Now

Question 1 : What Is Talend? Answer : Talend is an open-source software integration platform/vendor. Talend offers data integration and data management solutions. The various integration software and services for big data, cloud storage, data integration, data management, master data management, data quality, data preparation, and enterprise applications are provided by Talend. But Talend’s first product i.e. Talend Open Studio for Data Integration is more popularly referred to as Talend. Question 2 : What is a Job Design in Talend?

Question 1 : What is data visualization? Answer : Data visualization refers to the techniques used to organize and present information intuitively (e.g. points, lines, or bars). According to Tableau, using Tableau visualizations, you gain the ability to quickly answer questions; your data becomes a competitive advantage instead of an underutilized asset. Question 2 : Name the file extensions in Tableau. Answer : There are many file types and extensions in Tableau, some of them are: Tableau Workbook (.twb) Tableau

Q : Explain what is TIBCO Spotfire? A : Spotfire Enterprise Player, when combined with Core Lab’s RAPID database, allows our clients to perform analytics on the data sets being generated in our Joint Industry Projects. Each active Joint Industry Project has a Spotfire Analytical Template associated with it which allows our clients to investigate the various data sets through tabular and graphical displays. Each display can be filtered by a wide variety of data types stored in our RAPID database

Question 1 : What is Pentaho Data mining? Answer : Pentaho Data Mining uses the Waikato Environment for Information Analysis to search for data for patterns. It has functions for data processing, regression analysis, classification methods, etc. Question 2 : What is a Tuple? Answer : The finite ordered list of elements is called a tuple. Question 3 : What are the benefits of Pentaho? Answer : Pentaho is an Open source. It has a community that supports users. It

Q : Mention what is Obiee? A : Obiee stands for Oracle Business Intelligence Enterprise Edition (OBIEE). It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing (OLAP), ad hoc query and analysis dashboards, and scorecards. Q : Tell us the main features of OBIEE? A : There are following main features of OBIEE : 1.Hierarchy Drilling 2.Scheduled Report Generation 3.Graphical Reporting (Charts, Pivots, Gauges, ) 4.Ad Hoc Analysis 5.Global support and development capability Q : Mention

Question 1 : How does Qlik sense work? Answer : Qlik sense works intelligently by summarizing the vast amount of complex data by using graph kind of search sense where each Qlik instantly updates data. It has rich visual data insights that help in rules-based security and governance. Question 2 : How to manage data in the app with data manager? Answer : The data manager is managing and adding data from various sources or from the data market of

Q : MSBI Characteristics A : Criteria Result   Analytics Dashboards, guided navigation and drill down Type of Solution End-to-end Business solution with extended ETL User-friendly Ease of installation, use, maintenance Q : What are the Reporting Service Constituents in SSRS? A : A. Report Manager : A Web-based administration tool for managing the Report Server. B. Report Server : Provides services for implementation and delivery of reports. C. Report Designer : A place where we can create report. Q : Define Query parameter in SSRS?

Q : About Cognos TM1. A : IBM Cognos TM1 (formerly Applix TM1, formally Sinper TM1 – Table Manager 1) is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the “leaf” level. Computations on the leaf data are performed in real-time (for example, to aggregate numbers up a dimensional hierarchy). IBM