Logo     Photos

16 Member(s) Online

PyCon is a 100%
Volunteer-run
Conference Organized by
Members of the
Python
Community.

Site/Questions etc ?

Valid XHTML 1.0 Transitional

Valid CSS!

 
PyCon 2007 is sponsored
in part by
Zenoss - The Next Step in IT Management Google Microsoft .Net Framework EWT LLC Enthought, Inc.
Platinum
Wingware Python IDE Accense Technology, Inc.
Gold
Quality Vision International Inc. MerchantCircle Big Nerd Ranch, Inc. Canonical
Silver

Details of Talk

#059: 012 The Star Schema in Python - Analysis and Reporting without Overheads
Author(s):
Steven Lott
Items: audio-no    handouts-yes    released-yes    video-no    ADMIN
Abstract:

Data warehousing provides some powerful tools and techniques for doing data analysis and reporting. Specifically, the star-schema (or dimensional) data model gives us a design pattern that supports flexible "slice and dice" reporting. This technique is sometimes misunderstood, making it underutilized. This paper will present the essence of the dimensional model, implemented in Python.

Item(s):
DimensionalModel.odp 05:13:27 2007/01/30 30.7 kB application/octet-stream
abstract.stx 01:54:49 2007/01/21 402 bytes text/html
talk.zip 05:14:36 2007/01/30 1.2 MB application/zip

Note: Talk recordings have come from different donors, with different levels of quality. A suffix has been added to the basename of each recording reflecting this. For eventual upload to a repository like archive.org, a formal naming convention has been followed:

pycon-{date}-{track}-{timeslot}-{talkno}-{donor}.mp3

For those who might prefer a more human-meaningful name, the recordings have MP3/Ogg/Flac ID3 information within and a simple python script could rename your collection to something in a {title}-{author} form.