Sunday 22 June 2014

Data flow in MSBI


Raw data from different sources (Souce would be Any Data Base)---->Using SSIS--->Prepare Valid Information (Data Base)(It would be Any Data Base)--->Using SSAS--->Create Cube--->using SSRS-->generate reports
Or
Raw data---->SSIS-->SSAS-->SSRS
SSIS
Input is Any raw data from any Database -->SSIS-->Output is Common Database (Any database..could be sql, oracle, ...)
SSAS
input is Output of SSIS whic is 2 dimensional database--->SSAS-->Output is multidimensional
SSRA
input is Output of SSAS -->SSRS--->Generate reports