Your Cart Is Empty
Home > Professional Development Skills > Business Analysis > Data Modeling
In this course, you will learn to use logical data modeling to work directly with business users to accurately define requirements.
Since a business analyst needs to accurately elicit, define, and document user requirements, understanding the users' needs is key to an analyst's success. By using logical data modeling, a business analyst can convey requirements in a way that can easily be validated, and doing so allows stakeholders to understand the requirements, business rules, and data management methods for any given project.In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.
Category
ID
Duration
Level
Price
Business Analysis
13826
3 Day(s)
Foundation
$2,295.00
Objectives
Lesson objectives help you become comfortable with the course, and also provide a means to evaluate learning. In the Data Modeling training course, you will learn:· How logical data models relate to requirements· Identifying entities and attributes· Determining relationships and business rules· Data integrity through normalization
1. INTRODUCTION TO LOGICAL DATA MODELING· Importance of logical data modeling in requirements· When to use logical data models· Relationship between logical and physical data model· Elements of a logical data model· Read a high-level data model· Data model prerequisites· Data model sources of information· Developing a logical data model2. PROJECT CONTEXT AND DRIVERS· Importance of well-defined solution scope· Functional decomposition diagram· Context-level data flow diagram· Sources of requirementso Functional decomposition diagramso Data flow diagramso Use case modelso Workflow modelso Business ruleso State diagramso Class diagramso Other documentation· Types of modeling projectso Transactional business systemso Business intelligence and data warehousing systemso Integration and consolidation of existing systemso Maintenance of existing systemso Enterprise analysiso Commercial off-the-shelf application3. CONCEPTUAL DATA MODELING· Discovering entities· Defining entities· Documenting an entity· Identifying attributes· Distinguishing between entities and attributes4. CONCEPTUAL DATA MODELING-IDENTIFYING RELATIONSHIPS AND BUSINESS RULES· Model fundamental relationships· Cardinality of relationshipso One-to-oneo One-to-manyo Many-to-many· Is the relationship mandatory or optional?· Naming the relationships5. IDENTIFYING ATTRIBUTES· Discover attributes for the subject area· Assign attributes to the appropriate entity· Name attributes using established naming conventions· Documenting attributes
6. ADVANCED RELATIONSHIPS· Modeling many-to-many relationships· Model multiple relationships between the same two entities· Model self-referencing relationships· Model ternary relationships· Identify redundant relationships7. COMPLETING THE LOGICAL DATA MODEL· Use supertypes and subtypes to manage complexity· Use supertypes and subtypes to represent rules and constraints8. DATA INTEGRITY THROUGH NORMALIZATION· Normalize a logical data modelo First normal formo Second normal formo Third normal form· Reasons for denormalization· Transactional vs. business intelligence applications9. VERIFICATION AND VALIDATION· Verify the technical accuracy of a logical data model· Use CASE tools to assist in verification· Verify the logical data model using other modelso Data flow diagramo CRUD matrix
Questions?
Entry Certificate in Business Analysis (ECBA™)
Business Analysis Essentials
Data Modeling
Class Schedule
Live Online
Course Overview
Training Delivery Methods
With Productivity Point, you will have a spectrum of delivery methods to choose from... when where and how you like it. Whether it's in a classroom or online, we have a delivery option to meets your needs.
Classroom Live
Classroom Virtual
Private Group
On Demand
Classroom Live Training
Get in-person, hands-on instruction with live lab exercises taught by subject matter experts who deliver authorized and industry-leading content.
With classrooms in almost every major U.S. city, Productivity Point has something for users of every level, so you can earn the most popular industry certifications. You get hands-on learning experience with live lab exercises taught by experienced instructors. We proudly advocate our learning services to be hosted by the best-qualified trainers in terms of technical knowledge and teaching skills.
Classroom Virtual Training
Prefer to have a dedicated classroom for your virtual experience? Attend live, hands- on training via remote instructor from one of Productivity Point’s multiple locations.
Enjoy a focused and professional training environment, including all technical equipment provided along with administrative and technical support at your fingertips. With over 150 locations to choose from, review our course catalog or contact your personal Productivity Point Account Manager to see if the course you have in mind is delivered at one of our dedicated virtual classrooms in your area.
Live Online Training
Blend the best from traditional face-to-face instructor-led training with the latest in conferencing technology.
Private Group Training
Your private group classroom experience will not only take place in the location of your choice (including any of our training centers), but you will enjoy the following amenities:
On-Demand Learning
On-Demand is an IT training solution designed around your schedule, budget, and learning needs. Combining high-quality video, reading, and knowledge checks in a self-paced format, On-Demand helps you build skills as your schedule allows—all at once or five minutes at a time.
With On-Demand, you learn at your own pace and in the convenience of your own space.
With Learn at your own pace…
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com