Business Intelligence Archives | LightsOnData https://www.lightsondata.com/category/business-intelligence/ Practical resources, online courses, free articles and videos for data management, data governance, data quality, and business intelligence Fri, 03 Dec 2021 04:31:55 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 https://i0.wp.com/www.lightsondata.com/wp-content/uploads/2020/03/LOD-logo-favicon2.png?fit=32%2C32&ssl=1 Business Intelligence Archives | LightsOnData https://www.lightsondata.com/category/business-intelligence/ 32 32 142004744 How to use data visualization techniques and tools for business https://www.lightsondata.com/how-to-use-data-visualization-techniques-and-tools-for-business/ https://www.lightsondata.com/how-to-use-data-visualization-techniques-and-tools-for-business/#respond Fri, 03 Dec 2021 04:31:55 +0000 https://www.lightsondata.com/?p=3757 The constantly growing volumes of data within the business industry have crowned data visualization as an essential aspect for the growth and development of businesses. This article goes through a comprehensive range of concerns explaining how to implement and use data visualization techniques and tools within the business surrounding. Let’s get started! Table of Contents […]

The post How to use data visualization techniques and tools for business appeared first on LightsOnData.

]]> https://www.lightsondata.com/how-to-use-data-visualization-techniques-and-tools-for-business/feed/ 0 3757 Managing DW/ BI data integration risks through data reconciliation and data lineage processes https://www.lightsondata.com/managing-dw-bi-data-integration-risks-through-data-reconciliation-and-data-lineage-processes/ https://www.lightsondata.com/managing-dw-bi-data-integration-risks-through-data-reconciliation-and-data-lineage-processes/#respond Thu, 09 Jul 2020 00:40:54 +0000 https://www.lightsondata.com/?p=2135 Introduction Data lineage documents where data is coming from, where it is going, and what transformations are applied to it as it flows through multiple processes. It helps in understanding the data life cycle. It is one of the most critical pieces of information from a metadata management point of view. From data-quality and data-governance perspectives, it is essential […]

The post Managing DW/ BI data integration risks through data reconciliation and data lineage processes appeared first on LightsOnData.

]]> https://www.lightsondata.com/managing-dw-bi-data-integration-risks-through-data-reconciliation-and-data-lineage-processes/feed/ 0 2135 Main considerations for testing BI reports https://www.lightsondata.com/main-considerations-for-testing-bi-reports/ https://www.lightsondata.com/main-considerations-for-testing-bi-reports/#respond Wed, 03 Jun 2020 15:28:56 +0000 https://www.lightsondata.com/?p=1980 Among the most important phases of DW/BI testing is front-end report testing. The DW/BI project team should ensure that everything tested in the back-end DW and ETLs is now processed and displayed correctly in end-user reports. BI reports are often the most visible product of any DW/BI system. Data quality defects that are not discovered […]

The post Main considerations for testing BI reports appeared first on LightsOnData.

]]> https://www.lightsondata.com/main-considerations-for-testing-bi-reports/feed/ 0 1980 What you need to know about regression testing on DW/ BI projects https://www.lightsondata.com/regression-testing-on-dw-bi-projects/ https://www.lightsondata.com/regression-testing-on-dw-bi-projects/#respond Wed, 08 Apr 2020 15:03:19 +0000 https://www.lightsondata.com/?p=1716 Regression testing on large data integration DW/BI development projects is challenging. The number of test cases is often massive and many change impacts may be widely spread. For high-level integration regression testing, the retest-all approach is always time and resource consuming. To counter challenges with regression testing, this article proposes test scenarios based on changes […]

The post What you need to know about regression testing on DW/ BI projects appeared first on LightsOnData.

]]> https://www.lightsondata.com/regression-testing-on-dw-bi-projects/feed/ 0 1716 ETL test automation for DWH and BI – free white paper https://www.lightsondata.com/etl-test-automation-for-dwh-and-bi-free-white-paper/ https://www.lightsondata.com/etl-test-automation-for-dwh-and-bi-free-white-paper/#respond Wed, 29 Jan 2020 19:58:09 +0000 https://www.lightsondata.com/?p=1407 When your organization depends on business intelligence reporting, you will need a high level of process automation within your DWH/BI application development. When you can build automation into your DWH development process, you will need fewer highly skilled people to perform tedious and repetitive testing processes – usually, every day. It is practical to increase […]

The post ETL test automation for DWH and BI – free white paper appeared first on LightsOnData.

]]> https://www.lightsondata.com/etl-test-automation-for-dwh-and-bi-free-white-paper/feed/ 0 1407 Why (almost) everybody thinks a dashboard is all about numbers? https://www.lightsondata.com/why-dashboard-numbers/ https://www.lightsondata.com/why-dashboard-numbers/#respond Wed, 22 Jan 2020 20:16:31 +0000 https://www.lightsondata.com/?p=1421 Long ago I read an article about an apparently strange behavior: if you’re seeing a person looking at their watch and you immediately ask what time it is, just a small percentage can tell you the correct time. Some researches tried to investigate what’s the explanation for this apparently strange behavior. The results were quite […]

The post Why (almost) everybody thinks a dashboard is all about numbers? appeared first on LightsOnData.

]]> https://www.lightsondata.com/why-dashboard-numbers/feed/ 0 1421 The what, the why, and the how of shift left testing for BI and Data Warehouse Projects https://www.lightsondata.com/what-why-how-shift-left-testing-bi-data-warehouse/ https://www.lightsondata.com/what-why-how-shift-left-testing-bi-data-warehouse/#respond Wed, 15 Jan 2020 23:33:22 +0000 https://www.lightsondata.com/?p=1399 Shift left testing is an approach to Data Warehouse (DW) / BI development where testing is performed early in the lifecycle. Shifting left refers not only to dynamic data and BI application testing- it also refers to static testing, conducting reviews and inspections, and even more unit and integration testing. In this article, we highlight: […]

The post The what, the why, and the how of shift left testing for BI and Data Warehouse Projects appeared first on LightsOnData.

]]> https://www.lightsondata.com/what-why-how-shift-left-testing-bi-data-warehouse/feed/ 0 1399 6 must-have goals of your Business Intelligence program https://www.lightsondata.com/6-must-have-goals-of-your-business-intelligence-program/ https://www.lightsondata.com/6-must-have-goals-of-your-business-intelligence-program/#respond Wed, 04 Sep 2019 18:25:28 +0000 https://www.lightsondata.com/?p=1176 To get a successful business intelligence (BI) program started, I believe it should aim to address and abide by the following 6 goals: 1. Information must be easily accessible End users must be able to access information in a timely fashion so that their timely decision making is not compromised by this. Ease of accessibility […]

The post 6 must-have goals of your Business Intelligence program appeared first on LightsOnData.

]]> https://www.lightsondata.com/6-must-have-goals-of-your-business-intelligence-program/feed/ 0 1176 5 key stakeholders for successful report/ dashboard development https://www.lightsondata.com/5-key-stakeholders-for-successful-report-dashboard-development/ https://www.lightsondata.com/5-key-stakeholders-for-successful-report-dashboard-development/#respond Wed, 24 Jul 2019 18:59:13 +0000 https://www.lightsondata.com/?p=1153 One of the main functions of the Business Intelligence (BI) team is to provide the right information to the right people at the right time. 99% of the time, this comes in the form of well-designed, structured, and built reports and/or dashboards. There are a lot of challenges in getting that deliverable right in the […]

The post 5 key stakeholders for successful report/ dashboard development appeared first on LightsOnData.

]]> https://www.lightsondata.com/5-key-stakeholders-for-successful-report-dashboard-development/feed/ 0 1153 3 key data integrity testing strategies for DW/ BI systems https://www.lightsondata.com/3-key-data-integrity-testing-strategies-for-dw-bi-systems/ https://www.lightsondata.com/3-key-data-integrity-testing-strategies-for-dw-bi-systems/#comments Wed, 17 Jul 2019 20:24:36 +0000 https://www.lightsondata.com/?p=1157 Data warehousing and business intelligence users assume, and need, trustworthy data.In the Gartner Group’s Online IT Glossary, data integrity and data integrity testing are defined as follows:Data Integrity: the quality of the data residing in data repositories and database objects. The measurement which users consider when analyzing the value and reliability of the data.Data Integrity […]

The post 3 key data integrity testing strategies for DW/ BI systems appeared first on LightsOnData.

]]> https://www.lightsondata.com/3-key-data-integrity-testing-strategies-for-dw-bi-systems/feed/ 1 1157