July 13th, 2011 
I will be presenting at the next Atlanta Microsoft BI user group. Monday, July 25th, 2011. http://atlantabi.sqlpass.org/ Topic: SSIS Logging and Auditing Framework Level: Beginer / Intermediate Meeting Place Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA 30346 Overview: Proper logging in your SSIS packages can help save hours in [...]
Posts Tagged ‘Business Intelligence’
Step By Step PowerPivot using Excel Data
This post is a step by step beginner’s guide to PowerPivot. I will show the basics of creating a PowerPivot workbook using Excel data. PowerPivot has dramatically improved the way in which we can analyze our data in Excel. Using PowerPivot in an Excel PivotChart provides the added benefit of Slicers. Slicers are a cool new [...]
Posted in PowerPivot 
Tags: Business Intelligence, Excel, Excel 2010, Microsoft, Office 2010, Power Pivot, PowerPivot, Slicer 
No Comments »Reporting Services – Dynamic SQL
I am working on creating some auditing reports on our current SSIS framework. I would like to create a Reporting Services report that I can have a standard looking report and change the query based on the Package Name. To do this I created a table that contains the Package name and the validation query. [...]
Posted in SQLServerPedia Syndication, SSRS Tags: Business Intelligence, SQLServerPedia Syndication, SSRS Comments OffAtlanta Microsoft BI Users Group
The Atlanta Microsoft Business Intelligence Users Group is having it’s 1st meeting tonight. The group is a chapter of PASS and is focused on Microsoft BI. The kickoff meeting will be “Self-service BI with PowerPivot” by Teo Lachev Monday, Aug 23 6:30PM Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA [...]
Posted in Atlanta, Business Intelligence Tags: Atlanta, Business Intelligence, Microsoft, PASS, Power Pivot Comments Off