Overview, Business Intelligence (BI), SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS) and Azure SQL Server. Presentation contain :

  1. Basic Concept of BI

  2. Introduce Data Warehouse

  3. Microsoft BI Technologies

  4. Data Warehouse Design Concept

  5. Microsoft SQL Server Analysis Service (SSAS)

Demo Program: Step By Step: Develop ETL Process using SQL Server Integration Services (SSIS)

https://gallery.technet.microsoft.com/Design-Cube-in-SQL-Server-49ee6e1c

thECKM5KEO

  1. Microsoft SQL Server Integration Service (SSIS)

Demo Program: Step By Step: Develop ETL Process using SQL Server Integration Services (SSIS)

https://gallery.technet.microsoft.com/Step-By-step-Creating-a-d0e3e71d

  1. Microsoft SQL Server Reporting Service (SSRS)

Demo Program: Step by Step SSRS Report Design Using CUBE

https://gallery.technet.microsoft.com/Step-by-Step-SSRS-Report-8de35ea8

  1. Data Quality Service (DQS)

  2. Master Data Service

  3. Demos.

Resource :

  1. To know more about SQL Server 2014

https://www.microsoft.com/en-us/server-cloud/products/sql-server/Resources.aspx

  1. Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013

https://www.microsoft.com/en-us/download/details.aspx?id=42313

  1. Adventure Works 2014 Sample Databases

https://msftdbprodsamples.codeplex.com/releases/view/125550