Tag: power

OneNote – Microsoft’s Much Ignored Power Add-In

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.

 

Read More »

Using Power BI to combine Financial and Social Data for More Powerful Analytics

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

Read More »

Combining Social and Financial Data for Powerful Analytics

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.

Read More »

Lovin’ it….. Power BI Designer Preview

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. 

Read More »

Part 5 of 5: Power BI, Sharing the Wealth

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.

Read More »