Studying and Learning Business Intelligence

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to the level of a senior consultant. It seems they work in an environment that corners them into doing things a certain way and not giving the opportunity to grow pass their defined role. So I put together a list of study items to help people ramp up in BI skills.

Here are some suggested books:

BI:

http://www.amazon.com/Knights-Microsoft-Business-Intelligence-24-Hour/dp/0470889632/ref=sr_1_1?s=books&ie=UTF8&qid=1349185599&sr=1-1&keywords=business+intelligence+24+hours

SSIS:

http://www.amazon.com/Knights-Microsoft-Integration-Services-24-Hour/dp/1118479580/ref=sr_1_8?ie=UTF8&qid=1349185567&sr=8-8&keywords=ssis+2012

http://www.amazon.com/Professional-Microsoft-Server-Integration-Services/dp/111810112X/ref=sr_1_1?ie=UTF8&qid=1349122074&sr=8-1&keywords=ssis+2012

SSRS:

http://www.amazon.com/Professional-Microsoft-Server-Reporting-Services/dp/1118101111/ref=sr_1_1?ie=UTF8&qid=1349122094&sr=8-1&keywords=ssrs+professional

SSAS:

http://www.amazon.com/Expert-Development-Microsoft-Analysis-Services/dp/1847197221/ref=sr_1_3?s=books&ie=UTF8&qid=1349122111&sr=1-3&keywords=ssas+professional

For Data modeling:

http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1349122258&sr=8-1&keywords=data+warehouse+toolkit

You may also want to consider getting certified in business intelligence

http://www.bidn.com/blogs/MikeDavis/ssis/369/microsoft-business-intelligence-certification-70-448-ssis-ssas-ssrs

http://www.bidn.com/blogs/MikeDavis/ssis/881/microsoft-business-intelligence-certification-pro-test-70-452

I would also suggest you get involved with the SQL community by attending and speaking at your local user groups and SQL Saturdays, and start blogging to get your name out there.

http://www.sqlpass.org/

I would also suggest following these blogs and reading them weekly to keep up with the newest information.

SSIS:

http://sqlblog.com/blogs/jamie_thomson/

http://blogs.msdn.com/b/mattm/

SSAS:

http://cwebbbi.wordpress.com/

http://sqlblog.com/blogs/alberto_ferrari/

SSRS:

http://blogs.msdn.com/b/robertbruckner/

http://blogs.msdn.com/b/sqlrsteamblog/

http://blogs.msdn.com/b/bobmeyers/

Attend the free webinars available at :

http://pragmaticworks.com/LearningCenter.aspx

If you are a senior BI developer and you have other suggestions please leave a comment to help out those still growing.

Good luck in your studies.

Brad Ball Published a blog on how to ramp up in the DBA world her http://www.sqlballs.com/2012/10/dba-study-guide.html

About these ads
This entry was posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training and tagged , , . Bookmark the permalink.

2 Responses to Studying and Learning Business Intelligence

  1. Pingback: Adventures in Interviewing | MikeDavisSQL

  2. Rodrigo Braga Brison says:

    very useful recommendations.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s