If you're looking for MSBI Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed c…
Monitoring by Using Execution Log 2 The reporting services Execution log2 view is a good starting point from which to analyze your current workload a…
Publish Report Note:- Before publishing ensure the following settings a) solution explorer → project → properties →DeploymentOverwr…
Configuration Files Reporting services stoves configuration settings in various configuration files If we change the configuration files information…
Working with Report Manager 1) It is a client tool to work with client reports and management reports.2) It does various operations such as Subscr…
Working with Report Model These are templates that contain data sets and data sources. It stores attribute that is supposed to display in various rep…
Taking Sub Reports Sub Report displays the content in the main report or It is the report in the main report. It can take parameters. Generally, …
Drill Down Report With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for drill down report If you…
Passing Parameters Parameters provide user interactions with the report. There are 4 ways we pass the parameters. Non Queried parameters Queried …
Variables The variables are of two types. They are a) Report variable b) Group variable Report Variables This variable is used across anywher…
LookUp Enhancement in SSRS 2008 R2 The look up enhancement functions available in 2008 in below navigationGo to Text book (Table) → RT click → Expres…
Action Properties a) Go to report → refer to the drill-through report concept for this actionb) Go to URL: → Calling a URL while doing report actio…
Working With TextBox Properties Each and every cell in a text box Text box is having below properties (a) fx Expression → here we write expre…
Creating Table Report It displays data in rows and columns format It contains 3 sections: a) Header section: Here column Headings (or) Aggregate Inf…
Creating Reports There are 3 ways to create re ports By using report server project wizard By using report server project By using report model …
SSRS Configuration Manager Generally, this tool is available for administrators to configure the reporting services components and items If you w…
SQL Server Reporting Services(SSRS) Introduction: Today, data generation is the simplistic task that can be done by organizations but making the mo…
CREATING a CUBE WITHOUT DATA SOURCES in SSAS This is possible in ways a) Without Template b) With template WITHOUT TEMPLATE: On the fly, we need to create …
Aggregation Design Aggregations are precalculated summaries of data from cells. Aggregations improve query response time by preparing answer…
SSAS Performance Tuning 1) Optimize Cube And Measure Group Design Define cascading attribute relationships, for example, day > Month > Quarter > yea…
SSAS Cube Deployment There are many to deploy cube objects (or) cubes a) BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO) b) Deployment wizard c) X…
SSAS Security SSAS BIDS level it supports ‘role-based’ security User (or) group assigns to a Role, each role contains set of responsibilities. (objects priv…
Conformed Dimension This is designed to implement “Write Back” option Here the data are written back to the data sources. Scenario dimension perf…
Named Query These queries are helpful to construct a table with a customized query. Here advantages area) Restriction of rows and columnsb) Multiple …
Storage Settings While creating the partitions we must specify either of the below storage settings.a) ROLAP (Related OLAP): In this case data and ag…
SSAS PARTITION Real-time Usage:Multiple Partitions will process the data more parallel.–> We can run the specified partition to process the required …
PERSPECTIVES –> It is helpful to provide limited visibility to cube objects.–> In this case, what are all the dimensions, fact, KPI's, calculations ……
SSAS Calculations These are the intermediate operations perform between data source to cube database.–> These are created at BIDS level.–> It uses MD…
MDX (MultiDimensional eXpressions) –> To work with Normal two – dimensional applications, two-dimensional programming languages are enough ( C, C ++, .NET …etc…
Dimension Wizard –> This wizard is used to add, remove dimensions and their relationships.–> We can add dimensions to another dimension (or) measure …
CUBE: It is a multidimensional object constructed with dimensions and facts in a particular design for taking multidimensional decisions CUBE Creatio…
SQL Server Analysis Services (SSAS) Need of Analytical ApplicationsTo create multidimensional objects and to provide multidimensional analysis, we re…
In this topic, let us try to understand the intrinsic details of what database normalization is and also, at the same time, we will try to understand …
SQL Server Data Modeling A data model is an abstraction of some aspect of the real world (system) Why a data model? Helps to visualize the busine…
Data Warehousing Concepts DATA: data is composed of observable and recordable facts that are often found in operational for transactions systems. O…
SQL Server Performance Tuning For more than 2 yrs of experience people this PERFORMANCE TUNING mandatory concept and they must have good knowledge o…
Working with transaction and isolation level Transaction: It is the logical collection of statements or steps which can be succeeded or failed. The …
Incremental load in SSIS Daily data — (Stores) –> Table (Granularity data) Maintain history [SCD] Direct loading ETL loading (indirect load)…
SSIS Package Deployment Providing a run able solution at testing or production generally we go for deployment (moving the developed application from one enviro…
Checkpoints in SSIS Checkpoint configuration helps us to resume from the last task in the package. i.e., if the multiple tasks are there in a package…
Debugging SSIS Packages There are three ways of debugging. They are:1) By executing the package partiallyIt multiple tasks are present in a package t…
Slowly Changing Dimensions To process the data from granularity tables to main tables, we follow a mechanism called slowly changing dimensions type.E…
Control flow Items It contains container and control flow tasks in ssisContainerIt contains other tasksEg: for each loop container For loop cont…
These are the SSIS practicals in MSBI Architecture Execution Data flow task operations Sources Destinations Transformations SSIS Practical …
SSIS (SQL Server Integration Services) SSIS are 2 typesETL Operations (Extracting Transform Load)E- Extracting –> Getting dataT- Transform –> perform…
SQL Server Management Studio (SSMS) a) Open SSMS (SQL server management studio)b) Select server type in the following Database engineàTo connect…
MSBI Installation Steps H/W Requirements1) Ghz Pentium – III Compatible (or) faster processor (2GHZ (or) faster recommended).2) 512 MB of RAM (or) mo…
MSBI Competitive Advantages 1) It is a single suite for end-to-end business solution. 2) It has extended capability for extraction, transformation a…
MSBI Interview Questions: Q1. Differentiate views and Materialized Views. Ans. 1.Views Views are used to visualize the query result as a virtual …
MSBI Career opportunities and Job trends Outline Skills required to become MSBI expert Job Roles and Responsibilities MSBI Career opportunities…
If you're looking for MSBI Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed c…
Monitoring by Using Execution Log 2 The reporting services Execution log2 view is a good starting point from which to analyze your current workload a…
Publish Report Note:- Before publishing ensure the following settings a) solution explorer → project → properties →DeploymentOverwr…
Configuration Files Reporting services stoves configuration settings in various configuration files If we change the configuration files information…
Working with Report Manager 1) It is a client tool to work with client reports and management reports.2) It does various operations such as Subscr…
Working with Report Model These are templates that contain data sets and data sources. It stores attribute that is supposed to display in various rep…
Taking Sub Reports Sub Report displays the content in the main report or It is the report in the main report. It can take parameters. Generally, …
Drill Down Report With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for drill down report If you…
Passing Parameters Parameters provide user interactions with the report. There are 4 ways we pass the parameters. Non Queried parameters Queried …
Variables The variables are of two types. They are a) Report variable b) Group variable Report Variables This variable is used across anywher…
LookUp Enhancement in SSRS 2008 R2 The look up enhancement functions available in 2008 in below navigationGo to Text book (Table) → RT click → Expres…
Action Properties a) Go to report → refer to the drill-through report concept for this actionb) Go to URL: → Calling a URL while doing report actio…
Working With TextBox Properties Each and every cell in a text box Text box is having below properties (a) fx Expression → here we write expre…
Creating Table Report It displays data in rows and columns format It contains 3 sections: a) Header section: Here column Headings (or) Aggregate Inf…
Creating Reports There are 3 ways to create re ports By using report server project wizard By using report server project By using report model …
SSRS Configuration Manager Generally, this tool is available for administrators to configure the reporting services components and items If you w…
SQL Server Reporting Services(SSRS) Introduction: Today, data generation is the simplistic task that can be done by organizations but making the mo…
CREATING a CUBE WITHOUT DATA SOURCES in SSAS This is possible in ways a) Without Template b) With template WITHOUT TEMPLATE: On the fly, we need to create …
Aggregation Design Aggregations are precalculated summaries of data from cells. Aggregations improve query response time by preparing answer…
SSAS Performance Tuning 1) Optimize Cube And Measure Group Design Define cascading attribute relationships, for example, day > Month > Quarter > yea…
SSAS Cube Deployment There are many to deploy cube objects (or) cubes a) BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO) b) Deployment wizard c) X…
SSAS Security SSAS BIDS level it supports ‘role-based’ security User (or) group assigns to a Role, each role contains set of responsibilities. (objects priv…
Conformed Dimension This is designed to implement “Write Back” option Here the data are written back to the data sources. Scenario dimension perf…
Named Query These queries are helpful to construct a table with a customized query. Here advantages area) Restriction of rows and columnsb) Multiple …
Storage Settings While creating the partitions we must specify either of the below storage settings.a) ROLAP (Related OLAP): In this case data and ag…
SSAS PARTITION Real-time Usage:Multiple Partitions will process the data more parallel.–> We can run the specified partition to process the required …
PERSPECTIVES –> It is helpful to provide limited visibility to cube objects.–> In this case, what are all the dimensions, fact, KPI's, calculations ……
SSAS Calculations These are the intermediate operations perform between data source to cube database.–> These are created at BIDS level.–> It uses MD…
MDX (MultiDimensional eXpressions) –> To work with Normal two – dimensional applications, two-dimensional programming languages are enough ( C, C ++, .NET …etc…
Dimension Wizard –> This wizard is used to add, remove dimensions and their relationships.–> We can add dimensions to another dimension (or) measure …
CUBE: It is a multidimensional object constructed with dimensions and facts in a particular design for taking multidimensional decisions CUBE Creatio…
SQL Server Analysis Services (SSAS) Need of Analytical ApplicationsTo create multidimensional objects and to provide multidimensional analysis, we re…
In this topic, let us try to understand the intrinsic details of what database normalization is and also, at the same time, we will try to understand …
SQL Server Data Modeling A data model is an abstraction of some aspect of the real world (system) Why a data model? Helps to visualize the busine…
Data Warehousing Concepts DATA: data is composed of observable and recordable facts that are often found in operational for transactions systems. O…
SQL Server Performance Tuning For more than 2 yrs of experience people this PERFORMANCE TUNING mandatory concept and they must have good knowledge o…
Working with transaction and isolation level Transaction: It is the logical collection of statements or steps which can be succeeded or failed. The …
Incremental load in SSIS Daily data — (Stores) –> Table (Granularity data) Maintain history [SCD] Direct loading ETL loading (indirect load)…
SSIS Package Deployment Providing a run able solution at testing or production generally we go for deployment (moving the developed application from one enviro…
Checkpoints in SSIS Checkpoint configuration helps us to resume from the last task in the package. i.e., if the multiple tasks are there in a package…
Debugging SSIS Packages There are three ways of debugging. They are:1) By executing the package partiallyIt multiple tasks are present in a package t…
Slowly Changing Dimensions To process the data from granularity tables to main tables, we follow a mechanism called slowly changing dimensions type.E…
Control flow Items It contains container and control flow tasks in ssisContainerIt contains other tasksEg: for each loop container For loop cont…
These are the SSIS practicals in MSBI Architecture Execution Data flow task operations Sources Destinations Transformations SSIS Practical …
SSIS (SQL Server Integration Services) SSIS are 2 typesETL Operations (Extracting Transform Load)E- Extracting –> Getting dataT- Transform –> perform…
SQL Server Management Studio (SSMS) a) Open SSMS (SQL server management studio)b) Select server type in the following Database engineàTo connect…
MSBI Installation Steps H/W Requirements1) Ghz Pentium – III Compatible (or) faster processor (2GHZ (or) faster recommended).2) 512 MB of RAM (or) mo…
MSBI Competitive Advantages 1) It is a single suite for end-to-end business solution. 2) It has extended capability for extraction, transformation a…
MSBI Interview Questions: Q1. Differentiate views and Materialized Views. Ans. 1.Views Views are used to visualize the query result as a virtual …
MSBI Career opportunities and Job trends Outline Skills required to become MSBI expert Job Roles and Responsibilities MSBI Career opportunities…