businesspress24.com - Advanced Dimensional Modeling Techniques for Practitioners
 

Advanced Dimensional Modeling Techniques for Practitioners

ID: 1020316

Tuesday&Wednesday, December 7th&8th, 2010 - Munich

(PresseBox) - .
- Check-In: 08:30 - 09:00
- Program: 09:00 - 17:00
Real world data warehouse designs rarely resemble the simple star schemas found in product demos or introductory courses - a single fact table, fully additive facts, and several standard dimension tables.
This course takes you beyond fundamental principles of dimensional design, providing an extended set of techniques to address real-world complexity.
The course begins with a brief review of the core concepts dimensional modeling. These fundamentals are then built upon in four areas: multi-star designs, alternative fact table designs, dimensional intricacy, and scaling.
This comprehensive treatment provides the breadth and depth you will need to meet your data warehouse design challenges - whether you are building a dimensional data warehouse, a Corporate Information Factory, or stand-alone data marts.
You Will Learn
- Why most subject areas require multiple fact tables, and how to identify them
- When to use alternatives to the basic transaction fact table, including periodic snapshots, accumulating snapshots, and type-specific stars
- How to cope with dimensional intricacy, using techniques such as bridge tables, mini-dimensions, time-stamped dimensions and hybrid slow changes
- Techniques to ensure your data warehouse will scale as new subject areas are added Geared To
This course is geared toward professionals who need a comprehensive understanding of star schema design.
- Data warehouse designers
- Business intelligence developers
- Report designers
- Project managers
- Power users
- Database administrators
Instructor for all courses: Chris Adamson, Oakton Software LLC
Chris Adamson is an independent consultant, educator and author. He works with customers in all industries to develop data warehouse strategies, define and prioritize projects, and design solutions. He has taught dimensional design to thousands of students world wide. Chris's latest book is Star Schema: The Complete Reference. His other work includes and Data Warehouse Design Solutions andMastering Data Warehouse Aggregates. Chris blogs about data warehousing at www.StarSchemaCentral.com.






Themen in dieser Pressemitteilung:


Unternehmensinformation / Kurzprofil:



Leseranfragen:



PresseKontakt / Agentur:



drucken  als PDF  an Freund senden  Premiere at the animago CONFERENCE: Sebastian Dosch presents the DOSCH Career Guide - an Internet Portal for Creative Minds in the CG Field
TDWI Dimensional Data Modeling Primer
Bereitgestellt von Benutzer: PresseBox
Datum: 29.11.2010 - 08:35 Uhr
Sprache: Deutsch
News-ID 1020316
Anzahl Zeichen: 0

contact information:
Contact person:
Town:

Troisdorf


Phone:

Kategorie:

Chemical industry


Anmerkungen:


Diese Pressemitteilung wurde bisher 338 mal aufgerufen.


Die Pressemitteilung mit dem Titel:
"Advanced Dimensional Modeling Techniques for Practitioners
"
steht unter der journalistisch-redaktionellen Verantwortung von

SIGS DATACOM GmbH (Nachricht senden)

Beachten Sie bitte die weiteren Informationen zum Haftungsauschluß (gemäß TMG - TeleMedianGesetz) und dem Datenschutz (gemäß der DSGVO).


Alle Meldungen von SIGS DATACOM GmbH



 

Who is online

All members: 10 591
Register today: 0
Register yesterday: 0
Members online: 0
Guests online: 94


Don't have an account yet? You can create one. As registered user you have some advantages like theme manager, comments configuration and post comments with your name.