MBN News | The Independent Business Blogging Community

MBN News: The Independent Business Blogging Community

MBN International: English Flag Bulgarian Flag

29 Members | ~1,500 Unique Visitors with ~3,500 Visits Last Month | Last Update: 19 Sep 2018 | Google PageRank 5 (PR5)

MBN Most Popular

MBN Latest

Business Intelligence

business-intelligence-dictionary-data-marts-explained-nsbi

Business Intelligence Dictionary: Data Marts Explained | NSBI

Category: Business Intelligence (BI) | |

Having explained what a Data Warehouse is you should be now aware that it is not well optimized to serve a particular need but rather consolidate the whole historical data of an organization. This implies a number of issues when trying to maximize performance for particular usage. Here come Data Marts. ...Read more


business-intelligence-dictionary-star-schema-snowflake-schema-nsbi

Business Intelligence Dictionary: Star Schema, Snowflake Schema | NSBI

Category: Business Intelligence (BI) | |

Relational database normalized schema is different from the architecture of a data warehouse. This article will explain what are the two most common design approaches when building a data warehouse - the Star Schema and the Snowflake Schema. NSBI Tutorials aim to make Business Intelligence (BI) and...Read more


business-intelligence-dictionary-database-normalization-and-normal-forms-nsbi

Business Intelligence Dictionary: Database Normalization And Normal Forms | NSBI

Category: Business Intelligence (BI) | |

Optimization has always been a priority for business and database optimization is not an exclusion. Relational Database optimization is often related to a process called Normalization. Normalization | Definition Normalization is a process of optimization of a relational database in terms of data...Read more


business-intelligence-dictionary-entity-relationship-e-r-diagrams-nsbi

Business Intelligence Dictionary: Entity Relationship (E/R) Diagrams | NSBI

Category: Business Intelligence (BI) | |

It is important for developers that they get an overview of available data, relationships and architecture. This is where Entity Relationships (E/R) diagrams are introduced. Entity Relationship (E/R) Diagrams | Definition Data is grouped in rows and columns, then grouped in tables and views. Next...Read more


business-intelligence-dictionary-tables-and-views-explained-nsbi

Business Intelligence Dictionary: Tables And Views Explained | NSBI

Category: Business Intelligence (BI) | |

Data is grouped together into larger units that represent a single subject or process. These structures are most commonly known as tables. Database Tables | Definition NSBI Dictionary defines Tables as a logical structure that represents a set of fields and tuples associated with them. Based on the...Read more


business-intelligence-dictionary-slowly-changing-dimensions-scd-explained-nsbi

Business Intelligence Dictionary: Slowly Changing Dimensions-SCD explained | NSBI

Category: Business Intelligence (BI) | |

Things change. Dimensions are no exclusion. When a data designer plans a data warehouse architecture they have to plan ahead with a slowly changing dimensions strategy. Slowly Changing Dimensions-SCD | Definition Slowly Changing Dimension (SCD) is a term first introduced by Kimball Group among...Read more


business-intelligence-dictionary-surrogate-keys-explained-nsbi

Business Intelligence Dictionary: Surrogate Keys Explained | NSBI

Category: Business Intelligence (BI) | |

Surrogate Key | Definition Primary Keys and Foreign Keys are also known as business keys since they are primarily used in various operational databases. When we load a Data Warehouse, however, those keys may no longer uniquely identify each tuple in a table, therefore a new kind of key is introduced -...Read more


business-intelligence-dictionary-primary-keys-and-foreign-keys-explained-nsbi

Business Intelligence Dictionary: Primary Keys and Foreign Keys Explained | NSBI

Category: Business Intelligence (BI) | |

Keys are a special kind of database fields that are designed to support a relational design where tables can be related to one another. Primary Key | Definition NSBI Dictionary defines a Primary Key as a logical structure of field or group of fields that uniquely identifies each record within a...Read more