Office
Power BI learning resources – follow up 3
Another great resource for learning about Power BI is the course on EDX: Analyzing and Visualizing Data with Power BI. Granted, has been around for a while, but I forgot blogging about it; maybe it is a…
First Look: Azure Data Catalog
The First Look series focusses on new products, recent announcements, previews or things I have not had the time to provide a first look at and serves as introduction to the subject. First look posts are fairly…
Comparing Datazen, SSRS and Power View
It is a difficult task, but it can be done… comparing Datazen, SSRS and Power View. See http://www.sqlchick.com/entries/2015/6/20/comparison-of-datazen-vs-ssrs-reporting-services-vs-power-view for a in-depth comparison!
Power BI Pro Tip: Pareto analysis with DAX / Power Pivot
Today’s post is a guest post by Michiel Rozema (https://www.linkedin.com/in/michielrozema). Thanks Michiel! Dutch Data Dude Jeroen approached me with the question whether it would be possible to create a Pareto chart from a Power Pivot model, using…
Power BI Pro Tip: making date / time calculations work (Time Intelligence)
Ever so often I get asked how to do a year-over-year, quarter-over-quarter, month-over-month or year-vs-year calculation in Power BI. In most cases people would like to create a KPI to measure a certain periods performance compared to…
Loading multiple JSON files using Power Query
I had to figure out recently how to load multiple JSON files using Power Query. It turned out to be less easy than expected, so I figured it is worth blogging about… The scenario: I have multiple…
Walkthrough: how to connect to Dynamics CRM Online with Power BI
In this walkthrough I will step through the process of connecting to a Dynamics CRM Online instance with Power BI (specifically Power Query). For this you will need to latest version of Power Query installed. After you…
New Power Query update
Recently a Power Query update was released (see http://blogs.office.com/2015/03/05/3-updates-excel-power-query/). Mayor updates: performance on load, Dynamics CRM Online connector and new transformations, most notably advanced date/time calculations. Personally I enjoy the CRM Online connector, but I am most fond of…
Power BI trial for non-US customers
We are currently running a preview in the US of the new Power BI experience. This experience is not available yet to customers outside of the US. If you are outside of the US and want to…
Master Data Services 2014 Add-in for Excel published
Just a bit over a week ago a new version of the Master Data Services Add-in for Excel was released. It is the 2014 release, which will also work for SQL Server 2012. Main benefit is up to 4x…