www.sqlpass.org    Professional Association for SQL Server
 Upcoming Meetings

Next Meeting




Microsoft BI for Financial Reporting

  • In-Person @ 115 Perimeter Center Place Atlanta, Georgia, United States (map)
  • 18:30 - 20:30 Eastern Daylight Time
  • Language: English

TEK Systems

Kate Kitzel: kkitzel@teksystems.com, T 770.522.1172 | M 678.480.7155

Featured Presentation:

Microsoft BI for Financial Reporting

Justin Stephens

Using a Finance data mart in SQL Server 2012, I will demo how to use SSAS 2012 and Excel 2013 for Financial Reporting. This will include the basic DW model for Financial Reporting, how to configure the key dimensions in SSAS, how to setup WriteBack functionality in the Finance Cube with Security, and how to use Excel for the Reporting and WriteBack execution to update Budgets within the Cube.

About Justin:
I began working with SQL Server 2000 (DW, DTS, and SSAS) in the fall of 2000 for a small software company in Texas. Early on, I became the SME for MDX Reporting using ASP and later ASP.NET. I was given a few projects using DTS/SSIS that expanded the reporting capabilities. In 2005, I spread my wings and began a long exodus from Texas that led me to Atlanta. Over the last 13 years, I have worked for/with some notable companies (Wal-Mart, McKesson, Dell, AMD, BCD Travel, Barclay's) in various industries (Retail, Wholesale Distribution, Finance, Travel, and Education). During this time, I achieved my MCITP in Business Intelligence using the 2008 R2 BI Stack. I am a die-hard proponent of the MSBI stack.

 Past Meetings

Meeting Archive

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.