Power BI – New Features and Need for Big Data Functionality
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
February 8, 2017
Tag: power
Power BI Visuals in SSRS 2016 Web Site
Yesterday, January 17, 2017, Microsoft released the Power BI reports in SQL Server Reporting Services (SSRS) technical preview. I downloaded the technical preview and installed it
January 18, 2017
Conditional Formatting in Excel
This is another addition to my continuing series on Excel and the Project Manager. This time I want to demonstrate some advanced functionality using conditional
December 13, 2016
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.
May 9, 2016
Real Time Data Warehouse ETL
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.
January 4, 2016
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
May 28, 2015
Power BI & Dynamics CRM Online 2015
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.
May 26, 2015
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.
April 16, 2015
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.
April 16, 2015
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.
October 24, 2014
