



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A comprehensive overview of business intelligence (bi), covering its definition, framework, and key components. It explains how bi transforms data into actionable insights for business decision-making. The document details essential bi tools and technologies, including etl processes, data warehousing, query and reporting, data visualization, and data analytics. It also explores advanced concepts such as dashboards, data mining, and master data management, offering a structured understanding of bi's role in enhancing business performance and competitive advantage. This resource is ideal for students and professionals seeking to grasp the fundamentals and practical applications of business intelligence.
Typology: Exams
1 / 5
This page cannot be seen from the preview
Don't miss anything!




Business intelligence - ✔✔describes a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making. B I - is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom. - ✔✔B I - is not a product by itself, but a framework of concepts, practices, tools, and technologies that help a business better understand its core capabilities, provide snapshots of the company situation, and identify key opportunities to create competitive advantage. ETL - ✔✔extraction, transformation, and loading ETL tools - ✔✔collect, filter, integrate, and aggregate internal and external data to be saved into a data store optimized for decision support. Internal data is generated by the company during its day-to-day operations, such as product sales history, invoicing, and payments. - ✔✔external data sources provide data that cannot be found within the company but is relevant to the business, such as stock prices, market indicators, marketing information (such as demographics), and competitors' data.
Data store - ✔✔The data store is optimized for decision support and is generally represented by a data warehouse or a data mart. The data is stored in structures that are optimized for data analysis and query speed. Data Store is - ✔✔Optimized for decision support and query analysis Query and reporting - ✔✔Performs data selection and retrieval, and it is used by the data analyst to create queries that access the database and create the required reports. Depending on the implementation, the query and reporting tool accesses the operational database, or more commonly, the data store. - ✔✔Blank Data visualization - ✔✔This component presents data to the end user in a variety of meaningful and innovative ways. This tool helps the end user select the most appropriate presentation format, such as summary reports, maps, pie or bar graphs, mixed graphs, and static or interactive dashboards. Data monitoring and alerting - ✔✔allows real-time monitoring of business activities. The BI system will present the concise information in a single integrated view for the data analyst. This integrated view could include specific metrics about the system performance or activities, such as number of orders placed in the last four hours, number of customer complaints by product by month, and total revenue by region. - ✔✔Alerts can be placed on a given metric; once the value of a metric goes below or above a certain baseline, the system will perform a
Portals - ✔✔provide a unified, single point of entry for information distribution. Portals are a web-based technology that use a web browser to integrate data from multiple sources into a single webpage. Data analysis and reporting tools - ✔✔Used to query multiple and diverse data sources to create integrated reports. Data-mining tools - ✔✔Provide advanced statistical analysis to uncover problems and opportunities hidden within business data. Data warehouses (DW) - ✔✔the foundation of a BI infrastructure. Data is captured from the production system and placed in the DW on a near real-time basis. B I provides company-wide integration of data and the capability to respond to business issues in a timely manner. - ✔✔ OLAP tools - ✔✔Online analytical processing provides multidimensional data analysis. Data visualization - ✔✔provide advanced visual analysis and techniques to enhance understanding and create additional insight of business data and its true meaning.
is abstracting data to provide information in a visual format that enhances the user's ability to effectively comprehend the meaning of the data. - ✔✔Data visualization aggregates the data into a format that provides at-a-glance insight into overall trends and patterns. Master data management (MDM) - ✔✔A collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization M D M's main goal is to provide a comprehensive and consistent definition of all data within an organization. - ✔✔MDM ensures that all company resources (people, procedures, and IT systems) that work with data have uniform and consistent views of the company's data. Key performance indicators... K P eye's (KPIs) - ✔✔quantifiable numeric or scale-based measurements that assess the company's effectiveness or success in reaching its strategic and operational goals.