Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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. |
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: | Power BI Desktop overview |
Level: | Average difficulty |
Exercise: | Use a Tabular Model as the basis for a new Power BI Desktop report. |
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: | Calculated columns |
Level: | Harder than average |
Exercise: | Use the ISBLANK and RELATED functions to show missing parent rows. |
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: | Changing query context |
Level: | Average difficulty |
Exercise: | Use the RANKX function to order habitats by the number of purchases within each. |
Software: | SSAS - tabular |
Topic: | The EARLIER Function |
Level: | Harder than average |
Exercise: | Use the EARLIER function to aggregate data by shopping centre size bands. |
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: | Prototyping using PowerPivot |
Level: | Average difficulty |
Exercise: | Prototype a simple data model in PowerPivot, then load it into Analysis Services tabular. |
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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.