Intro to Business Intelligence

What is the definition of Business Intelligence (BI)?

• The process of turning data into information and knowledge to drive profitable business action

• The process of converting information into data

• The process of storing data in multiple sources

• The process of managing knowledge

What is the main purpose of Online Analytical Processing (OLAP)?

• To manage knowledge

• To mine data from different sources

• To create reports for business intelligence

• To quickly answer multi-dimensional analytical queries

What are some challenges inherent to any Business Intelligence (BI) project?

• Data is always consistent, workers have the same data needs, data is formatted properly

• Data is stored in one place, workers have similar data needs, data is not formatted properly

• Data exists in multiple places, data is not formatted to support complex analysis, different kinds of workers have different data needs

• Data is inconsistent, workers have different data needs, data is formatted properly

What is the process of consolidating data often called?

• Extraction, Transformation, and Loading (ETL)

• Data Warehousing

• Data Mining

• Data Cleaning

What are measures in the context of Business Intelligence (BI)?

• Where you want to see data, usually in charts

• When you want to see data, usually in reports

• How you want to see data, usually text-based

• What you want to see, usually numeric and often additive

What are dimensions in the context of Business Intelligence (BI)?

• How you want to see data, such as by time, geography, product, etc.

• What you want to see, usually numeric and often additive

• Where you want to see data, usually in charts

• When you want to see data, usually in reports

What is the purpose of hierarchies in Business Intelligence (BI)?

• To assist user analysis by putting attributes into a hierarchical structure

• To hide data from users

• To confuse users with complex data structures

• To limit access to certain data

What is the main function of the ETL process in Business Intelligence (BI)?

• To manage knowledge

• To create reports for business intelligence

• To extract data from source systems, transform it, and load it to a data warehouse or data mart

• To mine data from different sources

What are some common ETL tools used in Business Intelligence (BI)?

• Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Access

• Adobe Photoshop, Adobe Illustrator, Adobe InDesign, Adobe Premiere

• Oracle Data Integrator (ODI), Informatica, IBM Ascential, Abinitio

• Google Sheets, Google Docs, Google Slides, Google Forms

What is the significance of data visualization in Business Intelligence (BI)?

• To make data look pretty

• To confuse users with complex data structures

• To assist in understanding data trends and patterns

• To limit access to certain data