A few days ago I posted a link to one BIML introduction webcast. Now I now it will be a series of webcasts this week, it’s a great oportunity to learn more about it! Stay tuned and subscribe to the remaining days of the BIML ACADEMY. Recordings on previous days will be available too.
While we are on BI topic, you can get yourself started on the Stairway to Integration Services articles teaching how to use SSIS. These series of articles are a great idea from the guys at SQL Server Central. SSIS (Integration Services) is a great tool to Extract, Transform, and Load (ETL) data and can be used on various kind of projects and reports.
A final note on the topic is that this tool allows you to expand its capability. BIDS Helper is a great set of add-ins that really expand the SQL Data Tools and makes your life easier. Codeplex.com has some really nice projects shared and is worth a look.
Bonus content: as we are talking about additional stuff for SQL 2012, you might want to take a look at Microsoft® SQL Server® 2012 SP1 Feature Pack (no links for SP2 and SP3, sue MS). Also the SQL Data Tools itself should be installable over this direct download for 2012 (no need to get a full SQL Server ISO). For newer versions check this page (match it to your Visual Studio version just for safety). You can try to apply SQL Server® 2012 Service Pack 3 (SP3) to it, but I’m not sure if it will work. Of course, install your SQL Server Management Studio of choice first (I recomend that you stick to the version your servers currently run at work. At home use the newer to learn it. Previous versions are available here or at the SQL2012 SP3 page). You might have a bit of trouble with 32bit vs 64 bit SSIS issues, but it should be easy to overcome.
PS: sorry for so much links in just one post. Microsoft really makes a confusion with their development tools, but it seems they are trying to consolidate that.
PS2: you might experience some compatibility warnings after installing the Data Tools for VS2012. Please update this KB2781514: (source). Also please install in this order: SSMS, Data Tools, full VS suite (if you are a developer).