March 2017: The Analytical Data Mart and The Customer Analytic Record

Presented by Dr. Bob Nisbet

Instructor, Predictive Analytics Certificate Program, University of California, Irvine

The rise of Predictive Analytics in business will generate many opportunities for data managers. The Business Ecosystem has arrived, and Predictive Analytics models are the “windows” into understanding its operational complexity. The Operational Data Store (ODS) is an elaboration of data warehousing design to serve the needs of business data users better (cf. Kent Graziano’s talk). The Analytical Data Mart (ADM) serves an analogous purpose to serve the needs of predictive analytics. Differences between the organization of data in an EDW or ODS and that needed to serve analytics efficiently are discussed. The discussion will include some specific data transforms required by analytical algorithms, and how the “heavy lifting” of their processing can be committed to data mart operations,. An example of the blending of an ODS and an ADM to serve predictive analytics modeling operations in a Santa Barbara bank will be presented.

Speaker

Dr. Bob Nisbet’s original training was in Botany, with specialties in plant ecology and paleobotany. He taught and conducted research in Botany and Ecology for many years in several colleges and universities, most recently as a Researcher in Forest Growth Modeling at the University of California, Santa Barbara. He led a field investigation in central Ohio to collect plant fossils from Mississippian sediments. He retains his interest in paleobotany to the present. For the last 20 years of his career, Bob was active as a Data Scientist, initially for AT&T, then for NCR Corporation (after the split in 1996). He led the Yield Management analytical team at NCR Corporation which pioneered the design and development of configurable data mining applications for retail sales forecasting, and Churn, Propensity-to-buy, and Customer Acquisition in Telecommunications, Insurance, Banking, Credit, membership organizations (e.g. AAA), and Health Care industries. He is lead author of the award-winning “Handbook of Statistical Analysis & Data Mining Applications” (Academic Press, 2009), and a co-author and general editor of the award-winning “Practical Text Mining” (Academic Press, 2012) and “Practical Predictive Analytics and Decisioning Systems in Medicine” (Academic Press, 2015). In his retirement, he serves as an Instructor in the University of California at Irvine Predictive Analytics Certificate Program, teaching many online and on-campus courses each year in Effective Data Preparation, and co-teaching Introduction to Predictive Analytics. He serves also as a technical advisor of the Predictive Analytics Certificate Program at UC-Irvine, as a Technical Editor of the Practical Predictive Analytics series of books by Cambridge University Press. He serves also on the Conservation Advisory board of the Santa Barbara Botanic Garden, where he provides botanical and analytical services.

When

March 16, 2017 (Chapter Meetings, 3rd Thursday)

Schedule

8:30 – 9:00 am – Sign In
9:00 – 10:15 am – Presentation
10:15 – 10:30 am – Break, Chapter Announcements
10:30 – 11:30 am – Presentation continued

Standard Insurance Center in the Atrium room, 900 SW 5th Avenue in Portland. Make sure you go to the Standard Insurance tower on 900 SW 5th Ave as there are two Standard locations in downtown Portland.

The room is located at the top of the south elevator bank (as you enter from the 5th street sidewalk, continue to the right past the elevators and up the escalators, then through the double glass doors into a new window-ed space).

Cost

Free for Members!
$15 for Non-Members
$5 for Students with valid student ID
See our corporate members

February 2017: Agile Data Warehousing, Building a Virtualized ODS

Presented by Kent Graziano
Senior Technical Evangelist at Snowflake Computing

At a past client, in order to meet timelines to fulfill urgent, unmet reporting needs, we found it necessary to build a virtualized Operational Data Store (ODS) as the first phase of a new Data Vault 2.0 project. This allowed us to deliver new objects, quickly and incrementally to the report developer 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 Oracle SQL Developer Data Modeler (SDDM) against (gasp!)  a MS SQL Server Database. In this talk I will show you the architecture for this approach, the rationale, and then some of the tricks I 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.

Goals:

  • learn a data warehouse architecture that can be implemented incrementally and in layers
  • learn what a Virtual ODS is and how it can help you be Agile
  • how to quickly build pattern based stage tables in SDDM
  • how to build complex, pattern based views in SDDM
  • tip on how to use analytic functions to create virtual columns
  • see examples of how to embed change data capture into a view-based ELT loading architecture

Speaker

Kent Graziano is a Senior Technical Evangelist with Snowflake Computing and the author of The Data Warrior blog. 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. 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.

When

Feb 16, 2017 (Chapter Meetings, 3rd Thursday)

Schedule

8:30 – 9:00 am – Sign In
9:00 – 10:15 am – Presentation
10:15 – 10:30 am – Break, Chapter Announcements
10:30 – 11:30 am – Presentation continued

Standard Insurance Center in the Atrium room, 900 SW 5th Avenue in Portland. Make sure you go to the Standard Insurance tower on 900 SW 5th Ave as there are two Standard locations in downtown Portland.

The room is located at the top of the south elevator bank (as you enter from the 5th street sidewalk, continue to the right past the elevators and up the escalators, then through the double glass doors into a new window-ed space).

Cost

Free for Members!
$15 for Non-Members
$5 for Students with valid student ID
See our corporate members

January 2017: Advanced Data Visualization

Presented by Amit Manghani

The world produces more than 2.5 exabytes of data every day. There is just too much information out there and traditional reports using tabs, rows and columns do not paint the whole picture any longer.

Visualization is one key approach to gaining insight from this mountain of data. Advanced Visualizations Platforms have enabled the use of more dynamic and interactive business graphics, such as real-time dashboards and charts that update automatically as the data changes. It enables knowledge workers to see the trends and patterns (along with gaps and outliers) in the data that are not as easily identified in rows and columns of numbers. Even Data Scientists are leveraging advanced visualizations tools to explore, understand and communicate insights, along with the actions that need to be taken.

In this session, we will explore how advanced visualization tools are being utilized in the era of big data to draw valuable business insights and we will also delve into some of the predominant data visualization tools being used by Data Scientists.

Speaker

Amit P. Manghani, M.S., MBA, has more than a decade of experience in the Information Technology domain dealing with Enterprise Information Management, Business Intelligence, Web Applications and Cloud Computing technologies at leading Information Management companies such as Oracle, Informatica and SAP. Prior to joining Oracle, Amit was focused on utilizing the power of emerging data integration technologies encompassing real-time data acquisition/ movement, event processing and agile data access within Big Data usage scenarios. Now as Senior Director of Product Management at Oracle, he is responsible for enabling partners globally on the different facets of Oracle Sales Cloud ranging from Analytics to Mobile to Sales Prediction capabilities. He is an avid follower of technology trends and has published articles in leading online journals and has presented at several technology conferences. Also in 2012, Amit was certified in Hadoop which is the premier certification for Big Data processing.

When

January 19, 2017 (Chapter Meetings, 3rd Thursday)

Schedule

8:30 – 9:00 am – Sign In
9:00 – 10:15 am – Presentation
10:15 – 10:30 am – Break, Chapter Announcements
10:30 – 11:30 am – Presentation continued

Standard Insurance Center in the Atrium room
900 SW 5th Avenue in Portland.

The room is located at the 5th street level past the south elevator bank (as you enter from the 5th street sidewalk to the right past the elevators and then through the double glass doors into a new window-ed space).

Cost

Free for Members!
$15 for Non-Members
$5 for Students with valid student ID
See our corporate members