March 28, 2007 at 5:46 pm
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?
March 29, 2007 at 6:00 am
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]
March 29, 2007 at 12:23 pm
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