Mainly looking for a plan of attack to learning BI while I'm currently unemployed.
Yes, I know, took me a long time but had a lot of life snags along the way.... I currently have completed all the 4 courses for the MCDBA (SQL 2000 implementation and maintenance. still trying to pass 70-293 - windows 2003 infrastructure) and I
have work experience supporting applications with SQL backends, however, I have no work experience as a production DBA and no experience creating front ends other than forms in Access. As I have learned more throughout the years on my own, I have discovered
that my dream job would be a BI analyst or developer.
My training and experience is with basic sql admin/maint and sql queries for SQL 2000 and SQL 2005. I realize the following are most of what I need to learn to get closer to being able to get a job using MS BI technologies:
SSAS
SSIS
SSRS
SQL 2008 (admin? implementation?)
Visual Studio
.NET (which language is best?)
What's the best order in which to take any training/courses so I can learn them? Does the above order work? Are there other suggestions? The only programming background I have are the college, class and online courses for Visual Basic 5, Power C, Pascal,
VBA from over 10 years ago... So, I understand programming code enough to learn it quickly again. Just not sure what kind of prerequisites each of the above might require of each other and if I'm missing something I should add to the list.
Thank you for your input. I'll worry about cert tests later. Right now, I just want to learn the technology and get familiar with it doing my own projects, etc. I have a test system setup currently with Windows and SQL 2008 and step by step books from
o'reilly for SSAS, SSIS, and SSRS, so I can get started on those right away.
Maybe someone already in BI can describe the order in which they learned the different technologies or the order in which they wish they would have learned things. Thanks!
Dana Schwehr MCP, A+
