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
Wednesday, December 11, 2013
Wednesday, November 20, 2013
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
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
Thursday, October 10, 2013
How to Test SSRS MDX Queries in SQL Server Management Studio
Monday, October 7, 2013
Sunday, October 6, 2013
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
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
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
Friday, September 6, 2013
Power Query Reference
http://office.microsoft.com/en-us/excel-help/microsoft-power-query-for-excel-help-HA104003813.aspx
Friday, August 30, 2013
Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1)
http://technet.microsoft.com/en-us/library/jj218795.aspx
Announcing Power BI for Office 365
http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.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/
Subscribe to:
Comments (Atom)