MS SQL Reporting Services

Assignment Instructions

  1. Review multidimensional cubes.Option A: For the multidimensional and tabular models, see AdventureWorks for Analysis Services. Use AdventureWorksDW as source data. Interact with the cube provided as part of the Multidimensional Modeling Project. Provide a 250–350 word summary of the developed cube.Source: Microsoft. Retrieved from https://www.microsoft.comOption B: Create a mockup of a multidimensional cube with six dimensions and at least two fact tables. Review three scenarios that a user would apply to drill down the data. You can use Microsoft Excel® with pivot tables, MS Visio, or hand draw. Provide a 250 to 350-word summary of the developed cube.
  2. Review reporting capabilities.Option A: Develop an SSRS report or a BI tool against the AdventureWorks Data Warehouse. For information on this, go to Reporting Services Tutorials.Source: Microsoft. Retrieved from https://www.microsoft.comOption B: Create a mockup of a report with six fields from at least two dimensions and at least two facts. You can use Excel with pivot tables, MS Visio, or hand draw. Provide a 250 to 350-word summary of the developed cube.
  3. Expand this data warehouse, adding unstructured data. Provide a 350 to 450-word summary describing this new entity and the ontology that you will use to define values using this object.

 

Last Updated on July 29, 2020 by Essay Pro