Colorado Springs SQL Server Users Group

Are you going?

8 people going


Epicentral Coworking

415 N Tejon St · Colorado Springs, CO

How to find us

Between Boulder and St. Vrain on Tejon

Location image of event venue


We invite you to join us for our August meeting on Wednesday, August 21st sponsored by Sensible Data Integrations at Epicentral Coworking, featuring presentations by Scot Reagin speaking on Azure Analysis Services and Mark Tillman on Untangling the UNPIVOT.

When: 5:30 PM to 8:00 PM

Where: Epicentral Coworking, 415 N Tejon, Colorado Springs, CO
What: We'll begin with networking and dinner from 5:30 to 6:00 PM. At 6:00, we'll have a few announcements, a word from our sponsor and peer Q&A time followed by our presentations. After the presentations and some SWAG, we'll have some time for socializing and additional networking. The CSSUG will provide some drinks while you network.

Our main presentation:
Topic: Azure Analysis Services – Multidimensional solutions in the cloud by Scot Reagin

Virtually all of today’s data solutions are hybrid solutions – partially in the cloud, partially on premises – as organizations attempt to fulfill an ‘all in the cloud’ mandate. The reality is that cloud platforms like Azure do many things very well, but not all things, and functional gaps remain which complicate and sometimes prevent a full migration away from on premises environments.

Azure Analysis Services (AAS) is a good example of this reality – it works very well for many applications but is limited to Tabular Models and cost can explode if those models are not created thoughtfully. And, what is the path to Azure for my multidimensional cubes? Do I care about Azure Analysis Services if I use Power BI? As always the answer to these questions is a clear and absolute ‘it depends’.

In this session we’ll explore Azure Analysis Services functionality, fit in various solutions, and gaps and techniques that are important to consider when implementing AAS.

About Scot
Scot Reagin, Solution Architect, Sensible Data Integrations Inc,

TDWI Certified Business Intelligence Professional
Certified Data Vault Data Modeler

More than thirty years of technology experience serving in a wide variety of roles including: Software Designer, Solution Architect, and Operations and General Manager. Experience designing and implementing complete analytic solutions for organizations of many sizes and in diverse industries.

Business intelligence specific experience encompasses all aspects of Enterprise Information solutions including: Information Quality, Enterprise Data Warehousing, Business Analysis Data Marts, and comprehensive visualization applications.

Our 101 presentation:
Untangling the UNPIVOT, Mark Tillman

CASE Statements are fine for pivoting data, but not ideal. Learn a new way with PIVOT and UNPIVOT: they break some T-SQL rules, and that makes them more fun to work with.

About Mark
Mark A. Tillman is a Business Intelligence Developer for a large law firm and has been an officer for SQL Server Users' Groups for over 4 years, and currently the Treasurer for the Colorado Springs SSUG. Mark has extensive experience with creating stored procedures and using SSRS for reporting, plus experience with writing MDX and creating reports with SSAS cubes.

Our sponsor, Sensible Data Integrations, provides:
SDI INTEGRATION HUB™ -- Looking for a way to access and use data from both legacy and brand new systems? Save time and ensure consistency across multiple systems with an automated platform.

SALESFORCE INTEGRATION -- Ensure your data is in place and be ready to integrate across environments. We can help.

BUSINESS INTELLIGENCE -- Fix broken reporting systems or develop entirely new capabilities. We’ll help you find solutions to everything from reporting and ad hoc analytics to dashboards, scorecards, and data marts.

DATA ANALYSIS & PERFORMANCE TUNING -- Improve your database efficiency and reliability. We analyze your systems and recommend tailored optimizations and updated best practices