Free SSAS - tabular exercises

This page lists 30 SSAS - tabular exercises. You can use the menu on the left to show just exercises for a specific topic.

This page lists 30 SSAS - tabular exercises. You can use the menu above to show just exercises for a specific topic.

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: DAX queries
Level: Relatively easy
Course:
Exercise: Use the EVALUATE and TOPN functions in DAX queries to list out rows from tables.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Date calculations
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Use the TOTALYTD and TOTALQTD to calculate and show cumulative yearly and quarterly totals.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: KPIs
Level: Relatively easy
Course: SSAS - Tabular Model
Exercise: Create a KPI to show if this quarter's sales exceed the previous quarter's.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Date calculations
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use various DAX calendar-based functions to return interesting statistics!.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Hierarchies
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create a geographical hierarchy, and use it to analyse sales by region, town, etc.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2016 and later
Topic: Power BI Desktop overview
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use a Tabular Model as the basis for a new Power BI Desktop report.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: PowerView
Level: Average difficulty
Course:
Exercise: Create a data model, and from this a Power View report with a table, chart and tiles.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Prototyping using PowerPivot
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Prototype a simple data model in PowerPivot, then load it into Analysis Services tabular.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Perspectives
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Present different data models to different users by creating simple a perspective.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: KPIs
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use absolute KPIs to show for each product whether it has 5% of total sales.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Security
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Create two simple roles to limit access to your data model to particular types of animal.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Changing query context
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Use the RANKX function to order habitats by the number of purchases within each.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: DAX queries
Level: Average difficulty
Course:
Exercise: Use the SUMMARIZE function to show how many rows there are for each calendar year/quarter.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Measures
Level: Average difficulty
Course: SSAS - Tabular Model
Exercise: Show sales as a percentage of total sales for all families, using CALCULATE.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

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

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: DAX queries
Level: Harder than average
Course:
Exercise: Use ADDCOLUMNS and DEFINE MEASURE to create and show additional columns for a DAX query.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: Security
Level: Harder than average
Course: SSAS - Tabular Model
Exercise: Use the CustomUser field and a permissions table to control access to a model using roles.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: PowerView
Level: Harder than average
Course:
Exercise: Create a Power View report based on a tabular model, with a multiple pie chart.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

Software: SSAS - tabular
Version: SSAS 2012 and later
Topic: The EARLIER Function
Level: Harder than average
Course:
Exercise: Use the EARLIER function to aggregate data by shopping centre size bands.

Go to exercise ...

Software: SSAS - tabular
Version: SSAS 2012 and later
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 ...

You can search our full list of SSAS exercises here. Or why not learn to do them the right way on one of our classroom SSAS training courses in the UK, or on one of our live online SSAS courses wherever you are in the world?

This page has 0 threads Add post