- Back to Home »
- Data Warehouse and Business Intelligence
Posted by : Rega
Monday, September 28, 2015
NIM : 1304505113
Major / Faculty : IT Engineering / Engineering
College : Udayana University
Lecturer : I Putu Agus Eka Pratama S.T.,M.T
1. Data Warehouse & Business Intelligence
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis.
DWs are central repositories of integrated data from one or more
disparate sources. They store current and historical data and are used
for creating analytical reports for knowledge workers throughout the
enterprise. Examples of reports could range from annual and quarterly
comparisons and trends to detailed daily sales analyses.
Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis
purposes. BI technologies are capable of handling large amounts of
unstructured data to help identify, develop and otherwise create new
strategic business opportunities. The goal of BI is to allow for the
easy interpretation of these large volumes of data. Identifying new
opportunities and implementing an effective strategy based on insights
can provide businesses with a competitive market advantage and long-term
stability.
2. Artificial Intelligence and Business Intelligence
Artificial intelligence (AI)
is technology and a branch of computer science that studies and develops intelligent machines and software. Major AI researchers and textbooks define the field as the study and design of intelligent agents, where an intelligent agent is a system that perceives its environment and takes actions that maximize its chances of success.
Business intelligence (BI)
is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle large amounts of information to help identify and develop new opportunities. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.
is technology and a branch of computer science that studies and develops intelligent machines and software. Major AI researchers and textbooks define the field as the study and design of intelligent agents, where an intelligent agent is a system that perceives its environment and takes actions that maximize its chances of success.
Business intelligence (BI)
is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle large amounts of information to help identify and develop new opportunities. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.
3. Business Intelligence,Data Warehouse,OLAP,Data Warehouse,Open Data
OLAP (On-line Analytical Processing)
OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions.
Queries are often very complex and involve aggregations. For OLAP systems a
response time is an effectiveness measure. OLAP applications are widely used by
Data Mining techniques. In OLAP database there is aggregated, historical data,
stored in multi-dimensional schemas (usually star schema).
Open Data
Open data is often focused on non-textual material such as maps, genomes, connectomes, chemical compounds, mathematical and scientific formulae, medical data and practice, bioscience and biodiversity. Problems often arise because these are commercially valuable or can be aggregated into works of value. Access to, or re-use of, the data is controlled by organisations, both public and private. Control may be through access restrictions, licenses, copyright, patents and charges for access or re-use. Advocates of open data argue that these restrictions are against the communal good and that these data should be made available without restriction or fee. In addition, it is important that the data are re-usable without requiring further permission, though the types of re-use (such as the creation of derivative works) may be controlled by a license.
Open data is often focused on non-textual material such as maps, genomes, connectomes, chemical compounds, mathematical and scientific formulae, medical data and practice, bioscience and biodiversity. Problems often arise because these are commercially valuable or can be aggregated into works of value. Access to, or re-use of, the data is controlled by organisations, both public and private. Control may be through access restrictions, licenses, copyright, patents and charges for access or re-use. Advocates of open data argue that these restrictions are against the communal good and that these data should be made available without restriction or fee. In addition, it is important that the data are re-usable without requiring further permission, though the types of re-use (such as the creation of derivative works) may be controlled by a license.
Business intelligence (BI)
Business intelligence (BI) is the set of techniques and
tools for the transformation of raw data into meaningful and useful
information for business analysis
purposes. BI technologies are capable of handling large amounts of
unstructured data to help identify, develop and otherwise create new
strategic business opportunities. The goal of BI is to allow for the
easy interpretation of these large volumes of data. Identifying new
opportunities and implementing an effective strategy based on insights
can provide businesses with a competitive market advantage and long-term
stability.
Data Warehouse
Data Warehouse is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.
Data Warehouse is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.
3. Data Warehouses Architecture
a. Central Architecture
Centralized Architecture with data centering from all clients
b. Federated Architecture
Architecture that where data is saved in different databases storage and each client has different databases storage
Tiered Architecture is architecture that data spread from one data warehouse or tiered database. Data is only centered and edited step by step from that tier