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 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.
This page has 0 threads
Add post