tag:calagator.org,2005:/events/searchCalagator: Events tagged with: ODS2017-02-07T17:38:59-08:00tag:calagator.org,2005:Calagator::Event/12504713902017-01-28T21:06:10-08:002017-02-07T17:38:59-08:00Agile Data Warehousing, Building a Virtualized ODS” with Kent Graziano - DAMA PDXThursday, February 16, 2017 from 8:30-11:30am at Standard Insurance Center Auditoriumhttp://calagator.org/events/12504713902017-02-16T08:30:00-08:002017-02-16T11:30:00-08:00<div class="vevent">
<h1 class="summary">Agile Data Warehousing, Building a Virtualized ODS” with Kent Graziano - DAMA PDX</h1>
<div class='date'><time class="dtstart dt-start" title="2017-02-16T08:30:00" datetime="2017-02-16T08:30:00">Thursday, February 16, 2017 from 8:30</time>–<time class="dtend dt-end" title="2017-02-16T11:30:00" datetime="2017-02-16T11:30:00">11:30am</time></div>
<div class="location vcard">
<a href='/venues/202391337' class='url'>
<span class='fn org'>Standard Insurance Center Auditorium</span>
</a>
<div class="adr">
<div class="street-address">900 SW 5th Avenue</div>
<span class="locality">Portland</span>
, <span class="region">Oregon</span>
<span class="postal-code">97204</span>
<div class='country-name'>United States<div>
(<a href='https://maps.google.com/maps?q=900%20SW%205th%20Avenue,%20Portland%20Oregon%2097204%20United%20States'>map</a>)
</div>
</div>
<div class="description">
<p>Greetings Portland Lovers of Data, join your local Data User Group downtown on Thursday Feb 16th to learn about “Agile Data Warehousing, Building a Virtualized ODS” with Kent Graziano, Senior Technical Evangelist with Snowflake Computing and the author of The Data Warrior blog.</p>
<p>This is our usual monthly Portland Data Management User Group Chapter meeting.</p>
<p>For more information and to register go to: <a href="http://www.damapdx.org/">http://www.damapdx.org/</a> or our new meetup page at: <a href="https://www.meetup.com/PDX-Data-Engineering/events/237139605/">https://www.meetup.com/PDX-Data-Engineering/events/237139605/</a>. Please register at one of those sites, so that we have a count for our usual continental breakfast. Walk-ins are welcome.</p>
<h3>Presentation Summary</h3>
<p>In order to meet timelines to fulfill urgent, unmet reporting needs, we built a virtualized Operational Data Store (ODS). This allowed us to deliver new objects, quickly and incrementally, so we could quickly show the business users their data. In order to limit the need for refactoring in later stages of the data warehouse development, we chose to build this virtualization layer on top of a Type 2 persistent staging layer. All of this was done using the free Oracle SQL Developer Data Modeler (SDDM) against a MS SQL Server Database.</p>
<p>In this talk, we will show you the architecture for this approach, the rationale, and then some of the tricks used in SDDM to build all the stage tables and views very quickly. In the end you will see actual SQL code for the virtual ODS that you can leverage for your own projects.</p>
<p>Goals</p>
<p>• Learn what a Virtual ODS is and how it can help you be Agile</p>
<p>• Learn a data warehouse architecture that can be implemented incrementally and in layers</p>
<p>• How to quickly build pattern based stage tables in SDDM</p>
<p>• How to build complex, pattern based views in SDDM</p>
<p>• Tips on how to use analytic functions to create virtual columns</p>
<p>• See examples of how to embed change data capture into a view-based ELT loading architecture</p>
<h3>Speaker</h3>
<p>Kent Graziano is a Senior Technical Evangelist with Snowflake Computing and the author of The Data Warrior blog (<a href="https://kentgraziano.com/">https://kentgraziano.com/</a>). He is a certified Data Vault Master (CDVP2), Oracle ACE Director, former member of the Boulder BI Brain Trust (#BBBT), expert data modeler and architect with over 30 years of experience, including 25 years doing data warehousing with multiple architectures.</p>
<p>Kent is an award winning speaker and author having written numerous articles, and has given hundreds of presentations, nationally and internationally. He is a co-author of four books including The Data Model Resource Book (1st Edition), and Supercharge Your Data Warehouse. His now has several ebooks on Kindle including A Check List for Doing a Data Model Design Reviews and An Introduction to Agile Data Engineering. You can follow Kent on his blog and twitter @kentgraziano.</p>
<h3>Schedule</h3>
<p>8:30 - 9:00 am - Sign In <br>
9:00 - 10:15 am - Presentation <br>
10:15 - 10:30 am - Break, Chapter Announcements <br>
10:30 - 11:30 am - Presentation continued <br>
Free for Members and employees of our Corporate Members</p>
<p>There is a nominal charge for non-members to cover refreshments and speaker travel costs: $5 for Students with valid student ID / $15 for General public. See the list of DAMA PDX corporate members at damapdx.org</p>
<h3>About DAMA PDX </h3>
<p>The Portland Metro Chapter of the Data Administration Management Association has been serving our Portland data community since 1984. We are a not-for-profit, vendor independent, professional association dedicated to advancing the concepts and practices of enterprise information and data resource management.</p>
<p>Our Mission: Deliver thought provoking data-centric presentations to make you more successful in your job.</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="https://www.meetup.com/PDX-Data-Engineering/events/237139605/">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/Agile Data Warehousing">Agile Data Warehousing</a>, <a class="p-category" href="/events/tag/Graziano">Graziano</a>, <a class="p-category" href="/events/tag/ODS">ODS</a>, <a class="p-category" href="/events/tag/data">data</a>, <a class="p-category" href="/events/tag/portland">portland</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250471390.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250471390/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Saturday, January 28, 2017 at 9:06pm</strong> and last updated <br /><strong>Tuesday, February 7, 2017 at 5:38pm</strong>.
</div>
</div>
</div>
45.5174 -122.678