SQL Server Data Tools – Business Intelligence (SSDT BI) for SQL Server 2014 CTP1

In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL Server 2014 CTP1 no new version of SSDT BI been released, however you can use the existing version of SSDT BI to create and deploy projects for SQL Server 2014 CTP1. The Visual Studio 2012 version of SSDT… Read more

Power View connectivity for Multidimensional Models released

On November 29, 2012 we released the “Power View for Multidimensional Models — Preview.”  We are excited to announce SQL Server 2012 Service Pack 1 Cumulative Update 4, released today, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update… Read more

Released: Kerberos Configuration Manager for SQL Server

Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046. This diagnostic tool can help to troubleshoot Kerberos-related configuration issues with SQL Server, which is very exciting for us because Kerberos authentication plays a critical role in many BI-related authentication… Read more

Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel

Accounting and Finance Professionals have a new learning resource. The Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel article, Excel workbook samples, and sample Access database provide scenario based data modeling and analysis help for self-service BI with PowerPivot and Power View. The scenario describes how Finance professionals at Contoso Ltd…. Read more

Released: Twitter Analytics for Excel 2013

Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in Excel 2013! For all… Read more

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online

Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or… Read more