How to Get Business Intelligence Project Templates in VS 2012, 2013 and 2015

Yes. I agree. It’s a bit confusing.

I downloaded the SSDT Tools installer for Visual Studio 2013 and, of course, I assumed it’s for SQL Server 2012 but it was for the SQL Serve 2014. I just banged my head against the wall. Ouch! It hurts…

So, what does it mean? Can I do a BI project using VS 2013 and SQL Server 2012 or SQL Server 2008/R2?

Yes. We can do. Let me explain it.

If you install SSDT BI Tools for Visual Studio 2012, it means the Microsoft, by default assumes you’re going to work with the SQL Server 2012 version. You will get all BI project templates in the Visual Studio 2012. So, here it’s smooth. No confusion, no problem at all.

If you install SSDT BI Tools for Visual Studio 2013, the Microsoft assumes you’re going to work with the SQL Server 2014 version. The VS 2013 has been designed keeping SQL Server 2014 in mind. I got confused while installing SSDT BI tools as I had VS 2013 and SQL Server 2012 setup on my machine and SSDT installer showed me it’s installing for the SQL Server 2014. I was in a fix to continue or not, but then I decided to go on.

Read more…

Software Engineering Training at L&T Technology Services, Mysuru, 14 – 15 September, 2015

Just finished Software Engineering training at L&T Technology Services, Mysuru…It was really awesome experience teaching this subject…


Software Fundamentals, OOPs and OOAD Using UML Training at L&T Technology Services, Mysuru, 07 – 11 September, 2015

Though, little bigger batch, enjoyed a lot! Just finished Software Fundamentals, OOPs, and OOAD using UML at L&T Technology Services, Mysuru. I love L&T trainings here as this is really awesome training venue and hospitality and, of course lovely weather…Morning is so cool here…Wish to come back here again…


Visual C# Training at Siemens, Electronic City, Bangalore, 1 – 3 September, 2015

Finished Visual C# training at Siemens Technologies and Services, Electronic City, Bangalore with 25 participants. It was really nice experience sharing my knowledge on C# with experienced professionals. Happy to know everyone was satisfied…:)


.NET Training at Accenture, Bangalore, Aug 3 – Aug 26, 2015

Just finished .NET GreenField training at Accenture, Bengaluru yesterday. Enjoyed a lot. Enthusiastic participants…:)


.NET Training at Accenture, Bangalore, July 6 – July 29, 2015

Just finished .NET GF training at Accenture, Bengaluru…Glad to know that 80% participants passed online and practical test. Enjoyed at the location as it was nearby my home i.e. Bang-8 this time…Thanks to the Accenture for the opportunity.


SQL Server 2012 SSIS and SSAS Training at Wipro Technologies, Kochi, 29 June – 03 July, 2015

Just finished 5 days SQL Server 2012 Integration Services and Analysis Services at Wipro Technologies, Kochi. Enjoyed teaching Microsoft BI tools, especially Analysis Services.

Working with Dimensions, Hierarchies, Partitions, Aggregations, etc. is really challenging.

Thanks to all participants at Wipro for inviting me. Trust we’ll be meeting in future as well…




Get every new post delivered to your Inbox.

Join 148 other followers