This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

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:	Relatively easy
Exercise:	Create a tabular model in Visual Studio, and view it in Excel.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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

Show this exercise

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.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSAS - tabular
Topic:	Measures
Level:	Average difficulty
Exercise:	Show sales as a percentage of total sales for all families, using CALCULATE.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	SSAS - tabular
Topic:	Changing query context
Level:	Average difficulty
Exercise:	Use the RANKX function to order habitats by the number of purchases within each.

Show this exercise

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

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSAS - tabular
Topic:	Date calculations
Level:	Average difficulty
Exercise:	Use various DAX calendar-based functions to return interesting statistics!.

Show this exercise

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

Show this exercise

Software:	SSAS - tabular
Topic:	KPIs
Level:	Relatively easy
Exercise:	Create a KPI to show if this quarter's sales exceed the previous quarter's.

Show this exercise

Software:	SSAS - tabular
Topic:	KPIs
Level:	Average difficulty
Exercise:	Use absolute KPIs to show for each product whether it has 5% of total sales.

Show this exercise

Software:	SSAS - tabular
Topic:	Perspectives
Level:	Average difficulty
Exercise:	Present different data models to different users by creating simple a perspective.

Show this exercise

Software:	SSAS - tabular
Topic:	Prototyping using PowerPivot
Level:	Average difficulty
Exercise:	Prototype a simple data model in PowerPivot, then load it into Analysis Services tabular.

Show this exercise

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.

Show this exercise

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.

Show this 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 SSAS training courses? You can attend our online training classes wherever you are in the world!

This page has 0 threads

Add a new post

EXERCISE TOPIC

SSAS EXERCISES

SSAS - TABULAR EXERCISES

Free SSAS - tabular exercises

Head office

London

Manchester