a2c News

News Article Detail


Agile Data Warehouse Design for Big Data Seminar now Available Online 12/18/2013 Jim Stagnitto and John DiPietro of consulting firm a2c recently lead a seminar and discussion on Agile Data Warehouse Design for Big Data…


(Click on image to view presentation)


On November 14, 2013, a2c’s Jim Stagnitto and John DiPietro were joined by 93 Data Scientists at a Microsoft NERD (New England Research & Development Center) and Cognezius Analytics Virtualization sponsored Meetup featuring Agile Data Warehouse Design for Big Data on the MIT campus in Cambridge Massachusetts.  Agile Data Warehouse Design is a step-by-step method which enables data warehousing/business intelligence (DW/BI) professionals to better collect and translate business intelligence requirements into successful dimensional data warehouse design.  During the one hour seminar, a2c CTO John DiPietro and Information Services Practice Director Jim Stagnitto provided an overview of Agile Methodology, based on author Stagnitto’s   Agile Data Warehouse Design (co-written with Lawrence Corr).   The method utilizes BEAM (Business Event Analysis and Modeling) - an agile approach to dimensional data modeling that can be used throughout analysis and design to improve productivity and communication between DW designers and BI stakeholders. BEAM builds upon the body of mature "best practice" dimensional DW design techniques, and collects "just enough" non-technical business process information from BI stakeholders to allow the modeler to slot their business needs directly and simply into proven DW design patterns.


BEAM encourages DW/BI designers to move away from the keyboard and their entity relationship modeling tools and begin "white board" modeling interactively with BI stakeholders.  With the right guidance, BI stakeholders can and should model their own BI data requirements, so that they can fully comprehend and govern reporting and analysis capabilities and to assure that the Data Warehouse will be able to fulfill business driven needs.


Director Stagnitto is a veteran strategist and Data Warehouse Architect, specializing in powerful designs that extract the maximum business benefit from Intelligence and Insight investments, Master Data Management (MDM) and Customer Data Integration (CDI).   He is a renowned Data Warehousing, Data Quality, and Data Integration thought-leader and has co-authored Agile Data Warehouse Design, and contributed to Ralph Kimball’s “Data Warehouse Designer” column and Ralph and Joe Caserta's latest book, The DW ETL Toolkit


John DiPietro is the Chief Technology Officer for a2c where he is responsible for setting the vision, strategy, delivery, and methodologies for a2c’s Solution Practice Offerings for all national accounts. The a2c CTO brings with him an expansive depth and breadth of specialized skills in the arenas of Big Data, Data Warehousing, Data Enterprise Management, and Data Analytics.


Preview this Big Data Seminar, and request the complete audio and animated download featuring Agile Data Warehouse Design, and discover a new and agile approach to dimensional data modeling via this fun and informative one hour session.  Demystify this process and find out what the 93 Data Scientists who attended November's Boston Big Data Meetup are talking about-


“Excellent presentation. It is good to hear meaningful …information about new developments in how Agile methodologies can be applied to DW/BI work. Big Kudos to the presenters and organizers. Thanks, I found it very useful and enjoyable.”- Ramon Venegas


“Extremely useful to understand how to apply Agile approach to DWH; how create a framework where model changes are welcome, and bring users to the process of DWH modeling.” – Alfredo Gomez


For further information regarding Agile Data Warehouse Design, please contact Jim Stagnitto or John DiPietro at 215-789-4816