29 Members | ~1,500 Unique Visitors with ~3,500 Visits Last Month | Last Update: 07 Mar 2021 | Google PageRank 5 (PR5)
Category: Business Intelligence (BI) | Nick Shopov | 15/02/2015 21:16
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
Category: Business Intelligence (BI) | Nick Shopov | 07/12/2014 09:39
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
Category: Business Intelligence (BI) | Nick Shopov | 09/11/2014 20:46
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
Category: Business Intelligence (BI) | Nick Shopov | 04/11/2014 20:13
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
Category: Business Intelligence (BI) | Nick Shopov | 02/11/2014 19:42
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
Category: Business Intelligence (BI) | Nick Shopov | 30/10/2014 08:08
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
Category: Business Intelligence (BI) | Nick Shopov | 28/10/2014 20:14
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
Category: Business Intelligence (BI) | Nick Shopov | 26/10/2014 17:24
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