ONSITE EDUCATION

Your Team,
Your Location,
Our Instructors

Must-Have Skills for Modern Data Modeling

Duration: Three Day Workshop

Prerequisite: None

Course Outline

Recent data management trends such as data lakes and NoSQL databases have disrupted traditional data architectures. As data management evolves, the practices of conventional data modeling struggle to keep up. Failing to model isn’t the answer, though. NoSQL doesn’t mean no data models. Data architects and data modelers must learn new skills and techniques to work in the world of modern data management.

Business intelligence and analytics systems challenge the proven data modeling techniques of the past. From requirements to implementation and application, new roles, uses, and kinds of data demand updated modeling skills. The data modeler’s toolbox must address relational data, dimensional data, unstructured data, and master data. Dimensional data is a core component of modern business intelligence and data warehouse implementations. Dimensionally organized data offers a more effective and adaptable foundation for BI and analytics needs than can be achieved with normalized data structures. The big data phenomenon expands the purpose and changes the role of data modeling. Data modeling is still an important process – perhaps more important than ever before. But data modeling purpose and processes must change to keep pace with the rapidly evolving world of data.

The Must-Have Skills for Modern Data Modeling workshop will cover essential techniques and best practices for data modeling over three days of in-depth, interactive training.

Your Team Will Learn

  • How entity-relationship modeling techniques are adapted for data warehousing and BI
  • How generalization and abstraction techniques enhance data warehouse design
  • How to apply data modeling techniques to gain understanding of data sources
  • Requirements gathering techniques for business metrics and dimensional data
  • How to build a logical dimensional data model
  • How to translate a logical dimensional model into a star-schema design
  • To distinguish between data store modeling (schema on write) and data access modeling (schema on read) and when to use each
  • The scope and variety of data modeling techniques that work for modern data systems that include relational, dimensional, NoSQL, NewSQL, graph, and document databases

Geared To

  • Data architects, data modelers, and data engineers
  • Data warehouse and data mart designers and developers
  • Data integrators, database designers, and database developers
  • Anyone challenged with the need to combine structured and unstructured data for BI and analytics uses

 

Contact Us to Get Started Today

REQUEST INFORMATION

Yvonne Baho

Yvonne M. Baho Director, Enterprise Learning
Phone: 978.582.7105
Email: ybaho@tdwi.org

TESTIMONIALS

"Very good overall view of DW concepts and provided valuable insight for such a varied audience."

Jerry Bundt Nestle Purina

"This was the best training class I’ve had in my 20 year career."

Tim Grieb Seattle Children’s Hospital

"The instructor did an excellent job and demonstrated an understanding of real world applications."

Sean Dewulf Con-way Freight

REQUEST INFORMATION

Yvonne Baho Yvonne M. Baho
Director, Enterprise Learning
Phone: 978.582.7105
E-mail: ybaho@tdwi.org
TDWI Onsite Brochure Download

Download the Onsite Brochure

Download Now

Contact Us to Get Started Today

Discover the impact Onsite Education has had on real Fortune 500 clients through practical in-depth training.

  • Banking
  • Healthcare
  • Manufacturing
TDWI has provided education to 95% of the Fortune 100 companies.
Our expert instructors will help your company surge ahead of the competition.