Archives

Data Modeling for NoSQL DBMS

DESCRIPTION:

We have heard the business case and related modern technology oriented justifications for adopting NoSQL DBMS solutions in support of data driven business transformation.   Now comes the hard part.  Now that we’ve agreed we need to make the move, we need to identify the architectural technological implications facing the folks that have to build and maintain this new mission critical platform.   As the leader in Data Modeling, we have identified a critical success factor facing the majority of organizations adopting a document database like MongoDB.  Successfully deploying this solution requires a significant paradigm shift in how we design NoSQL data structures and deploy the databases that manage them.

Traditional database design has been focused on normalization and a storage optimized model.  This was driven by the technological playing field of the day and the belief that normalization and the resulting referential integrity it provided was paramount.   However, when we look at the new data use cases, the new development technologies and techniques available and the DBMS capabilities and behaviors they demand, the deck has been shuffled with regards to the goals and priorities of database design.

Demands for real-time access and analysis drive the demand for real time performance.  From a design perspective, query performance is now king.  We have the new platforms and technologies to handle the risks of de-normalization and we can now embrace it in pursuit of simplified querying and high- performance response.

In this session, we will cover how data modeling can guide you through this paradigm shift and take the pain out of transforming your approach to modern database design.  The session will include:

  • Problem Definition and Context
  • Resulting Pain Points
  • Adopting a query optimized design approach
  • Critical Use Case: Transforming legacy database applications/schema into high performance NoSQL databases
  • How Data Modeling Helps

PRESENTER:
Danny Sandwell, ERwin

With more than 25 years’ experience in the IT industry, Danny has been with erwin for 16 years. His industry experience includes various roles in data administration, database design, business intelligence, metadata management and application development.

LOCATION DETAILS:

Principal Financial Group
711 High St
Des Moines, IA 50309

Please bring a form of ID as it will be necessary to check in at the security desk.

Parking:
Free at lot shown in map
812 7th St (South of Crocker Str, Between 7th and 8th Street)

Hosted By: Principal Financial Group

www.principal.com

Panel Discussion on the Evolving Role of Data Management

DESCRIPTION:
Have you seen changes in the way your team does database development? Are you using new tools or techniques that disrupt the status quo? Have you seen more data activities shift from specialists to teams? Are there heightened expectations for your data initiatives due to data technology hype?

Participate in a discussion with a panel of local data professionals from different companies and with multiple areas of expertise. The panel will share their experiences on wide range of topics including Agile, Big Data, and Data Services and how they affect the role of Data Management.

Time:
Registration 8:30-9:00
Presentation: 9:00-11:00
Q&A & Networking: 11:00-11:30

PRESENTER:
Speaker names:
Panelists from various local companies

Speaker bios:
Will be available and shared 1-1.5 weeks before event

LOCATION DETAILS:
Wells Fargo
13733 University Avenue
Clive, IA 50325

Parking:
Wells Fargo Parking

Demystifying Cloud Data Warehousing

DESCRIPTION:
We all know that data warehouses and best practices for them are changing dramatically today. As organizations build new data warehouses and modernize established ones, they are turning to cloud data warehousing in hopes of taking advantage of the performance, concurrency, simplicity, and lower cost of the cloud or simply to reduce their data center footprint (and the maintenance that goes with that). But what is a Cloud Data Warehouse really? How is it different from traditional on-premises data warehousing and big data platforms?

In this talk to be discussed:
• Demystify cloud data warehousing by defining it and its goals
• Discuss the real-world benefits of cloud-native data warehousing
• Discuss some of the coolest features as exemplified by the Snowflake Elastic Data Warehouse
• Discuss the real-world benefits of a solution like Snowflake
• Discuss some of the differences between Snowflake and other cloud data warehouse options

PRESENTER:
. Kent Graziano

Kent Graziano is a Senior Technical Evangelist for Snowflake Computing and an award winning author, speaker, and trainer, in the areas of data modeling, data architecture, and data warehousing. He is an Oracle ACE Director, member of the OakTable Network and DAMA-I, a certified Data Vault Master and Data Vault 2.0 Practitioner (CDVP2), expert data modeler and solution architect with more than 30 years of experience, including over two decades doing data warehousing and business intelligence (in multiple industries). He is an internationally recognized expert in Oracle SQL Developer Data Modeler and Agile Data Warehousing. Mr. Graziano has developed and led many successful software and data warehouse implementation teams, including multiple agile DW/BI teams. He has written numerous articles, authored three Kindle book (available on Amazon.com), co-authored four books, and has given hundreds of presentations, nationally and internationally. He was a co-author on the first book on Data Vault, and the technical editor for Super Charge Your Data Warehouse. In 2014, he was voted one of the best presenters at OUGF14 in Helsinki, Finland. You can follow Kent on twitter @KentGraziano or on his blog The Data Warrior

http://www.KentGraziano.com

LOCATION DETAILS:
Principal Financial Group
750 Park
Des Moines, IA 50309


Hosted By: Principal Financial Group

https://www.principal.com/

Whos Modeling Data in Agile Anyway?

DESCRIPTION:
Agile and data. Sounds a lot like peanut butter and sardines, right? Ugh! Successful projects require an understanding, and analysis of multiple models including scope, process, interface, interaction and data, regardless of your approach; Waterfall, Agile, Wagile, Scrummerfall etc. The better the modeling, the better the chance of implementing a successful project. However, when it comes to Agile, I often see a lot of people running for the hills pretending everyone knows exactly what the data is used for leaving the developers to fend for themselves. Given the speed of Agile we need to look at modeling our data differently. In this dynamic and interactive workshop, you will learn and practice modern, tool agnostic, Agile approaches to capturing and modeling data

PRESENTER:
Bob the BA

Bob the BA provides badass business analysis training, consulting and mentoring services. Bob is passionate about helping you think, learn and work differently. Bob is CBAP® certified with 30+ years of experience in corporate America; with a background in managing BA centers of excellence, assessing and managing BA maturity, quality, and competency. Bob is an author and award-winning curriculum developer. Bob has presented numerous keynote, workshops, seminars, conferences, and training sessions across North America. Bob is a founding member and past President of the IIBA® MSP Chapter.

http://www.BobtheBA.com

LOCATION DETAILS:
Nationwide Insurance
100 Locust St
Des Moines, IA 50309

Please bring a form of ID as it will be necessary to check in at the security desk.

Parking:
Please use the parking garage directly behind Nationwide (address is 1100 Walnut St). There are entrances to the parking garage from Walnut St, 12th St, and Mulberry St. After you park, take the elevators down to 3rd floor for the skywalk, and enter Nationwide from the east side of the garage. Bring your parking ticket to get validated by the security guard. All non-Nationwide associates must sign-in with the security guard to gain access.

Hosted By: Nationwide Insurance
nationwide

http://www.nationwide.com

DAMA Day 2017

DESCRIPTION:
Are you trying to help your organization become more data-driven? Do you want to learn more about data topics? Would connecting with other data professionals be beneficial to you? DAMA Day 2017 will deliver an exciting set of topics to inform, educate and connect central Iowa data professionals via educational presentations, and case studies. Topics include Data Lake, Developing a Native Mobile BI App, and BI Self-Serve Practices.

2017 DAMA Day Flyer final

Cost: $30 (includes lunch)

7:45 – 8:15 – Registration/check-in
8:15 – 8:30 – Welcome
8:30 – 9:30 – Mobile BI App – Principal
9:30 – 9:45 – Break
9:45 – 10:45 – Data Lake – Sogeti
10:45 – 11:00 – Break
11:00 – Noon – BI self-service & lessons learned – Nationwide
Noon – 1:00 Lunch/networking

PRESENTATION LINKS:
DAMA Day 2017 – Data Lakes

DAMA Day 2017 Mobile BI App

DAMA Day 2017 Self Service Analytics

LOCATION DETAILS:
Drake University Aliber Hall, Room 101
2903 University Ave
Des Moines, IA 50311

Hosted By: Drake University

http://www.drake.edu/

Predictive Text Modeling using R: A Case Study

To help DAMA better serve you please consider taking this quick survey —Link to Survey

DESCRIPTION:
In this session we will discuss Wellmark’s experience of implementing and using open-source software to enable modeling of unstructured text. This tool led to a recent analytical project that optimized and automated part of a previously inefficient customer service process. Attendees will learn more about obtaining open-source tools in a highly conservative and secure technology environment, as well as applications of text analytics.

MEETING TIMELINE:
Registration: 8:30-9:00
Presentation: 9:00-11:00
Networking: 11:00-11:30

PRESENTER:
Tammy Armstrong
Tammy Armstrong is a lover of data and problem solving working in speech and text analytics at Wellmark. Tammy enjoys data science-oriented programming in SAS, Python, R, and anything else that gets the job done. She holds an MS in analytics from North Carolina State University and a BA in economics from Gettysburg College.

Mary Fagan
Mary Fagan is a technical leader of business intelligence and analytical software at Wellmark. Provide technical SME knowledge of tools and integration within enterprise environment supporting Business Analytic teams. 20 years’ experience in business intelligence, reporting and software engineering with a passion for data.

LOCATION DETAILS:
Wellmark Blue Cross Blue Shield
1331 Grand Ave
Des Moines, IA 50309

Parking:
•Enter the Wellmark ramp parking facility on 11th street.
•Stop at the gate and push the intercom button. Provide your name and event (DAMA) information to the security officer who will confirm your appointment and open the gate.
•Proceed to the third floor to the reserved guest parking. If all parking spots are full, please park in the next available spot that is convenient for you. Handicap parking is available on all floors.
•Follow the signs to the level three skybridge security entrance or take the elevators to level three. A security officer at the skybridge security desk will greet you, ask for identification to verify your name on the guest badge, and direct you to the main lobby desk where your Wellmark host will greet you.

Hosted by:

www.wellmark.com

PRESENTATION DOC LINKS:
20170418 DAMA Text Analytics Presentation

Data Security in the Digital Age

PRESENTATION LINK:
Data Security in the Digital Age

DESCRIPTION:
Hackers are focused on stealing data now that they have found ways to monetize it. Recent attacks have shown they are creating targeted attacks against organizations and their employees including spear phishing and ransomware. This presentation will look these new threats and how they work. We will discuss a couple of examples of targeted threats. We will also discuss methods (both technical and employee training) to mitigate data loss under this new threat environment.

PRESENTER:
Doug JacobsonDoug Jacobson
Doug Jacobson is a Professor in the Department of Electrical and Computer Engineering at Iowa State University and currently holds the rank of University Professor. Dr. Jacobson joined the faculty in 1985. Dr. Jacobson’s current funded research is targeted at developing robust countermeasures for network-based security exploits and large scale attack simulation environments. He is director of the Internet-Scale Event and Attack Generation Environment (ISEAGE) test bed project. Dr. Jacobson has given over 150 presentations in the area of computer security and has testified in front of the U.S. Senate committee of the Judiciary on security issues associated with peer-to-peer networking. He has published numerous papers on computer security education and the use of hands-on laboratories to teach computer security, as well as written a textbook on network security. He also created a computer security outreach program targeted at the general public, post-secondary students and faculty. He co-authored a book on security literacy for the non-technical audience and also lectures on this topic. His team has developed a cyber security literacy curriculum for grades k-12.

LOCATION DETAILS:
Nationwide Insurance
W266, 2nd Floor Conference Room
100 Locust St
Des Moines, IA 50309

Please bring a form of ID as it will be necessary to check in at the security desk.

Parking:
Please use the parking garage directly behind Nationwide (address is 1100 Walnut St). There are entrances to the parking garage from Walnut St, 12th St, and Mulberry St. After you park, take the elevators down to 3rd floor for the skywalk, and enter Nationwide from the east side of the garage. Bring your parking ticket to get validated by the security guard. All non-Nationwide associates must sign-in with the security guard to gain access.

Hosted By: Nationwide Insurance
nationwide

http://www.nationwide.com

Managing Data Quality Issues in an Agile Environment

DESCRIPTION:
This session will show how to integrate Manage Data Quality Issues into an Agile Environment. We will review identification, prioritization, process and governance aligning to business critical objectives.
The process will show continued progress, improvement, and evolution. It provides a way for the data quality issue backlog intake to come from multiple avenues for a full company perspective to prioritize based on business objectives. The multiple avenues consist of data profiling discovery, business rule verification, implementation team findings, business needs, reporting pre-analysis conclusions and fraud detection requirements.
A Data Quality Issues Practice will streamline, provide consistency and improve quality through collaboration between business and information technology teams. Quality items are quickly captured, refined and worked through to be classified and prioritized.
The agile life cycle provides a way to tightly integrate into day-to-day processes making quality visible within every aspect of the business. Data Quality is given a focus to keep company data assets in the highest quality so decisions are made based on accurate, complete data.

The session outline consists of:
• Objective – Definition and Problem
• Background – Disciplines
• Processes
• Governance Prioritization
• Tools and Standards
• Communications
• Continuous Improvement and Maturity
• Summary

PRESENTER:
Kim OlsonKim Olson

Kim Olson’s enterprise architecture experience spans the full spectrum from Enterprise Information Management, Business and Data Architecture, Data Design, Governance, Business Intelligence, Data Warehousing, Master Data Management, Data Security, Reference Data Management, Data Quality and Metadata Management.
She has created, managed and maintained several data governance programs in various business groups. Some of the programs include: Data Quality, Reference Data Management, Business Data Governance, Clinical Definition Alignment, Integrated Data Warehouse Program Governance, Enterprise Architecture Program, Cross Functional Reporting Practice, Enterprise Service Bus Standards, Enterprise Information Delivery Environment and Data Architecture Practices.
She has a Master of Science in Software Engineering and Bachelor of Science in Accounting. Prior Data Management Professional (CDMP) Certification, Project Management Professional (PMP) Certification and Certified in the Governance of Enterprise IT (CGEIT).

LOCATION DETAILS:
Farm Bureau Financial Services
5400 Univeristy Ave
West Des Moines, IA 50265
Directions to West Des Moines IA Corporate Headquarters

PRESENTATION DOC LINKS:
With presenter’s approval, presentation content will be added soon after the event has been held.

The Data Governance Journey at Principal (Presented By Andrea Jackson & Sarah Playle – Hosted/Sponsored by Wellmark)

MEETING TIMELINE:
Registration: 8:30-9:00
Presentation: 9:00-11:00
Networking: 11:00-11:30

LOCATION DETAILS:
Wellmark Blue Cross and Blue Shield
1331 Grand Ave
Des Moines, IA 50309

REGISTRATION:
Register now by clicking here!

PARKING DETAILS:
View specific parking details here!

PRESENTATION LINK:
09.20.2016 Data Governance in Principal Presentation

HOSTED AND SPONSORED BY:
Wellmark Blue Cross and Blue Shield
www.wellmark.com

DESCRIPTION:
Sarah Playle, Assistant Director of Data Quality & Governance for Principal Global Investors and Andrea Jackson, Sr. IT Business Analyst in Principal Corporate Systems Support will provide insights on how they created business cases for Data Governance programs in two business areas at Principal.  They will review practical implementation approaches applied at Principal and lessons learned along the way.

PRESENTERS:
Andrea Jackson, CBAP®
Principal Financial Group

Andrea is a Senior IT Business Analyst  in Corporate Systems Support at the Principal Financial Group.   She joined the Principal in 2000 and is currently in a Program BA role.  Andrea has over 15 years of experience in business analysis planning and monitoring, elicitation and collaboration, requirements lifecycle management, business analysis and design, strategic thinking, process improvement and change management using SAFe, Agile and Waterfall project methodologies.  In 2015, Andrea took on responsibility of developing a framework for and implementing an enterprise proof of concept for governance of analytic data.  The established framework provides vision and strategic direction for data governance, guidance for day to day management of enterprise analytic data, and education for defined roles.  She has a bachelor’s degree in accounting from the University of Northern Iowa and co-chaired the Content Team for the 2016 Iowa Business Analyst Development Day.

Sarah L Playle – Assistant Director Data Quality & Governance 
Principal Global Investors

In 2014, Sarah took on the responsibility of establishing a Data Governance Program for PGI which includes ongoing alignment with PGI IT and ongoing education of how the Data Governance program helps facilitate a data-driven culture across the firm.   PGI’s Data Governance program provides guiding principles, policies, roles, metrics and oversight for PGI Data Domains. Sarah joined the firm in 2000. Prior to her current role, Sarah spent 13 years in investment operations with leadership roles in portfolio accounting, valuation, security data, trade settlement and mandate compliance. She received a bachelor’s degree in accounting from Simpson College and served in various leadership roles on the LOMA Investment Operations Committee.

DAMA Day 2016 Event

PRESENTATION MATERIALS:
2016 DAMA Day MicroStrategy Best Practices for Designing Dashboards presentation
2016 DAMA Day-InformationBuilders Data Quality presentation

LOCATION DETAILS:
Drake University
Aliber Hall, Room 101
2903 University Ave
Des Moines, IA 50311

MEETING REGISTRATION:
Click here to register for the event.

QUICK PAY METHOD FOR DAMA-IA MEMBERS ($30):

QUICK PAY METHOD FOR VISITORS / NON-DAMA-IA MEMBERS ($50):

MEETING AGENDA:
Click here to view the agenda.

PARKING DETAILS:
View the parking map.

DESCRIPTION:
Are you trying to help your organization become more data-driven? Do you want to learn more about data topics? Would connecting with other data professionals be beneficial to you? DAMA Day 2016 will deliver an exciting set of topics to inform, educate and connect central Iowa data professionals via educational presentations, case studies, and panel discussions. Topics include Hadoop, Data Quality, Data Professional Intern Panel, Data Globlization/Unicode, and more.

COST:
DAMA Iowa members: $30
Non-DAMA Iowa members: $50

HOSTED BY:
Drake Logo
www.Drake.edu

SPONSORED BY:

www.hortonworks.com


http://www.ibm.com/us-en/


www.informationbuilders.com/


http://www.microstrategy.com/us