Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Does Business Intelligence (BI) works with existing applications and databases?
- Correct Answer
- Yes Business Intelligence (BI) solution like 1KEY is designed to interoperate with data that exists in virtually any enterprise data source, such as Oracle, IBM DB2, or Sybase For example, you can use SQL Server 2005 Reporting Services to run reports on data stored in an Oracle database Also, SQL Server 2005 Integration Services can be used to extract data to or from any OLEDB data source 1KEY can connect to multiple database, multiple applications like ERP, CRM, SCM, HRM, financial accounting or any other core transactional application (SAP, Orracle E-Business Suite, PeopleSoft, JD Edwards, Siebel, QAD MFG/Pro, Microsoft Dynamics, Navision, Ramco, TallyERP)
- 1. What is a BI dashboard? Discuss
- 2. Explain the SQL Server 2005 Business Intelligence components. Discuss
- 3. Who are BI systems intended for? Discuss
- 4. What are the examples of BI Initiatives (Focus Areas)? Discuss
- 5. Which industries can benefit from BI? Discuss
- 6. How would you explain the concept of business intelligence? What is its importance? Discuss
- 7. What are the core BI tools that professionals work with? Which ones have you used? Discuss
- 8. What is a Universe? Discuss
- 9. Name some of the standard Business Intelligence tools in the market? Discuss
- 10. what is flat aggregation? Discuss
Technology problems
Search Results
Correct Answer: Dashboards are real-time business intelligence interfaces They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question
Correct Answer: - SQL Server Integration Services:- Used for data transformation and creation Used in data acquisition form a source system - SQL Server Analysis Services: Allows data discovery using data mining Using business logic it supports data enhancement - SQL Server Reporting Services:- Used for Data presentation and distribution access
Correct Answer: For any member of the company who makes decisions based on transactional systems' data Such systems may be oriented to different levels (analysts, managers, directors, auditors, etc), providing different kinds of information in each case
Correct Answer: Customer Satisfaction, Problem Resolution, Loyalty & Customer Value, Up-sell & Cross-sell, Customer Churn, Customer Segmentation, Cost Control, Revenue & Profitability, Performance Management, Outage / Downtime, Defect, Marketing Effectiveness, Collections are some of the examples of BI initiatives
Correct Answer: Companies across all the industries like Manufacturing, BFSI, Retail, Service, Telecom, ITES, Pharma & Healthcare, Infrastructure & Construction, Automotive, Education, Government, Public Sector, etc can benefit from BI
Correct Answer: Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them
Correct Answer: SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis
Correct Answer: 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 For example, 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 which they can generate and perform analysis
Correct Answer: 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
Correct Answer: If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.