Msbi Training

This section is designed to make you knowledgeable in differentiating various transformations and their use in different business scenarios. 

Topics: 

• Data conversion transformation
• Union all transformation
• Multicast transformation
• Conditional Split transformation
• Lookup transformation
• Merge and Merge Join transformation
• Foreach loop and use-cases
• Cached Lookup transformation
• Bulk-insert task
• Advance execution of SQL tasks using various scenarios 
• The archival process with dynamic variables and FST

Learning Outcome: Upon the completion of this section you will be able to understand the various transformations and how they are used in different business Use-cases. You will also gain hands-on expertise on Split transformation, usage of Foreach loop, Foreach loop and File system for data archival and process to insert and update records in slowly changing dimension. 

In this chapter, you will be learning how the objects of core SSIS workflow work together and communicates with one another to contribute to the smooth functioning of security and other functions. 

Topics: 

• Event handling, parameters
• Transaction Options, Logging options, CheckPoints, Log Provider
• Configure OnError event and error output 
• Package protection levels. 

Learning outcome: You will acquire complete knowledge on event handling, and package security in SSIS.  You will gain hands-on expertise in the creation of event handling tasks and Parameterize a package. 

This section is designed to cover the SSIS programming features which provide you with the required knowledge to handle custom requirements using .Net code.  In addition to this, you will also learn the process to configure and deploy SSIS projects in real-time.        

Topics: 

• Package Configurations, and script component,
• Troubleshooting & debugging
• Package deployment
• Executing packages – DTExecUI and DTExec 
• Scheduling package using SQL agent 
• Overview of package performance tuning
• SSIS best practices

Learning outcome: Upon the completion of this module, you will acquire knowledge of concepts like custom code, package configuration and deployment models.  You will gain hands-on experience in implementing custom code with script task and control using flow task that contains a script task to send an email.

This chapter is designed to provide full-fledged knowledge of SQL Server Analysis Services and its architecture. You will also be introduced to the various SSAS models along with measure groups and design dimensions.  Moreover, you will learn about SSAS administration with a major focus on processing and deployment. 

Topics: 

• Introduction to SASS
• Features of SSASS
• SAS architecture 
• Modelling in SSAS
• Data sources and data source views
• Multidimensional model and tabular model 
• Identify the Fact and Dimensions
• Dimension hierarchies
• Designing dimensions
• Designing measure groups
• Storage modes: ROLAP, MOLAP, Partitions HOLAP. 
• Attribute relationships.

Learning Outcome:  After completion of this module, you will acquire a complete understanding of SSAS concepts, modelling concepts, Dimension and measure groups, and importing data in SSAS from various sources. You will also gain hands-on expertise in creating dimensions and hierarchies, and creating data sources and data source views. 

In this chapter, you will learn the fundamentals of DAX & MDX and come to know the steps to be followed in SSAS performance tuning and troubleshooting. In addition to this, you will also be learning the creation of reports against SSAS as a data source and Ad-hoc reporting. 

Topics: 

• SSAS deployment
• Named queries and named calculations 
• Methods of database deployment
• Aggregation, Perspectives, KPIs, Translations, Actions.
• Different processing options
• Cube processing
• Introduction to MDX and DAX queries
• Performance optimization of Cube 
• Data loading into DW using SSIS, DAX Queries and  MDX queries
• Scheduling Cube performance. 

Learning outcome: After completion of this section, you will gain a complete understanding of concepts such as SSAS deployment, cube processing, MDX and DAX queries and performance optimization. You will gain hands-on experience in retrieving tabular data using DAX, retrieving data from a Cube using MDX query, and scheduling cube processing.

This module is designed to provide you with the fundamental knowledge in reporting services, SSRS architecture, and configuration process. You will also understand the environment in which reports are generated and the server in which reports are deployed. 

Topics: 

• SSRS features
• Reporting services lifecycle architecture 
• Cascaded parameters
• Report parameters 
• Types of Reports: Parameterized, Snapshot, Linked, Cached, Subreports Clickthrough, Ad hoc, Drillthrough. 
• Creating Groups, Expressions Sort and Interactive Sort, Filters, Repeating Row Headers and Column Headers Alternate Row Colors. 
• Exporting Reports to different formats
• Introduction to mobile report publisher 

Learning Outcome: By the completion of this chapter, you will gain a complete overview of  SSRS concepts, various types of Reports, and reports exportation into different formats. You will gain practical experience in creating a group in a table and usage of an interactive sort on a table and exporting report as a PDF. 

In this section, you will be going through various types of reports and their features along with the best methods to use. You will also learn various administrative tasks performed in SSRS. 

Topics: 

• Web PortalDeploying data sources and reports 
• Aspects of security
• Securing access to reports 
• Data Source Security, Snapshot Report and Caching Report
• Managing subscriptions 
• Ad-Hoc Reporting with report builder 
• Managing Subscriptions
• Report Subscriptions: Data-Driven, Standard. 

Learning outcome: After completion of this section, you will gain knowledge of various concepts such as Web Portal, Develop SSRS report using MDX and configure data source security. You will also gain hands-on expertise in creating a linked report, giving access to reports for different users from different locations.    

This chapter is designed to provide you with the overall knowledge of how these MSBI components work together in business intelligence tools to solve organizational data problems.  This module explains the end to end process of business intelligence tools. 

Topics: 

• End to end concepts business process with MSBI components: SSIS, SSAS. SSRS and MDX. 
• Best practises being followed in MSBI

Learning outcome: By the completion of this module, you will become familiar with the implementation and usage of SSIS, SSAS, SSRS and MDX and gain practical experience in using SSIS, SSAS, SSRS and MDX.