A Software Engineer and data professional's blog on SQL, data, databases, data architectures, data management, programming, Software Engineering, Project Management, ERP implementation and other IT related topics.
Pages
- 🏠Home
- 🗃️Definitions
- 🔢SQL Server
- 🎞️SQL Server: VoD
- 🏭Fabric
- 🎞️Fabric: VoD
- ⚡Power BI
- 🎞️Power BI: VoD
- 📚Data
- 📚Engineering
- 📚Management
- 📚SQL Server
- 🎞️D365: VoD
- 📚Systems Thinking
- ✂...Quotes
- 🧾D365: GL
- 💸D365: AP
- 💰D365: AR
- 🏠D365: FA
- 👥D365: HR
- ⛓️D365: SCM
- 🔤Acronyms
- 🪢Experts
- 🗃️Quotes
- 🔠Dataviz & BI
- 🔠D365
- 🔠Fabric
- 🔠Engineering
- 🔠Management
- 🔡Glossary
- 🌐Resources
- 🏺Dataviz
- 🗺️Social
- 📅Events
- ℹ️ About
16 February 2015
📊Business Intelligence: BI Boards (Definitions)
15 February 2015
📊Business Intelligence: Reporting (Definitions)
"An automated business process or related functionality that provides a detailed, formal account of relevant or requested information." (DAMA International, "The DAMA Dictionary of Data Management", 2011)
[enterprise reporting:] "1.The process of producing reports using unified views of enterprise data. 2.A category of software tools used to produce reports; a term for what were simply known as reporting tools." (DAMA International, "The DAMA Dictionary of Data Management", 2011)
[ad hoc reporting:] "A reporting system that enables end users to run queries and create custom reports without having to know the technicalities of the underlying database schema and query syntax." (Microsoft, "SQL Server 2012 Glossary", 2012)
"A process by which insight is presented in a visually appealing and informative manner." (Evan Stubbs, "Delivering Business Analytics: Practical Guidelines for Best Practice", 2013)
"The practice of reporting what has happened, analyzing contributing data to determine why it happened, and monitoring new data to determine what is happening now. Also known as descriptive analytics and business intelligence." (Brenda L Dietrich et al, "Analytics Across the Enterprise", 2014)
"The process of collecting data from various sources and presenting it to business people in an understandable way." (Daniel Linstedt & W H Inmon, "Data Architecture: A Primer for the Data Scientist", 2014)
"A common interaction with an organizing system." (Robert J Glushko, "The Discipline of Organizing: Professional Edition" 4th Ed., 2016)
"The function or activity for generating documents that contain information organized in a narrative, graphic, or tabular form, often in a repeatable and regular fashion." (Jonathan Ferrar et al., 2017)
"Business intelligence reporting, or BI reporting, is the process of gathering data by utilizing different software and tools to extract relevant insights. Ultimately, it provides suggestions and observations about business trends, empowering decision-makers to act." (Data Pine) [source]
"When we talk about reporting in business intelligence (BI), we are talking about two things. One is reporting strictly defined. The other is 'reporting' taken in a more general meaning. In the first case, reporting is the art of collecting data from various data sources and presenting it to end-users in a way that is understandable and ready to be analyzed. In the second sense, reporting means presenting data and information, so it also includes analysis–in other words, allowing end-users to both see and understand the data, as well as act on it." (Logi Analytics) [source]
🪙Business Intelligence: Data Visualization (Definitions)
07 February 2015
📊Business Intelligence: Report Model (Definitions)
"A semantic description of business entities and their relationships in a SQL Server Reporting Services solution. Used to create ad hoc reports through the Report Builder application." (Marilyn Miller-White et al, "MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance 70-444", 2007)
"A 'blueprint' of a report. A report model includes the data source (such as a SQL Server database) and a data view (the tables and/or views that can be used in the report). Users can then use the report model to create their own reports, picking and choosing what data they want to include from the data view." (Robert D. Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)
"Report models are templates used to create reports with Report Builder. They include the data source definitions (such as which server and which database to connect to for the model) and data source VIEW definitions (such as which tables or VIEWs to include in the model). Reports can't be viewed from a report model. Instead, the report model must be used to create a report using Report Builder." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)
"A metadata description of business data used for creating ad hoc reports in Report Builder." (Jim Joseph, "Microsoft SQL Server 2008 Reporting Services Unleashed", 2009)
"A metadata description of business data used for creating ad hoc reports." (Microsoft, "SQL Server 2012 Glossary", 2012)
"A metadata description of business data used for creating ad hoc reports in Report Builder." (Microsoft Technet)
06 February 2015
📊Business Intelligence: Dashboards (Definitions)
05 February 2015
📊Business Intelligence: Trend Analysis (Definitions)
"The process of looking at homogeneous data over a duration of time to find recurring and predictable behavior." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)
"the process of looking at homogeneous data over a spectrum of time." (William H Inmon, "Building the Data Warehouse", 2005)
"An analytical technique that uses mathematical models to forecast future outcomes based on historical results. It is a method of determining the variance from a baseline of a budget, cost, schedule, or scope parameter by using prior progress reporting periods' data and projecting how much that parameter's variance from baseline might be at some future point in the project if no changes are made in executing the project." (Cynthia Stackpole, "PMP® Certification All-in-One For Dummies®", 2011)
[trending] "A process by which underlying trends are identified within time-related data. These trends may be manually, algorithmically, or statistically identified and may be extrapolated into the future to aid planning." (Evan Stubbs, "Delivering Business Analytics: Practical Guidelines for Best Practice", 2013)
"A form of statistical analysis used to analyze activities over a period of time." (Sally-Anne Pitt, "Internal Audit Quality", 2014)
"Using tools and statistics to identify consistent movement in one direction or another. The analysis might show a consistent upward trend or a consistent downward trend, but either way it indicates a change worth investigating." (Darril Gibson, "Effective Help Desk Specialist Skills", 2014)
"A data analysis technique that examines project performance over time to determine if performance is improving or deteriorating." (Cate McCoy & James L Haner, "CAPM Certified Associate in Project Management Practice Exams", 2018)
"An analytical technique that uses mathematical models to forecast future outcomes based on historical results." (Project Management Institute, "The Standard for Organizational Project Management (OPM)", 2018)
"analysis of data to identify time-related patters" (ITIL)
03 February 2015
📊Business Intelligence: Indicator (Definitions)
"An indicator is an objective feature or attribute supporting the implementation of a process. Indicators are used for the rating of process attributes. The indicators of the process dimension are base practices and work products; the indicators of the capability dimension are generic practices and generic resources." (Lars Dittmann et al, "Automotive SPICE in Practice", 2008)
"1.An attribute type that is considered to be binary: On or Off, True or False, Yes or No." (DAMA International, "The DAMA Dictionary of Data Management", 2011)
"A metric that you can use to predict the project’s future. For example, if the metric 'comments per KLOC' is 3, that may be an indicator that the project will be hard to maintain." (Rod Stephens, "Beginning Software Engineering", 2015)
"A measure that can be used to estimate or predict another measure." (ISO 14598)
29 January 2015
📊Business Intelligence: Descriptive Analytics (Definitions)
27 January 2015
📊Business Intelligence: Delta Lake (Definitions)
"Delta Lake, an open source ACID table storage layer over cloud object stores initially developed at Databricks." (Michael Armbrust et al, "Delta Lake: High-Performance ACID Table Storage over Cloud Object Stores", Proceedings of the VLDB Endowment 13(12), 2020) [link]
"Delta Lake is a transactional storage software layer that runs on top of an existing data lake and adds RDW-like features that improve the lake’s reliability, security, and performance. Delta Lake itself is not storage." (James Serra, "Deciphering Data Architectures", 2024)
"A Delta Lake is an open-source storage layer designed to run on top of an existing data lake and improve its reliability, security, and performance." (Hewlett Packard Enterprise) [source]
"Delta Lake is an open source storage framework that enables building a Lakehouse architecture with various compute engines." (Apache Druid) [source]
"Delta Lake is an open-source storage framework designed to improve performance and provide transactional guarantees to data lake tables." (lakeFS) [source]
"Delta Lake is an open-source storage framework that enables building a format agnostic Lakehouse architecture with compute engines including Spark, PrestoDB, Flink, Trino, Hive, Snowflake, Google BigQuery, Athena, Redshift, Databricks, Azure Fabric and APIs for Scala, Java, Rust, and Python." (Delta) [source]
"Delta Lake is an open-source storage layer that uses the ACID compliance of transactional databases to bring reliability, performance, and flexibility to data lakes. It is ideal for scenarios where you need transactional capabilities and schema enforcement within your data lake." (Qlik) [source]
"Delta Lake is an open-source storage layer for big data workloads. It provides ACID transactions for batch/streaming data pipelines reading and writing data concurrently." (Database of Databases) [source]
"Delta Lake is the optimized storage layer that provides the foundation for tables in a lakehouse on Databricks. Delta Lake is open source software that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata handling." (Databricks) [source]
"Delta Lake is the optimized storage layer that provides the foundation for tables in a lakehouse on Databricks. Delta Lake is open source software that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata handling. Delta Lake is fully compatible with Apache Spark APIs, and was developed for tight integration with Structured Streaming, allowing you to easily use a single copy of data for both batch and streaming operations and providing incremental processing at scale." (Microsoft) [source]
25 January 2015
📊Business Intelligence: Prescriptive Analytics (Definitions)
20 January 2015
📊Business Intelligence: Business Analytics (Definitions)
"Meta-data that includes data definitions, report definitions, users, usage statistics, and performance statistics." (DAMA International, "The DAMA Dictionary of Data Management", 2011)
"Provides models, which are formulas or algorithms and procedures to BI." (Linda Volonino & Efraim Turban, "Information Technology for Management "8th Ed, 2011)
"The process of leveraging all forms of analytics to achieve business outcomes by requiring business relevancy, actionable insight, performance management, and value measurement." (Evan Stubbs, "Delivering Business Analytics: Practical Guidelines for Best Practice", 2013)
"Application of analytical tools to business questions. Business Analytics focuses on developing insights and understanding related to business performance using quantitative and statistical methods. Business Analytics includes Business Intelligence and Reporting." (Daniel J Power & Ciara Heavin, "Decision Support, Analytics, and Business Intelligence" 3rd Ed., 2017)
"BA is a data-driven decision making approach that uses statistical and quantitative analysis, information technology, and management science (mathematical modeling, simulation), along with data mining and fact-based data to measure past business performance to guide an organization in business planning and effective decision making." (Amar Sahay, "Business Analytics" Vol. I, 2018)
"Use of data and quantitative and qualitative tools and techniques to improve operations and to support business decision making. Emphasis on using statistical and management science techniques, including data mining, to develop predictive and prescriptive models." (Daniel J. Power & Ciara Heavin, "Data-Based Decision Making and Digital Transformation", 2018)
"Aggregated information on business processes that enables managers to analyze process trends, view performance metrics, and respond to organizational change." (Appian)
"Refers to the skills, technologies, and practices for investigation of past business performance to gain insight and drive business planning. It focuses on developing new insights and understanding of business performance based on data and statistical methods. While business intelligence (BI) focuses on a consistent set of metrics to both measure past performance and guide business planning, business analytics is focused on developing new insights and understanding based on statistical methods and predictive modeling." (Insight Software)
"Business Analytics describes the skills, technologies, statistical methods and data driven approaches used to explore and investigate past business performance to gain new insights that can support business planning." (Accenture)
"Business analytics is comprised of solutions used to build analysis models and simulations to create scenarios, understand realities and predict future states. Business analytics includes data mining, predictive analytics, applied analytics and statistics, and is delivered as an application suitable for a business user." (Gartner)
"Business analytics (BA) is the iterative, methodical exploration of an organization's data, with an emphasis on statistical analysis." (Techtarget) [source]
"Business Analytics is the process by which businesses use statistical methods and technologies for analyzing historical data in order to gain new insight and improve strategic decision-making." (OmiSci) [source]
"Business analytics is the process of gathering and processing all of your business data, and applying statistical models and iterative methodologies to translate that data into business insights." (Tibco) [source]
"Describes the skills, technologies, statistical methods and data driven approaches used to explore and investigate past business performance to gain new insights that can support business planning. Examples of business analytics tools include data visualization, business intelligence reporting and big data platforms." (Accenture)
17 January 2015
♜Strategic Management: Scenario Analysis (Definitions)
"The process of identifying and evaluating potential risks to your business, and how they might play out, before they occur." (Annetta Cortez & Bob Yehling, "The Complete Idiot's Guide® To Risk Management", 2010)
"A technique to evaluate scenarios in order to predict their effect on portfolio objectives." (Project Management Institute, "The Standard for Portfolio Management" 3rd Ed., 2012)
"Scenario analysis, or what-if analysis, assesses the potential outcome of various scenarios by setting up several possible situations and analyzing the potential outcomes of each situation." (Christopher Donohue et al, "Foundations of Financial Risk: An Overview of Financial Risk and Risk-based Financial Regulation" 2nd Ed., 2015)
"A scenario analysis involves changing parameters in a model and then examining the results. A tool that helps a user explore different scenarios by changing a range of input values." (Ciara Heavin & Daniel J Power, "Decision Support, Analytics, and Business Intelligence" 3rd Ed., 2017)
"A technique for integrating information and ideas on current trends and future developments into a small number of distinctly different future outcomes." (Robert M Grant, "Contemporary Strategy Analysis" 10th Ed, 2018)
15 January 2015
📊Business Intelligence: Key Performance Indicator [KPI] (Definitions)
📊Business Intelligence: Single Version of Truth [SVoT]/Single Source of Truth [SSoT] (Definitions)
10 January 2015
📊Business Intelligence: Self-Service BI (Definitions)
Self-service business intelligence (BI): "A self-service BI is a semantic layer that enables business users to perform ad hoc reporting and analysis with no IT intervention. Self-service BI helps in the higher adoption of BI solutions." (Saumya Chaki, "Enterprise Information Management in Practice", 2015)
Self-Service BI: "The activity of end users being self-sufficient in supplying themselves with Business Intelligence reports and/ or queries without having to rely on IT." (BI System Builders)
"Self-service
analytics or self-service business intelligence refers to tools used to connect
and analyze data, and which are operated primarily by business departments in
the organization – rather than IT professionals or dedicated data analysts." (Sisense)
[source]
"Self-service BI is a trend with a somewhat vague definition. In the most general sense, self-service BI tasks are those that business users carry out themselves instead of passing them on to IT for fulfillment. The aim is to give the users of BI tools more freedom and responsibility at the same time. At its heart lies the notion of user independence and self-sufficiency when it comes to the use of corporate information, which leads to a decentralization of BI in the organization." (BI Survey) [source]
"Self-service BI (business intelligence) is a software tool or application that empowers business users to analyze data, visualize insights, and obtain and share information in the form of reports and self-service BI dashboards – without the help of IT." (Logi Analytics) [source]
About Me

- Adrian
- Koeln, NRW, Germany
- IT Professional with more than 25 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.