Business Intelligence SIG

PASS Data Warehousing and

Business Intelligence Virtual Chapter

Web: http://Bi.sqlpass.org | Twitter: @PASSBIVC | Email: amylewisAZ@gmail.com

Virtual Chapter Sponsored by:

January 2012 Upcoming Sessions

Thur Jan 26th 12pm Eastern (US) *Rescheduled from 1/12

Security Tips and tricks for Analysis Servers 2008 R2

Speaker: Chris Webb

URL: https://www.livemeeting.com/cc/usergroups/join?id=P2PMP7&role=attend&pw=x%22RB%29MG%3F8

This session will look beyond the basics of security in Analysis Services 2008 R2, covering more advanced topics such as dynamic security and security on parent/child hierarchies and providing tips and tricks that even experienced SSAS developers may not know about.

Chris Webb is the owner of Crossjoin Consulting, a UK-based consultancy, and specialises in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of two books: “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”. He blogs regularly on Microsoft BI at http://cwebbbi.wordpress.com/

Tues Jan 31st 12pm Eastern (US)

Building Visually Compelling BI Experiences with SQL Server 2008 R2 PowerPivot

Speaker: Peter Myers

URL: https://www.livemeeting.com/cc/usergroups/join?id=WMT7KF&role=attend&pw=GZ%26%22%5E%3ER8d

SQL Server 2008 R2 PowerPivot allows analysts to use Excel 2010 to load and prepare large volumes of data from various data sources to create a data model. The data model can then be enriched with calculations to become a data source for Excel PivotTable, PivotChart and CUBE function reports. And as compelling as these BI experiences can be that’s not the end of the story. A PowerPivot workbook deployed to SharePoint Server 2010 can be used to create even more compelling BI experiences using Reporting Services and PerformancePoint Services. In this presentation learn about the fundamentals of PowerPivot data model creation, and the exciting ways PowerPivot data models can be used to visualize and share data.

Peter Myers has been working with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office. Specifically, he works with SQL Server Integration Services, SQL Server Analysis Services (cubes and data mining), SQL Server Reporting Services, Microsoft Excel, PowerPivot and PerformancePoint Services. He has a broad business background supported by a Bachelor’s degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2007. Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events and conferences.

Door Prize! Attend this session for a chance to win an Amazon $25 gift card, thanks to our Virtual Chapter Sponsor SolidQ!