Colorado Springs SQL Server Users Group

We invite you to join us for our July meeting on Wednesday, July 19th at the Hyatt Place - 503 W. Garden of the Gods Rd! This month we're pleased to feature our main presentation with Meagan Longoria who will be talking about Improving Data Warehouse ETL/SSIS Delivery by Automating Design Patterns.

When: 5:30 PM to 8:00 PM

Where: Hyatt Place - 503 W. Garden of the Gods Rd
What: We'll begin with networking and a delicious dinner featuring Sliced Grilled Chicken Breast served on Pretzel Rolls from 5:30 to 6:00 PM. At 6:00, we'll have a few announcements and peer Q&A time followed by our 101 and main presentations. After the presentations, we'll move to the hotel lounge for socializing and additional networking time. The CSSUG provides two drink tickets - relax with a coffee, soda, or beer (or two) while you network.

Our Main Presentation:

Meagan Longoria, Blue-Granite

Improve SSIS Delivery By Automating Design Patterns

What if I told you that 90% of your data integration development in SQL Server could be automated? In 5 years, you will be “old fashioned” if you are hand coding SSIS packages. Developers with different skill levels and design preferences create databases and SSIS packages however they see fit to get the job done. Documentation is frequently omitted. Maintenance and small enhancements consume too much development time while manual errors and inconsistencies slip through the testing and release process. You can use tools and frameworks to rearrange the development process and alleviate these common problems. The implementation and automation of design patterns leads to improved efficiency and communication. Join me in this session to learn how to use Business Intelligence Markup Language (Biml) and Excel to facilitate metadata-driven SSIS development. I’ll use database schema information plus Excel inputs to implement a small data mart from staging through the dimensional model.

About Meagan:

Meagan Longoria is a business intelligence consultant with BlueGranite who lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use Biml, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings as well as through her blog (DataSavvy.me).

Our 101 Presentation:

Writing SQL Server Reports Using Tableau

Gilbert Mfitundinda, Compassion International

About Gilbert:

Gilbert Mfitundinda works with Compassion’s IT department as a Database Administrator. He had earlier served as a Ministry Sponsorship Coordinator for Christ’s Hope International Uganda, an organization that provides holistic care for families affected by HIV/AIDS. He also serves as the Project Manager and Social Marketing Strategist for Maelearn, an online platform that preserves and shares academic material for free, making education resources globally accessible. Additionally, Gilbert is the Founder of Love Restoration, a community-based organization that provides love, care, and hope to the less-privileged.

As always, you can check out

SpringsSQL.org (https://protect-us.mimecast.com/s/4Q5wBmiGOznId)

any time for more information about upcoming meetings and other events.