Power BI Blog Posts for Microsoft Dynamics 365 and Dynamics CRM | Magnetism Solutions | NZ (Auckland, Wellington, Christchurch and Dunedin)

Anomaly/Outlier Detection using Excel and SQL Server Analysis Services

Ahmed Anwar, 16 December 2015

In this article, I’m going to talk about how to use the SQL Server Data Mining Excel Add-in to detect odd patterns in records or datasets. Anomaly detection (or outlier detection) is the process of identifying unexpected patterns in a dataset. Typically anomalous problems appear in Banks, errors in
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power Map Report Part 3

Colin Maitland, 19 July 2015

In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the second layer of a Power Map report in Microsoft Excel to display Account Reven
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power Map Report Part 2

Colin Maitland, 17 July 2015

In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the first layer of a Power Map report in Microsoft Excel to display Account Number
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power Map Report Part 1

Colin Maitland, 17 July 2015

In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data retrieved from a Microsoft Dynamics CRM Online Organisation using a Power Query query. In this blog I will demonstrate how to create a Power Map report and configure the first layer to
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power View Report Part 3

Colin Maitland, 14 July 2015

This is the third blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The report is based on an ODataFeed related query created using Power Que
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power View Report Part 2

Colin Maitland, 13 July 2015

This is the second blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The completed report will look similar that shown below. In my prev
Read the full article here
Power BI Microsoft Dynamics CRM Online – Power View Report Part 1

Colin Maitland, 11 June 2015

In this blog and the next two blogs I will demonstrate how to create a simple Power View report in Microsoft Excel that displays information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. This report uses a Power Query named AccountOpportunitiesSet previou
Read the full article here
Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 3

Colin Maitland, 03 June 2015

In my previous blog I demonstrated how to convert a Column Chart that displays the Sum of Estimated Value by Account into a Pie Chart. In this blog I will demonstrate how to update the Column Chart to display both the Sum of Estimated Value and the Sum of Actual Value. I will also demonstrate how to
Read the full article here
Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 2

Colin Maitland, 29 May 2015

In my previous blog I demonstrated how to create a simple Clustered Column Chart in Microsoft Excel that displays the Sum of Estimated Revenue by Account using data queried from a Microsoft Dynamics CRM Online Organisation. In this blog I will demonstrate how to convert this chart into a 3D
Read the full article here
Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 1

Colin Maitland, 26 May 2015

In this blog I will demonstrate how to create a simple Clustered Column Chart in Microsoft Excel to display Microsoft Dynamics CRM Online Sum of Estimated Value for Opportunities by Account. The chart is based on the AccountOpportunitySet query built using Power Query as demonstrated in the previous
Read the full article here
Power BI Microsoft Dynamics CRM Online – Part 18

Colin Maitland, 23 April 2015

In this series of blogs I have described how to create and configure a set of Microsoft Dynamics CRM Online Organisation Accounts, Contact and Opportunity oDataSet queries using Power Query in Microsoft Excel. The following list provides a quick-reference to the previous blogs in this series:
Read the full article here
Power BI Microsoft Dynamics CRM 2013 – Part 16

Colin Maitland, 10 December 2014

In my previous blogs in this series I have demonstrated how to connect Microsoft Excel 2013 Professional Plus to a Microsoft Dynamics CRM Online Organisation, download Account, Contact and Opportunity ODataSets and update those ODataSets using Power Query so that they are ready to be used for develo
Read the full article here
Export Test Cases from Excel to TFS

Manjula Chetty, 02 December 2014

There are many testers who prefer to write test cases in excel as it is easier and one can view all the test cases in one single page and then copy it across to TFS. Copying test cases from Excel to TFS one by one is a very time consuming task. The alternative to that would be using Test case Migrat
Read the full article here
Power BI Microsoft Dynamics CRM 2013 – Part 14

Colin Maitland, 27 November 2014

In this blog on this series on using the Power BI tools in Microsoft Excel to analyse and report on information retrieved from a Microsoft Dynamics CRM Online Organisation I will demonstrate how to transform Date/Time columns in the ODataSets. In my previous blog I demonstrated how to transform the
Read the full article here
Power BI Microsoft Dynamics CRM 2013 – Part 12

Colin Maitland, 12 November 2014

This blog is Part 12, in a series on creating reports using PowerBI tools such as PowerPivot, Power View and Power Map in Microsoft Excel for a Microsoft Dynamics CRM Online Organisation. In this blog and the next I will demonstrate how to transform the Option Set column Values into their correspo
Read the full article here

Filter by Category