Data Warehouse Automation-Fast Scrum,Leveraging Analytics-Drive Enterprise Value

Presentation: Why do enterprise data warehouses take so long, cost so much and too often cannot answer by questions?

Guest speaker: Charles Lorenz, Data Warehouse Automation Specialist

Summary: An Enterprise Data Warehouse (EDW) is a critical factor in getting a leg up on the competition. Organizations invest millions of dollars and thousands of person hours designing, implementing and maintaining their EDW. Far too often, those responsible for the EDW are disappointed that the EDW does not provide a competitive advantage and costs to maintain it keep climbing.

This presentation will explore the reasons why so many EDW implementations do not live up to expectations. In mitigating those causes, we will discuss how Data Warehouse Automation (DWA) tools allow for a Scrum based build leading to a higher probability of success in implementing an EDW at a low initial cost and total cost of ownership (TCO).

What attendees will learn from this presentation:

• How DWA coupled with Scrum significantly reduces time and cost, while at the same time increasing quality and user satisfaction.

• Identify the industry leaders

• Discuss how DWA by itself does not necessarily guarantee success

We will provide a demo of how DWA technology allows for a Scum based approach by building a data mart for Sales with slowly changing dimensions and incremental loading, generating the data warehouse relational tables as well as cubes, populating the data warehouse, cubes, and running some reports.

Presentation: Leveraging Analytics to Drive Enterprise Value

Guest speaker: Andy Curtis, Senior VP, Northern Trust

Bio

Charles Lorenz is a Data Warehouse Automation Specialist. He has over 15 years’ experience architecting and delivering business intelligence solutions encompassing data staging to data mart, star schema design, multidimensional database implementation, reporting and visualization development in varied industries including banking, insurance, manufacturing, and specialty chemical. He has delivered solutions with Microsoft’s Reporting Services, Analysis Services, and Integration Services, and he has also delivered solutions with Cognos, Qlikview, and Datazen (before it was purchased by Microsoft).

Andy Curtis is a Senior Vice President at Northern Trust where he leads an enterprise analytics team focused on leveraging data to enhance Northern Trust’s profitability.

Prior to his current role, Andy led marketing and analytics teams at General Re-New England Asset Management, JP Morgan, and Y&R/Wunderman. He has helped organizations across many industries enhance the utilization and segmentation of client data to create more profitable relationships.

Andy received his Bachelor’s degree and MBA from the University of Chicago.