A Software Engineer and data professional's blog on Business Intelligence /Analytics, SQL Server & other DBMS, DIKW Management, Software Engineering/Programming, Project Management, Dynamics 365 & other ERP systems, respectively 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
- 🔠Dataviz & BI
- 🔠D365
- 🔠Fabric
- 🔠Engineering
- 🔠Management
- 🔡Glossary
- 🌐Resources
- 🏺Dataviz
- 🗺️Social
- 📅Events
- ℹ️ About
15 February 2015
🪙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]
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.