Use PowerShell and CSOM to batch create SharePoint Online Site Collections with a custom template 31 January 2016 Tommy-Vanhee CSOM, PowerShell, SharePoint Online Introduction In this post I will show you how to create multiple Site Collections in SharePoi [More]
Recap of Microsoft Ignite 2015 event 19 June 2015 Lieven-Iliano At last month's conferences, Build 2015 in San Francisco and Ignite in Chicago, Microsoft has shown [More]
Reporting with Dynamics CRM 2015 and the new Power BI Designer 07 May 2015 Jurgen-Postelmans This article will show how you can use the new Power BI Designer to create Power View reports on top [More]
An Office 365 App for Site Collection Provisioning in SharePoint Online 20 February 2015 Robrecht-Van-Caenegem Office 365, SharePoint Online Continuing on my previous post, I decided to create a new Office 365 app that would be able to manage site collections in SharePoint Online. When deciding to build an app that does site collection provisioning, you could chose to do this as a SharePoint App, but SharePoint Apps are typically contex... [More]
Consuming SharePoint CSOM from an Office 365 app 18 February 2015 Robrecht-Van-Caenegem Office 365, SharePoint I’ve been a C# developer for more than five years now. When SharePoint 2013 was released, I started doing development for SharePoint 2013 and later also SharePoint Online. My focus was on developing web services (in combination with the SharePoint App model), native client and mobile applications us... [More]
Weird localization problem in DAX editor 17 September 2014 Nico-Jacobs Business Intelligence, Excel, Power BI, SQL Server BI One of my students (thanks, Stefan!) discovered during the PowerBI course a bizarre localization issue in the DAX editor of Excel and SQL Server Data Tools, which is easy to replicate: Install Office 2013 or SQL Server data tools on a machine with a locale which uses a comma as decimal separator (I... [More]
Excel Power Query supports Multi-value Lookup columns in SharePoint lists 15 September 2014 Nico-Jacobs Business Intelligence, Excel, Power BI Power Query is a handy tool to load all sorts of data in Excel or PowerBI. One of the supported data types is SharePoint lists. But Power Query does more than the straight-forward loading of data in a single list. If a SharePoint list contains a lookup column referring to another list, Power Query w... [More]
Loading data in Azure Machine Learning 24 July 2014 Nico-Jacobs Azure, Business Intelligence, Data Mining, AzureML In July 2014 Microsoft made their cloud-based data mining environment (known as Azure Machine Learning, or AzureML) available to the public. With this platform users can analyze large amounts of data without the need to install and configure special software: A browser and a credit card is all you n... [More]
First Steps in Azure Machine Learning 15 July 2014 Nico-Jacobs Azure, Data Mining, SQL Server BI Today Microsoft announces the availability of machine learning (data mining) in Azure. As you can assume, you need an Azure account to get started with this, but there are free trial accounts… you can try before you buy. To get started with the machine learning preview go to http://manage.windowsaz... [More]
Building custom reports for SQL Server management 26 June 2014 Nico-Jacobs Business Intelligence, SQL Server, Reporting Services, Talks Recently I presented a session at the ITPROceed conference on ‘Administration intelligence’: using Business Intelligence solutions for analyzing log files, generate documentation, do disk quota estimations and other typical administration tasks. You can find the full presentation at SlideShare. In ... [More]