Business intelligence

  Home  Basic Common  Business intelligence


“Business intelligence Interview Questions and Answers will guide all of us here that Business intelligence (BI) refers to all the skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context. Business intelligence may also refer to the collected information itself to make a successful business. Get preparation of Business Intelligence Jobs by our Business intelligence Interview Questions and Answers.”



36 Business Intelligence Questions And Answers

1⟩ What is a Universe in Business Intelligence?

A "universe" is a "Business object" terminology. Business objects also happens to be the name of the company. The universe is the interfacing layer between the client and the datawarehouse . The universe defines the relationship among the various tables in the datawarehouse.

Or

Universe is a semantic layer between the database and the user interface (reports).

 216 views

2⟩ What is Business Intelligence?

Business Intelligence is a process for increasing the competitive advantage of a business by intelligent use of available data in decision making.

The five key stages of Business Intelligence:

► Data Sourcing

► Data Analysis

► Situation Awareness

► Risk Assessment

► Decision Support

 228 views

3⟩ Why we ca not create an aggregate on an ODS Object?

► Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.

► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.

► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

 211 views

5⟩ What are dashboards?

A management reporting tool to gauge how well the organization company is performing. It normally uses "traffic-lights" or "smiley faces" to determine the status.

 217 views

7⟩ Name some of the standard Business Intelligence tools in the Market?

Some of the standard Business Intelligence tools in the market According to their performance

► MICROSTRATEGY

► BUSINESS OBJECTS,CRYSTAL REPORTS

► COGNOS REPORT NET

► MS-OLAP SERVICES

Or

► Seagate Crystal report

► SAS

► Business objects

► Microstrategy

► Cognos

► Microsoft OLAP

7. Hyperion

8. Microsoft integrated services

 208 views

10⟩ How do we enhance the functionality of the reports in BO?

You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

 212 views

11⟩ Can you explain the concepts and capabilities of Business Intelligence?

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a better understanding of data. Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle sales, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

 220 views

12⟩ What is the purpose of ETL (Extract Transform Load)?

ETL (Extract Transform Load) is used to extract data from various sources. Transform the data which means applying business rules and performing data cleaning (the latter being often overlooked that causes issues) and Load the clean data into data warehouse. Sometimes in ETL there is also master data management element so it can extract data, perform transformation and it may use proper tools to perform data cleansing and check business rules. In recent versions of SQL Server (including 2012) we can have Master Data Services (MDS) and Data Qaulity Services (DQS).

 226 views

13⟩ What is SAS business intelligence?

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

 219 views

14⟩ Explain business intelligence Dashboard?

Dashboard in business intelligence is used for rapid prototyping, cloning and deployment for all databases, operational applications or spread sheets through an organization.

A dashboard in BI allows an enterprise's status/position, heading to, by using graphs, maps and chars. The drill-down and roll-over capabilities allows organizing things without revealing important information. It is fully customizable, including free-form design options. Dashboard consolidates vital statistics of business into an easy-to-read page.

 233 views

15⟩ Do you know what is SAS?

SAS BI provides the information about an enterprise when needed. It provides this information in customized format. SAS BI integrates data across the enterprise and delivers the self-service reporting and analysis. This consumes less time for responding requests and for business uses to view the information. An integrated, flexible and robust presentation layer for SAS Analytics with full breadth is also offered by SAS BI. All these are integrated within the context of business for better and faster decision making.

 243 views

16⟩ What is OLAP in Business Intelligence?

Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.

A good OLAP interface has writes an efficient sql and reads an accurate data from db.To design and architect having good knowledge on DB understanding the report requirements.

 235 views

17⟩ What is broad cast agent in business intelligence?

A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast agents allows the flexibility to the users to receive reports periodically or not. They help to manage and schedule the documents.

 223 views

18⟩ What is dashboard in business intelligence?

A dashboard in business intelligence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM's. They need to know how much cash is deposited, how much is left etc.

 223 views