Here is the PowerPoint presentation: DBA: Transitioning to a BI Role
I had some excellent questions at the end of the session, and here is more follow-up to my answers:
- Any recommended books? This is a must read: The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset by Ralph Kimball. This is the bible for building BI projects. Your first step should be to read this book. I can’t believe I forgot to mention it!
- Do Microsoft certifications help? They are a great way to learn about BI and may help to make you stand out when looking for a BI opportunity. More info here and here
- How much knowledge of business processes is beneficial to being effective with BI? I have never had any business management courses. I have learned those things on the various project I have been on. If you can learn about accounting either on the job or off hours, that would help as many BI projects deal with financial data and understanding that would be a plus. However, many times I have jumped into a new project not knowing anything about the business (i.e. Oil and Gas, Stock exchange, Healthcare) and learned as I went. Most projects will not expect you to know the business – they just want you to know BI and will let you learn the business part. If you are a quick learner, you will be fine. And the best way to become a quick learner is to be constantly learning!
DBA: Transitioning to a BI Role
Business Intelligence is an extremely hot career. If you are a DBA, how can you transition to a BI role? James Serra will describe what exactly BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. Then James will delve into the steps to take to become a BI expert and how he made the transition.