1) You should know the fundamentals about SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS) and SQL Server Analysis Services
2) I assume that you already know - "How to create a package, How to load a text file, How to create a report, Fact and Dimension are not knew to you, You have built a Cube at least once"
3) This is not a step by step guide (If time permits, i will create one at a later point of time)
4) Download - Source Text files + Table creation scripts + SSIS Packages
2) I assume that you already know - "How to create a package, How to load a text file, How to create a report, Fact and Dimension are not knew to you, You have built a Cube at least once"
3) This is not a step by step guide (If time permits, i will create one at a later point of time)
4) Download - Source Text files + Table creation scripts + SSIS Packages
