Summarizing and Slicing Data

An introduction to the use of pivot tables in Excel
Module lessons:

Module: Preparation - Lesson 2 [0:54]
More Rows and Columns
Same idea, but with a different dataset. Data from the CPEC website will be examined.

http://www.cpec.ca.gov

Each individual row (or record or case) for contains the data associated with a unique transaction, event, or person/thing.

The data, going down each of the columns (or field, or variable) is completely consistent, in both meaning and in format.

At the head (or the top) of each column (or field, or variable) is the column name. Names are required.



To follow along, download sample data: K12_Public_High_School-2003-07.csv
Video size:

Learner comments for Preparation:2

Fetch error
SELECT blog1.blogTitle AS blogTitle, blog1.parentID AS parentIdentifier, blog1.blogID AS parentID, blog2.parentID AS childID, blog1.blogTime AS blogTimeParent, blog1.useremail AS useremailParent, blog1.blogImage AS blogImageParent, blog1.blogText AS blogTextParent, blog1.module AS blogModParent, blog1.lesson AS blogLesParent, blog2.blogTime AS blogTime, blog2.useremail AS useremail, blog2.blogImage AS blogImage, blog2.blogText AS blogText, blog1.blogID AS blogID, blog2.blogID AS child FROM blogItems as blog1 LEFT JOIN blogItems AS blog2 ON blog1.blogID = blog2.parentID WHERE blog1.module = 'prep' and blog1.lesson= 'tableLayout2' ORDER BY blogTimeParent DESC