Microsoft PowerPivot 2010 training exercises (page 1 of 2)

Showing exercises 1-20 (out of 26)

Category: PowerPivot 2010
Topic: Connecting to tables
Level: Relatively easy
Course:
Exercise: Create a pivot table of average prices for transactions.

Go to exercise ...

Category: PowerPivot 2010
Topic: Creating a data model
Level: Average difficulty
Course:
Exercise: Import a table then amend it and import others to create data model.

Go to exercise ...

Category: PowerPivot 2010
Topic: Relationships
Level: Harder than average
Course:
Exercise: Create a pivot table with slicer based on ten different tables.

Go to exercise ...

Category: PowerPivot 2010
Topic: Connecting to Excel
Level: Average difficulty
Course:
Exercise: Create a linked Excel workbook in PowerPivot and use it in relationships.

Go to exercise ...

Category: PowerPivot 2010
Topic: Connecting to other data
Level: Harder than average
Course:
Exercise: Link to two Excel workbooks and one SQL Server table in PowerPivot.

Go to exercise ...

Category: PowerPivot 2010
Topic: Calculated columns
Level: Relatively easy
Course:
Exercise: Total sales by weekday, using simple two calculated columns.

Go to exercise ...

Category: PowerPivot 2010
Topic: Calculated columns
Level: Average difficulty
Course:
Exercise: Divide years into bands using SWITCH and calculated columns.

Go to exercise ...

Category: PowerPivot 2010
Topic: Calculated columns
Level: Harder than average
Course:
Exercise: Summarise sales by status of animal, using calculated columns.

Go to exercise ...

Category: PowerPivot 2010
Topic: Measures
Level: Average difficulty
Course:
Exercise: Calculate total and average transaction values using measures.

Go to exercise ...

Category: PowerPivot 2010
Topic: Measures
Level: Harder than average
Course:
Exercise: Calculate ratio of area to units for shopping centres using AVERAGEX.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Relatively easy
Course:
Exercise: Use ALL and CALCULATE to get proportions of totals for regions.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Relatively easy
Course:
Exercise: Divide sales by 4 legs and other for a measure, using the FILTER function.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Create measure using CALCULATE and ALL to get ratios against total.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Exclude a month from totals using the VALUES function to retain context.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Use the RANKX function to order total sales over species.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Use FILTER and ALL to show sales as a proportion of one region's total.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Harder than average
Course:
Exercise: Create a calculated column using EARLIER to show previous joiner count.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Harder than average
Course:
Exercise: Filter calculated sums to compare two stores' sales figures.

Go to exercise ...

Category: PowerPivot 2010
Topic: Creating a calendar
Level: Average difficulty
Course:
Exercise: Create and import a calendar in Excel or SQL giving star signs.

Go to exercise ...

Category: PowerPivot 2010
Topic: Date calculations
Level: Relatively easy
Course:
Exercise: Use the TOTALYTD and TOTALQTD functions to show cumulative totals.

Go to exercise ...

This page has 0 threads Add post