1.9 Glossary of Terms

1. Algorithmic Bias: Systematic errors in AI or machine learning outputs that arise from biased assumptions in the training data or model design, potentially leading to unfair or discriminatory outcomes.

2. Artificial Intelligence (AI): The simulation of human intelligence by computer systems, including learning from data, recognizing patterns, making decisions, and generating content. In BI, AI is used to automate analysis, generate predictions, and assist with reporting.

3. AutoML (Automated Machine Learning): Platforms and tools that automate the process of building machine learning models, including data preprocessing, feature selection, model selection, and hyperparameter tuning, making predictive modeling accessible to non-specialists.

4. Business Intelligence (BI): A set of technologies, applications, and practices for the collection, integration, analysis, and presentation of business information. The purpose of BI is to support better business decision-making.

5. CRM (Customer Relationship Management): Software systems used to manage and analyze customer interactions and data throughout the customer lifecycle, with the goal of improving business relationships, customer retention, and sales growth.

6. Dashboards: Information management tools that visually track, analyze, and display key performance indicators (KPI), metrics, and key data points to monitor the health of a business, department, or specific process.

7. Data Integration: The process of consolidating data from multiple sources into a unified, consistent format. This typically involves resolving inconsistencies, standardizing formats, and loading data into a data warehouse using ETL processes.

8. Data Mart: A subset of a data warehouse focused on a specific business area, department, or subject. Data marts provide targeted data access for particular user groups, enabling faster and more focused analysis.

9. Data Mining: The process of discovering patterns and knowledge from large amounts of data. The data is often processed using sophisticated algorithms to identify relationships, trends, and patterns used for making predictions.

10. Data Warehousing: A system used to report and analyze data. Data warehouses are central repositories of integrated data from one or more disparate sources, storing current and historical data in one place for creating analytical reports.

11. Descriptive Mining: A method of data mining focused on exploring data to find patterns or relationships that describe the data and can be used to understand what is happening within it.

12. ERP (Enterprise Resource Planning): Integrated software systems that manage core business processes — including finance, human resources, supply chain, and manufacturing — in a unified platform. ERP systems are a major source of data for BI applications.

13. ETL (Extract, Transform, Load): A data integration process that extracts data from source systems, transforms it into a consistent format (cleaning, standardizing, and restructuring), and loads it into a data warehouse or other target system for analysis.

14. Formal Modeling: The creation of mathematical or simulation models to represent systems or business processes. These models help in theoretical analysis and hypothesis testing.

15. Generative AI: A category of AI systems capable of creating new content — including text, code, images, and data visualizations — based on patterns learned from training data. Large language models (LLMs) such as ChatGPT and Claude are prominent examples used in BI for code generation, report drafting, and data interpretation.

16. GIS (Geographic Information System): A framework for gathering, managing, and analyzing spatial and geographic data. GIS combines cartographic science with tools for database management and information analysis, primarily through layers of information added to geographical maps.

17. Large Language Model (LLM): A type of AI model trained on vast amounts of text data that can understand and generate human language. LLMs can write code, summarize data, answer questions about datasets, and assist with BI tasks through natural language interaction.

18. Machine Learning (ML): A subset of artificial intelligence in which algorithms learn patterns from data and improve their performance over time without being explicitly programmed. In BI, ML is used for prediction, classification, clustering, and anomaly detection.

19. Microsoft Power BI: A business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

20. Natural Language Processing (NLP): A branch of AI focused on enabling computers to understand, interpret, and generate human language. In BI, NLP powers features like natural language querying, where users can ask questions about data in plain English.

21. OLAP (Online Analytical Processing): A category of software tools that provides analysis of data stored in a database. OLAP allows users to analyze data in multiple dimensions, making it easier to perform complex calculations, trend analysis, and data modeling.

22. Performance Management: The practice of monitoring and managing an organization’s performance according to key performance indicators such as revenue, return on investment, overhead, and operational costs.

23. Predictive Mining: A form of data mining that involves using historical data to make predictions about future events. This technique uses statistical models and forecast algorithms to understand potential future outcomes.

24. QlikView: A BI tool for turning data into knowledge. It supports interactive dashboards and visualization and offers associative data indexing to explore complex data from multiple sources.

25. R and RStudio: R is a programming language and software environment used for statistical computing and graphics supported by the R Foundation for Statistical Computing. RStudio is an integrated development environment (IDE) for R.

26. SQL (Structured Query Language): The standard programming language for managing and querying relational databases. SQL is used to extract, filter, and manipulate data stored in databases and data warehouses, and is a foundational skill for BI practitioners.

27. SAP BusinessObjects: A suite of front-end applications that allow business users to view, sort, and analyze business intelligence data.

28. Tableau: A visual analytics engine that makes it easier to create interactive, sharable dashboards. It emphasizes the ability to perform advanced data analysis by dragging and dropping data elements without requiring programming skills.