This project was provided by John Bryce High Tech College (Tel-Aviv, Israel).

As a part of the project was established the BI system, which provides to an end user to perform data analysis on the basis of current business data.

The creating of this system was performed in Microsoft SQL Server 2012 environment and included three stages :
  1. ETL process in SQL Server Integration Service.
  2. Analysis cube in SQL Server Analysis Service.
  3. Reports in Excel and SQL Server Report Service.

The project contains the following folders :
  1. Specification documents
  2. Source files for projects
  3. Generated sql scripts
  4. DWH schema
  5. SSMS project
  6. Backup files
  7. SSIS project
  8. SSAS project
  9. Excel reports
  10. SSRS project

Last edited Dec 13, 2014 at 9:46 AM by PavelZeger, version 8