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
- 🗃️Posts
- 🗃️Definitions
- 🏭Fabric
- ⚡Power BI
- 🔢SQL Server
- 📚Data
- 📚Engineering
- 📚Management
- 📚SQL Server
- 📚Systems Thinking
- ✂...Quotes
- 🧾D365: GL
- 💸D365: AP
- 💰D365: AR
- 👥D365: HR
- ⛓️D365: SCM
- 🔤Acronyms
- 🪢Experts
- 🗃️Quotes
- 🔠Dataviz
- 🔠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]
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)
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]
05 January 2015
📊Business Intelligence: Real-time Analytics [RTA] (Definitions)
"Real-time analytics (RTA) describes an approach to data processing that allows us to extract value from events as soon as they are made available." (Mark Needham, "Building Real-Time Analytics Systems: From Events to Insights with Apache Kafka and Apache Pinot", 2023)
"Real-time analytics involves the use of tools and techniques to analyze data immediately after it's collected, enabling decision-makers to draw insights and take action in real-time. It integrates, processes, and analyzes live data to support instantaneous decision making. It's characterized by low latency between when data enters the system and when it’s processed." (Dremio) [source]
"Real-Time Intelligence is a powerful service that empowers everyone in your organization to extract insights and visualize their data in motion. It offers an end-to-end solution for event-driven scenarios, streaming data, and data logs." (Microsoft) [source]
"Real-time analytics is a set of techniques for processing data as soon as it becomes available. The main goal is to provide fast and actionable insights." (MongoDB) [source]
"Real-time analytics is the analysis of data as soon as that data becomes available. In other words, users get insights or can draw conclusions immediately (or very rapidly after) the data enters their system." (Sisense) [source]
"Real-time analytics is the discipline that applies logic and mathematics to data to provide insights for making better decisions quickly. For some use cases, real time simply means the analytics is completed within a few seconds or minutes after the arrival of new data. On-demand real-time analytics waits for users or systems to request a query and then delivers the analytic results. Continuous real-time analytics is more proactive and alerts users or triggers responses as events happen." (Gartner) [source]
"Real-time analytics is the use of data and related resources for analysis as soon as it enters the system. The adjective real-time refers to a level of computer responsiveness that a user senses as immediate or nearly immediate." (Techtarget) [source]
"Real time analytics lets users see, analyze and understand data as it arrives in a system. Logic and mathematics are applied to the data so it can give users insights for making real-time decisions." (OmiSci) [source]
"Real-time analytics refers to the practice of collecting and analyzing streaming data as it is generated, with minimal latency between the generation of data and the analysis of that data." (Databricks) [source]
"The ability to use all available enterprise data as needed and usually involves streaming data that allows users to make business decisions on the fly." (Solutions Review)
02 January 2015
📊Business Intelligence: Decision Support System [DSS] (Definitions)
"Interactive computer-based systems intended to help decision makers utilize data and models to identify and solve problems and make decisions." (D J Power, "Decision Support Systems Hyperbook", 2000)
"The original name for data warehousing." (Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit" 2nd Ed., 2002)
"The presentation of data to support management in making decisions." (William A Giovinazzo, "Internet-Enabled Business Intelligence", 2002)
"The automated process to provide facts and information to facilitate decision-making activities. Usually DSS involves the analysis of many units of data in a heuristic fashion." (Margaret Y Chu, "Blissful Data ", 2004)
"A system used to support managerial decisions. Usually DSS involves the analysis of many units of data in a heuristic fashion. As a rule, DSS processing does not involve the update of data." (William H Inmon, "Building the Data Warehouse", 2005)
"Commonly known as DSS databases, these support decisions, generally more management-level and even executive-level decision-type of objectives." (Gavin Powell, "Beginning Database Design", 2006)
"A system used to support managerial decisions. Usually DSS involves the analysis of many units of data in a heuristic fashion. As a rule, DSS processing does not involve the update of data." (William H Inmon & Anthony Nesavich, "Tapping into Unstructured Data", 2007)
"A branch of the broadly defined management information system (MIS). It is an information system that provides answers to problems and that integrates the decision maker into the system as a component. The system utilizes such quantitative techniques as regression and financial planning modeling. DSS software furnishes support to the accountant in the decision - making process." (Jae K Shim & Joel G Siegel, "Budgeting Basics and Beyond", 2008)
"An application that uses data to support managerial decisions through ad hoc query, summarization, drill-down analysis, trend analysis, exception identification and 'what if' scenario modeling." (DAMA International, "The DAMA Dictionary of Data Management", 2011)
"An arrangement of computerized tools used to assist managerial decision making within a business." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)
"Computer-based information system that combines models and data to solve semistructured and some unstructured problems with intensive user involvement." (Linda Volonino & Efraim Turban, "Information Technology for Management" 8th Ed., 2011)
"Information processing application used by managers and business professionals to analyze situations, monitor and compare performance data, highlight changes that require their attention, and to identify the more promising solutions. DSSs are one component of the overall MIS content for a business" (Kenneth A Shaw, "Integrated Management of Processes and Information", 2013)
"A DSS is an interactive computer-based system or subsystem intended to help decision makers use communications technologies, data, documents, knowledge, or models to identify and solve problems, complete decision process tasks, and make decisions." (Ciara Heavin & Daniel J Power, "Decision Support, Analytics, and Business Intelligence" 3rd Ed., 2017)
"A computer-based information system that supports individual or team decision making. Five primary types: communications-driven, data-driven, document-driven, knowledgedriven, and data-driven DSS." (Daniel J Power & Ciara Heavin, "Data-Based Decision Making and Digital Transformation", 2018)
"A coordinated assemblage of people, devices or other resources that analyzes, typically, business data and presents it so that users can make business decisions more easily." (GEMET - Environmental thesaurus)
"A computer system that provides managers with the tools they need to analyze information they deem relevant for a particular decision or class of decisions. Pearson, "Digital Planet: Tomorrow's Technology and You" 10th Ed.)
About Me
- Adrian
- Koeln, NRW, Germany
- IT Professional with more than 24 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.