WISE OWL EXERCISES

SSAS EXERCISES

SSAS - TABULAR EXERCISES

- Creating a data model (2)
- Excel pivot tables (1)
- PowerView (2)
- Power BI Desktop overview (1)
- Other data sources (1)
- Calculated columns (4)
- Measures (3)
- Changing query context (2)
- The EARLIER Function (1)
- DAX queries (3)
- Date calculations (3)
- Hierarchies (1)
- KPIs (2)
- Perspectives (1)
- Prototyping using PowerPivot (1)
- Security (2)

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

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

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: | Perspectives |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Present different data models to different users by creating simple a perspective. |

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

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

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 habitats by the number of purchases 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 sales as a percentage of total sales for all families, 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 land and non-land 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. 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