EIS vs MIS
78 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the historical development of business intelligence?

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

What is the purpose of a data warehouse?

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

What are some examples of applications in business intelligence?

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

What is the purpose of the ETL process in a data warehouse?

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

What is the role of a staging area in a data warehouse?

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

What is the function of an operational data store (ODS) in data warehousing?

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

What are the main components of a data warehouse?

<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

What is the definition of business intelligence (BI)?

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

What is the difference between operational and dispositive systems?

<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

What are the characteristics of operational data?

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

What is the purpose of a data warehouse (DWH)?

<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

Name two different database structures used in the physical implementation of a multidimensional data model.

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

How are dimensions arranged in a star schema?

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

What is the difference between SCD type 1 and SCD type 2 historicization?

<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

What are the four generic systems used for analysis in business intelligence?

<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

What are the key features of passive metadata?

<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

What is the purpose of business metadata?

<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

What are the advantages of a multidimensional data model over a relational data model?

<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

What are the different physical storage concepts used in data warehousing?

<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

What are the benefits of using DMS or CMS functions in role assignments for distributed BI knowledge?

<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

How do BI portals provide structured access to information for users?

<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

What are some ways to increase user orientation in BI portals?

<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

What are the two main differences between EIS and MIS?

<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

What are model-based analysis systems used for?

<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

What is data mining?

<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

What are concept-oriented systems in business intelligence?

<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

What is the historical development of business intelligence?

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

What are the core applications that support decision-making in BI?

<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

What is the broader sense of business intelligence (BI)?

<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

What is the purpose of the ETL process in a data warehouse?

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

What is the function of an operational data store (ODS) in data warehousing?

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

What are the different physical storage concepts used in data warehousing?

<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

What are the main components of a data warehouse?

<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

What is the purpose of passive metadata?

<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

What do business metadata focus on?

<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

Why are multidimensional data models more flexible than relational data models?

<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

What are OLAP cubes used for?

<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

Define business intelligence (BI) and explain its purpose.

<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

What are the differences between operational and dispositive systems?

<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

What is the role of a data warehouse (DWH) in business intelligence?

<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

Explain the concept of concurrent queries and transactions in relation to operational data.

<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

What are the benefits of using DMS or CMS functions in role assignments for distributed BI knowledge?

<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

How do BI portals provide structured access to information for users?

<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

What are some ways to increase user orientation in BI portals?

<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

What are the two different database structures used in the physical implementation of a multidimensional data model?

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

What is the difference between SCD type 1 and SCD type 2 historicization?

<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

What are the different ways to access a data warehouse or data marts?

<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

What is the purpose of reporting systems in business intelligence?

<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

What are the two main types of systems in business intelligence and how do they differ?

<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

What is data mining and what does it involve?

<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

What are concept-oriented systems in business intelligence and what do they provide?

<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

How can BI analyses be effectively distributed within a company?

<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

What is the historical development of business intelligence?

<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

What is the difference between BI in the narrower sense and analysis-oriented BI?

<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

What does business intelligence (BI) in the broader sense include?

<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

What are the benefits of using DMS or CMS functions in role assignments for distributed BI knowledge?

<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

How do BI portals provide structured and centralized access to information for management and other users?

<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

What are some ways to increase user orientation in BI portals?

<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

What are the two main differences between EIS and MIS?

<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

What is the purpose of model-based analysis systems?

<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

What is data mining and what does it involve?

<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

What are concept-oriented systems in business intelligence and what do they provide?

<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

What is the purpose of data provisioning in business intelligence?

<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

What are the characteristics of operational data?

<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

What is the difference between operational and dispositive data?

<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

What is the concept of concurrent queries and transactions in relation to operational data?

<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

What are the two different database structures used in the physical implementation of a multidimensional data model?

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

What is the main difference between the star schema and snowflake schema?

<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

What is the purpose of dimension historicization according to SCD type 2 in a multidimensional data model?

<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

What are the different types of analytical systems used in business intelligence?

<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

What is the purpose of the ETL process in a data warehouse?

<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

What are the main components of a data warehouse?

<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

What distinguishes a central core data warehouse (C-DWH) from data mart architecture?

<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

What is the function of an operational data store (ODS) in data warehousing?

<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

What are the key features of passive metadata?

<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

What is the purpose of OLAP cubes in business intelligence?

<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

How are multidimensional models physically stored in a data warehouse?

<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

What is the role of metadata in the design and operation of BI systems?

<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

More Like This

EIS vs MIS
26 questions

EIS vs MIS

IndividualizedSplendor avatar
IndividualizedSplendor
EIS vs MIS
26 questions

EIS vs MIS

IndividualizedSplendor avatar
IndividualizedSplendor
EIS, DSS, and Systems Overview
45 questions

EIS, DSS, and Systems Overview

ShinyAntigorite5749 avatar
ShinyAntigorite5749
Use Quizgecko on...
Browser
Open
Browser
Browser