Posts

Showing posts with the label business intelligence Data Pipeline

Testing of Business Intelligence (BI) Applications

Image
  Business intelligence (BI)  Is a process of gathering, analyzing, and transforming raw data into accurate, efficient, and meaningful information which can be used to make wise business decisions and refine business strategy. As part of the BI process, organizations collect data from internal IT systems and external sources, prepare it for analysis, run queries against the data and create data visualizations, BI dashboards and reports to make the analytics results available to business users for operational decision-making and strategic planning.  Business Intelligence Testing (BI Testing)  initiatives help companies gain deeper and better insights so they can manage or make decisions based on hard facts or data. What is Business Intelligence Testing: Business Intelligence testing helps the business users to validate and verify the accuracy of these BI Reports and Dashboards and ensures data credibility and accuracy of insights derived from the BI process. Rep...
2 comments
Read more

Business Intelligence (BI) Data Pipeline

Image
  Business Intelligence Data Pipeline We must ensure the reports are delivered correctly. But Business Intelligence report is just the final output of a very long data pipeline. So, if the report is wrong, it is not necessary that the defect is in the report; the root cause of the defect might be somewhere along with the breadth of the data pipeline.    The Business Intelligence Data Pipeline can be divided into two distinct stages:   Part A: Data Processing & Storage a.  Source data b. ETL c. Database/Data warehouse   Part B: BI Testing a.  Data Layer b. Reports c. Dashboards        BI System Testing process has 3 stages: Data Layer:  Data Layer or Metadata Layer is about data. It describes where data is being used and stored, the source of data, and how one piece of data relates to information. It includes description of data structure (schema, dimensions and hierarchies) and definitions of conform...
4 comments
Read more