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

Showing exercises 1-20 (out of 29)

Category: SSAS - tabular
Topic: Creating a data model
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Create a tabular model in Visual Studio, and view it in Excel.

Go to exercise ...

Category: SSAS - tabular
Topic: Creating a data model
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create a full data model in SSDT, deploy it and create a pivot table including a slicer from it.

Go to exercise ...

Category: SSAS - tabular
Topic: Excel pivot tables
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Without much help, create a data model, two pivot tables and a single controlling slicer.

Go to exercise ...

Category: SSAS - tabular
Topic: PowerView
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create a data model, and from this a Power View report with a table, chart and tiles.

Go to exercise ...

Category: SSAS - tabular
Topic: PowerView
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Create a Power View report based on a tabular model, with a multiple pie chart.

Go to exercise ...

Category: SSAS - tabular
Topic: Other data sources
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Bring in data from Excel, Access and Word (via the clipboard) to create a 4-table data model.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Bring columns from different tables into a single table using the RELATED function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Count the number of rows in a related table, using the RELATEDTABLE function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create 3 calculated columns using & (concatenation), the YEAR function and the SWITCH function.

Go to exercise ...

Category: SSAS - tabular
Topic: Calculated columns
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use the ISBLANK and RELATED functions to show missing parent rows.

Go to exercise ...

Category: SSAS - tabular
Topic: Measures
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Divide a table up into price categories using a simple CALCULATE function.

Go to exercise ...

Category: SSAS - tabular
Topic: Measures
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Show four-legged animals sales as a percentage of total sales, using CALCULATE.

Go to exercise ...

Category: SSAS - tabular
Topic: Measures
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use AVERAGEX and CALCULATE to show true ratios of area to units for shopping centres.

Go to exercise ...

Category: SSAS - tabular
Topic: Changing query context
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use the RANKX function to order regions by the number of sales transactions within each.

Go to exercise ...

Category: SSAS - tabular
Topic: Changing query context
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Compare South and non-South data in a pivot table, using the VALUES function to modify the query context.

Go to exercise ...

Category: SSAS - tabular
Topic: The EARLIER Function
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use the EARLIER function to aggregate data by shopping centre size bands.

Go to exercise ...

Category: SSAS - tabular
Topic: DAX queries
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Use the EVALUATE and TOPN functions in DAX queries to list out rows from tables.

Go to exercise ...

Category: SSAS - tabular
Topic: DAX queries
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use the SUMMARIZE function to show how many rows there are for each calendar year/quarter.

Go to exercise ...

Category: SSAS - tabular
Topic: DAX queries
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use ADDCOLUMNS and DEFINE MEASURE to create and show additional columns for a DAX query.

Go to exercise ...

Category: SSAS - tabular
Topic: Date calculations
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Use the SAMEPERIODLASTYEAR and DATEADD functions to calculate and show totals.

Go to exercise ...

This page has 0 threads Add post