Operational vs. Analytical Reports?
Relational or Dimensional Data Models?
Operational Data Stores, Data Marts and Data Warehouses?

How are they different and why does it matter?

This one-day workshop answers these questions and provides a conceptual framework to understand where to place different types of data and reporting and why.

Discussion topics include:

• A compare and contrast the major systems of a reporting architecture
• An introduction to Dimensional Modeling
• Relational vs. Dimensional Modeling
• An introduction to Bitmap Indexes
• A compare and contract of B-Tree and Bitmap Indexes
• Two major Data Warehouse camps – Kimball & Inmon
• Practical Considerations for Reporting Success
  

.