Data Modeling Made Simple with PowerDesigner will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices, and how to apply these principles with PowerDesigner. You'll build many PowerDesigner data models along the way, increasing your skills first with the fundamentals and later with more advanced feature of PowerDesigner. This book combines real-world experience and best practices to help you master the following ten objectives:
- You will know when a data model is needed and which PowerDesigner models are the most appropriate for each situation
- You will be able to read a data model of any size and complexity with the same confidence as reading a book
- You will know when to apply and how to make use of all the key features of PowerDesigner
- You will be able to build, step-by-step in PowerDesigner, a pyramid of linked data models, including a conceptual data model, a fully normalized relational data model, a physical data model, and an easily navigable dimensional model
- You will be able to apply techniques such as indexing, transforms, and forward engineering to turn a logical data model into an efficient physical design
- You will improve data governance and modeling consistency within your organization by leveraging features such as PowerDesigner's reference models, Glossary, domains, and model comparison and model mapping techniques
- You will know how to utilize dependencies and traceability links to assess the impact of change
- You will know how to integrate your PowerDesigner models with externally-managed files, including the import and export of data using Excel and Requirements documents
- You will know where you can take advantage of the entire PowerDesigner model set, to increase the success rate of corporate-wide initiatives such as business intelligence and enterprise resource planning (ERP)
- You will understand the key differentiators between PowerDesigner and other data modeling tools you may have used before
This book contains seven sections:
Section I introduces data modeling, along with its purpose and variations.
Section II explains all of the components on a data model including entities, data elements, relationships, and keys. Also included is a discussion of the importance of quality names and definitions for your objects.
Section III explains the important role of data modeling tools, the key features required of any data modeling tool, and an introduction to the essential features of PowerDesigner. It also describes how to create and manage data modeling objects in PowerDesigner.
Section IV introduces the Data Model Pyramid, then dives into the relational and dimensional subject areas, logical, and physical data models, and describes how PowerDesigner supports these models and the connections between them.
Section V guides you through the creation of your own Data Model Pyramid.
Section VI focuses on additional PowerDesigner features (some of which have already been introduced) that make life easier for data modelers. Learn how to get information into and out of PowerDesigner, and improve the quality of your data models with a cross-reference of key PowerDesigner features with the Data Model Scorecard.
Section VII discusses PowerDesigner topics beyond data modeling, including the XML physical model and the other types of model available in PowerDesigner.
About Steve Steve Hoberman is the most requested data modeling instructor in the world. Steve balances the formality and precision of data modeling with the realities of building software systems with severe time, budget, and people constraints. In his consulting and teaching, he focuses on templates, tools, and guidelines to reap the benefits of data modeling with minimal investment. He taught his first data modeling class in 1992 and has educated more than 10,000 people about data modeling and business intelligence techniques since then. Steve is the author of five books on data modeling, the founder of the Design Challenges group, and inventor of the Data Model Scorecard®.
About George
George McGeachie has worked in the field of data modeling and metadata in a variety of industries for many years. George has evaluated, implemented, tailored and used various data modeling and metadata management tools during data modeling assignments around the globe. He is always regarded as a power user for whichever tool is in use, finding new ways of exploiting their capabilities.
