Pittsburgh SQL User Group: Data Warehousing Presentation

Today, I am giving my first presentation at my local SQL Server User Group.  Below are links to the slides.  I will also add some more resource here after todays presentation.

Introduction to Data Warehousing slides

DEMO: Build Your First Cube

Below is the description of the discussion.

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.

Date: Monday, November 16, 2009

Time: 11:45 a.m. Registration; 12:00 PM – 2:00 p.m.

Venue: Council Training Room, 2000 Technology Drive, Pittsburgh, PA 15219

Cost: No charge

RSVP: Email Heather Jones at Heather_Jones@Dell.com

If you have any questions, need more information, or would be willing to participate in any upcoming presentations or discussions, please Heather Jones at Heather_Jones@Dell.com.

  • Luke

    Great demo! Very useful.

    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.

  • Nice work, I am sure this will be useful to me as we are talking about doing some data warehousing. Thanks for your hard work.


    what should be the dimensions and facts for CRM ??

  • Anne-sophie BaDa

    Hi ! I want to do the demo but I can’t find files with the database names Adventure Work DW. Can you help me please.

  • Yes, you can find all the AdventureWorks databases here.