Baton Rouge SQL Server User Group

Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge, LA. The topic will be Attributes and Hierarchies in Analysis Services 2012. The flow will be from requirements gathering thru implementation in the Semantic Model.

My employer, Turner Industries, LLC, will be sponsoring the evening which includes the .Net User and Windows Phone groups in Baton Rouge. We all meet on the same night and have networking/dinner together with a lightening round for all groups. Please come join us at Louisiana Technology Park on Florida Blvd. The park is an business incubator for technology companies in Baton Rouge and Louisiana.

March '13 SQL Server User Group Meeting

Topic: Attributes and Hierarchies in Analysis Services 2012

Date: Wednesday, March 13, 2013

Location: The Louisiana Technology Park

Sponsored By: TBA

Agenda:

5:45 - 6:15 pm: Networking and Refreshments

6:15 - 6:30 pm: Lightning Round Topic

6:30 - 8:00 pm: Main Topic

8:00 - until: Open Forum for questions and giveaways

Main Topic: Attributes and Hierarchies in Analysis Services 2012

Main Topic Speaker: Thomas LeBlanc, Turner Industries

Summary: The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.

Summary: Thomas LeBlanc (MCITP DBA/BI) is a Sr. SQL Server DBA @ Turner Industries & the PASS Data Architecture Virtual Chapter Chair. His specialties include normalization, performance tuning, database design, ETL-SSIS, SSAS cubes and T-SQL code. DBA work includes monitoring many SQL Server instances at Turner for performance and uptime then spends the other half of his time gathering requirements, designing, coding and presenting Data Marts using SSIS, SSAS Cubes, Excel & PerformancePoint while migrating some cubes to 2012 Tabular Model for PowerView.