WISE OWL EXERCISES

SSAS EXERCISES

SSAS - TABULAR EXERCISES

# Free SSAS - tabular exercises

This page lists 29 **SSAS - tabular** exercises. You can use the menu 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. |

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. |

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. |

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. |

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. |

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. |

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. |

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!. |

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. |

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. |

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. |

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 10% of total sales. |

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 perspectives. |

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 species. |

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. |

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. |

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 regions by the number of sales transactions within each. |

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. |

Software: | SSAS - tabular |

Version: | SSAS 2012 and later |

Topic: | Measures |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Show four-legged animals sales as a percentage of total sales, using CALCULATE. |

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. |

Software: | SSAS - tabular |

Version: | SSAS 2012 and later |

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. |

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. |

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. |

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. |

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. |

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. |

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. |

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. |

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. |

You can search our full list of SSAS exercises here.