Dimensional Modeling: Introduction
What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.
Have you ever fished in a Data Lake?
Why build a data warehouse when you can have _____. Fill in the blank with the latest marketing epiphany.
Early Arriving Facts / Late Arriving Dimensions
A resilient ETL process deals with data quality issues without causing a process failure while also meeting business requirements. One issue that should be anticipated
Top 3 Reasons Why Metadata is Key to Data Warehousing Success
Metadata has the power to make or break a data warehouse. Like most innovation, a metadata driven approach to data warehousing solves common challenges by taking the process to a higher level.
What is a data warehouse?
What exactly is a data warehouse? Why create a data warehouse? This short video provides non-technical answers that are easily understood by anyone.
Now Hiring ETL Developers – $7.25 per hour
We have all seen the job postings. “Immediate hire… ETL developer with 10 years’ experience.” Regardless of fast changing technologies there will be a need
External Data Mashup
Some of the most challenging data warehousing situations come in the form of external data mashups. Because the term “data mashup” has taken on a
SQL Server 2014 Has Arrived!
Like many of you I have been waiting for SQL Server 2014 to be released to market for quite a while. Now that it has
Don’t Miss These Critical ETL Considerations
Anyone who has been involved with data warehousing knows that there are plenty of things that can go wrong. Mistakes can be made when researching
Dealing with Deletes in the Data Warehouse
Data warehousing has a clear set of objectives such as data persistence, single easy to navigate data model, fast query performance, etc… While it is