Power-Bi

Su GitHub si trova un interessantissimo plugin per SSIS che permette di avere come destinazione un dataset di PowerBI. Inutile dire come questa possibilità possa aprire innumerevoli soluzioni, anche per la creazione di Dashboard aggiornabili in real-time in modo veramente molto molto semplice.

Il codice è qui:

https://github.com/nicksav/SSISAdapterForPowerBI

e l’articolo che ne descrive l’idea di fondo è qui:

E’ stata rilasciata una nuova versione del Power BI Desktop, l’editor offline per Power BI. Le novità più importanti sono

• Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file
• HDInsight Spark connector
• Azure SQL Data Warehouse connector
• Support for Custom MDX/DAX queries when importing data from SSAS
• Navigator dialog improvements:
  • Resizable Navigator dialog
  • Ability to multi-select items in Navigator (CTRL+Click, SHIFT+Click, etc.).
• Query Editor improvements:
  • Query Group creation/deletion improvements (multi-select, etc.)
  • Ability to Split Query (i.e. refactor common base steps into a new query)
  • Query Icons to reflect type of query in Queries navigator pane
• Data Modeling improvements:
  • Resizing of columns in Data View
  • Moving Measures from one table to another
• Live Analysis Services Connections: Ability to change the database from Edit Queries dialog.

Qui il dettaglio ed il link per il download.

Datazen è stata recentemente acquisita da Microsoft e grazie a questo nuovo assetto societario, il loro prodotto di punta per creazione di Dashboard per tutte le piattaforme mobile e desktop è disponibile gratuitamente come parte della licenza enterprise con software assurance. Il prodotto è fantastico, se siete coperti dalla licenza, andante senza indugio a scaricarlo!

Sul canale SQLPASS TV di YouTube, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Developing and Managing a Business Intelligence Semantic Model tenuta da Cathy Dumas (Program Manager @ Microsoft).

Abstract

Use the new features in SQL Server code name “Denali” to develop and manage a BI Semantic Model in Analysis Services. We will discuss the new capabilities in creating your BI Semantic Models, using PowerPivot as a starting point, and how to troubleshoot your models.

Sul canale SQLPASS TV di YouTube, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione End-to-End SQL Server PowerPivot tenuta Peter Myers (Mentor @ SolidQ).

Abstract

One of the pillars of SQL Server 2008 R2 is Managed Self-Service BI. The SQL Server PowerPivot for Excel add-in is a key offering in this pillar, and delivers an entirely new analytic experience to Excel 2010. The add-in allows analysts to load and prepare large volumes of data from various sources to create a multidimensional model. The model can be enriched with sophisticated calculations. Then the model can then be used as the source for PivotTable and PivotChart reports. And yet that’s not the end of the story. With the SQL Server PowerPivot for SharePoint add-in, the Excel workbooks that host the PowerPivot model can be catalogued in SharePoint and exposed as a data source for other Excel and Reporting Services reports. These SharePoint hosted models can then be managed by IT with scheduled data refreshes from the originating data stores.

Microsoft ha messo a disposizione qui:

http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx

o qui

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

numerosi eBook gratuiti, ed una buona parte di essi e’ dedicata a SQL Server:

• Books Online: Backup and Restore of SQL Server Databases
• Books Online: Data Analysis Expressions (DAX) Reference
• Books Online: Master Data Services
• Books Online: Multidimensional Expressions (MDX) Reference
• Books Online: Transact-SQL Data Manipulation Language (DML) Reference
• Introducing Microsoft SQL Server 2008 R2
• Introducing Microsoft SQL Server 2012
• Master Data Services Capacity Guidelines
• Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
• Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
• QuickStart: Learn DAX Basics in 30 Minutes
• SQL Server 2012 Tutorials: Analysis Services - Data Mining
• SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling
• SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling
• SQL Server 2012 Tutorials: Reporting Services
• SQL Server 2012 Upgrade Technical Guide