With January’s Power BI update, two items that I was looking forward to have been released. The first one was the public preview of email
My first experience working with OneNote was about 5 years ago at a large corporation. This company fell under Sarbanes-Oxley rules, and as such everything was in the public domain: meeting notes, invites, emails, everything. It was used by everybody and everybody felt it was a chore to use.
To implement my Service Broker ETL API, I started with the basic code/framework provided by Eitan Blumin in this blog post:http://www.madeiradata.com/service-broker-asynchronous-triggers/. He provides a good basic framework for the setup of Service Broker and an explanation of the installation scripts. To learn more on the basic framework and scripts to implement Service Broker please refer to his post.
In my last blog post we talked about Power BI Designer Preview and why I was lovin’ it. In this post I’m going to use Microsoft’s most recently Power BI tool to connect to my SQL server instance to analysis my Google Analytics data, Marketing data and CRM opportunities.
Connect to your SQL Data
Let’s get started by selecting the Get Data button in the top left corner and then select SQL Server
The Power BI preview released by Microsoft in Convergence provided a great tool to quickly make sense of large amounts of data. Power BI does all the heavy lifting and provides a quick and easy way to interact with the data. As promised by Microsoft with the release of Dynamics CRM Online 2015 Update 1 CRM is now available within PowerBI alongside SalesForce & Google Analytics to gather data and provide data analysis. As of publishing this article the Power BI Dynamics CRM connector will only work with Dynamics CRM Online, it will not work with an on premise CRM installation, hopefully the on premise connectivity is not too far.
This year Convergence was held in Atlanta. While this conference is a huge Dynamics Users conference, they highlight applications that are not necessarily part of the Dynamic stack. One of the most captivating sessions I attended focused on Power BI, Microsoft’s excel based Business Intelligence tool.
Microsoft has a great new offering, Power BI Designer Preview, as part of the Power BI platform. It is a standalone Windows Desktop application that can be downloaded from the Power BI site. It is an optional Power BI content authoring option for users that are unable to upgrade to the latest version of Excel. The application combines Power Query, Power Pivot Data Model and Power View into a seamless experience that will allow users to build their Power BI dashboards and reports.
We have put a lot of hard work into this blog series with building a patron analysis so now it’s time to share the wealth of our analysis insights with the rest of the company. Power BI’s web site and mobile approach with the deployment of Office 365 and refreshable data through a Data Management Gateway, is the perfect solution. The Data Management Gateway has come a long way since the first version and with version 1.2 it now supports many data source types from Power Query connections.