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 companies i…
Monitoring by Using Execution Log 2 The reporting services Execution log2 view is a good starting point from which to analyze your current workload and underst…
Publish Report Note:- Before publishing ensure the following settings a) solution explorer → project → properties → Deployment Overwrite Data…
Configuration Files Reporting services stoves configuration settings in various configuration files If we change the configuration files information automatic…
Working with Report Manager 1) It is a client tool to work with client reports and manger reports. 2) It does various operations such as Subscription Creat…
Working with Report Model These are templates that contain data set and data sources. It stores attributes which are supposed to display in various reports. Be…
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 sub reports ar…
Drill Down Report With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for drill down report Learn how to use M…
Passing Parameters Parameters provide user interactions to the report. There are 4 ways we pass the parameters. Non Queried parameters Queried parameters …
Variables The variables are of two types. They are a) Report variable b) Group variable Report Variables This variable is used across anywhere in the r…
LookUp Enhancement in SSRS 2008 R2 The look up enhancement functions available in 2008 in below navigation Go to Text book (Table) → RT click → Expression → ca…
Action Properties a) Go to report → refer to the drill through report concept for this action b) Go to URL: → Calling a URL while doing report actions. Ex: A…
Working With TextBox Properties Each and every cell in a text box Text box is having below properties (a) fx Expression → here we write expressions to d…
Creating Table Report It displays data in rows and columns format It contains 3 sections a) Header section: Here column Headings (or) Aggregate Information di…
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 & builder …
SSRS Configuration Manager Generally, this tool is available for administrators to configure the reporting services components and items Learn how to use MS…
SSRS Overview Reports are required in general but situations a) For Internal Reports b) For external Reports Internal Reports: Generally, company Internal Oper…
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 answers before questio…
SSAS Performance Tuning 1) Optimize Cube And Measure Group Design Define cascading attribute relationships, for example, day > Month > Quarter > year and def…
SSAS Cube Deployment There are many to deploy cube objects (or) cubes a) BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO) b) Deployment wizard c) XMLA Script…
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 performs many …
Named Query These queries are helpful to construct a table with a customized query. Here advantages are a) Restriction of rows and columns b) Multiple columns …
Storage Settings While creating the partitions we must specify either of the below storage settings. a) ROLAP (Related OLAP): In this case data and aggregation…
SSAS PARTITION Real-time Usage: Multiple Partitions will process the data more parallel. –> We can run the specified partition to process the required data (so…
PERSPECTIVES –> It is helpful to provide limited visibility to cube objects. –> In this case, what are all the dimensions, fact, KPI's, calculations ….etc You …
SSAS Calculations These are the intermediate operations perform between data source to cube database. –> These are created at BIDS level. –> It uses MDX syntax…
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 group tab…
CUBE: It is a multidimensional object constructed with dimensions and facts in a particular design for taking multidimensional decisions CUBE Creation Steps: …
SQL Server Analysis Services (SSAS) Need of Analytical Applications To create multidimensional objects and to provide multidimensional analysis, we require ana…
Normalization & T-SQL The process of applying normal forms one by one at the time of data designing is called normalization Advantages: Reducing unnecess…
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 business A mo…
Data Warehousing Concepts DATA: data is composed of observable and recordable facts that are often found in operational for transactions systems. OLTP: OL…
SQL Server Performance Tuning For more than 2 yrs of experience people this PERFORMANCE TUNING mandatory concept and they must have good knowledge on this. S…
Working with transaction and isolation level Transaction: It is the logical collection of statements or steps which can be succeeded or failed. The transactio…
Incremental load in SSIS Daily data — (Stores) –> Table (Granularity data) Maintain history [SCD] Direct loading ETL loading (indirect load) Eg: loa…
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. If there…
Debugging SSIS Packages There are three ways of debugging. They are: 1) By executing the package partially It multiple tasks are present in a package then we c…
Slowly Changing Dimensions To process the data from granularity tables to main tables, we follow a mechanism called slowly changing dimensions type. Eg: there…
Control flow Items It contains container and control flow tasks in ssis Container It contains other tasks Eg: for each loop container For loop container …
These are the SSIS practicals in MSBI Architecture Execution Data flow task operations Sources Destinations Transformations SSIS Practical Architectur…
SSIS (SQL Server Integration Services) SSIS are 2 types ETL Operations (Extracting Transform Load) E- Extracting –> Getting data T- Transform –> performing int…
SQL Server Management Studio (SSMS) a) Open SSMS (SQL server management studio) b) Select server type in the following Database engineàTo connect and work w…
MSBI Installation Steps H/W Requirements 1) Ghz Pentium – III Compatible (or) faster processor (2GHZ (or) faster recommended). 2) 512 MB of RAM (or) more (2GB …
MSBI Competitive Advantages 1) It is a single suite for end-to-end business solution. 2) It has extended capability for extraction, transformation and loading…
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 companies i…
Monitoring by Using Execution Log 2 The reporting services Execution log2 view is a good starting point from which to analyze your current workload and underst…
Publish Report Note:- Before publishing ensure the following settings a) solution explorer → project → properties → Deployment Overwrite Data…
Configuration Files Reporting services stoves configuration settings in various configuration files If we change the configuration files information automatic…
Working with Report Manager 1) It is a client tool to work with client reports and manger reports. 2) It does various operations such as Subscription Creat…
Working with Report Model These are templates that contain data set and data sources. It stores attributes which are supposed to display in various reports. Be…
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 sub reports ar…
Drill Down Report With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for drill down report Learn how to use M…
Passing Parameters Parameters provide user interactions to the report. There are 4 ways we pass the parameters. Non Queried parameters Queried parameters …
Variables The variables are of two types. They are a) Report variable b) Group variable Report Variables This variable is used across anywhere in the r…
LookUp Enhancement in SSRS 2008 R2 The look up enhancement functions available in 2008 in below navigation Go to Text book (Table) → RT click → Expression → ca…
Action Properties a) Go to report → refer to the drill through report concept for this action b) Go to URL: → Calling a URL while doing report actions. Ex: A…
Working With TextBox Properties Each and every cell in a text box Text box is having below properties (a) fx Expression → here we write expressions to d…
Creating Table Report It displays data in rows and columns format It contains 3 sections a) Header section: Here column Headings (or) Aggregate Information di…
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 & builder …
SSRS Configuration Manager Generally, this tool is available for administrators to configure the reporting services components and items Learn how to use MS…
SSRS Overview Reports are required in general but situations a) For Internal Reports b) For external Reports Internal Reports: Generally, company Internal Oper…
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 answers before questio…
SSAS Performance Tuning 1) Optimize Cube And Measure Group Design Define cascading attribute relationships, for example, day > Month > Quarter > year and def…
SSAS Cube Deployment There are many to deploy cube objects (or) cubes a) BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO) b) Deployment wizard c) XMLA Script…
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 performs many …
Named Query These queries are helpful to construct a table with a customized query. Here advantages are a) Restriction of rows and columns b) Multiple columns …
Storage Settings While creating the partitions we must specify either of the below storage settings. a) ROLAP (Related OLAP): In this case data and aggregation…
SSAS PARTITION Real-time Usage: Multiple Partitions will process the data more parallel. –> We can run the specified partition to process the required data (so…
PERSPECTIVES –> It is helpful to provide limited visibility to cube objects. –> In this case, what are all the dimensions, fact, KPI's, calculations ….etc You …
SSAS Calculations These are the intermediate operations perform between data source to cube database. –> These are created at BIDS level. –> It uses MDX syntax…
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 group tab…
CUBE: It is a multidimensional object constructed with dimensions and facts in a particular design for taking multidimensional decisions CUBE Creation Steps: …
SQL Server Analysis Services (SSAS) Need of Analytical Applications To create multidimensional objects and to provide multidimensional analysis, we require ana…
Normalization & T-SQL The process of applying normal forms one by one at the time of data designing is called normalization Advantages: Reducing unnecess…
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 business A mo…
Data Warehousing Concepts DATA: data is composed of observable and recordable facts that are often found in operational for transactions systems. OLTP: OL…
SQL Server Performance Tuning For more than 2 yrs of experience people this PERFORMANCE TUNING mandatory concept and they must have good knowledge on this. S…
Working with transaction and isolation level Transaction: It is the logical collection of statements or steps which can be succeeded or failed. The transactio…
Incremental load in SSIS Daily data — (Stores) –> Table (Granularity data) Maintain history [SCD] Direct loading ETL loading (indirect load) Eg: loa…
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. If there…
Debugging SSIS Packages There are three ways of debugging. They are: 1) By executing the package partially It multiple tasks are present in a package then we c…
Slowly Changing Dimensions To process the data from granularity tables to main tables, we follow a mechanism called slowly changing dimensions type. Eg: there…
Control flow Items It contains container and control flow tasks in ssis Container It contains other tasks Eg: for each loop container For loop container …
These are the SSIS practicals in MSBI Architecture Execution Data flow task operations Sources Destinations Transformations SSIS Practical Architectur…
SSIS (SQL Server Integration Services) SSIS are 2 types ETL Operations (Extracting Transform Load) E- Extracting –> Getting data T- Transform –> performing int…
SQL Server Management Studio (SSMS) a) Open SSMS (SQL server management studio) b) Select server type in the following Database engineàTo connect and work w…
MSBI Installation Steps H/W Requirements 1) Ghz Pentium – III Compatible (or) faster processor (2GHZ (or) faster recommended). 2) 512 MB of RAM (or) more (2GB …
MSBI Competitive Advantages 1) It is a single suite for end-to-end business solution. 2) It has extended capability for extraction, transformation and loading…