EIS vs MIS

The historical development of business intelligence goes back to the 1960s, with the emergence of systems for supporting managerial decision-making.

A data warehouse is a central database that brings together data from different systems used throughout a company, allowing for improved decision-making.

Some examples of applications in business intelligence include online analytical processing (OLAP), management information systems (MIS), and executive information systems (EIS).

<p>The purpose of the ETL process is to transform operational data into management-relevant information.</p> Signup and view all the answers

<p>The staging area is where extracts are temporarily stored to relieve downstream systems.</p> Signup and view all the answers

<p>An operational data store is used to store current transaction data for evaluation purposes.</p> Signup and view all the answers

<p>The main components of a data warehouse include the staging area, basic database, data mart, ODS, and metadata.</p> Signup and view all the answers

<p>Business intelligence (BI) refers to procedures and processes that facilitate the systematic analysis of electronic data.</p> Signup and view all the answers

<p>Operational systems are used for everyday operations and frequently queried, while dispositive systems are queried by fewer people but for complex issues.</p> Signup and view all the answers

<p>Operational data is detailed, granular, up-to-date, transaction-oriented, and often redundant.</p> Signup and view all the answers

<p>A data warehouse is used to merge heterogeneous data from various source systems and provide a consolidated view for analysis and decision making.</p> Signup and view all the answers

<p>Star schema and Snowflake schema</p> Signup and view all the answers

<p>Around the fact table in a star shape</p> Signup and view all the answers

<p>SCD type 1 overwrites the previous data record, while SCD type 2 adds a validity interval to each data record</p> Signup and view all the answers

<p>Free data research, ad-hoc analysis systems (e.g., OLAP), report systems, and model-based analysis systems</p> Signup and view all the answers

<p>Passive metadata primarily document the data on which they are based and their relationship to the environment.</p> Signup and view all the answers

<p>Business metadata provides additional information such as keywords and notes about the meta objects, and helps in the efficient design of development and operating processes and increasing the effectiveness of BI systems.</p> Signup and view all the answers

<p>A multidimensional data model provides flexible views of data, which is beneficial for decision makers with different interests in the data. It is more flexible than a relational data model.</p> Signup and view all the answers

<p>The different physical storage concepts used in data warehousing are relational storage model (ROLAP), multidimensional storage model (MOLAP), and hybrid storage model (HOLAP).</p> Signup and view all the answers

<p>The benefits of using DMS or CMS functions in role assignments for distributed BI knowledge include the ability to differentiate role assignments and assign different rights, as well as the centrally controlled access to BI knowledge.</p> Signup and view all the answers

<p>BI portals integrate web-based analysis systems that are made available to users without them needing to install additional software. This gives management and other users centralized and structured access to the available information.</p> Signup and view all the answers

<p>Some ways to increase user orientation in BI portals include implicit personalization using user profiles and usage data, making recommendations for relevant portal content, and implementing single sign-on for convenience.</p> Signup and view all the answers

<p>EIS primarily present highly condensed, controlling-relevant internal data, while MIS will present all relevant operational data. EIS often integrate external information that is often unstructured but relevant to the company, whereas MIS typically only present internal company data.</p> Signup and view all the answers

<p>Model-based analysis systems are used for complex evaluations that require strong algorithmic or rule-based orientation. They use business models for calculations and analyses.</p> Signup and view all the answers

<p>Data mining is the software-supported determination of previously unknown correlations, patterns, and trends evident in the data stock of very large databases or DWHs.</p> Signup and view all the answers

<p>Concept-oriented systems are BI tools that provide analyses and data based on specific business concepts or procedures. They help direct the attention of management to all relevant parts of the company.</p> Signup and view all the answers

<p>The historical development of business intelligence goes back to the 1960s.</p> Signup and view all the answers

<p>The core applications that support decision-making in BI are online analytical processing (OLAP), management information systems (MIS), and executive information systems (EIS).</p> Signup and view all the answers

<p>In the broader sense, business intelligence (BI) includes all BI applications that are used directly or indirectly for decision-making.</p> Signup and view all the answers

<p>The ETL process is used to convert operational data into management-relevant information.</p> Signup and view all the answers

<p>The operational data store (ODS) contains current transaction data for evaluation purposes.</p> Signup and view all the answers

<p>The different physical storage concepts used in data warehousing include staging area, basic database, data mart, ODS, and metadata.</p> Signup and view all the answers

<p>The main components of a data warehouse include staging area, basic database, data mart, ODS, and metadata.</p> Signup and view all the answers

<p>Passive metadata primarily document the data on which they are based and their relationship to the environment. They serve to define and store information about structure, development process, and data usage.</p> Signup and view all the answers

<p>Business metadata focus on the subsequent layers of transformation and authorization management. They provide additional information such as keywords and notes about the meta objects.</p> Signup and view all the answers

<p>For DWH applications, a multidimensional data model is more flexible than a relational data model. Enterprise data is arranged in a multidimensional data space.</p> Signup and view all the answers

<p>OLAP cubes are used for analyzing business ratios as carriers of quantitative information. They are described by corresponding sets of dimensions.</p> Signup and view all the answers

<p>Business intelligence (BI) refers to procedures and processes that facilitate the systematic analysis of electronic data. Its purpose is to provide managers with consistent and reliable data to support decision-making.</p> Signup and view all the answers

<p>Operational systems are used for the everyday operations of a company and store information that is regularly changed and frequently queried. Dispositive systems are queried by individual experts seeking to address complex issues and evaluate a large number of data sets.</p> Signup and view all the answers

<p>A data warehouse is a database system that stores consistent data for analysis in business intelligence. It integrates data from various source systems and provides a foundation for powerful BI tools.</p> Signup and view all the answers

<p>Concurrent queries and transactions refer to the potential issue of conducting direct analyses on operational data. Resource-intensive queries with long runtimes can block the entire operational system and impair day-to-day business operations.</p> Signup and view all the answers

<p>The benefits of using DMS or CMS functions in role assignments for distributed BI knowledge include the ability to differentiate role assignments and assign different rights, centralized control of access to distributed BI knowledge, and targeted distribution of templates.</p> Signup and view all the answers

<p>BI portals provide structured access to information for users by integrating web-based analysis systems, offering centralized and structured access to available information, and using implicit personalization to make recommendations for relevant portal content.</p> Signup and view all the answers

<p>Some ways to increase user orientation in BI portals include using single sign-on for convenience, integrating web-based analysis systems, and offering centralized and structured access to available information.</p> Signup and view all the answers

<p>Star schema and Snowflake schema</p> Signup and view all the answers

<p>In SCD type 1, the previous data record is overwritten by the new data record, while in SCD type 2, a validity interval is added to each data record, allowing for the recording of previous entries.</p> Signup and view all the answers

<p>Accessing a data warehouse or data marts can be done through a data manipulation language (DML) such as SQL, or through Multidimensional Expressions (MDX) for ad-hoc analysis.</p> Signup and view all the answers

<p>Reporting systems provide users with a clear and simple evaluation of company data, presenting key performance indicators and metrics in a visual format.</p> Signup and view all the answers

<p>The two main types of systems in business intelligence are EIS and MIS. EIS primarily present highly condensed, controlling-relevant internal data, while MIS will present all relevant operational data. Additionally, EIS often integrate external information that is often unstructured but relevant to the company, whereas MIS typically only present internal company data.</p> Signup and view all the answers

<p>Data mining is the software-supported determination of previously unknown correlations, patterns, and trends evident in the data stock of very large databases or DWHs. It involves identifying previously unknown correlations, patterns, and trends in the data.</p> Signup and view all the answers

<p>Concept-oriented systems are business intelligence (BI) tools that provide analyses and data based on specific business concepts or procedures. They provide analyses and data based on extensive business concepts or procedures, such as value-based management.</p> Signup and view all the answers

<p>BI analyses can be effectively distributed within a company by using content and document management systems, as well as central, customized BI portals. These tools help ensure that the results of BI analyses are documented and made available in appropriate form throughout the company.</p> Signup and view all the answers

<p>The historical development of business intelligence goes back to the 1960s, with the emergence of different systems for supporting managerial decision-making.</p> Signup and view all the answers

<p>BI in the narrower sense refers to core applications that support decision-making without the additional input of more advanced methods or modeling. Analysis-oriented BI, on the other hand, refers to applications that allow decision makers to analyze existing data directly on the system using various methods and models.</p> Signup and view all the answers

<p>Business intelligence in the broader sense includes all BI applications that are used directly or indirectly for decision-making.</p> Signup and view all the answers

<p>The benefits of using DMS or CMS functions in role assignments for distributed BI knowledge include the ability to differentiate role assignments and assign different rights, centralized control of access to BI knowledge, and targeted distribution of templates in larger BI environments.</p> Signup and view all the answers

<p>BI portals integrate web-based analysis systems that are made available to users without them needing to install additional software. This gives management and other users centralized and structured access to the available information.</p> Signup and view all the answers

<p>Some ways to increase user orientation in BI portals include implicit personalization using user profiles and usage data to make recommendations for relevant portal content, and implementing single sign-on for easier access. BI portals also provide an effective and convenient way to present BI analyses to end users.</p> Signup and view all the answers

<ol> <li>EIS primarily present highly condensed, controlling-relevant internal data, while MIS will present all relevant operational data. 2) EIS often integrate external information that is often unstructured but relevant to the company, whereas MIS typically only present internal company data.</li> </ol> Signup and view all the answers

<p>Model-based analysis systems are used for complex evaluations and require a strong algorithmic or rule-based orientation. They use business models for calculations and analyses.</p> Signup and view all the answers

<p>Data mining is the software-supported determination of previously unknown correlations, patterns, and trends evident in the data stock of very large databases or DWHs. It involves identifying previously unknown correlations, patterns, and trends.</p> Signup and view all the answers

<p>Concept-oriented systems in business intelligence provide analyses and data based on specific business concepts or procedures. They are tools that implement comprehensive business concepts in BI analyses.</p> Signup and view all the answers

<p>Data provisioning in business intelligence refers to the procedures and processes that facilitate the systematic analysis of electronic data. It involves the preparation and storage of consistent data that meets the business needs of managers.</p> Signup and view all the answers

<p>Operational data in business intelligence is characterized by being detailed, granular, up-to-date, transaction-oriented, and often redundant and inconsistent.</p> Signup and view all the answers

<p>Operational data is used for everyday operations and is regularly changed and frequently queried. Dispositive data, on the other hand, is used for management and decision support, is task-dependent, standardized, and suitable for end users.</p> Signup and view all the answers

<p>The concept of concurrent queries and transactions in relation to operational data means that conducting direct analyses on operational data can be problematic. Resource-intensive queries with long runtimes have the potential to block the entire operational system and impair day-to-day business.</p> Signup and view all the answers

<p>Star schema and Snowflake schema</p> Signup and view all the answers

<p>The star schema arranges dimensions in a star shape around the fact table, while the snowflake schema splits data into different dimension tables, resulting in additional joins and potentially reduced query performance.</p> Signup and view all the answers

<p>Dimension historicization according to SCD type 2 adds a validity interval to each data record, recording the previous entry before a change is made. This allows for tracking changes over time and preserving historical information.</p> Signup and view all the answers

<p>The different types of analytical systems used in business intelligence include free data research, ad-hoc analysis systems (such as OLAP), report systems, model-based analysis systems, and concept-oriented systems.</p> Signup and view all the answers

<p>The purpose of the ETL process in a data warehouse is to extract data from operational systems, transform it according to the requirements of the company, and load it into the data warehouse for further analysis.</p> Signup and view all the answers

<p>The main components of a data warehouse are the staging area, basic database, data mart, operational data store (ODS), and metadata.</p> Signup and view all the answers

<p>A central core data warehouse (C-DWH) is a company-wide data warehouse that integrates data from different operational systems, whereas data mart architecture involves creating independent data marts in individual departments.</p> Signup and view all the answers

<p>An operational data store (ODS) is a preliminary stage of the data warehouse that contains current transaction data for evaluation purposes. It acts as a buffer between the operational systems and the data warehouse, providing real-time or near-real-time data for analysis.</p> Signup and view all the answers

<p>Passive metadata primarily document the data on which they are based and their relationship to the environment. They serve to define and store information about structure, development process, and data usage.</p> Signup and view all the answers

<p>OLAP cubes focus on business ratios as carriers of quantitative information and describe them using sets of dimensions. They provide flexible navigation through a multidimensional data model, allowing operations such as roll-up, drill-down, slice and dice, drill-across, pivoting, and rotation.</p> Signup and view all the answers

<p>Multidimensional models can be physically stored using different storage models: the relational storage model (ROLAP), the multidimensional storage model (MOLAP), or the hybrid storage model (HOLAP). MOLAP combines the strengths of the relational and multidimensional concepts, while HOLAP attempts to combine both models.</p> Signup and view all the answers

<p>Metadata plays a crucial role in the efficient design of development and operating processes in BI systems. It ensures that information is properly defined, stored, and utilized. Metadata also serves as a control element for data warehouse managers.</p> Signup and view all the answers