Top 100+ Msbi Interview Questions And Answers

Question 1. What Is Ms Bi (microsoft Business Intelligence)?

Answer :

Microsoft Business Intelligence (BI) is a suite of products and gear that you can use to screen, examine and plan your business by way of the usage of scorecards, dashboards, control reporting and analytics.

Question 2. What Are The Tools In Ms Bi?

Answer :

It includes the subsequent tools:

SQL Server Analysis Services (SSAS)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Performance Point Services (PPS) which changed into introduced as a free carrier in Microsoft Office SharePoint 2010.
Informatica Interview Questions
Question three. What Is Ssis? How It Related With Sql Server?

Answer :

SQL Server Integration Services (SSIS) is a part of SQL Server which may be used to carry out a wide range of Data Migration and ETL operations. SSIS is a component in MSBI procedure of SQL Server.
This is a platform for Integration and Workflow programs. It is thought for a fast and flexible OLTP and OLAP extensions used for statistics extraction, transformation, and loading (ETL). The device will also be used to automate maintenance of SQL Server databases and multidimensional statistics sets.
Question 4. What Are The Tools Associated With Ssis?

Answer :

We use Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Projects.
We use SSMS to manipulate the SSIS Packages and Projects.
Informatica Tutorial
Question five. What Are The Differences Between Dts And Ssis?

Answer :

 

DB2 Using SQL Interview Questions
Question 6. What Is A Workflow In Ssis ?

Answer :

Workflow is a hard and fast of instructions on to specify the Program Executor on a way to execute responsibilities and containers within SSIS Packages.

Question 7. What Is The Control Flow?

Answer :

A manipulate drift consists of one or greater responsibilities and packing containers that execute when the package runs. To manage order or outline the situations for strolling the following mission or container within the bundle manipulate drift, we use priority constraints to connect the tasks and containers in a package. A subset of tasks and boxes can also be grouped and run time and again as a unit within the bundle manipulate go with the flow. SQL Server 2005 Integration Services (SSIS) gives three one of a kind varieties of control glide factors: Containers that provide structures in programs, Tasks that offer functionality, and Precedence Constraints that connect the executables, containers, and duties into an ordered control float.

DB2 Using SQL Tutorial SQL Interview Questions
Question eight. What Is A Data Flow?

Answer :

A records waft includes the resources and destinations that extract and load information, the ameliorations that alter and extend statistics, and the trails that hyperlink sources, differences, and destinations. The Data Flow venture is the executable within the SSIS bundle that creates, orders, and runs the information go with the flow. A separate instance of the records drift engine is opened for each Data Flow assignment in a package. Data Sources, Transformations, and Data Destinations are the three important categories inside the Data Flow.

Question nine. How Does Error-dealing with Work In Ssis?

Answer :

When a statistics glide element applies a metamorphosis to column information, extracts statistics from sources, or loads statistics into locations, mistakes can occur. Errors often arise due to unexpected records values.
Type of usual Errors in SSIS:

Data Connection Errors, which arise in case the relationship supervisor cannot be initialized with the connection string. This applies to both Data Sources and Data Destinations at the side of Control Flows that use the Connection Strings.
Data Transformation Errors, which arise even as facts is being transformed over a Data Pipeline from Source to Destination.
Expression Evaluation mistakes, which arise if expressions which might be evaluated at run time perform invalid.
SSIS(SQL Server Integration Services) Interview Questions
Question 10. What Is Environment Variable In Ssis?

Answer :

An environment variable configuration sets a bundle assets same to the fee in an environment variable.
Environmental configurations are beneficial for configuring houses that are depending on the computer this is executing the bundle.
Question 11. What Are The Transformations Available In Ssis?

Answer :

AGGEGATE - It applies mixture features to Record Sets to produce new output statistics from aggregated values.
AUDIT - Adds Package and Task level Metadata - along with Machine Name, Execution Instance, Package Name, Package ID, etc.
CHARACTER MAP - Performs SQL Server level makes string facts changes which includes converting information from lower case to upper case.
CONDITIONAL SPLIT – Separates available input into separate output pipelines based on Boolean Expressions configured for each output.
COPY COLUMN - Add a duplicate of column to the output we are able to later rework the copy maintaining the original for auditing.
DATA CONVERSION - Converts columns information kinds from one to every other kind. It stands for Explicit Column Conversion.
DATA MINING QUERY – Used to perform information mining query against evaluation offerings and manage Predictions Graphs and Controls.
DERIVED COLUMN - Create a brand new (computed) column from given expressions.
EXPORT COLUMN – Used to export a Image particular column from the database to a flat document.
FUZZY GROUPING – Used for information cleaning by way of locating rows which are probable duplicates.
FUZZY LOOKUP - Used for Pattern Matching and Ranking based on fuzzy common sense.
IMPORT COLUMN - Reads photograph particular column from database onto a flat record.
LOOKUP - Performs the research (searching) of a given reference object set against a records supply. It is used for actual suits simplest.
MERGE - Merges two looked after facts sets right into a single facts set right into a unmarried facts drift.
MERGE JOIN - Merges  facts units right into a unmarried dataset using a join junction.
MULTI CAST - Sends a copy of furnished Data Source onto a couple of Destinations.
ROW COUNT - Stores the ensuing row matter from the statistics go with the flow / transformation into a variable.
ROW SAMPLING - Captures sample records via the usage of a row count number of the whole rows in dataflow particular by rows or percentage.
UNION ALL - Merge a couple of statistics units right into a single dataset.
PIVOT – Used for Normalization of information assets to lessen analomolies via changing rows into columns
UNPIVOT – Used for demoralizing the facts shape with the aid of converts columns into rows incase of constructing Data Warehouses.
DWBI Interview Questions
Question 12. How To Log Ssis Executions?

Answer :

SSIS includes logging features that write log entries when run-time occasions occur and can also write custom messages. This is not enabled by way of default. Integration Services supports a numerous set of log companies, and offers you the capacity to create custom log vendors. The Integration Services log carriers can write log entries to textual content documents, SQL Server Profiler, SQL Server, Windows Event Log, or XML files. Logs are associated with packages and are configured at the bundle degree. Each task or box in a bundle can log facts to any package deal log. The responsibilities and containers in a package deal can be enabled for logging even supposing the package itself isn't always.

Informatica Interview Questions
Question 13. How Do You Deploy Ssis Packages?

Answer :

BUILDing SSIS Projects gives a Deployment Manifest File. We need to run the manifest record and determine whether or not to deploy this onto File System or onto SQL Server [ msdb]. SQL Server Deployment is very quicker and more relaxed then File System Deployment. Alternatively, we can also import the bundle from SSMS from File System or SQ Server.

Question 14. What Are Variables And What Is Variable Scope ?

Answer :

Variables save values that a SSIS package and its bins, obligations, and event handlers can use at run time. The scripts inside the Script task and the Script component can also use variables. The precedence constraints that sequence responsibilities and containers right into a workflow can use variables when their constraint definitions include expressions. Integration Services supports two styles of variables: consumer-described variables and system variables. User-defined variables are described with the aid of package deal developers, and gadget variables are described by using Integration Services. You can create as many user-defined variables as a package deal calls for, but you can't create extra system variables.

Question 15. Can You Name Five Of The Perfmon Counters For Ssis And The Value They Provide?

Answer :

SQLServer:SSIS Service
SSIS Package Instances
SQLServer:SSIS Pipeline
BLOB bytes examine
BLOB bytes written
BLOB documents in use
Buffer memory
Buffers in use
Buffers spooled
Flat buffer reminiscence
Flat buffers in use
Private buffer reminiscence
Private buffers in use
Rows examine
Rows written.
SSRS(SQL Server Reporting Services) Interview Questions
Question 16. What Is Analysis Services? List Out The Features?

Answer :

Microsoft SQL Server 2005 Analysis Services (SSAS) grants on line analytical processing (OLAP) and records mining functionality for enterprise intelligence packages. Analysis Services helps OLAP by letting we layout, create, and control multidimensional systems that incorporate data aggregated from different facts sources, inclusive of relational databases. For information mining packages, Analysis Services shall we we design, create, and visualize information mining fashions that are made out of other statistics resources by means of using a wide type of industry-widespread records mining algorithms.
Analysis Services is a center tier server for analytical processing, OLAP, and Data mining. It manages multidimensional cubes of records and affords access to hundreds of facts consisting of aggregation of statistics. One can create records mining fashions from statistics sources and use it for Business Intelligence also consisting of reporting features.
Analysis carrier presents a combined view of the records used in OLAP or Data mining. Services here refer to OLAP, Data mining. Analysis services assists in developing, designing and dealing with multidimensional systems containing statistics from varied sources. It gives a big range of records mining algorithms for precise tendencies and needs.
Some of the key features are:

Ease of use with a number of wizards and designers.
Flexible facts version introduction and control
Scalable structure to handle OLAP
Provides integration of administration gear, records assets, safety, caching, and reporting and so forth.
Provides enormous support for custom applications.
Question 17. What Is Udm? Its Significance In Ssas?

Answer :

The role of a Unified Dimensional Model (UDM) is to provide a bridge among the user and the information assets. A UDM is constructed over one or extra bodily information sources, and then the cease consumer issues queries in opposition to the UDM the use of one among a ramification of customer equipment, along with Microsoft Excel. At a minimum, while the UDM is built simply as a thin layer over the information source, the advantages to the give up person are a simpler, extra readily understood version of the records, isolation from heterogeneous backend statistics sources, and improved overall performance for precis kind queries. In some scenarios a easy UDM like this is constructed totally automatically. With greater investment inside the production of the UDM, additional advantages accrue from the richness of metadata that the version can offer.
The UDM provides the subsequent advantages:

Allows the consumer model to be greatly enriched.
Provides high performance queries assisting interactive analysis, even over large facts volumes.
Allows enterprise policies to be captured within the model to help richer analysis.
SQL Server Analysis Services (SSAS) Interview Questions
Question 18. What Is The Need For Ssas Component?

Answer :

Analysis Services is the most effective thing in SQL Server the usage of which we can carry out Analysis and Forecast operations.
SSAS is very smooth to use and interactive.
Faster Analysis and Troubleshooting.
Ability to create and manipulate Data warehouses.
Apply green Security Principles.
DB2 Using SQL Interview Questions
Question 19. Explain The Two-tier Architecture Of Ssas?

Answer :

SSAS uses each server and client additives to supply OLAP and data mining functionality BI Applications.
The server factor is carried out as a Microsoft Windows carrier. Each instance of Analysis Services implemented as a separate instance of the Windows service.
Clients speak with Analysis Services the usage of the standard the XMLA (XML For Analysis) , protocol for issuing commands and receiving responses, uncovered as a web service.
Question 20. What Are The Components Of Ssas?

Answer :

An OLAP Engine is used for permitting speedy advert hoc queries by means of give up customers. A person can interactively discover facts via drilling, reducing or pivoting.
Drilling refers back to the process of exploring information of the statistics.
Slicing refers back to the procedure of placing facts in rows and columns.
Pivoting refers to switching categories of information among rows and columns.
In OLAP, we are able to be the usage of what are known as as Dimensional Databases.
Informatica Admin Interview Questions
Question 21. What Is Fasmi ?

Answer :

A database is referred to as a OLAP Database if the database satisfies the FASMI policies :

Fast Analysis– is described in the OLAP situation in 5 seconds or much less.
Shared – Must support get entry to to facts with the aid of many users inside the factors of Sensitivity and Write Backs.
Multidimensional – The records inside the OLAP Database ought to be multidimensional in structure.
Information – The OLAP database Must guide huge volumes of data.
Question 22. What Languages Are Used In Ssas ?

Answer :

Structured Query Language (SQL)
Multidimensional Expressions (MDX) - an industry fashionable query language orientated toward analysis.
Data Mining Extensions (DMX) - an enterprise fashionable question language orientated toward statistics mining.
Analysis Services Scripting Language (ASSL) - used to manipulate Analysis Services database gadgets.
Question 23. How Cubes Are Implemented In Ssas ?

Answer :

Cubes are multidimensional models that shop statistics from one or extra sources.
Cubes can also save aggregations.
SSAS Cubes are created the usage of the Cube Wizard.
We also build Dimensions when growing Cubes.
Cubes can see simplest the DSV( logical View).
Informatica Data Quality Interview Questions
Question 24. What Is The Difference Between A Derived Measure And A Calculated Measure?

Answer :

The difference among a derived measure and a calculated measure is while the calculation is executed. A derived degree is calculated before aggregations are created, and the values of the derived degree are stored in the dice. A calculated measure is calculated after aggregations are created, and the values of a calculated degree aren’t saved in the dice. The primary criterion for deciding on among a derived degree and a calculated measure isn't performance, but accuracy.

SQL Interview Questions
Question 25. What Is A Partition?

Answer :

A partition in Analysis Services is the physical location of stored cube facts. Every cube has as a minimum one partition through default. Each time we create a measure group, some other partition is created. Queries run quicker towards a partitioned cube because Analysis Services best desires to study data from the partitions that contain the solutions to the queries. Queries run even faster whilst partition additionally stores aggregations, the pre calculated totals for additive measures. Partitions are a powerful and bendy way of dealing with cubes, specifically large cubes.

Question 26. While Creating A New Calculated Member In A Cube What Is The Use Of Property Called Non-empty Behavior?

Answer :

Nonempty behavior is vital belongings for ratio calculations. If the denominator is empty, an MDX expression will go back an mistakes just as it'd if the denominator Were identical to 0. By choosing one or more measures for the Non-Empty Behavior assets, we are organising a demand that every decided on degree first be evaluated before the calculation expression is evaluated. If each selected degree is empty, then the expression is likewise treated as empty and no blunders is returned.

Question 27. What Is A Ragged Hierarchy?

Answer :

Under normal instances, every stage in a hierarchy in Microsoft SQL Server 2005 Analysis Services (SSAS) has the equal range of participants above it as some other member on the equal stage. In a ragged hierarchy, the logical discern member of at least one member isn't always inside the degree right away above the member. When this takes place, the hierarchy descends to exclusive ranges for distinctive drilldown paths. Expanding thru every level for each drilldown course is then unnecessarily complicated.

SSIS(SQL Server Integration Services) Interview Questions
Question 28. What Are The Roles Of An Analysis Services Information Worker?

Answer :

The function of an Analysis Services statistics worker is the conventional "domain expert" role in commercial enterprise intelligence (BI) a person who understands the records employed with the aid of an answer and is capable of translate the information into business information. The position of an Analysis Services records employee often has one of the following task titles: Business Analyst (Report Consumer), Manager (Report Consumer), Technical Trainer, Help Desk/Operation, or Network Administrator.

Question 29. What Are The Different Ways Of Creating Aggregations?

Answer :

We can create aggregations for quicker MDX statements the usage of Aggregation Wizard or via UBO – Usage Based Optimizations. Always, select UBO method in real time performance troubleshooting.

Question 30. What Is Writeback? What Are The Pre-conditions?

Answer :

The Enable/Disable Writeback dialog container allows or disables writeback for a measure institution in a cube. Enabling writeback on a degree institution defines a writeback partition and creates a writeback desk for that degree group. Disabling writeback on a measure institution removes the writeback partition however does now not delete the writeback desk, to keep away from unanticipated records loss.

Question 31. What Is Processing?

Answer :

Processing is a critical and resource extensive operation in the facts warehouse lifecycle and wishes to be carefully optimized and executed. Analysis Services 2005 offers a high performance and scalable processing architecture with a comprehensive set of controls for database administrators.
We can system an OLAP database, individual dice, Dimension or a selected Partition in a cube.

Question 32. Name Few Business Analysis Enhancements For Ssas?

Answer :

The following table lists the commercial enterprise intelligence upgrades which can be available in Microsoft SQL Server 2005 Analysis Services (SSAS). The table additionally indicates the dice or measurement to which every enterprise intelligence enhancement applies, and suggests whether or not an enhancement may be implemented to an object that turned into created without the use of a records supply and for which no schema has been generated.

Question 33. What Mdx Functions Do You Most Commonly Use?

Answer :

This is a great query due to the fact you only recognise this solution by enjoy. If you ask me this query, the answer almost rushes out of me. “CrossJoin, Descendants, and NonEmpty, further to Sum, Count, and Aggregate. My non-public favourite is CrossJoin as it lets in me discover non-contiguous slices of the dice and aggregate even though the ones dice cells don’t roll up to a natural ancestor.” Indeed, CrossJoin has effortlessly been my bread and butter.

DWBI Interview Questions
Question 34. How Do I Find The Bottom 10 Customers With The Lowest Sales In 2003 That Were Not Null?

Answer :

Simply the usage of bottomcount will go back customers with null sales. You will should integrate it with NONEMPTY or FILTER.

SELECT  [Measures].[Internet Sales Amount]  ON COLUMNS ,
BOTTOMCOUNT(
NONEMPTY(DESCENDANTS( [Customer].[Customer Geography].[All Customers]
, [Customer].[Customer Geography].[Customer] )
, ( [Measures].[Internet Sales Amount] ) )
, 10
, ( [Measures].[Internet Sales Amount] )
) ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar].[Calendar Year].&[2003] ) ;
Question 35. How In Mdx Query Can I Get Top 3 Sales Years Based On Order Quantity?

Answer :

By default Analysis Services returns individuals in an order designated all through characteristic layout. Attribute houses that define ordering are "OrderBy" and "OrderByAttribute". Lets say we want to look order counts for every yr. In Adventure Works MDX question might be:

SELECT [Measures].[Reseller Order Quantity] ON zero
, [Date].[Calendar].[Calendar Year].Members ON 1
FROM [Adventure Works];
Same query using TopCount:

SELECT
[Measures].[Reseller Order Quantity] ON zero,
TopCount([Date].[Calendar].[Calendar Year].Members,3, 
[Measures].[Reseller Order Quantity]) ON 1
FROM [Adventure Works];
Question 36. How Do You Extract First Tuple From The Set?

Answer :

Use should usefunction Set.Item(zero)
Example:

SELECT [Date].[Calendar].[Calendar Year].Members
.Item(zero)
ON 0
FROM [Adventure Works]
SSRS(SQL Server Reporting Services) Interview Questions
Question 37. How Can I Setup Default Dimension Member In Calculation Script?

Answer :

You can use ALTER CUBE assertion. Syntax:

ALTER CUBE CurrentCube undertaking is control waft level object where as script component is information go with the flow degree object, each of the functionalities are identical. This 2 are very effective objects in SSIS.
Normally we can put into effect custom code by the use of those additives. By using this two items we can perform any motion like DML operations at the facts from DB, document and we are able to do any operation the use of c# or vb.Net code we can use it as Source, vacation spot as properly.

Question 39. What Is A Master Package?

Answer :

Master bundle is not anything however it is also a ordinary SSIS package deal, it act like a grasp to run the all different (toddler) applications. If you name the alternative SSIS packages in a new SSIS package the usage of ‘Execute Package Task’, the new package known as as master package. The use of this package(Master) is, in place of walking all character packages if we can run the single grasp package, then robotically all the toddler applications will run. Normally we truely agenda the master package in Sql server agent with the aid of including the all child packages values inside the grasp bundle config file.

Question forty. Difference B/w Cube-install And Process?

Answer :

Once you construct the cube in the BIDS, we will say the structure of the dice is created. So once the cube shape is constructed we need to install the shape to the real Sql server evaluation server. This technique is called DEPLOYMENT of dice. (like creating one object(desk) in the relational database).
So once you installation the shape to the SSAS server, we want to load the information into the shape we have created. This method of loading statistics into the dice and creating the aggregations is referred to as Cube processing.(like putting the records into your table) So to make a cube on-line for the user for querying we want to build the shape of the dice in BIDS and deploy it to a SSAS server and the technique it to load with facts and aggregations, then the person can query at the SSAS cube.

SQL Server Analysis Services (SSAS) Interview Questions
Question 41. What Is The Use Of Data Source View?

Answer :

Data Source Views (DSV) have been added in SQL Server Analysis Services (SSAS) 2005. A DSV is a metadata layer between the dice and the underlying facts supply that permits us to construct our cubes with out being related to the underlying source.

Question 42. Differences Between Calculated Members And Calculated Measures?

Answer :

Member is not anything but column on size desk. Measure is nothing however column on truth desk.
The time period calculated member refers to the introduction of any MDX item thru a calculation. The calculated member can be part of the measures measurement in which a easy MDX expression along with addition or subtraction of  or extra base measures results in a brand new degree. Such calculated contributors at the measure size are known as calculated measures.
Calculated Member is associated with the Dimension where as calculated Measure is related to the measure in degree institution.
Informatica Admin Interview Questions
Question forty three. What Are The Types Of Parameters In Ssrs?

Answer :

The sorts of parameters in SSRS are:

Single cost parameters
Multi price parameters
Cascading parameters.
Question 44. Difference B/w View And Materialized View?

Answer :

Views

A view takes the output of a question and makes it appear like a virtual desk. You can use a view in maximum locations in which a desk may be used.
All operations done on a view will affect records inside the base desk and so are problem to the integrity constraints and triggers of the base table.
A View can be used to simplify SQL statements for the person or to isolate an utility from any future trade to the base desk definition. A View also can be used to enhance protection by limiting get right of entry to to a predetermined set of rows or columns.
In addition to running on base tables, one View can be based on some other, a view also can JOIN a view with a desk (GROUP BY or UNION).
Materialized Views

Materialized views are schema objects that may be used to summarize, precompute, reflect, and distribute facts. E.G. To construct a information warehouse.
A materialized view gives oblique get entry to to desk facts by way of storing the effects of a query in a separate schema item. Unlike an normal view, which does not take in any storage area or incorporate any statistics.
The existence of a materialized view is transparent to SQL, but whilst used for query rewrites will improve the overall performance of SQL execution. An updatable materialized view helps you to insert, replace, and delete.
Question forty five. What Is Hyperion? Is It An Olap Tool?

Answer :

It’s an Business Intelligence gear. Like Brio which was an unbiased product offered over my Hyperion has converted this product name to Hyperion Intelligence.
Yes. You can analyze facts schemas the usage of this gear.
Question 46. What Is The Difference Between Olap And Etl Tools?

Answer :

OLAP: It’s a web analytical processing device. There are various products to be had for facts evaluation.
ETL: Extract, Transform and Load. This is a product to extract the records from multiple/single source remodel the data and cargo it right into a table, flat record or sincerely a target.
Question 47. What Is Olap?

Answer :

OLAP - On-Line Analytical Processing.
Designates a class of programs and technologies that allow the collection, storage, manipulation and reproduction of multidimensional facts, with the goal of evaluation.

Question forty eight. What Is Molap?

Answer :

MOLAP - Multidimensional OLAP.
This term designates a Cartesian data structure extra mainly. In effect, MOLAP contrasts with ROLAP. In the previous, joins among tables are already suitable, which enhances performances. In the latter, joins are computed at some point of the request.
Targeted at companies of customers as it's a shared environment. Data is saved in an different server-based totally format. It plays greater complex evaluation of statistics.

Question 49. What Is Dolap?

Answer :

DOLAP - Desktop OLAP.
Small OLAP products for local multidimensional evaluation Desktop OLAP. There may be a mini multidimensional database (the use of Personal Express), or extraction of a datacube (the use of Business Objects).
Designed for low-stop, single, departmental user. Data is stored in cubes at the desktop. It's like having your personal spreadsheet. Since the statistics is local, quit users don't have to worry approximately performance hits in opposition to the server.

Question 50. What Is Rolap?

Answer :

ROLAP - Relational OLAP.
Designates one or numerous superstar schemas saved in relational databases. This era lets in multidimensional evaluation with facts saved in relational databases. Used for big departments or groups because it helps massive amounts of data and users.

Question fifty one. What Is Holap?

Answer :

HOLAP: Hybridization of OLAP.

Question fifty two. Explain About Auditing In Bo Xi R2? What Is The Use Of It?

Answer :

Auditor is used by the business items administrators to recognise the whole statistics of the commercial enterprise intelligence device.

It video display units entire BIsystem at a glance.
Analyzes usage and trade impact.
Optimises the BI deployment.
In BOXI, auditing isn't a entire package deal - Desktop Intelligence reports aren't absolutely audited because of the reality these reviews are not always held within XI's repository (well, that and other reasons related to XI's architecture), but WEBI reports will be fully audited.

Question fifty three. Why We Can't Create An Aggregate On An Ods Object?

Answer :

Operational Data Store has very low information latency. Data moved to ODS totally on occasion based totally rather than time primarily based ETL to Data Warehouse/Data Mart.
ODS is extra in the direction of OLTP device. We don't generally opt to keep aggregated records in OLTP. So it's miles with ODS.
Unlike facts warehouse in which records is HISTORICAL, ODS is near actual time(NRT). So statistics aggregation is less vital is ODS as data continues converting.
Question fifty four. How Do You Define Multiple Queries In A Document?

Answer :

You can create more than one queries by means of the use of Data Provider choice available within the reporting tool.

Question 55. What Is A Universe?

Answer :

A "universe" is a "Business item" terminology. Business objects additionally happens to be the name of the enterprise. The universe is the interfacing layer among the consumer and the facts warehouse . The universe defines the relationship most of the numerous tables inside the statistics warehouse.

Question fifty six. What Is Business Intelligence?

Answer :

Business intelligence (BI) is a broad class of software packages and technology for accumulating, storing, studying, and providing get entry to to statistics to help company users make higher commercial enterprise selections. BI programs encompass the activities of selection aid, question and reporting, on-line analytical processing (OLAP), statistical analysis, forecasting, and facts mining.

Question 57. How Do We Enhance The Functionality Of The Reports In Bo?

Answer :

You can layout the BO Reports with the aid of the usage of numerous functions to be had. You can turn the table reviews into a 2-Dimensional or three-Dimensional charts. You can observe an Alert to expose a few facts in a extraordinary layout, based on some enterprise rule. You also can create a few activates, that allows you to asks consumer to provide some input values before seeing the reports, this way they will see most effective filtered information. There are many comparable interesting options available to beautify the reviews.

Question 58. What Are Dashboards?

Answer :

Dashboard is a user interface that organizes and offers information in a way that is straightforward to examine. It’s a reporting device that consolidates aggregates and arranges measurements metrics.

Question 59. Explain The Concepts And Capabilities Of Business Intelligence?

Answer :

Business Intelligence is all about approaches, capabilities, technology, practices and packages used for supporting choice making.
Business Intelligence programs should perform.

Centrally initiated by way of the business desires.
It consists of choice guide system, question reporting, OLAP, records mining, forecasting.
Question 60. Name Some Of The Standard Business Intelligence Tools In The Market?

Answer :

The following are the standard Business Intelligence tools in the marketplace:

BUSINESS OBJECTS CRYSTAL REPORTS
MICRO STRATEGY
MS-OLAP SERVICES
COGNOS REPORT NET.
Question sixty one. Explain The Dashboard In The Business Intelligence?

Answer :

Dashboard in business intelligence is used for fast prototyping, cloning and deployment for all databases, operational applications or spread sheets thru an business enterprise.
A dashboard in BI lets in an agency’s popularity/role, heading to, by way of the usage of graphs, maps and chars. The drill-down and roll-over talents allows organizing matters with out revealing crucial statistics. It is fully customizable, including free-shape design options. Dashboard consolidates vital facts of business into an easy-to-examine web page.

Question sixty two. Explain The Sql Server 2005 Business Intelligence Components?

Answer :

SQL Server Integration Services:- Used for facts transformation and creation. Used in records acquisition shape a supply gadget.
SQL Server Analysis Services: Allows statistics discovery using records mining. Using business logic it supports facts enhancement.
SQL Server Reporting Services:- Used for Data presentation and distribution get entry to.
Question sixty three. Explain The Advantages Of Business Performance Management?

Answer :

BPM may be very beneficial in studying the contemporary overall performance of your commercial enterprise. After studying the overall performance of various operations to your company you can effortlessly identify the various regions where you want to attention on for you to growth the earnings and Revenue.
This system will absolutely assist you in making ready your self for the destiny techniques which in flip will assist you in aggressive advantage and taking corrective powerful decisions at the proper time.

Question sixty four. What Is The Main Use Of Business Content? How Data Can Be Loaded Into Business Content After Installation?

Answer :

Business content material can come from numerous components of your commercial enterprise operations. Some from the finance department and a few from the sales branch.
If those business content material are constant and may be used by both departments then it's all approximately loading the statistics into a statistics warehouse for analysis purposes.
In case records are inconsistent and can not be easily in comparison, then a statistics integration tool would assist to integrate records from various records sources before it's far loaded into the records warehouse.
Question 65. What Do You Mean By Conditional Reports?

Answer :

A conditional report is based totally on the records amassed, then analyzed throughout the document generation, which reviews out effects of the analysis within the document's output.

Question sixty six. What Is Flat Aggregation?

Answer :

If you create an Aggregate with greater than 16 characteristics, then we call that combination as FLAT Aggregate. When an combination is active then new records isn't always to be had for reporting, those aggregates are called Flat Aggregates.