• Used the data warehouse that i have implemented and loaded with data in Assignment 1 as the data source for the assignment 2.
• Used DWBI assignment 1 data warehouse as the data source and create an SSAS cube.
• Designed the cube by including necessary measures in fact table(s) and connecting dimensions.
o Roll-up
o Drill-down
o Slice
o Dice
o Pivot
• Developed and published following reports in SSRS Web Portal.
o Report 1: Report with a matrix
o Report 2: Report with more than one parameter. Parameters should have lists of values. Selection of the value of first parameter, should change the list of available values in the second parameter. You can use any one or more items in the report to visualize data.
o Report 3: Create an SSRS drill-down report.
o Report 4: Create an SSRS drill-through report.