Atlanta Business Intelligence Group

Next Meeting

Monday,

June

30

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

Back to Top