Saturday, June 07, 2008

Development or Business Intelligence

Thinking about the need for Business intelligence, and how close this field has been brought to the developer, it pushed me to dig into it a little, and now, I find myself working with SSIS and SSAS quite a bit, which gave me more flexibility in my conception, and avoid complicating life through coding windows services when SSIS would do a great job;

Also, finally I understand the difference between analytical and transactional databases; Business intelligence principles are important for to understand for many devleopers working in small to medium sized projects, in order to avoid pitfalls such as :

- trying to create dashboards with long running complex queries;

- using C# and windows services, when Sql Server Integration Services could do the job.

- understand where reporting on a transactional database should stop, and switch to an OLAP database

This and a lot more I'm still finding out. Of course, once on a large project, everyone has a specialty, yet, for the last four years, I've been working on small to medium size project (3 roles at ones often), which lead me to work with web development, business intelligence and sql server 2005 administration all at once.

I'll be posting tips on Business Intelligence, that hopefully would be helpful!

here are some useful links for Business Intelligence Videos :

http://www.trainingspot.com

I personnaly have purchased the videos from trainingspot, and they have been very helpful in understanding the concepts, really great!

http://www.learnintegrationservices.com

plannning to check out this integration services videos. not too expensive :)

Regards !