Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE AND DATA WAREHOUSE - Coggle Diagram
DATABASE AND DATA WAREHOUSE
Data warehouse
a logical collection of information
gathered from many different operational databases
that supports business analysis activities and decision-making tasks
Extraction, transformation, and loading (ETL)
a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse
Databases contain information in a series of two-dimensional tables
In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows
Dimension – a particular attribute of information
Cube
Cube B represents a slice of information displaying promotion II for all products at all stores
Cube C represents a slice of information displaying promotion III for product B at store 2
Cube A represents store information (the layers), product information (the rows), and promotion information (the columns)
common term for the representation of multidimensional information
Users can slice and dice the cube to drill down into the information
Information cleansing or scrubbing
a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
Business Intelligence (BI)
Technology
Even the smallest company with BI software can do sophisticated analyses today that were unavailable to the largest organizations a generation ago. The largest companies today can create enterprise wide BI systems that compute and monitor metrics on virtually every variable important for managing the company
People
Understanding the role of people in BI allows organizations to systematically create insight and turn these insights into actions. Organizations can improve their decision making by having the right people making the decisions. This usually means a manager who is in the field and close to the customer rather than an analyst rich in data but poor in experience. In recent years “business intelligence for the masses” has been an important trend, and many organizations have made great strides in providing sophisticated yet simple analytical tools and information to a much larger user population than previously possible.
Culture
A key responsibility of executives is to shape and manage corporate culture. The extent to which the BI attitude flourishes in an organization depends in large part on the organization’s culture. Perhaps the most important step an organization can take to encourage BI is to measure the performance of the organization against a set of key indicators. The actions of publishing what the organization thinks are the most important indicators, measuring these indicators, and analyzing the results to guide improvement display a strong commitment to BI throughout the organization
