MS BI SSIS Training Course Content

Spread the love

MS BI SSIS Training Course Content Details

What is MS BI SSIS

SQL Server Integration Services (SSIS) may be a element of the Microsoft SQL Server info software package which will be wont to perform a broad vary of knowledge migration tasks. SSIS may be a platform for information integration and work flow applications.

MS BI SSIS training in hyderabad kukatpallyUsing SSIS, Innovent Solutions will assist you implement AN acceptable info management foundation which will deliver integrated, accurate, and timely information across your organization. Our information management solutions facilitate make sure you offer trustworthy information within the areas of business intelligence, informationdeposition, information migration, and master information management. Our goal is to produce call manufacturers with correct, relevant and unjust info, leading to improved profitableness, improved client satisfaction and operation potency.
Utilizing SQL Server Integration Services we are able to work with you to form positive information is sourced properly, guarantee its quality, and supply the suitable information design for effective news and analysis. Our consulting services address the subsequent areas .for more info click here.




MS BI SSIS Training  Course Content

01.What Is Microsoft BI?

  • Core concept – BI is the cube or UDM
  • Example cube as seen using Excel pivot table
  • MS BI is comprehensive – more than Analysis Services on SQL Server
  • Demonstration of SQL Reporting Services with cube as data source

02.OLAP Modeling

  • Modeling source schemas—stars and snowflakes
  • Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
  • Understanding fact (measures) and cube modeling
  • Other types of modeling—data mining etc…

03.Using SSAS in BIDS

  • Understanding the development environment
  • Creating Data Sources and Data Source Views
  • Creating cubes – using the UDM and the Cube Build Wizard
  • Refining Dimensions and Measures in BIDS

04.Intermediate SSAS

  • KPIs
  • Perspectives
  • Translations – cube metadata and currency localization
  • Actions – regular, drill-through and reporting

05.Advanced SSAS

  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
  • Modeling changing dimensions – Dimension Intelligence w/ Wizard
  • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

06.Cube Storage and Aggregation

  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP, ROLAP, HOLAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design – Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options

07.Beginning MDX

  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions




08.Intermediate MDX

  • Adding calculated members
  • Adding scripts
  • Adding named sets
  • NET Assemblies

09.SSAS Administration

  • Best practices – health monitoring
  • XMLA scripting (SQL Mgmt Studio)
  • Other Documentation methods
  • Security – roles and permissions
  • Disaster Recovery – backup / restore
  • Clustering – high availability

10.Introduction to Data Mining

  • What and why?
  • Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
  • Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
  • Data Mining dimensions
  • Data Mining clients
  • Processing mining models

11.Introduction to Reporting Clients

  • Excel 2003 Pivot Tables
  • SQL RS & Report Builder
  • SPS RS web parts & .NET 2.0 report viewer controls
  • Business Scorecards 2005 & ProClarity

12.SSIS for DBAs: Using SQL Server Management Studio




  • The Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS
  • Scheduling and Executing Plans
  • Examining Database Maintenance Plan Packages
  • Changes in SQL Server 2005 Service Pack 2

13.Business Intelligence Development Studio

  • Launching BIDS
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

MS BI SSIS Training Demo

Contact Us for MS BI SSIS training demo Online and Classroom Training

venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 10, 2017 — 9:30 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.