New Power BI Solution Templates Provide End to End Data Marts

Microsoft has announced today that they are going to provide a series of “Solution Templates” as part of the Power BI service.  The first solution templates are based on Dynamics CRM and Salesforce and feature an end to end solution for extracting data out of the underlying data source, transforming it into a reporting database and then using Power BI to visualize the data.

A Power BI solution template includes three components:

  1. The ability to get data out of the source application with an initial full load and subsequent incremental loads (ie, just new and changed records) to get data into a datamart or data warehouse,
  2. A pre-configured database and Power BI model with extensible schema and calculations for measures and KPIs pertaining to the domain, and
  3. Quick start tools like a default set of Power BI reports that work out of the box and can be extended.

Solution Templates leverage either SQL Server on premise or Azure SQL in Azure to provide the operational data store.