November’s presentation will include an Introduction to Data Warehousing with SQL Server presented by John Sterrett, a Database Administrator and Web Engineering Specialist for Orrick, Herrington & Sutcliffe LLP. If you are interested in learning how Analysis Services, Integration Services and Reporting Services can provide Business Intelligence this meeting is for you. We will start with the basic concepts of data warehousing including key terms and definitions. Next, we will cover some sample business cases while we walk through the process of designing a data warehouse. Once this session is complete you will be able to develop your first cube.

The only thing that I had to do differently was the impersonation information on slide 8. Use credentials of current user didn’t work for me. I got a security error on slide 30 (Process the Cube) with this setting. Explicitly adding a username and password worked fine though.