How to Build a Data Warehouse in a Day
Dan Paolini
Director, Data Management Services
State of NJ - OIT
Sunday, April 23, 2006
3:30 pm - 6:45 pm
Level: Intermediate

This presentation is for business management or technical staff struggling with the concepts of data warehousing. No, we won't really build a data warehouse in a day, but we will cover the essential ingredients necessary to develop a foundational understanding of this discipline.

Using a simple but representative case study, we will discuss:
  • Understanding Data Warehouse Architecture
  • User-Driven Analysis and Design
  • Modeling and Building the Database
  • ETL - The Secret of Successful Data Warehouses
  • Business Intelligence - More than Just Reports
Attendees will be able to see a data warehouse project develop while being presented with common problems, opportunities, pitfalls, and objectives. Attendees will have the opportunity to interact and ask questions specific to their current or planned data warehousing environment. The tutorial will cover different technology categories applicable to data warehousing, but specific tools or vendors will not be featured.

Dan Paolini is the State of New Jersey's Director of Data Management Services and first Information Architect. Before returning to State employment, he co-founded and led a successful database consulting and training firm for six years. He has also served as the Chief Technology Officer for a public school district and for a State educational institution.

He has presented eight keynotes and more than fifty technical papers at more than twenty conferences in North America and Europe on many diverse topics. Dan was a contributing editor for a monthly database magazine for three years as well as the technical editor for three database books.

Dan is the Vice President for Standards for the DAMA International Foundation. He also serves as a moderator for the Data Architecture Professional Group.

Dan has served more than thirty years as a volunteer firefighter, recently retiring as chief of his fire department. He has been honored several times for rescues and service. In his spare time he writes music and teaches Sunday School.