I am a Junior Data Analyst , and use primarily Excel 2010 . I would like to begin using BI Tools that came with MS SQL and have some questions about the training . I already use MySQL so I am already familiar with using SQL .
1) . Does it matter which Service I learn first Integration Service , Reporting Services or Analysis Service ? Or is there no prerequisite order in which to train ? ( I suspect it may depend on what tools you need but would like to be certain) .
2) Which would be better to learn first , T-SQL or Python for scripting in BI ?
3) I am deciding if I should use a MS SQL Hosting Service as opposed to adding a Virtual Drive to my Windows 7 machine and loading Application . If I do take this route , what should I look for in a Hosting Service ? Such as minimum memory , disk space , bandwidth , cost per month , and generally any real world pros and cons to be aware of .
Thanks for any info .