Ever have that feeling of doom?

  • I have been working on SS2k for about two years now. I take on the role of App. developer, SQL developer and DBA for a number of ancillary systems. With the purchase of SS2k5 my boss has decided it is a great time to try out DW/BI using SSIS, SSAS, and SSRS.

    My new assignment (not to interfere with anything I am currently working on) is to develop a system to integrate our change management system (AS400), incident management system (SQL Server), project management system (Oracle), and HR system (AS400). This system should allow reporting for project, people, objects, teams, departments, etc. Lets assume I have never done something like this before (I have written 2 DTS packages). Where do I start? I have scoured the internet and SQL Server Central, and I am having trouble grasping some of the basic design considerations.

    Where is a great place to start?

    - Table design

    - ETL

    - reporting

    - data cleanliness

    help?

  • Jason,

    I agree there are lot's of sources and sometimes it's hard to choose. If you've never done anything like this I would start with the Tutorials from BOL in SQL 2005.

    Another real good source is "Project Real" from Microsoft, which gives you lot's best practices. See here: http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

     

    Markus

     

    [font="Verdana"]Markus Bohse[/font]

  • Thanks for the link.

    One of the big problems I am running into is how to represent an org chart in a system like this. Is there a best practice for representing an org chart?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply