Intro to Business Intelligence

Business Intelligence Process

Involves gathering, storing, analyzing, and presenting data to support business decision-making. It typically includes data collection, data cleansing, data integration, data analysis, and data visualization stages

Business Intelligence

Refers to the technologies, applications, and practices for collecting, integrating, analyzing, and presenting business data to facilitate informed decision-making.

Data warehouse

A central repository for storing integrated, historical data from multiple sources.

ETL (Extract, Transform, Load)

Processes for extracting data from source systems, transforming it into a usable format, and loading it into the data warehouse.

Reporting and analytics tools

Software for analyzing data, generating reports, and visualizing insights.

Dashboards and scorecards

Tools for monitoring key performance indicators (KPIs) and presenting information visually and intuitively.

Operational sources

refer to the various systems and sources from which data is collected for analysis. These may include transactional databases, CRM systems, ERP systems, weblogs, social media platforms, and sensor data.

descriptive analytics

(summarizing data)

diagnostic analytics

(analyzing past performance)

predictive analytics

(forecasting future trends)

prescriptive analytics

(suggesting actions based on analysis).

Classification

Categorizing data into predefined classes or groups based on attributes.

Clustering

Identifying natural groupings in data based on similarities.

Regression

Predicting a continuous value based on the relationship between variables.

Association

Discovering relationships between variables in large datasets, often used in market basket analysis.