Microsoft SSAS - multidimensional training exercises (page 1 of 2)

Showing exercises 1-20 (out of 21)

Category: SSAS - multidimensional
Topic: Data Source Views
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a data source view containing a diagram, including multiple tables and a new relationship.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Data Source Views
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a data source view to include named queries, and use this to explore data graphically.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Dimensions
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a dimension classifying animals by species, and tidy it up (for example, so the ALL member is renamed).

Go to exercise ...

Category: SSAS - multidimensional
Topic: Dimensions
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a dimension based on geographical tables, and enable browsing by it so that everything looks tidy.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Dimensions
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create a discretized dimension dividing targets up into equal buckets (this also includes doing the same thing using a named calculation).

Go to exercise ...

Category: SSAS - multidimensional
Topic: Basic Cubes
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create the simplest possible cube: summing sales targets by region and year.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Basic Cubes
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a cube showing total sales by species and region, with filtering and formatting applied.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Basic Cubes
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create a cube comparing two different measure groups (sales and targets), and set the IgnoreUnrelatedDimensions property.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Hierarchies and Relationships
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a natural hierarchy showing fluffy toys within animals within species.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Hierarchies and Relationships
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create an unnatural hierarchy, showing product sales by target age band and gender, and use this to build and filter a cube.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Parent-child Hierarchies
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create a parent-child hierarchy on a staff table, and use this to filter a cube to show sales for a particular store manager.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Time dimensions
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a cube showing the number of staff joining by year, including generating a time dimension and role-playing dimensions.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Calculations
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a simple calculation for a cube, either using form view or by typing in the MDX expression.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Writing MDX Queries
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a simple query showing animal types as column headings and species as row headings, then apply a WHERE slice.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Writing MDX Queries
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a query using sets to show total sales for two specific Mayan months, across shopping centre type.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Writing MDX Queries
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create an MDX query using a named set and NON EMPTY clause to get data for two specific shopping centres.

Go to exercise ...

Category: SSAS - multidimensional
Topic: MDX Expressions
Level: Relatively easy
Course: SSAS - Multidimensional
Exercise: Create a cube calculation to show sales which are up on the previous period in a different colour.

Go to exercise ...

Category: SSAS - multidimensional
Topic: MDX Expressions
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create a cube calculation showing for each sales value how this compares to sales of fluffy owls.

Go to exercise ...

Category: SSAS - multidimensional
Topic: MDX Expressions
Level: Harder than average
Course: SSAS - Multidimensional
Exercise: Create cube calculations showing month to date or year to date figures, depending on the level of granularity.

Go to exercise ...

Category: SSAS - multidimensional
Topic: Cube actions
Level: Average difficulty
Course: SSAS - Multidimensional
Exercise: Create separate click-throughs for shopping centre and centre type level, with customised captions based on MDX expressions.

Go to exercise ...

This page has 0 threads Add post