. Data Warehousing Archives - EWSOLUTIONS

Teaching Data Management Since 1998

Data Management University

Request a free consultation with a DMU Expert

Search DMU Library

DATA MANAGEMENT MOMENTS

2 - 3 Minute Data Management Videos

19 Jun, 2019

Foundations of Data Extraction Transform Load (ETL)

19 June, 2019
Wayne Yaddow
ETL

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

155 views

0 comments

3 Apr, 2019

Effective Data Warehouse Testing Strategy

03 April, 2019
Wayne Yaddow
Data Warehousing

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 ab

556 views

0 comments

20 Mar, 2019

Introduction to Data Warehouse Testing

20 March, 2019
Wayne Yaddow
ETL

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 thei

486 views

0 comments

29 Mar, 2018

Ensuring Speed, Flexibility and Agility with Self Service Analytics

29 March, 2018
Patricia L. Saporito
Data Warehousing

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 agile, self-service model that enables greater user access to data and the ability to create and perform individualize

1,159 views

0 comments

5 Mar, 2018

Improving the ROI of Big Data and Analytics through Leveraging new Sources of Data

05 March, 2018
Bart Baesens
Data Warehousing

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 thinking about further boosting their performance. Far too often, they focus on the analytical techniques rather than on the key ingredient: d

1,872 views

0 comments

27 Sep, 2017

Building a Rock Solid Data and Analytics Strategy

27 September, 2017
Patricia L. Saporito
Analytics

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 thigh bone”, your data strategy is connected to your analytics strategy – or it should be! Further, your analytics strategy

2,009 views

0 comments

21 Jul, 2017

Challenges of Data Warehouse Re-Architecture

21 July, 2017
Bruce D. Johnson
Data Warehousing

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 re-architecting data warehouses, whether we want to admit it or not. Since data warehouses are business driven (rethink your strateg

1,902 views

0 comments

23 Feb, 2017

Data Warehouse Standards

23 February, 2017
Sid Adelman
Data Warehousing

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, pause…  Well I guess Boscoe is busy with his chewy toy and doesn't want to come just now.") A number of organizations

1,390 views

0 comments

1 Oct, 2010

Increasing the Business Value of Business Intelligence

01 October, 2010
Mark Mosely
Data Warehousing / Business Intelligence / Analytics

Organizations can find increased value in business intelligence and analytics efforts through the use of various data delivery strategies. Introduction Like many organizations, your company probably has invested significant time, effort, and money into establishing your data warehousing and business intelligence environment.  You’ve built the databases and the ETL programs to move, clean and in

2,220 views

0 comments

20 Mar, 2015

Foundations of Data Warehousing

20 March, 2015
David Marco
Data Warehousing

Data warehousing is the proven architecture for delivering subject-oriented, stable, analytical information for decision making.  Effective data warehouse development provides many business benefits. Introduction A data warehouse is an enviroment that combines an integrated decision support database with software to collect, cleanse, transform, and store data from a variety of operational and ext

4,942 views

0 comments

 

View all podcasts

View Our Podcasts

DMU provides regular podcasts of our best webinars, expert speaking events and our 3 minute Data Management Moment teaching videos.

View Our Upcoming Webinars

Click here to signup for our upcoming expert webinars and to view our previous webinars

WordPress Image Lightbox