addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

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

  • Aug 26, 2016 · 8:30 AM
  • IBM

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


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.

Join or login to comment.

  • John M.

    Thank you, Diana, et al, and presenters for making this a successful meeting, given the break room we used. I think it made networking even better than a classroom.

    August 27

  • Dharti P.

    Sorry I missed the event as well due to work emergency situation I had to deal with it today morning. If anybody have a copy of presentation please share with me as well. Thanks!

    August 26

  • Nimit A.

    Is it possible to record this event or share the presentation later? I am very interested in attending but due to client commitments will not be able to attend.

    August 24

    • Ben P.

      We will try Nimit.

      August 24

    • Ben P.

      Disregard my statement. Wrong group.

      August 24

  • Nicole

    Is there a cost to this?

    August 5

    • Eric L.

      No charge, this is sponsored by the TDWI Chicago chapter. We have quarterly meetings with various topics.

      2 · August 6

Our Sponsors

  • IBM

    Sponsorship for the facilities, refreshments and board support.

  • Snowflake

    Cloud Analytics

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy