Both native installation and Sharepoint mode installations can be used , in case of latter the SQL server installation should be in accordance with SharePoint.

What is the difference between the Merge and Union All transformation in MSBI.

Merge only gives the output in a sorted manner while UNION ALL does not.

Which different versions of any of the tools in MSBI stack have you worked, any illustrations on the difference in functionalities?

2008 R2, 2012, 2016
Expression Task was introduced in SSIS 2012
SSAS Tabular was introduced starting 2012.
SQL 2016 contained new date functions like EndOfMonth etc.

What are dimensions ?

These represent entities about which factual data or aggregations are collected.

Can you use ORDER BY in a view?

How can you prepare drill down SSRS reports?

By using Row Groups.

What are subreports ?

These are reports that are designed to be opened from main reports by specifying Action which can be to ‘Go to URL’ or ‘Go to Report’ etc.

What are the various components of SSRS?

Report server , Report Manager , Report Builder , Report Configuration manager.

How would you debug a script task in SSIS ?

Using breakpoints.

Purpose of Checkpoints in SSIS?

It is used to start the package execution from the last successful run

What is Time Intelligence in SSAS?

SSAS project can be configured to use the Time Intelligence feature which enables easy use of the YTD, TD , MTD functionalities.

Is it possible to use a date other than the current date as reference for getting Year to Date, quarter To Date aggregations in a data warehouse?

Yes

Which SSIS task can be used to send DBmail ?

NotifyOperator .

If the same task can be achieved using SQL and SSIS, which would you prefer and why?

SQL for better performance, Sorting is a classic example.

What are package configurations?

How to dynamically create SQL command in SSIS ?

Using expressions and variables.

What is the benefit of using SQL command in an OLEDB source?

It is useful when all the source columns need not be pulled.

What Are the Different Kinds of SSRS Reports?

Reports can be managed into operational and cautious reports.
The pack depends on the wellspring of information and level of assessment connected by a specific report.
Operational reports depend on OLTP sources and are static reports and Analytical reports depend on OLAP sources and everything thought about attract drill-down and drill-through for evaluation.
The explanation behind the truth, SSRS reports can be directed into parameterized, related, gathering, set away, and so forth…

Clarify by what method may you store your referencing in an SSRS report or a Database server?

Regulating SQL questions truly in the substance approach in the information ought to be kept up a key superior to standard ways.
Then again perhaps, it ought to be coordinated in a set away framework in the database server.
The bit of room is that the SQL would be in an amassed strategy in an SP and gives a large portion of the upsides of SP showed up contrastingly in relationship with utilizing a with no managing arrangements from the report.

What is a related report in SSRS?

A related report is a report server thing that gives a path to a present report. Keenly, it would seem that a program clear course that you use to run a program or open a record.
A related report is gotten from a present report and holds the center’s report definition.

What is SSRS and why it is used?

SQL Server Reporting Services (SSRS. is a server-based report making programming structure from Microsoft.
The SSRS affiliation gives an interface into Microsoft Visual Studio with the objective that designers, in like manner as SQL administrators, can interface with SQL databases and use SSRS instruments to manage SQL reports from different points of view.

What is SSRS organizing?

SSRS is a concentrated and extensible uncovering stage, which joins an organized system of managing parts, adjusted interfaces, and instruments.

What are SSIS SSAS and SSRS in SQL?

The SQL Server Analysis Services, or SSAS, is a multidimensional evaluation contraption that features Online Analytical Processing, astonishing data mining limits, and dynamically important estimations to business information inside a social database.

What is a data driven selection SSRS?

A data driven selection gives a way to deal with oversee use of dynamic intrigue data that is recouped from an external data source at run time.
A data driven speculation can what’s more use static substance and default regards that you show when the enrollment is portrayed.

What is the partition between the table and the structure?

In the table and system plans, cells are overseen into lines and domains.
The key partition among tables and structures is that tables can join basically line parties, while systems have line get-togethers and fragment get-togethers.

What is a sub-report?

Sub-reports are installed in the standard report.
Much equivalent to the essential report, you similarly pass parameters and request to it.
Consider a sub-report as an enlargement to your essential report, anyway it contains another enlightening record.
For instance, you could make a report of customers and thereafter use a sub-report to show a summary of solicitations for each customer.

What is the enlightening record?

Enlightening lists are the sections that contain your records.
You can have an unmistakable instructive file, an enlightening list with one record, or an educational list with considerable number records.
You can see an instructive record like an altered table.
The enlightening gathering has the fragments and lines like a table, yet you choose the areas and number of sections using your SQL enunciations.

What is the data source?

A data source is the database and tables where your instructive gathering begins from. You ought to describe the data source when you make your database affiliation.
Every datum set needs a source from which to pull the data. Your specifying server can be SQL Server 2000, 2005, 2008 and 2012.

Could SSRS report hold results?

Putting away reports makes it much snappier for customers to access and view data.
If you have normal data that doesn’t change regularly, it’s optimal to store results.
SSRS allows you to save gives a record of your noteworthy server.
This suggests it reduces the pile on the SQL Server and your customers can quickly get to data without scrutinizing the server a couple of times.

What designs can SSRS charge or render to?

SSRS is impeccable with a couple of report gatherings.
Right when the customer runs the report, the default design prints to the web program.
You can in like manner extra or passage to HTML, Excel, CSV, Image, PDF and XML plans.
The SSRS uncovering programming has gets at the most elevated purpose of each report that the customer can use to convey these records.

Define SSIS and how is it related to SQL Server?

SSIS or SQL Server Integration Service is SQL Server component that is used to perform a number of operations that may be data migration or ETL types of operations. In MSBI process, SSIS is basically a component that is used by the SQL Server. SSIS platform is used for workflow integration and applications. In this platform, OLAP and OLTP are quite faster that can be used for data transformation, extraction, and loading. This SSIS tool can also be used to automate maintenance process of multidimensional datasets and SQL Server databases. SQL Server in the Easiest Way

Name the tools that are associated with SSIS.

We use several tools for SSIS like BIDS or business intelligence development studio and SSMS or SQL Server Management Studio tool to manage the development of SSIS projects. Some of the tools that are mostly used listed below:

Limited Error Handling	Message Boxes in .Net Scripting
No Deployment Wizard	Complex and Powerful Error Handling
Data Transformation Services	SQL Server Integration Services
Message Boxes in Active Scripts	Interactive Deployment Wizard
Limited Set of Transformation	Complete BI Integration
No BI Functionality	Good Number of Transformation

Explain error handling in SSIS.

In SSIS, data flow execution error may occur while fetching data from the source or in case of transformation or loading data to the destination. Here, the reason for the errors is unexpected data values while performing these operations.

Typically following types of errors can occur in SSIS:

Data Connection Error: When connection manager cannot be initialized, this type of error occurs. These errors can occur at data source and destination both as it is basically associated with the connection string and both of them use connection string for establishing a connection.
Data Transformation Error: When data is transformed over data pipeline, this type of error can occur. Secondly, when data flows from source to destination then this error occurs.
Expression Evaluation Error: If any of the runtime expression execution fails then this error occurs.

How can an SSIS package be deployed?

There is a Deployment Manifest File that is provided by SSIS Build. This manifest file is run to perform deployment either onto file system or to SQL Server. SQL Server deployment is quite faster and secure than file system deployment. So, packages can be imported from SQL Server, File System or SSMS.

How can you log into SSIS execution?

When a run-time event occurs then log entries are being written through SSIS logging features. This is not enabled by default. A diverse set of log providers are supported by SSIS and user can also create custom log provider. Here log entries are written to text files, SQL Server, SQL Server Profiler or XML Files. Logs are usually configured at the package level as they are associated with packages. Task and containers can be enabled for logging.

Name any five perform counters for SSIS and what value they provide?

SQL Server: SSIS Service
BLOB bytes read
Buffer Memory
Flat buffer memory
Flat Buffer in use

What is query parameter in SSRS?

Query parameters are included in SQL script data sources. They begin with the symbol @.

Define UDM or Unified Dimensional Model and its significance in SAAS.

UDM or unified dimensional model provides a bridge between data sources and user and is built with the help of one or more data sources. End user issues queries through various client tools by using UDM, these client tools may be Microsoft Excel. Following benefits are offered by UDM:

The user model is enriched greatly.
Even for huge data volumes, it can provide high-performance queries and can support interactive analysis too.
Business rules can be captured in the model and they usually support the richer analysis.

What are the SSAS components?

Following components are SSAS components:

Dimensional database components can be used in OLAP
Drilling is the process to explore data details
SQLicing means to place data in rows and columns
Pivoting means to switch data categories between rows and columns

What are the differences between DTS and SSIS?

Data Transformation Services vs SQL Server Integration Services
Data Transformation Services	SQL Server Integration Services
1. Limited error handling	1. Complex and powerful error handling
2. Message boxes in ActiveX scripts	2. Message boxes in .NET scripting
3. No deployment wizard	3. Interactive deployment wizard
4. A limited set of transformations	4. A good number of transformations
5. No BI functionality	5. Complete BI integration

What is control flow?

A control flow consists of one or more tasks and containers that execute when the package runs. To control order or define the conditions for running the next task or container in the package control flow, we use precedence constraints to connect the tasks and containers in a package. A subset of tasks and containers can also be grouped and run repeatedly as a unit within the package control flow. SQL Server Integration Services (SSIS. provides three different types of control flow elements:

Containers that provide structures in packages
Tasks that provide functionality
Precedence Constraints that connect the executables, containers, and tasks into an ordered control flow

How do you deploy SSIS packages?

SSIS Project BUILD provides a Deployment Manifest File which needs to be run. We have to then decide whether to deploy this onto File System or onto SQL Server [ msdb]. SQL Server Deployment is faster and more secure then File System Deployment. Another way of doing this is to import the package from SSMS from File System or SQL Server.

Name the components of SSAS.

The components are:

An OLAP Engine is used for enabling fast ad hoc queries by end users. A user can interactively explore data by drilling, SQLicing or pivoting.
Drilling refers to the process of exploring details of the data.
SQLicing refers to the process of placing data in rows and columns.
Pivoting refers to switching categories of data between rows and columns.
In OLAP, we will be using what are called as Dimensional Databases.

How does error-handling work in SSIS?

When a data flow component applies a transformation to column data, extracts data from sources, or loads data into destinations, errors can occur. Errors frequently occur because of unexpected data values.
The types of typical Errors in SSIS are:

Data Connection Errors, which occur in case the connection manager cannot be initialized with the connection string. This applies to both Data Sources and Data Destinations along with Control Flows that use the Connection Strings.
Data Transformation Errors, which occur while data is being transformed over a Data Pipeline from Source to Destination.
Expression Evaluation errors, which occur if expressions that are evaluated at run time perform invalid

What is the difference between WHERE and HAVING clauses in SQL Server?

HAVING clause can be used only with a GROUP BY clause, whereas a WHERE clause can be used with constructs such as SELECT, UPDATE, DELETE etc.
HAVING clause is applied as a filter to the data/output resulting from the GROUP BY clause, where as a WHERE clause is applied to every row in the SELECT, UPDATE, DELETE etc constructs.
In queries where both HAVING and WHERE clauses are used, WHERE clause is applied first (to every row in the SELECT statement to filter the records before they are fed to GROUP BY clause for aggregation. and then the HAVING clause is applied (to filter the aggregated result from GROUP BY clause

What languages are used in SSAS?

The languages used are:

Structured qquery Language (SQL.)
Multidimensional Expressions (MDX. – an industry standard qquery language orientated towards analysis
Data Mining Extensions (DMX. – an industry standard qquery language oriented toward data mining
Analysis Services Scripting Language (ASSQL. – used to manage Analysis Services database objects

Name the business analysis enhancements available for SSAS.

The table below shows the business intelligence enhancements that are available in Microsoft SQL Server Analysis Services (SSAS The table also lists the cube or dimension to which each business intelligence enhancement applies, and indicates whether an enhancement can be applied to an object that was created without using a data source and for which no schema has been generated.

Enhancement	Type	Applied to	No data source
Time Intelligence	Cube	Cube	No
Account Intelligence	Dimension	Dimension or cube	No
Dimension Intelligence	Dimension	Dimension or cube	Yes
Custom Aggregation	Dimension	Dimension (unary operator. or cube	No
Semi additive Behavior	Cube	Cube	Yes
Custom Member Formula	Dimension	Dimension or cube	No
Custom Sorting and Uniqueness Settings	Dimension	Dimension or cube	Yes
Dimension Writeback	Dimension	Dimension or cube	Yes

What are the differences between TRUNCATE & DELETE clauses in SQL Server?

TRUNCATE is a DDL (Data Definition Language. command, whereas DELETE is a DML (Data Manipulation Language. command.

TRUNCATE removes all the records from a table without making a log entry for individual row deletions whereas DELETE removes all or selected records (based on absence or presence of a WHERE condition. from a table by making a log entry for individual row deletion. Hence TRUNCATE is faster than DELETE.

TRUNCATE removes all the records from a table and a WHERE clause or filter condition cannot be used with TRUNCATE, whereas DELETE can remove selected records or all records based on whether a WHERE clause (optional. is used or not used respectively

TRUNCATE cannot be used on a table if it satisfies one of the following conditions:

The table is referenced by one of more FOREIGN KEY constraints
The table is marked/enabled for replication TRUNCATE resets IDENTITY in any of the columns in a table, whereas DELETE does not reset the IDENTITY.

What are the differences between DTS and SSIS?

Data Transformation Services SQL Server Integration Services

Limited Error Handling Complex and powerful Error Handling
Message Boxes in ActiveX Scripts Message Boxes in .NET Scripting
No Deployment Wizard Interactive Deployment Wizard
Limited Set of Transformation Good number of Transformations
NO BI functionality Complete BI Integration.

What are the benefits of using embedded code in a report?

The benefits are:
Reusability of Code: function created in embedded code to achieve a logic can be then used in manifold expressions
Centralized code: it helps in the better manageability of code.

Can You Name Five Of The Perfmon Counters For SSIS And The Value TheyProvide?

SQLServer: SSIS Service
SSIS Package Instances
SQLServer: SSIS Pipeline
BLOB bytes read
BLOB bytes are written
BLOB files in use
Buffer memory
Buffers in use
Buffers spooled
Flat buffer memory
Flat buffers in use
Private buffer memory
Private buffers in use
Rows read
Rows wrote.
S Utility: this utility is mainly used to automate report server deployment.

While creating a new calculated member in a cube what is the use of a property called non-empty behavior?

Nonempty behavior is an important property for ratio calculations. If the denominator is empty, an MDX expression will return an error just as it would if the denominator Were eual to zero. By selecting one or more measures for the Non-Empty Behavior property, we are establishing a requirement that each selected measure first be evaluated before the calculation expression is evaluated. If each selected measure is empty, then The expression is also treated as empty and no error is returned.

Explain transfer SQL Server object task?

It allows us to allocate different SQL server objects between different instances of SQL Server. Object incomes from the table, stored procedures, user-defined functions, etc.

What Are the Types of Parameters in Ssrs?

The types of parameters in SSRS are:

Single value parameters
Multivalue parameters
Cascading parameters.

What Is Hyperion? Is It an Olap Tool?

It’s Business Intelligence tools. Like Brio which was an independent product bought over my, Hyperion has converted this product name to Hyperion Intelligence.

Yes. You can analyze data schemas using these tools.

How in MDX qquery can I get top 3 sales years based on order quantity?

By default, Analysis Services returns members in an order specified during attribute design. Attribute properties that define ordering are “OrderBy” and “OrderByAttribute”. Let us say we want to see order counts for each year. In Adventure Works MDX qquery would be:

SELECT {[Measures].[Reseller Order quantity]} ON 0, [Date].[Calendar].[Calendar Year]
.Members ON 1
FROM [Adventure Works];
Same qquery using Top Count:
SELECT {[Measures].[Reseller Order quantity]} ON 0,
Top Count([Date].[Calendar].[Calendar Year].Members,3, [Measures].
[Reseller Order quantity]. ON 1
FROM [Adventure Works];

What are check point and how they work?

SSIS 2005 included a feature called checkpoints, which allows you to restart the package if it fails for any reason. During package execution, the last completed task or container is noted in a checkpoint file, and the checkpoint file is removed if the package completes successfully. But if the package fails before completing, the checkpoint file remains available as a reference to the location from which to restart the package.

You need to set three package properties:

CheckpointFileName: For this property, you need to provide a path and filename for the checkpoint file. If you plan to keep checkpoints implemented when you put a package into production, it’s a good idea to use a Universal Naming Convention (UNC. path.

CheckpointUsage: This property has three possible values: Never, Always, and exists. The default is Never, which prevents checkpoint creation. When you specify the Always option, the package uses the checkpoint file if it exists. If it doesn’t exist, the package fails. Therefore, the Always option isn’t recommended for a package in production because the package shouldn’t be failing regularly. (A package failure is the only way a checkpoint file gets created. Once the package completes successfully, the checkpoint file is removed The best option to use is IfExists. When you select this option, the package uses the checkpoint file if it exists. If it doesn’t exist, the program starts from the beginning of the package.

SaveCheckpoints: This property must be set to True. Otherwise, the previous settings won’t have any effect. By default, it’s set to False.

How we can handle Early Arriving Facts?

Early Arriving Facts sometimes get unavoidable because delay or error in Dimension ETL or may be due to logic of ETL. To handle Early arriving Facts, we can create a dummy Dimension with natural/business key and keep the rest of the attributes as null or default.

Explain the two-tier architecture of SSAS?

ASSAS uses both server and client components to supply OLAP and data mining functionality to BI Applications.
The server component is implemented as a Microsoft Windows service. Each instance of Analysis Services is implemented as a separate instance of the Windows service.
Clients communicate with Analysis Services using the standard XMLA (XML for Analysis. protocol for issuing commands and receiving responses.

What is Report Builder?

Report Builder is a business-user, ad-hoc report design client that allows users to design reports based on the business terms (Report Builder model. they are familiar with, but without needing to understand database schemas or how to write SQL or MDX queries. Report Builder works with both SQL Server and Analysis Services data sources.

How does Report Builder support Analysis Services cubes?

Report Builder supports relational SQL and Analysis Services data sources in SQL Server. To create a model for Analysis Services cube, go to Report Manager or Management Studio, create a data source for your Analysis Services database, and then select the Generate Model option to create the model.

Difference between Logical Page and Physical Page in SSRS?

Logical page breaks are page breaks that you insert before or after report items or groups. Page breaks help to determine how the content is fitted to a report page for optimal viewing when rendering or exporting the report. The following rules apply when rendering logical page breaks: Logical page breaks are ignored for report items that are constantly hidden and for report items where the visibility is controlled by clicking another report item.

Logical page breaks are applied on conditionally visible items if they are currently visible at the time the report is rendered. Space is preserved between the report item with the logical page break and its peer report items. Logical page breaks that are inserted before a report item push the report item down to the next page. The report item is rendered at the top of the next page. Logical page breaks defined on items in table or matrix cells are not kept. This does not apply to items in lists.

Define query parameter in SSRS?

query parameters are revealed in the query of the data sources that are to be included in the SQL script’s where clause of the SQL that can accept parameters. query parameters begin with the symbol @.

What do you understand by the matrix in SSRS?

A matrix is a data region related to a report set. Matrix permits us to create crosstab reports with the report variables showing on rows and columns. It allows us to drag.

Can you import Microsoft Excel data to SSRS?

Reporting Services does not import data. It only queries data in whatever format it is stored in their native storage system. I will assume that you’re asking whether you can create reports and use Excel spreadsheets as data sources. The answer is Yes, Reporting Services supports a wide variety of data sources, including Excel files. You’ll get the best performance with the built-in native .NET providers but you should be able to connect to any ODBC or OLE-DB data source, whether it comes from Microsoft or a third-party company.

Can we deploy SSRS reports on our website?

Your reports can only be deployed on a reporting services site. Your only option for viewing them from other sites is an HTTP link. Some tools, like SharePoint, offer controls allowing you to view reports in the context of the other websites, but the report is still deployed to and hosted from reporting services.

How we can restart the package from previous failure point? Define Checkpoints and how they are implemented in SSIS?

When a package is arranged to use checkpoints, material about package execution is written to a checkpoint file. When the failed package is rerun, the checkpoint file is used to restart the package from the point of failure. If the package runs effectively, the checkpoint file is deleted, and then re-created the next time that the package is run.

How we can do Logging in SSIS?

Logging Configuration provides an inbuilt feature which can log the detail of various events like onError, warning, etc.

How do users use Report Builder with SQL Server data sources?

While models that provide access to SQL Server Analysis Services are automatically generated on the report server, the Report Builder Model Designer can be used to generate or modify the models that are built on top of SQL Server relational databases. These model-building projects are a new type of project within a Visual Studio-based development shell.

What is the use of Expression task ?

To set User variables’ values during run time without having to use the Script task .

Which are blocking transformations in SSIS ?

Sort , Merge , Merge Join .

What can you use to get the Cube measure values

DAX, MDX.

What is SCD-2?

SQLowly changing transformation, type 2

When do use SCD -2, give an example

Employee table where the employee location, name etc changes but employee ID does not and we need to keep the entire history of changes to any attributes of the employee entity.

How can you implement SCD?

It can be implemented by both SSIS and stored procedures.

How to dynamically process Cubes?

Using XMLA

What is a data warehouse?

Collection of dimensions and facts

What are Facts?

These contain the aggregations built on top of transactional data .

Explain the SQLowly arriving dimension scenario?

When the data for dimensions arrives later than that of FACTs.

Can you parameterize SSRS reports?

Yes

What are cascading parameters?

It is used when the drop-down list of one parameter impacts the values in the drop down list of other, like Country and Region.

What are subscriptions in SSRS?

It is used to process the report and send it to a target audience.

What is data driven subscription?

It is where the attributes required to create a subscription are drawn from database fields.

What property in SSIS needs to be set to prevent the ForEachLoop container from failing due to failure of a contained task ?

PropagateError.

What are the DAX functions you have used?

SUM, CALCULATE, SWITH , RELATED , LOOKUP , YEAR, MTD.

What is YTD ?

Year to date meaning it get the records which lie from the Start of the year uptill the date field value in the row

What are the modes of SSAS?

Multidimensional, Tabular.

What actions are required for publishing an SSRS report to SharePoint?

You need to remap the data source and dataset and create them beforehand.

How to run a piece of XMLA code in a batch?

Using <BATCH> </BATCH> .

Name some transformation sin SSIS ?

Bulk Insert , Lookup , Merge, Merge Join, Fuzzy Lookup.

These are used to facilitate more dynamic and smooth package deployments across PROD, DEV, and test environments.

How to call a child package from Parent package?

Using parent child package configurations.

What are layers involved in creating a datawarehouse ?

Landing, Staging, and Modelling where Landing contains data received from sources, Staging layer contains the transformations made to fit the data for aggregations, Modelling is where aggregations are stored.

How to create aggregations in SSAS tabular ?

Using DAX .

What is the default mode of SSAS?

Multidimensional.

State differences between the Multidimensional and Tabular

Tabular doesnot have DataMining algorithms
The dataprocessing upper limit of tabular is less than multidimensional .

Any other tools that use DAX?

PowerBI .

How can you configure the Report server URL?

Using the Report Configuration Manager.

What is a shared file subscription?

It is where the report file is dropped in a shared location by the Reporting services.

How to debug an expression at runtime in SSIS ?

By using breakpoints and assigning the expression to a variable.

Clarify can SSRS reports Cache results?

Sparing reports draw in clients to access and view reports in a general sense snappier.
SSRS licenses Cache gives a record of the overseeing server.

What are the Reporting Services parts?

Revealing affiliations domains help progress.
These controlling parts mix a few instruments that are utilized to make, control and view reports.
Report Designer is balanced making the reports.
Report Server is utilized for executing and scattering reports.
Report Manager contemplates dealing with the report server.

What sorts of records can report be continued running under?

The Report Server Service can be continued running under a trademark help account, a Windows account on your close to PC, or in your structure space What are SSRS reports used for?

SQL Server Reporting Services (SSRS. is a server-based report passing on programming structure made by Microsoft and used as a response for affiliations who need to produce custom reports from a get-together of data sources, for instance, SQL databases and other outside sources, that empowers supervisor to share reports.

What is Snapshot Report in SSRS?

A report see is a report that contains plan information and requesting results that were recouped at a specific point in time.
Not the SQLightest bit like on-demand reports, which get cutting edge question results when you select the report, report sneak apexes are overseen on a timetable and sometime later saved to a report server.

What is falling parameters in SSRS?

Falling parameters give a framework for supervising a ton of report data.
You can delineate a lot of related parameters with the objective that the snappy diagram of characteristics for one parameter depends on the value picked in another parameter. For example, the central parameter is free and may show a snappy outline of thing classes.

What is the drill-down report in SSRS?

Drill Down Reports in SSRS.
The Drill Down Reports in SSRS means drawing in Users to Show or Hide the Column Data by giving in spite of and fewer pictures on a book box (essentially, Providing Interactivity to the Users.

What is the explore report in SSRS?

A click through report is a report that introductions related data from a report model when you click the characteristic data contained inside your model-based report.
These reports are passed on by the report server subject to the information contained inside the report model.

What is Report Subscription in SSRS?

A Reporting Services intrigue is a structure that passes on a report at a specific time or in light of an event, and in a record position that you show.
Enrollments can be used to design and robotize the vehicle of a report and with a specific procedure of report parameter regards.

Do you make your reports using the wizard or physically?

Also, similarly as with most Microsoft gadgets, SSRS consolidates a wizard that energizes you make reports.
The wizard is exceptional for people who are new to the thing, yet it’s awful in case you can’t go past the mechanical assemblies and make a report without any planning.
Before you go for your gatherings, guarantee you can make a report without any planning without any wizards or mechanical assemblies to make them for you.
Most associations need someone who can change reports, and wizards leave space for by no customizations.

What are request parameters?

Request parameters are the bits of a SQL question that empower you to channel results. Parameters are contained in the SQL’s “the spot” explanation.
These parameters tell the SQL server which records you have to invigorate, select, or delete.
By the day’s end, notwithstanding the where stipulation parameters, you would impact all records in your tables.

What are the RDL reports?

RDL records take after the “language” for SSRS servers.
Regardless, RDL records are made in XML, so the “language” of SSRS servers is XML.
PDF records contain the request and configuration bunch for your reports.

What servers can be used with SSRS?

While most associations use SQL Server with SSRS, you can similarly join other database servers with your SSRS reports.
SSRS is flawless with Oracle, ODBC and OLEDB affiliations, Hyperion, Teradata and level XML records that contain data.

What is mixed mode database security?

Exactly when you present SQL Server, you have the choice to allow SQL Server to arrange with Windows or anticipate that customers should have an alternate SQL Server customer name and mystery word.
While Windows coordination is beneficial, it’s not seen as the most secure of the two security decisions.
It’s more brilliant to require an alternate SQL Server customer name and mystery key when marking into the database server.
Your reports will require their customer name and mystery expression to run reports from SSRS.

How might you send a report to a noteworthy server?

The SSRS uncovering programming fuses instruments to pass on authentically to the SQL Server itemizing server.
After you’ve planned your item with the most ideal SQL Server, customer name and mystery key, you just need to right-tap the report you have to pass on and click “Send.”
Make sure you test the report after you send it to ensure there are no bugs and that the data returned is correct.

How might you adjust a report?

Open SQL Server Management Studio and the reporting adventure.
Develop the center point that contains your reports.
Right-click the report and snap “Modify.” You can in like manner save your noteworthy record from this view.

How may you approach working up an SSRS report?

The general development approach for an SSRS report is to start by making a data source.
Considering the data source make one or differing datasets as required for parameters and the body of the report.
Wire required controls from the instrument stash which would go about as a compartment for the fields in the dataset. Structure the controls added to the report body.
Check and grasp the report finally pass on the report.

Define Control Flow in MSBI tools?

Control flow consists of more than one container and tasks that are executed along with the package execution. We can control the order of execution for containers and tasks of package control flow and for this, we prefer precedence constraints through which we can connect tasks and containers of a package. Even subset of any container and task can also be regrouped repeatedly as a unit. SSIS or SQL Server Integration Service basically provides three types of containers that can provide package structures, tasks to provide functionality and precedence constraints to connect executable containers and tasks.

Explain data flow in SSIS.

Data flow involves sources of data along with its destination to load and extract data, a transformation that can extend and modify data along with paths that can link sources, transformation, and destinations. Data flow engine is an executable process of SSIS that can create, order, and run data flow. For each data flow task, a separate data flow engine is opened in the package. Hence, we can say that in case of data flow data source, transformation, and data destinations are three important categories.

Enlist and explain SSIS transformation and their purpose.

SSIS provides the following transformations as discussed below:

AUDIT: It is used to add task and package level metadata like package name, machine name, execution instance or package ID.
Aggregate: Through this aggregate function is applied to the record set and new output from these aggregated values is produced
Conditional Split: Separate input values are distributed among separate output pipelines as per the Boolean value of the expression that is configured for each output
Data conversion: It is used to convert column data types from one form to another
Character Map: It can perform column level string operations like to change data from lower case to upper case
Data Mining query: It is used to perform data mining queries against managing controls and analysis services
Fuzzy LookUp: Is used to match the pattern on the basis of Fuzzy Logic
Merge: It can merge two sorted datasets into a single data asset or data flow
Multicast: Is used to send a copy of supplied data source to multiple destinations.

What is variable and the scope of variables?

The value that can be used by SSIS package containers, tasks, and event handlers at runtime are stored in the variables of SSIS package. Script task and script components are used by these variables. Moreover, precedence constraints can be used to sequence tasks and containers into a workflow. Usually, two types of variables are used by these integration services, one is user-defined variables and other is system variables. User-defined variables are basically defined by the package developers, while system variables are defined by the integration services. The user can define and use as many as user-defined variables, while there is only a certain number of system variables that can be used and they cannot be created.

What is subreport and how are they created?

Subreport is just like other reports that can be termed in main reports and even generated through that as well. Main report parameters can be inherited to subreports and a report can be created in this way.SQL Server Training & Certification

Explain the need for SAAS component.

With the following facts, you will quickly understand the need for SAAS components –

SSAS in an interactive and easy to use component,
Troubleshooting and faster analysis can be performed,
A data warehouse can be easily managed and created,
Efficient security principles can be applied,
Analysis and forecast operations can be performed by analysis services.

Explain two-tier SSAS architecture?

Both client and server components are used to provide data mining functionality for BI applications and to supply OLAP
The client can use analytics services by using XMLA protocol to receive a response, issue commands, and can be exposed as a web service
The server component is used as Microsoft Windows service and each analysis service implement as a separate instance of windows service.

Define SSIS. How is it related with SQL Server?

A component of SQL Server, SQL Server Integration Services (SSIS. can be used to perform a variety of Data migration and ETL operations.
SSIS is a platform for Integration and Workflow applications which is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL.)
It can also be used to automate maintenance of SQL Server databases and multidimensional data sets.

Which are the different Lookup Cache Modes Available in SSIS?

There are three Cache Modes available in SSIS Lookup Transformation:

Full Cache Mode: In this cache mode, SSIS queries the database before the start of the data flow task execution (pre-execute phase. and loads all the data from lookup/reference table into SSIS lookup cache.
Partial Cache Mode: In this cache mode, SSIS queries the database against new rows coming in from the source. If there is a match, the row is cached into SSIS Lookup Cache for rows coming subsequently in the data flow which might have a match. When the cache is full, SSIS then proceeds to remove few rows from cache based on the usage/match statistics for those rows and loads the new matching rows into the Lookup Cache.
No Cache Mode: In this cache mode, SSIS does not cache any rows into Lookup Cache (except in cases such as two subsequent source data rows having a match with same lookup values. For every row coming from the source, the database is queried to get the matching value/data from the reference table.

What is data flow?

Data flow consists of the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations. Data Flow task is the executable within the SSIS package that creates, orders, and runs the data flow. A separate instance of the data flow engine is opened for each Data Flow task in a package. Three important categories in the data flow are:

Data Sources
Transformations
Data Destinations

How to log SSIS Executions?

SSIS includes logging features that write log entries when run-time events occur. They can also write custom messages although it is not enabled by default. Integration Services supports a diverse set of log providers, giving you the ability to create custom log providers. The Integration Services log providers can write log entries to text files, SQL Server Profiler, SQL Server, Windows Event Log, or XML files. Logs are associated with packages and are configured at the package level. Each task or container in a package can log information to any package log. The tasks and containers in a package can be enabled for logging even if the package itself is not.

Explain the two-tier architecture of SSAS?

SSAS uses both server and client components to supply OLAP and data mining functionality to BI Applications.
The server component is implemented as a Microsoft Windows service. Each instance of Analysis Services is implemented as a separate instance of the Windows service.
Clients communicate with Analysis Services using the standard XMLA (XML for Analysis. protocol for issuing commands and receiving responses.

What is OLAP?

OLAP stands for On-Line Analytical Processing. It stands for a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

Differentiate between OLAP and ETL tools.

OLAP is an online analytical processing tool.
ETL stands for Extract, Transform and Load. This is a product to extract the data from multiple/single sources and transform the data and load it into a table, flat file or simply a target.

Name the tools used in MSBI.

Microsoft BI contains the following tools:

SQL Server Analysis Services (SSAS.
SQL Server Integration Services (SSIS.
SQL Server Reporting Services (SSRS.
Performance Point Services (PPS.

What is a workflow in SSIS?

Workflow is a set of instructions to tell the Program Executor how to execute tasks and containers within SSIS Packages.

Name the differences between view and materialized view.

Views:

A view takes the output of a qquery and makes it appear like a virtual table. You can use a view in most places where a table can be used.
All operations performed on a view will affect data in the base table and so are subject to the integrity constraints and triggers of the base table.
A View can be used to simplify SQL statements for the user or to isolate an application from any future change to the base table definition. A View can also be used to improve security by restricting access to a predetermined set of rows or columns.
In addition to operating on base tables, one View can be based on another. A view can also JOIN a view with a table (GROUP BY or UNION.

Materialized Views:

Materialized views are schema objects that can be used to summarize, pre-compute, replicate, and distribute data. E.g., to construct a data warehouse.
A materialized view provides indirect access to table data by storing the results of a qquery in a separate schema object.
The existence of a materialized view is transparent to SQL, but when used for qquery rewrites, it will improve the performance of SQL execution.

What is Writeback? What are the pre-conditions?

The Enable/Disable WriteBack dialog box enables or disables WriteBack for a measure group in a cube. Enabling WriteBack on a measure group defines a WriteBack partition and creates a WriteBack table for that measure group. Disabling WriteBack on a measure group removes the WriteBack partition but does not delete the WriteBack table, to avoid unanticipated data loss.

How do you extract first tuple from the set?

Use could usefunctionSet.Item(0.
Example:

SELECT {{[Date].[Calendar].[Calendar Year].Members }.Item(0.}
ON 0
FROM [Adventure Works]

If you want to create a calculated member that intersects all measures, where do you put it and why?

You would put it in a dimension other than Measures because a member in a dimension cannot intersect its own relatives in that dimension.

What is the use of property called non-empty behavior while creating a new calculated member in a cube?

Nonempty behavior is used for ratio calculations. An MDX expression will return an error if the denominator is empty, just as it would if the denominator were equal to zero. By selecting one or more measures for the non-empty behavior property, we’re establishing a requirement that each selected measure first be evaluated before the calculation expression is evaluated. If each selected measure is empty, then the expression is also treated as empty and no error is returned.

What are the differences between TRUNCATE & DELETE clauses in SQL Server?

TRUNCATE is a DDL (Data Definition Language. command, whereas DELETE is a DML (Data Manipulation Language. command.
TRUNCATE removes all the records from a table without making a log entry for individual row deletions whereas DELETE removes all or selected records (based on absence or presence of a WHERE condition. from a table by making a log entry for individual row deletion. Hence TRUNCATE is faster than DELETE.
TRUNCATE removes all the records from a table and a WHERE clause or filter condition cannot be used with TRUNCATE, whereas DELETE can remove selected records or all records based on whether a WHERE clause (Optional. is used or not used respectively.
TRUNCATE cannot be used on a table if it satisfies one of the following conditions:

Table is referenced by one of more FOREIGN KEY constraints
Table is marked/enabled for replication

TRUNCATE resets IDENTITY in any of the columns in a table, whereas DELETE does not reset the IDENTITY.

What are the Command-Line Utilities available in Reporting Services?

Rsconfig Utility (Rsconfig.exe.: encrypts and stores connection and account values in the RSReportServer.config file.

RsKeymgmt Utility: it is used to Extracts, restores, creates, and deletes the symmetric key used to protect sensitive report server data against unauthorized access.

Name different types of data sources in SSRS?

SSRS uses a different data source. Some of them are listed below.

SQL Server SAP Net weaver BI.
Report Server Model.
SQL Server Analysis Service OLEDB.
SAP Net weaver BI.
XML

How we can schedule an SSIS package?

Using SQL Server Agent we can schedule an SSIS package.

What Are Variables and What Is Variable Scope?

Variables store values that an 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 use variables when their constraint definitions include expressions.

Integration Services supports two types of variables: user-defined variables and system variables. User-defined variables are defined by package developers, and system variables are defined by Integration Services. You can create as many user-defined variables as a package requires, but you cannot create additional system variables.

How to create Drill-Down reports?

By grouping data on essential fields
Then toggle reflectivity based on the grouped filed.

What is MSBI (Microsoft Business Intelligence?

Microsoft Business Intelligence (BI. is a suite of products and tools that you can use to monitor, analyze and plan your business by using scorecards, dashboards, management reporting, and analytics?

What are the tools in MSBI?

It contains the following tools:

SQL Server Analysis Services (SSAS.
SQL Server Integration Services (SSIS.
SQL Server Reporting Services (SSRS.
Performance Point Services (PPS. which was added as a free service in Microsoft Office SharePoint 2010.

How we can create Drill-through reports?

By Using Navigation property of a cell and scenery child report and its parameters in it we can create Drill-through reports.

Progress execution by practicing Linux software invasion and striping over four extents.

Name a few Business Analysis Enhancements for SSAS?

The following table lists the business intelligence enhancements that are available in Microsoft SQL Server Analysis Services (SSAS The table also shows the cube or dimension to which each business intelligence enhancement applies, and indicates whether an enhancement can be applied to an object that was created without using a data source and for which no schema has been generated.

Enhancement Type Applied to No data source
Time Intelligence Cube Cube No
Account Intelligence Dimension Dimension or cube No
Dimension Intelligence Dimension Dimension or cube Yes
Custom Aggregation Dimension Dimension (unary operator. or cube No
Semiadditive Behavior Cube Cube Yes
Custom Member Formula Dimension Dimension or cube No
Custom Sorting and Uniqueness Settings Dimension Dimension or cube Yes
Dimension Writeback Dimension Dimension or cube Yes.

Where do you put calculated members?

The reflexive answer is “in the Measures dimension” but this is the obvious answer. So, I always follow up with another question. “If you want to create a calculated member that intersects all measures, where do you put it?” A high percentage of candidates can’t answer this question, and the answer is “In a dimension other than Measures.” If they can answer it, I immediately ask them why. The answer is “Because a member in a dimension cannot intersect its relatives in that dimension.”

What Is the Difference Between Olap And ETL Tools?

OLAP: It’s an online analytical processing tool. There are various products available for data analysis.
ETL: Extract, Transform and Load. This is a product to extract the data from multiple/single source transform the data and load it into a table, flat file or simply a target.

How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?

Simply using bottom count will return customers with null sales. You will have to combine 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].;

What Is Processing?

Processing is a critical and resource-intensive operation in the data warehouse lifecycle and needs to be carefully optimized and executed. Analysis Services 2005 offers high performance and scalable processing architecture with a comprehensive set of controls for database administrators.
We can process an OLAP database, individual cube, Dimension or a specific Partition in a cube.

How do you extract the first tuple from the set?

Use could usefunctionSet.Item(0.
Example:

SELECT {{[Date].[Calendar].[Calendar Year].Members
}.Item(0.}
ON 0
FROM [Adventure Works]

What Is Processing?

We can process an OLAP database, individual cube, Dimension or a specific Partition in a cube.

How checkpoint works in for loop?

The Foreach Loop container is another atomic unit of work that can be restarted. However, the checkpoint file does not contain information about the work completed by the child containers, and the Foreach Loop container and its child containers run again when the package restarts.

What Is A Master Package?

The Master package is nothing but it is also a normal SSIS package, it acts as a master to run the all other (child. packages. If you call the other SSIS packages in a new SSIS package using ‘Execute Package Task’, the new package called a master package. The use of this package (Master. is, instead of running all individual packages if we can run the single master package, then automatically all the child packages will run. Normally we simply schedule the master package in SQL server agent by adding the all-child packages values in the master package config file.

How does error-handling work in SSIS?

The types of typical Errors in SSIS are:
Data Connection Errors, which occur in case the connection manager cannot be initialized with the connection string. This applies to both Data Sources and Data Destinations along with Control Flows that use the Connection Strings.
Data Transformation Errors, which occur while data is being transformed over a Data Pipeline from Source to Destination.
Expression Evaluation errors, which occur if expressions that are evaluated at runtime perform invalid

What are the Reporting Services components?

Reporting services components assist in development. These processing components include some tools that are used to create, manage and view reports. A report designer is used to create the reports. a report server is used to execute and distribute reports. a report manager is used to manage the report server.

SQL Server Reporting Services vs Crystal Reports?

Crystal reports are processed by IIS while SSRS have a report server. Caching in Crystal reports is available through cache server. On the other hand, caching in SSRS is available for Report history snapshots. Crystal reports have standards and user-defined field labels. SSRS allows the only user-defined field labels.

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 a cube. (like creating one object (table. in the relational database.

So, once you deploy the structure to the SSAS server, we need to load the data into the structure we have created. This process of loading data into the cube and creating the aggregations is called Cube processing. (like inserting the data into your table. So, to make a cube online for the user for querying we need to build the structure of the cube in BIDS and deploy it to an SSAS server and the process it to load with data and aggregations, then the user can query on the SSAS cube.

How we can achieve parallelism in SSIS?

Parallelism is achieved using MaxConcurrentExecutable stuff of the package. Its default is -1 and is calculated as the number of computers + 2.

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

In the filter dialog box, click the name of the criteria that you would like to prompt the user for when viewing the report. For example, for the criteria Order Year=2000, click Order Year. Select the Prompt option in the drop-down list.

Do I need a report server to run reports in my application?

In addition to publishing reports to a report server, you can build reports using the Report Designer that is directly integrated with Visual Studio language projects. You can embed reports directly in any Windows Forms or ASP.NET Web application without access to a report server. The data access in embedded reports is a natural extension of the Visual Studio data facilities. Not only can you use traditional databases as a source of data for your reports, but you can also use object collections as well.

What is the need for SSAS component?

Analysis Services is the only component in SQL Server using which we can perform Analysis and Forecast operations.

SSAS is very easy to use and interactive.
Faster Analysis and Troubleshooting.
Ability to create and manage Data warehouses.
Apply efficient Security Principles.

Will running SSRS on Windows XP limit the number of users?

Yes, but not because of SSRS. The Internet Information Services (IIS. component of Windows XP only allows a small number of users to connect to the website at once. As SSRS runs via IIS, this would prevent more than a few people from using SSRS at once. Also, the only edition of SSRS that will install on Windows XP is the Developer Edition. This edition cannot be used for production use. You need Standard or Enterprise Edition for production use, which requires a Server OS to install on (Windows 2003 Standard, Windows 2008 Standard, etc.

Define SSIS. How it is related with SQL Server?

A component of SQL Server, SQL Server Integration Services (SSIS. can be used to perform a variety of Data migration and ETL operations. SSIS is a platform for Integration and Workflow applications which are known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). It can also be used to automate maintenance of SQL Server databases and multidimensional data sets.

What is a workflow in SSIS 2014?

Workflow is a set of instructions on to specify the Program Executor on how to execute tasks and containers within SSIS Packages.

So, this brings us to the end of the MSBI Interview Questions blog.
This Tecklearn ‘Top Microsoft BI Questions and Answers’ helps you with commonly asked questions if you are looking out for a job in Microsoft BI or Business Intelligence Domain. If you wish to learn MSBI and build a career in Business Intelligence domain, then check out our interactive, Microsoft BI Training, that comes with 24*7 support to guide you throughout your learning period.

https://www.tecklearn.com/course/microsoft-bi-course-training/

Microsoft BI Course Training

About the Course

Tecklearn’s Microsoft Business Intelligence Training makes you master Business intelligence and data mining tools. It will help you master MSBI concepts such as SSIS, SSRS and SSAS using SQL Server 2016 and SQL Server Data tools 2015. Microsoft BI Certification Course is designed to provide insights into different tools in Microsoft BI Suite like SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services. This MSBI training will also help you clear the MCSE: Business Intelligence Certification. As part of this training, you will learn data integration and creation of reports, dashboards, and cubes for faster reports generation.

Why Should you take Microsoft BI Training?

The Average salary for a Microsoft BI job role is $102K – Indeed.com
According to the research of HG Insights most of the technical enterprises are using Microsoft BI to evaluate their business.
Microsoft BI is a Leader in 2018 Gartner Magic Quadrant for Business Intelligence & Analytics Platforms (9th Consecutive Year).

Curriculum

MSBI SSIS Course Content

Introduction to MSBI and Data Warehousing

Fundamentals of Data Warehousing
Concepts of Dimensions, Measures, Metadata and Schemas
Data Marts and Design approaches
Normalization and Denormalization and Schema types
Concepts of Online Analytical Processing and Transactional Processing
OLAP Cube
Explain ETL process and various tasks involved in it
Slowly Changing Dimensions Types
Business Intelligence Concepts
Working of BI with data-warehouse

Introduction to SSIS

Understanding of the MSBI Architecture
Import and Export wizard
Understand SSIS Architecture
Control Flow and its Components (Tasks, Containers and Precedence Constraints)
Data Flow and its Components (Source and Destination Connections and types of Transformations)
System Variables and User-defined variables
Scenarios by combining Control Flow and Data Flow components
Hands On

Transformations and Use-Cases

Data Conversion transformation
Multicast transformation
Union all transformation
Conditional Split Transformation
Merge and Merge Join Transformation
Lookup transformation
Cached Lookup transformation
Foreach loop and use-cases
Bulk-insert task
Archival process using dynamic variables and FST
Advancing Execute SQL Task with Object return type
Types of Outputs usage
Hands On

Slowly Changing Dimensions

Understanding data that slowly changes over time
Learning the process of how new data is written over old data
Detail explanation of three types of SCDs –Type1, Type2 and Type3, and their differences
Hands On

Overview of Fuzzy Look-up Transformation and Lookup and Term Extraction

Concept of Fuzzy matching
How Fuzzy Lookup Transformation varies from Lookup Transformation
Hands On

Concepts of Logging & Configuration

Learning about error rows configuration
Package logging
Defining package configuration
Understanding constraints and event handlers
Hands On

MSBI SSAS Course Content

Introduction to SSAS

Introduction to SSAS
SSAS Architecture
Features of SSAS
Modelling in SSAS
Tabular Model and Multidimensional Model
Data Sources and Data Source Views
Fact and Dimensions
Designing Dimensions
Dimension Hierarchies
Designing Measure Groups
Attribute Relationships

Cube: Operations and Limitations

Various operations on Cube
Limitations of OLAP Cubes
Cube and In-memory Analytics
Architecture of In-memory analytics and its advantages
Understanding How in-memory analytics works
Deploying cube to get self-service business intelligence with existing data warehouse capabilities
Hands On

Dimensions

Overview of the Dimensions concept
Describing the Attributes and Attributes Hierarchies
Understanding Key and Value Pairs
Metadata Reload, logical keys and role-based dimensions
Hands On

Measures & Features of Cube

Measures of Cube and analyzing the Measures
Exploring the relationship between Measure and the Measure Group
Features of Cube and Dimension usage
Deploying actions and drill-through actions on data
Understanding the Key Performance Indicators
Working with data partitions, aggregations, translations and perspectives
Hands On

SSAS Deployment and MDX, DAX

SSAS Deployment
Database deployment methods
Aggregation, KPIs, Actions, Perspectives, Translations
Named Calculations and Named queries
Cube Processing
Different Processing Options
Explain MDX and DAX Queries
Performance Optimization of cube and Dimension, Best Practices
Loading Data into DW using SSIS, MDX queries and DAX Queries
Schedule the Cube processing
Hands On

MSBI SSRS Course Content

Introduction to SSRS

Understanding SSRS Architecture
Learning the data flow in different components
SSRS Report Building tool components

Matrix and Tablix Overview

Understanding the concepts of Matrix and Tablix
Working with Text Box, learning about formatting, row and column grouping
Understanding sorting and formatting
Concepts of Header, Footer, Totals, Subtotals and Page Breaks
Hands On

Parameters and Expression

Learning about Parameters, filter and visibility expression

SSRS Reporting

Reporting Services Architecture & Lifecycle
Report Parameters and Multi-Valued
Cascaded Parameters
Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drillthrough, Subreports
Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers
Describe Mobile report publisher
Exporting Reports to different formats
Hands On

Reports and Authenticity

Understanding Report Cache
Authorization, Authentication and Report Snapshot
Subscriptions and Site Security
Hands On

Got a question for us? Please mention it in the comments section and we will get back to you.

714