Applying DevOps-style test automation to projects can guarantee a high level of data quality in any business intelligence / analytics initiative. Introduction According to a CIO.com article, Gartner Group recently stated that between 70 and 80 percent of business intelligence initiatives
Data extraction, transformation, and loading processes enable many activities in information technology projects. Understanding the concepts and practices of ETL is essential for all data and technology professionals IntroductionData extract, transform, load (ETL) is a process of copying data from
Preparing a data warehouse testing strategy can ensure the successful development and completion of end-to-end testing of any data warehouse, data mart, or analytical environment. Introduction Organizations need to learn how to build an end-to-end data warehouse testing strategy. This
An Overview of Data Warehouse Testing Data warehouse and data integration testing should focus on ETL processes, BI engines, and applications that rely on data from the data warehouse and data marts. Introduction There is little that casts doubt on a data warehouse and BI project more quickly than incorrectly
Introduction Today’s digital world and fast paced business environment demands pervasive, timely analytics. Organizations must deliver speed, agility and ease of use for data access and analytics. In response, business intelligence (BI) and analytics teams are shifting to a more
Investing in new sources of data can help to unravel complex customer behavior and improve key analytical insights Introduction Big Data and Analytics are all around these days. Most companies already have their first analytical models in production and are
To be agile, business intelligence and analytics systems need frameworks and metrics to enable stable evolution. Introduction Enterprise Business Intelligence and analytics solutions are complex implementation efforts because of the Develop – Support (Growth-Sustain) cycles followed concurrently. Every enterprise wide BI
Every organization’s analytics strategy should be connected to its data strategy; and every organization should have a data strategy that supports its business strategy Introduction Like the lyrics in the children’s song Dem Bones, “the hip bone’s connected to the
Data warehouse / business intelligence / analytics environments require business and IT cooperation for successful architecture and design Introduction In working with many large corporations across a variety of industries, it is clear that we all face the reality of
Standards are different from guidelines. Standards are firm and must be followed. Successful data warehouses use standards Introduction Many dog owners give their dogs what they consider to be commands. They are really more like guidelines. (“Boscoe come!… pause, pause,
