Assignment 9B – Pivot Tables

Objectives

– To learn to use aggregation functions to analyze data.

– Use the PIVOT operator to perform data analysis tasks

Assignment

Pivot Tables are amazingly useful constructs for viewing and analyzing data. As part of this assignment you will demonstrate your use of the PIVOT operator to create a 2 dimensional table.

Default Assignment: You can demonstrate this by writing a Database Report that uses this operator on any set of data that you would like.

If you do not have any data to use, you may return to Assignment 2 and use the School Database. A good Pivot Table with a decent level of challenges would be Columns as “% Completion” and Rows as “School Name”

Information

Estimated Completion Time

Good luck and welcome to true data analysis.

Supporting Lectures 

There are non created as of yet.

Questions and Answers

New Assignment – No Answered Questions Yet

External Resources

Excellent Resources on how to create and use the PIVOT operator exists at

WiseOwl Use of the Pivot Operator – https://www.youtube.com/watch?v=C37-SKZDsdU

WiseOwl Creating Dynamic Pivot Tables – https://www.youtube.com/watch?v=uZGjHYS9lzI

Grading Criteria

Generate the Table as specified in the Assignment is worth full credit (as reported in a DB Table report).