Free SSAS - tabular exercises
You are welcome to try any of the 30 SSAS - tabular exercises listed below, but please do not distribute them in any form without asking for our written permission first.
Software: |
SSAS - tabular |
Topic: |
Creating a data model |
Level: |
Average difficulty |
Exercise: |
Create a full data model in SSDT, deploy it and create a pivot table including a slicer from it. |
Software: |
SSAS - tabular |
Topic: |
Excel pivot tables |
Level: |
Harder than average |
Exercise: |
Without much help, create a data model, two pivot tables and a single controlling slicer. |
Software: |
SSAS - tabular |
Topic: |
PowerView |
Level: |
Average difficulty |
Exercise: |
Create a data model, and from this a Power View report with a table, chart and tiles. |
Software: |
SSAS - tabular |
Topic: |
PowerView |
Level: |
Harder than average |
Exercise: |
Create a Power View report based on a tabular model, with a multiple pie chart. |
Software: |
SSAS - tabular |
Topic: |
Other data sources |
Level: |
Average difficulty |
Exercise: |
Bring in data from Excel, Access and Word (via the clipboard) to create a 4-table data model. |
Software: |
SSAS - tabular |
Topic: |
Calculated columns |
Level: |
Relatively easy |
Exercise: |
Bring columns from different tables into a single table using the RELATED function. |
Software: |
SSAS - tabular |
Topic: |
Calculated columns |
Level: |
Average difficulty |
Exercise: |
Count the number of rows in a related table, using the RELATEDTABLE function. |
Software: |
SSAS - tabular |
Topic: |
Calculated columns |
Level: |
Average difficulty |
Exercise: |
Create 3 calculated columns using & (concatenation), the YEAR function and the SWITCH function. |
Software: |
SSAS - tabular |
Topic: |
Measures |
Level: |
Relatively easy |
Exercise: |
Divide a table up into price categories using a simple CALCULATE function. |
Software: |
SSAS - tabular |
Topic: |
Measures |
Level: |
Average difficulty |
Exercise: |
Show sales as a percentage of total sales for all families, using CALCULATE. |
Software: |
SSAS - tabular |
Topic: |
Measures |
Level: |
Harder than average |
Exercise: |
Use AVERAGEX and CALCULATE to show true ratios of area to units for shopping centres. |
Software: |
SSAS - tabular |
Topic: |
Changing query context |
Level: |
Average difficulty |
Exercise: |
Compare land and non-land data in a pivot table, using the VALUES function to modify the query context. |
Software: |
SSAS - tabular |
Topic: |
DAX queries |
Level: |
Relatively easy |
Exercise: |
Use the EVALUATE and TOPN functions in DAX queries to list out rows from tables. |
Software: |
SSAS - tabular |
Topic: |
DAX queries |
Level: |
Average difficulty |
Exercise: |
Use the SUMMARIZE function to show how many rows there are for each calendar year/quarter. |
Software: |
SSAS - tabular |
Topic: |
DAX queries |
Level: |
Harder than average |
Exercise: |
Use ADDCOLUMNS and DEFINE MEASURE to create and show additional columns for a DAX query. |
Software: |
SSAS - tabular |
Topic: |
Date calculations |
Level: |
Relatively easy |
Exercise: |
Use the SAMEPERIODLASTYEAR and DATEADD functions to calculate and show totals. |
Software: |
SSAS - tabular |
Topic: |
Date calculations |
Level: |
Relatively easy |
Exercise: |
Use the TOTALYTD and TOTALQTD to calculate and show cumulative yearly and quarterly totals. |
Software: |
SSAS - tabular |
Topic: |
Date calculations |
Level: |
Average difficulty |
Exercise: |
Use various DAX calendar-based functions to return interesting statistics!. |
Software: |
SSAS - tabular |
Topic: |
Hierarchies |
Level: |
Average difficulty |
Exercise: |
Create a geographical hierarchy, and use it to analyse sales by region, town, etc. |
Software: |
SSAS - tabular |
Topic: |
KPIs |
Level: |
Relatively easy |
Exercise: |
Create a KPI to show if this quarter's sales exceed the previous quarter's. |
Software: |
SSAS - tabular |
Topic: |
KPIs |
Level: |
Average difficulty |
Exercise: |
Use absolute KPIs to show for each product whether it has 5% of total sales. |
Software: |
SSAS - tabular |
Topic: |
Perspectives |
Level: |
Average difficulty |
Exercise: |
Present different data models to different users by creating simple a perspective. |
Software: |
SSAS - tabular |
Topic: |
Security |
Level: |
Average difficulty |
Exercise: |
Create two simple roles to limit access to your data model to particular types of animal. |
Software: |
SSAS - tabular |
Topic: |
Security |
Level: |
Harder than average |
Exercise: |
Use the CustomUser field and a permissions table to control access to a model using roles. |
You can search our full list of SSAS exercises here.
Or why not learn to do them the right way on one of our SSAS training courses? You can attend our online training classes wherever you are in the world!