Denver SQL User Group July 20, 2017 Meeting

New Location Change!

Meeting Denver SQL User Group
Thursday, July 20, 2017 5:30pm – 8:30pm
Aurora Mental Health Center
791 Chambers Road,
Aurora CO 80011
https://goo.gl/maps/ZiTWLTvjzRD2

Auditorium in the Basement. Please enter by the Front Door.

Meeting Agenda
5:30 – 6:00 Food / Socializing
6:00 – 6:15 User Group Business
6:15 – 6:30 Open panel/Questions & Answers
6:30 – 7:00 Warmup presentation
7:00 – 8:30 Main presentation

30-minute Speaker
Bio:
Holly Adams (MS) is an Informatics Specialists (Business Intelligence) at Tri-County Health Department in Greenwood Village, Colorado. Health Departments generally don’t have much technical support. Her current mission is to share her knowledge with non-technical people in Public Health.

Abstract: Strategic Planning and Designing in Report Builder
If you know the basics of Report Builder 3.0’s tools and features, you may be ready to start building more comprehensive reports. In this session, Holly Adams, Environmental Health Informatics Specialist at Tri-County Health Department in Colorado, will walk you through the strategic questions and planning items you should consider when building a new report. Holly will also cover specific changes you can make to reports to make them more user-friendly and actionable.

60-Minute Speaker
Bio:
David Siska-Salkin is a Senior Consultant with RevGen Partners providing Business Intelligence and analytics design and development services. David has an MBA in Computer Information Services and has been developing BI solutions for 6 years. Working in a variety of industries he focuses on data warehouse design, custom ETL, and enterprise reporting solutions. In his free time David likes to garden, game, hike, and modify his truck for off-roading adventures.

Abstract: SSIS Historical Attribute Design Patterns
One of the key aspects of a good data warehouse solution is maintaining details for historic reporting. We will cover the basics of what a Type 2 dimension is and then delve into efficient SSIS design patterns to load and maintain attributes. This will include looking at hashing and the benefits of using the new Temporal Tables available starting in SQL Server 2016.