Skip to content
Learn Data Modeling

LearnDataModeling.com

Tutorial on Data Modeling, Data Warehouse & Business Intelligence!

"LearnDataModeling.com is recommended by One of the Top FAANG/MAAMA Companies" - Data Lake Data Modeling Training - Data Vault Approach starts on June 3rd, 2023 (7.00 P.M IST). Contact AntonysTrainingandSolution@gmail.com or 91-9080157239 for more details!
  • Home
  • Business Process
    • Business Process Topics – Index
  • Data Modeling
    • Data Modeling Topics – Index
  • DW & ETL
    • DW & ETL Tutorial Topics
  • Software & Mobile Apps Testing
    • Software & Mobile Apps Testing Topics
  • Business Intelligence
    • Business Intelligence Topics
  • DM Job Support
  • Data Modeling Training
  • Data Modeling Videos
    • Interview Question and Answer Videos
    • Data Modeling Videos For Sale
    • Data Modeling Demo Videos
  • Dimensional Model Training
  • Practical Scenarios
  • SQL Server Training
  • Testimonials

Tag: business metadata

Business Metadata

October 15, 2015 learndmdwbi Leave a comment

Metadata:

Metadata is data about data. Metadata comes into picture when we need to know about how data is stored and where it is stored. Metadata tools are helpful in capturing business metadata and the following section explains business metadata.

Business Metadata:

In IT, Business Metadata is adding additional text or statement around a particular word that adds value to data. Business Metadata is about creating definitions, business rules. For example, when tables and columns are created the following business metadata would be more useful for generating reports to functional and technical team.

The advantage is of this business metadata is whether they are technical or non-technical, everybody would understand what is going on within the organization.

Table’s Metadata: While creating a table, metadata for definition of a table, source system name, source entity names, business rules to transform the source table, and the usage of the table in reports should be added in order to make them available for taking metadata reports.

Column’s Metadata: Similarly for columns, source column name (mapping), business rules to transform the source column name, and the usage of the column in reports should be added for taking metadata reports.

Business Metadata Example:

Business Metadata Diagram

  • BI

Relational Databases

September 1, 2015 learndmdwbi Leave a comment

Database – RDBMS:

There are a number of relational databases to store data. A relational database contains normalized data stored in tables. Tables contain records and columns. RDBMS makes it easy to work with individual records. Each row contains a unique instance of data for the categories defined by the columns.

RDBMS are used in OLTP applications(e.g. ATM cards) very frequently and sometimes data warehouse may also use relational databases. Please refer to Relational data modeling for details to know how data from a source system is normalized and stored in RDBMS databases.

Popular RDBMS Databases:

[ultimatetables 81 /]

 

  • DW & ETL

Data Warehouse Concepts

September 1, 2015 learndmdwbi One comment

What is a Data Warehouse?

According to Inmon, famous author for several data warehouse books, “A data warehouse is a subject oriented, integrated, time variant, non volatile collection of data in support of management’s decision making process”.

In order to store data, over the years, many application designers in each branch have made their individual decisions as to how an application and database should be built. So source systems will be different in naming conventions, variable measurements, encoding structures, and physical attributes of data. Consider a bank that has got several branches in several countries, has millions of customers and the lines of business of the enterprise are savings, and loans. The following example explains how the data is integrated from source systems to target systems.

Example of Source Data:

[ultimatetables 79 /]

In the aforementioned example, attribute name, column name, datatype and values
are entirely different from one source system to another. This inconsistency in data can
be avoided by integrating the data into a data warehouse with good standards.

Example of Target Data (Data Warehouse):

[ultimatetables 80 /]

In the above example of target data, attribute names, column names, and datatypes
are consistent throughout the target system. This is how data from various source system
is integrated and accurately stored into the data warehouse.

Data Warehouse Architecture Diagram:

Data Warehouse Architecture Diagram

 

  • DW & ETL

Current Training Schedules

Course Details:

1. Online Data Modeling Training with Erwin!
For Syllabus and other details, please click here.

2. Data Lake Data Modeling Training - Data Vault Approach!
For Syllabus and other details, please click here!

3. SQL Server's T SQl with Agile, Data Analysis and Data Modeling Training!
For Syllabus and other details, please click here.

AntonysTrainingandSolution@gmail.com / 91-9080157239

Data Modeling Quiz

Click here to take the Quiz - Test your knowledge and skills in OLTP / Dimensional Data Modeling!!!

Categories

  • BI (11)
  • Business Process (17)
  • Data Modeling (58)
    • Data Modeling Comparison (3)
    • Data Modeling Interview Questions (4)
    • Data Modeling Overview (9)
    • Data Modeling Relationships (5)
    • Data Modeling Tools (12)
    • Data Modeling Types (9)
    • Domains Defaults (2)
    • ER Diagram (1)
    • Modeling DW and Data Mart (9)
    • Physical Data Modeling (2)
  • Data Modeling Videos (3)
  • DM & Database (7)
  • DW & ETL (20)
  • Software & Mobile Apps Testing (15)
  • Training (9)
  • Privacy Policy
  • Disclosure Policy
WordPress Theme: Dynamic News by ThemeZee.
error: Content is protected !!