I decided to do a course. Basically, I decided that rather than fumble through books and notes and help files, I’d actually go and learn a whole stack of new skills and upgrade some old ones. Courses are great, because you can learn an awful lot in a very short period of time, and if you choose the right one, you can learn best practice and learn it from the best.
As my strongest skill is actually in SQL Server, I decided to seek out something that would extend that. I decided that because database, and data concepts are used extensively in BI, it would be the logical choice.
For someone with as many years experience as I have, it is often difficult to find courses of a suitably advanced level, that will also help you hit the ground running in whatever the chosen skill is.
Well, I found the course of choice at Greg Low’s new company SolidQ. The course is Peter Myers BI Bootcamp. See http://learning.solidq.com/oz/CourseDetail.aspx?CourseScheduleId=7. Peter Myers is one of the top BI experts, if not the top BI expert in Australia. He wrote the course!
Anyway, I’ve now completed Day 1, now into Day 2. It’s actually been quite mind broadening. Basically, I had no idea exactly how extensive the need for Sql Server Integration Services (SSIS) is in Business Intelligence. To become an expert in BI, you will need to spend a lot of time taking the data from your data source, massaging it, and placing it in Fact and Dimension tables in your Data Warehouse database. And SSIS is just so rich! There are so many controls in the toolbox that can be added to the design area that it’s simply brilliant.