Wednesday, December 11, 2013

SQL Server Data Tools 2012 Downloads

Download SSDT for Visual Studio 2012 and SSDT-BI for Visual Studio 2012
http://msdn.microsoft.com/en-us/data/hh297027

You only get the SQL Server Database Project when you install SSDT for Visual Studio 2012.  Install SSDT-BI for Visual Studio 2012 to get the Analysis Services, Integration Services and Reporting Services project types.

Download Team Explorer for Visual Studio 2012
http://www.microsoft.com/en-us/download/details.aspx?id=30656

Sunday, November 10, 2013

PerformancePoint designer 2013 SSRS report issue caused by Aug 2013 CU

http://support.microsoft.com/kb/2881349

This bug prevents adding an SSRS report to a PPS dashboard after installing the August 2013 SharePoint CU.  The workaround is to only develop the cascading PerformancePoint filters in PerformancePoint Designer and the rest of the solution should get pieced together inside a SharePoint page using the Web Part connections features.

Reference: http://sqlmag.com/blog/building-real-world-microsoft-bi-dashboards-today

Friday, October 4, 2013

Developing and Managing a BI Semantic Model in Microsoft SQL Server 2012 Analysis Services

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI305

PowerPivot Blog

http://powerpivotblog.com/

Building the Perfect BI Semantic Tabular Models for Power View

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI303

DAX in the BI Tabular Model Whitepaper and Samples

http://www.microsoft.com/en-us/download/details.aspx?id=28572

PowerView Demos

http://blogs.msdn.com/b/oneclickbi/archive/2011/12/27/more-demos-of-power-view-available.aspx

SSRS Team Blog

http://blogs.msdn.com/b/sqlrsteamblog/

Learn DAX Basics in 30 Minutes

http://social.technet.microsoft.com/wiki/contents/articles/7040.quickstart-learn-dax-basics-in-30-minutes.aspx

PowerView Overview

http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx

Building Stylish Power View Reports

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI302

Friday, September 6, 2013

Power Query Reference

http://office.microsoft.com/en-us/excel-help/microsoft-power-query-for-excel-help-HA104003813.aspx

Sunday, August 25, 2013

Create Power View Reports in SharePoint 2013

http://www.mssqltips.com/sqlservertip/3005/teach-business-users-how-to-create-power-view-reports-with-sql-server-data-sources/

Extract from Excel using ODBC

https://www.simple-talk.com/sql/database-administration/getting-data-between-excel-and-sql-server-using-odbc--/

Sunday, August 18, 2013

Using Parameters in Power Query Extracts

http://www.sqlservercentral.com/blogs/dknight/2013/08/07/using-parameters-in-power-query-extracts/