DW - Data Warehousing & Modeling

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

A spreadmart (spreadsheet data mart) is a situation in which a company's employees have inconsistent views of corporate data because each department relies on the data from their own spreadsheets.

A role-based security is a user-level security feature that allows you to restrict access to a certain feature in the system based on the user role.In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks. 

Scheduling takes into account different tasks, the time, and the resources to be deployed in order to complete these tasks. It is the ability to determine when a particular process will take place in the future, with special consideration on resource availability, activities, and time constraints.

A structured query language (SQL) is the standard language for a relational database. The Structured Query Language uses a classic English keyword-oriented set of commands to query, describe, manipulate, and manage data.

A view is the way of depicting information in a database. Some options of viewing your data are to arrange your data items in a specific order, re-label, hide or to pre-aggregate certain fields.

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.’ 

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. 

A data scientist is a job title for an employee or business intelligence (BI) consultant who excels at analyzing data, particularly large amounts of data, to help a business gain a competitive edge. To do so, the employee is using statistical & data mining techniques. 

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.