Microsoft Power BI - Excel 2013 training exercises (page 1 of 2)

Showing exercises 1-20 (out of 25)

Category: Power BI - Excel 2013
Topic: PowerPivot data models
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: From the MAM database, import 6 tables and use them to show quantity sold by town.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Pivot tables using PowerPivot
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use slicers to control 2 pivot tables, and Quick Explore to drill down.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Pivot tables using PowerPivot
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use a timeline to restrict a pivot table to 4 specific quarters.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Using Excel tables
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Link to Excel, Access and the clipboard (via Word) to import and link 4 tables.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Transforming data in Power Query
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: For a table of populations, change data types and make other changes in Power Query.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Transforming data in Power Query
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Divide exchange rate and investment symbols into more parts by splitting and removing columns.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Transforming data in Power Query
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: For a table of skyscrapers, perform lots of query transforms and then pivot the results.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Calculated columns
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Create an aggregator column to sum transaction values by weekday in a pivot table.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Calculated columns
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Calculate age bands for different dates using the SWITCH functon.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to pick out only transactions whose price is a given amount.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Omitting a particular shopping centre from totals, using the VALUES function.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Sorting total sales into ascending order, using the RANKX function.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create two measures, showing average price for the South and all other regions.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: More advanced DAX functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Group sales into size bands using the EARLIER function.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Date functions
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the TOTALQTD and TOTALYTD functions to show total sales with quarterly and annual to-date figures.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the SAMEPERIODLASTYEAR and DATEADD functions to show comparison figures.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: Date functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use the DATESYTD, TOTALYTD, SAMEPERIODLASTYEAR and various other date functions to compare totals.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: KPIs
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use a KPI to show how well you are performing against the previous quarter.

Go to exercise ...

This page has 0 threads Add post