A Dimodelo Data Warehouse Automation Case Study Podcast

ByMike Rabinovici Updated on

Talking Analytics Platform Services with Ashley Furniture’s Data Architect Phil Haddad, and Microsoft’s Principal Program Manager in the Azure SQL Data Warehouse team, Matt Usher.  In this podcast we discuss:

  • Refractoring an exising data warehouse
  • Automating data warehouse development in an enterprise environment with 700 applications
  • Migrating to Azure Data Warehouse from PDW/APS
  • The role Microsoft Partners play
  • How Azure is changing the game for Data Warehousing and Analytics

Click here to listen – 

For more information please visit:

Mike Rabinovici

Similar Posts

Designing an Enterprise Data Warehouse – where to start?

ByAdam Gilmore

When faced with a new Enterprise Data Warehouse development, it’s hard to know where to start. Many people make the mistake of starting with some reporting requirements. Unfortunately, this leads to narrow silos that can’t accommodate new requirements. Initially, it’s better to anchor your high-level design to the core business processes of the business. If…

What is a Data Warehouse Bus Matrix? (and why you need one)

ByAdam Gilmore

A “Data Warehouse Bus Matrix” describes the high-level design of a Data Warehouse. At a glance, it shows all the facts and dimensions of a data warehouse and their relationships in a table-like ‘matrix’. It’s useful as a tool to design, plan, estimate and communicate your data warehouse. The “Data Warehouse Matrix” comes from the…

Range Lookups in the SSIS Lookup Transformation

ByAdam Gilmore

Let’s say, in an SSIS Data Flow which is processing invoices, you wanted to match an invoice to an event based on the date of the invoice falling between the start and end date of the event. To achieve this in a SSIS Lookup Transformation, you need to use advanced configuration. The configuration steps required follow: On…

| |

Conversations with Data Warehouse Experts – Dr. Claudia Imhoff

ByMike Rabinovici

In this episode, it is my pleasure to speak with Dr. Claudia Imhoff, a real rock star in our corner of the technology universe.  She not only has the technical chops and but also an in-depth understanding of the business landscape.  In 1992 she founded her consulting company, Intelligent Solutions, Inc., and in 2006 she…

|

Persistent Staging Case Study – Payroll Fact in Human Resources Data Warehouse

ByAdam Gilmore

This post is the first in a series of detailed cases studies discussing the ETL strategies that can be used when a Persistent staging layer is included in your Data Warehouse. It’s intended as a reference for developers using Dimodelo Data Warehouse Studio, our Data Warehouse Automation tool to quickly build a Data Warehouse. It’s…

Data Warehouse Automation – the next big thing

ByAdam Gilmore

Jet Reports have written an interesting article on Data Warehouse Automation. It appears this concept is gaining recognition. TDWI has also recognized the value of Data Warehouse Automation, as one of the emerging trends for 2015 and beyond. I’ve also written an introduction article on the who, what, where, when and why of Data Warehouse Automation….

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.