6:00 – 6:30 Pizza and Networking Sponsored by TEKsystems.

6:30 – 6:40 Announcements

6:40 – 6:50 Paul S. Waters: Upcoming Local and PASS SQL Events

6:50 – 8:15 Scott Currie: Using Excel and PowerPivot to Create Reports and Gain Insight form Your Data

8:15 – 8:30 Closing remarks and give-a-ways. 

Using Excel and PowerPivot to Create Reports and Gain Insight from Your Data

In this informal talk, we will spend most of the time in Microsoft Excel and the new PowerPivot add-in for Excel 2010.  In Excel we will cover getting data from SQL Server and SSAS for use with Pivot Tables to create Excel Reports. For PowerPivot, we'll first talk about what it adds to Excel and the concept of in-memory cubes. Then, using PowerPivot to get data from a variety of data sources, create data relationships, and build reports with PowerPivot will be demonstrated. Expect an informal atmosphere with lots of Q&A.
 
Biography
Scott Currie is the founder and CEO of Varigence, Inc., which offers a comprehensive collection of tools and frameworks for the Microsoft Business Intelligence Platform.  By leveraging the latest technologies from application development and programming language compilers, Varigence revolutionizes the way enterprises build, manage, and use Business Intelligence across their entire organizations.
 
Prior to founding Varigence, Scott worked for 7 years at the Microsoft Corporation.  Scott was the Program Manager for managed interoperability in the Visual C++ Compiler and the 64-bit Just In Time (JIT) compiler for the .NET Framework.  He also lead several important customer connection initiatives for the Developer Division at Microsoft including product feedback, product preview (CTP) and early adopter (TAP) programs, online crash analysis, and customer satisfaction measurements.  Scott later created and served as the Product Unit Manager for the Detego team at Microsoft, which was responsible for leveraging agile application development methodologies in the development of Business Intelligence solutions.
 
Scott graduated from the University of Pennsylvania with undergraduate majors in economics, mathematics, and computer science and a master's degree in computer science.