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 Introduction Data extract, transform, load (ETL) is a process of copying data from one or more sources into a target system which is usually designed to represent the data differently from the
Every organization needs a business architecture – the blueprint that explains the structure of the enterprise capabilities, business processes, and information exchanges, connecting strategy with execution Introduction A Business Architecture describes the business processes and functions needed to support an enterprise’s business strategy. It consists of requirements, principles, and models of the enterprise’s business processes. The goal of the Business
Every effective enterprise data strategy should consist of an analysis of the organization’s people, processes, technology, and organizational structure – and follow proven implementation steps. Introduction Along with understanding the concepts of a data strategy, it is important to know the parts of an enterprise data strategy. Each organization should develop and follow the proven implementation steps that lead to
Communication and miscommunication affect projects and so much more. There are simple steps anyone can take to improve all communications Introduction Most people have witnessed situations where two project team members start out talking calmly, then quickly escalate to a heated debate. Once the conversation starts, over time, the volume level increases, the participants start waving their arms wildly, and
Although the need for regulatory compliance may seem to negate the ability to become or remain agile, many organizations have discovered they can adopt and use LEAN and / or agile techniques and sustain their compliance activities successfully. Introduction In the business world, the term agility describes the ability of an organization’s system to quickly respond or adapt to changes
Organizations that want to realize the value of their data and information as enterprise assets should consider forming and sustaining an Enterprise Data / Information Management Program Office or Center of Excellence. Introduction Many organizations decide that implementing some form of enterprise information management (EIM) or enterprise data management (EDM) is a fantastic idea. They assess their current state of
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 is most often necessary because the success of a data warehousing project is highly dependent upon the team’s ability to
Data services support the emergence of data offices and data-centric architectures to allow organizations to develop opportunities for improved data management and usage Introduction Data Service is a part of a data-centric architecture. A good data-centric architecture has many benefits and organizations should focus on clarifying the reasons, opportunities and strengths of this architectural style. What is a data service?
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 reported data. It is crucial that data warehouse project teams do all in their power to deliver reports with high
A Data Office has become a reality as part of many organizations’ enterprise architecture frameworks. A data office can support moving the organization toward a data-centric view for enterprise services and solutions.. Introduction Data Office, data service, data-centric architecture, data governance, chief data officer, etc. are some terms that have become part of the language of data management professionals. More
