What is SSIS? How it related with SQL Server?

SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server. This is a platform for Integration and Workflow applications....
Read More »

Difference b/w Cube-Deploy and Process?

Once you build the cube in the BIDS, we can say the structure of the cube is created. So once the cube structure is built we need to deploy the structure to the actual Sql server analysis server. This process is called DEPLOYMENT of cube....
Read More »

Explain the Dashboard in the business intelligence?

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...
Read More »

What is FASMI ?

A database is called a OLAP Database if the database satisfies the FASMI  rules : ?    Fast Analysis– is defined in the OLAP scenario in five seconds or less. ?    Shared – Must support access to data by many users in the factors of Sensitivity...
Read More »

What are variables and what is variable scope ?

Variables store values that a SSIS package and its containers, tasks, and event handlers can use at run time. The scripts in the Script task and the Script component can also use variables. The precedence constraints that sequence tasks and containers into a workflow can...
Read More »

What is Business Intelligence?

Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI applications include the activities of decision support, query and reporting, online analytical processing (OLAP), statistical...
Read More »

Explain the advantages of Business Performance Management?

BPM is very useful in analyzing the current performance of your business. After analyzing the performance of different operations in your organization you can easily identify the various areas where you need to focus on in order to increase the profits and Revenue. This process...
Read More »