Tutorial - Requirements

The following data warehouse schema is available:

1. The report Player Stats will need to be developed.
   1. The following columns are needed.

      Name		Sortable	Description
      	Player	Y (asc)	The name of the player in the format of "{last}, {first}"
      	Team	N	The name of the team the player currently plays for.
      	G	Y (desc)	The number of games played.
      	P	N	The position currently played.
      Passing	Yds	Y (desc)	Total number of passing yards.
      	TD	Y (desc)	Total number of touchdowns thrown.
      	Int	Y (asc)	Total number of interceptions thrown.
      	Recptions	Y (desc)	Total number of passes completed.
      Rushing	Yds	Y (desc)	Total rushing yards.
      	TD	Y (desc)	Total touchdowns by rushing.
      Receiving	Rec	Y (desc)	Total number of catches.
      	Yds	Y (desc)	Total number of yards gained by receptions.
      	TD	Y (desc)	Total number of touchdowns made by receptions.
      Fumbles	Made	Y (asc)	Total number of fumbles.
      	Lost	Y (asc)	Total number of fumbles lost.
      Value	Avg	Y (desc)	...
      	Total	Y (desc)	...

   2. If the results are greater that 20 entries; page the results 20 per page.
   3. The following filtering criteria will be available.

      Player	A wildcard search on the name of the player.
      Position	A dropdown of the positions.
      Season	A dropdown of the start year.

Back to Tutorial.