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]
Identities in the Cloud @ ITPROceed 24 June 2014 Els-Putzeys A few days ago, I presented a session on Identities in the Cloud at ITPROceed. I talked about the options in Windows Azure Active Directory to create and manage users: Microsoft Online IDs, Directory Synchronization and Federation.For those of you that are interested in the presentation, you can dow... [More]
SQL Server 2014 In-memory OLTP (a.k.a Hekaton) @ Techorama 10 June 2014 Nico-Jacobs SQL Server, Talks A few days ago I presented a session on the In-Memory OLTP engine in SQL Server 2014 at Techorama, the Belgian developer conference. I talked about the good things In-Memory OLTP does, and the limitations it has. If you want to go through the slides and code examples again, feel free to download the... [More]
Presenting @ the Belgian SharePoint Saturday and Techorama 09 June 2014 Lieven-Iliano SharePoint This month I had the privelege to present a session at the Belgian SharePoint Saturday and the Techorama conference. As promised you can download both slidedecks at the links below:SharePoint Saturday: The SharePoint 2013 Design Manager: From HTML to SharePoint (2,2MB)Techorama Building a ... [More]
Loading GPX waypoints with Excel PowerQuery 02 June 2014 Nico-Jacobs Business Intelligence, Office, Power BI Plotting data on maps is becoming popular: We can use the geometry and geography data type in SQL Server, use the Reporting Services maps, Excel PowerView allows mapping coordinates on a map, and the recently released PowerMap plug-in in Excel offers beautiful visualizations of map data. But how ... [More]
AngularJS: Async Callbacks and the Angular Execution Context 20 March 2014 Lander-Verhack I was playing around with a Angular and Google Maps, and suddenly the world fell apart. Ok, maybe I'm a bit dramatic here, but angular behaved quite a bit different than I expected. This is a simplified version of the code that cracked the foundations of my beloved planet:$scope.geoCode = function (... [More]
Challenges in combining multiple data sets in PowerBI 20 March 2014 Nico-Jacobs Business Intelligence, Power BI, Office Relationship between house price and income A few days ago the media reported that Belgium was amongst one of the most expensive European countries to buy a house, if you compare the house price relative to the income. A few days ago I wrote a blog post on how we could analyze the Belgian house mar... [More]
Analyze the Belgian house market… yourself 07 March 2014 Nico-Jacobs Office, Power BI, Business Intelligence From time to time articles get published about the evolution of the Belgian house market. Interesting to learn about general trends but… sometimes you whished these analyses would be more tailored to your situation. It’s nice to know that prices for villas have stabilized last year, but does this tr... [More]
Dynamics CRM 2013 and Power BI for Office 365 - Part 2 05 February 2014 Jurgen-Postelmans In the first part of this blog post we used Power Query to create the following Data Model in Excel. As you can see the relationship between the 2 tables is still missing and we would also like to define a Hierarchy in QueryFromContact. And although we could have done this in Power Query itself we w... [More]