Bi-kipedia Entity relationship diagram (ERD) A diagram that pictorially represents entities, the relationships between them and the attributes used to describe them. Dimanche, 22 mars 2015
Bi-kipedia Prototyping The construction of a partial system to demonstrate some aspect or aspects of the intended system behavior in order to gain user acceptance or to establish technical feasibility. Dimanche, 22 mars 2015
Bi-kipedia Referential integrity constraint Rules that specify the correspondence of a foreign key to the primary key of its related table. For example, what should happen to the foreign key when the referenced primary key row is deleted. Dimanche, 22 mars 2015
Bi-kipedia Radio frequency identification (RFID) Transponder technology for the contactless recognition of objects. The heart of this technology is the so-called RFID tag, a small computer chip with a miniature antenna. It can be used on transport and goods packages as well as sales units and products. When the chip receives the radio signal from a reading device, it automatically transmits the stored data wirelessly. Transmission is based on radio frequencies. The tags are passive; they do not require any battery or maintenance. Dimanche, 22 mars 2015
Bi-kipedia Balanced scorecard A Balanced Scorecard is a performance management tool that summarizes an organization’s KPIs (key performance indicators) on a single page and integrates the KPI measures into the basic management structure of the organization. Dimanche, 22 mars 2015
Bi-kipedia Data Quality Data quality pertains to aspects such as availability, completeness, accuracy, consistency, relevance and timeliness of data. High data quality is essential to business intelligence’s role as a means of decisional support.Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems. Dimanche, 22 mars 2015
Bi-kipedia Pareto filtering The Pareto principle (also known as the 80-20 rule) states that, for many events, 80% of the effects come from 20% of the causes.This is a useful feature when a dimension, like customer, has a large number of categories and you want to identify the 20% of your clients who brings 80% of your sales. Filtering based on this principle automatically groups the categories that amount to less than 20% of a row or column total into ‘other’ category. Dimanche, 22 mars 2015
Bi-kipedia Percentage of total Displaying data in a table as a percentage of that particular data’s total, using the percentage (%) of row and percentage (%) of column calculation. For example, a user can summarize ‘Sales in a specific region’ as a percentage of ‘Total Sales.’ Dimanche, 22 mars 2015
Bi-kipedia Ranking Ranking is the process of positioning items such as individuals, groups or items on an ordinal scale in relation to others.A ranking can be obtained by evaluating each item in the collection in such a way that any two items can then be compared to see which should come higher in the ranking. Obviously, two different objects can have the same ranking. Dimanche, 22 mars 2015
Bi-kipedia Master Data Management Master Data Management (MDM) is a set of tools and processes that aim to deliver a single clean and consistent view of each master data entity (product, customer, employee, financial accounts, etc.) that exists within the organization Dimanche, 22 mars 2015