Explain the SQL Server 2005 Business Intelligence components.

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: The following are the two types of assemblies: => Private Assembly - Refers to the assembly that is used by a single application Private assemblies are kept in a local folder in which the client application has been installed => Public or Shared Assembly - Refers to the assembly that is allowed to be shared by multiple applications A shared assembly must reside in Global Assembly Cache (GAC) with a strong name assigned to it For example, imagine that you have created a DLL containing information about your business logic This DLL can be used by your client application In order to run the client application, the DLL must be included in the same folder in which the client application has been installed This makes the assembly private to your application Now suppose that the DLL needs to be reused in different applications Therefore, instead of copying the DLL in every client application folder, it can be placed in the global assembly cache using the GAC tool These assemblies are called shared assemblies

Correct Answer: Assemblies are the basic building blocks required for any application to function in the NET realm They are partially compiled code libraries that form the fundamental unit of deployment, versioning, activation scoping, reuse, and security Typically, assemblies provide a collection of types and resources that work together to form a logical unit of functionality They are the smallest deployable units of code in NET Compared to the executable files assemblies are far more reliable, more secure, and easy to manage An assembly contains a lot more than the Microsoft Intermediate Language (MSIL) code that is compiled and run by the Common Language Runtime (CLR) In other words, you can say that an assembly is a set of one or more modules and classes compiled in MSIL, and metadata that describes the assembly itself, as well as the functionalities of the assembly classes

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: 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)

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