SSAS - TABULAR EXERCISES

ALL CATEGORIES

- EXERCISES HOME PAGE (750)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- ASP.NET MVC (0)
- ASP.NET webforms - C# (25)
- ASP.NET webforms - VB (27)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel VBA Macros (37)
- Power BI - Excel 2013 (25)
- Power BI Desktop (0)
- PowerPivot 2010 (26)
- Report Builder 3.0 (42)
- SQL (115)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (18)
- SSRS Reporting Services (53)
- Visual Basic 2010 (42)
- Visual C Sharp 2010 (65)
- WPF - Visual C# (20)

# Microsoft SSAS - tabular training exercises (page 1 of 2)

Showing exercises 1-20 (out of 29)

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

Topic: | PowerView |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Create a data model, and from this a Power View report with a table, chart and tiles. |

Category: | SSAS - tabular |

Topic: | PowerView |

Level: | Harder than average |

Course: | SSAS - Tabular Model |

Exercise: | Create a Power View report based on a tabular model, with a multiple pie chart. |

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

Topic: | Calculated columns |

Level: | Relatively easy |

Course: | SSAS - Tabular Model |

Exercise: | Bring columns from different tables into a single table using the RELATED function. |

Category: | SSAS - tabular |

Topic: | Calculated columns |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Count the number of rows in a related table, using the RELATEDTABLE function. |

Category: | SSAS - tabular |

Topic: | Calculated columns |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Create 3 calculated columns using & (concatenation), the YEAR function and the SWITCH function. |

Category: | SSAS - tabular |

Topic: | Calculated columns |

Level: | Harder than average |

Course: | SSAS - Tabular Model |

Exercise: | Use the ISBLANK and RELATED functions to show missing parent rows. |

Category: | SSAS - tabular |

Topic: | Measures |

Level: | Relatively easy |

Course: | SSAS - Tabular Model |

Exercise: | Divide a table up into price categories using a simple CALCULATE function. |

Category: | SSAS - tabular |

Topic: | Measures |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

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

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

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

Category: | SSAS - tabular |

Topic: | The EARLIER Function |

Level: | Harder than average |

Course: | SSAS - Tabular Model |

Exercise: | Use the EARLIER function to aggregate data by shopping centre size bands. |

Category: | SSAS - tabular |

Topic: | DAX queries |

Level: | Relatively easy |

Course: | SSAS - Tabular Model |

Exercise: | Use the EVALUATE and TOPN functions in DAX queries to list out rows from tables. |

Category: | SSAS - tabular |

Topic: | DAX queries |

Level: | Average difficulty |

Course: | SSAS - Tabular Model |

Exercise: | Use the SUMMARIZE function to show how many rows there are for each calendar year/quarter. |

Category: | SSAS - tabular |

Topic: | DAX queries |

Level: | Harder than average |

Course: | SSAS - Tabular Model |

Exercise: | Use ADDCOLUMNS and DEFINE MEASURE to create and show additional columns for a DAX query. |

Category: | SSAS - tabular |

Topic: | Date calculations |

Level: | Relatively easy |

Course: | SSAS - Tabular Model |

Exercise: | Use the SAMEPERIODLASTYEAR and DATEADD functions to calculate and show totals. |

This page has 0 threads
Add post