Showing posts with label Data flow. Show all posts
Showing posts with label Data flow. Show all posts

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