March '15 Baton Rouge SQL Server User Group Meeting

posted Mar 4, 2015, 11:14 AM by BRSSUG SQLPass BatonRouge

Date: Wednesday, March11, 2015

Location: The Louisiana Technology Park -

Sponsored By: Envoc

5:45 - 6:15 pm: Networking and Dinner with the other user groups
6:15 - 6:30 pm: Announcements and Sponsor Message
6:30 - 7:00 pm: User Group business
7:00 - 8:00 pm: Main Topic Speaker
8:00 - 8:30 pm: Raffle and Giveaways

Main Topic
Getting Started With Tabular Analysis Services
Main Topic Speaker: Thomas LeBlanc

Main Topic Summary: This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.

Main Topic Bio
Thomas LeBlanc is a Data Warehouse Architect in Baton Rouge, and uses his 25 years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL systems and end-to-end dimensional data marts using SSIS, SSAS, 3rd party apps, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is currently the Excel BI VC chair and past chair of Data Arch VC and VC Mentor. Thomas has spoken at the PASS Summit for the last 4 years(2011-2014). Local work includes the Baton Rouge SQL Server User Group and assisting with four SQLSaturdays. Bing TheSmilingDBA for more information about Thomas