BUSINESS INTELLIGENCE VOCABULARY
Actionable insights to
drive growth for business
data science & analytics
Analysis or report created on the spot to answer the specific business question which is not clearly answered in a static report or deep drive to get clarity about business transactions or events. Ad Hoc Analysis is a business intelligence process.
Business intelligence is an umbrella term of a set of processes and best practices for data gathering, data analysis, data visualization using best-fit architectures and technologies.
BI practices creates a direct impact on data-driven decision-making processes.
Factless Fact Tables
Simple example of possible hierarchy widely adopted by by all dimensional data warehouse is date dimension : Year > Quarter > Month > Week > Day
Incremental load is ETL process to load delta(difference) from source to destination. Based on the requirement it can be streaming incremental load or batch incremental load. Incremental load is faster in comparison to full load as it touches less data.
Key Performance Indicators
Key performance Indicator is value measured by organizations to evaluate the effectiveness of key business objectives.
Metadata narrates other data. Detail data of Data e.g. description, structure, references etc.
Online Analytical Processing is compounding methods of data to perform multidimensional analysis of transactional data.
Power BI is Business Intelligence and Data visualization tool from Microsoft Corporation.
Pentaho is Business Intelligence, Data Integration and OLAP and reporting service tool from Hitachi and now known as Hitachi Ventara
Qlik View and Qlik Sence are Business Intelligence and Data Visualization Tools.
The database schema is logical view(skeleton) of all or part of entier relational database. Schema