Dynamics CRM 2013 and Power BI for Office 365 - Part 1 05 February 2014 Jurgen-Postelmans In this blog post we will have a look at how you can use Power Query to create a Power Pivot data model in Excel and publish it to a Power BI site in Office 365. Once the Excel file with the Power Pivot data model is in Power BI for Office 365 we can query it with Power Q&A. If you have... [More]
Power BI Training: Business Intelligence with Excel 29 January 2014 Nico-Jacobs Business Intelligence, Excel Power BI allows business users to solve certain business intelligence problems without the need of IT specialists. Since 2010 Power Pivot allows Excel users to create their own data models and do advanced analytics on this. Excel 2013 out of the box contains Power View as well, allowing people to cr... [More]
The whole world in a SQL Server database 29 January 2013 Nico-Jacobs SQL Server, Integration Services Some people have the whole world in their hand, but last weekend I tried something slightly less ambitious: Getting (part of) the whole world in a SQL Server database. Loads of spatial data from OpenStreetMap I’m always looking for interesting datasets. I was still lacking a large dataset with spa... [More]
Validation sets in SQL Server Data Mining 22 January 2013 Nico-Jacobs Analysis Services, SQL Server BI, Data Mining What are validation sets? Data Mining Data mining analyses historical data to find patterns that might help us better understand how our business works, or might help predict how the business might evolve in the future: Instead of doing ‘traditional BI’, where we pick some attributes and ask for a... [More]
Metro Style Applications and MVVM 06 October 2011 Lander-Verhack Metro Style When working with windows 8 on a tablet, you quickly notice the different ways a user can interact with your application. Your application can control the full screen, both in landscape or portrait, or can share the screen with an other application. Basically, there are four modes your application w... [More]
Using reporting services with Oracle package / stored procedure 16 December 2010 Nico-Jacobs SQL Server BI, Reporting Services Reporting services can create data sets on top of Oracle stored procedures. Sure, the manual says so, but this afternoon, I tried to get things up and running, and I want to share some of the dead ends and problems I experienced in that, maybe it can help you avoid these obstacles. Don’t panic, not ... [More]
Scripting in integration services data flow 24 November 2010 Nico-Jacobs If you wander how we can program our own conditional splits in SSIS data flow, or implement our own asynchronous transformations, or implement things such as a Year-To-Date, then you forgot to attend my session at the SQL Server Day. Luckily you can catch up with the slides and code samples on my we... [More]
Analysis Services documenter 13 March 2010 Nico-Jacobs Good news for those of you who are using our Analysis Services documenter tool: we just added a new feature. If you generate HTML documentation from a cube, then in the ‘full documentation mode’, the MDX script of your cube will be scripted as well into a bulleted list (one calculated member, named ... [More]
BCS presentation at Techdays Belgium 28 February 2010 Lieven-Iliano Last thursday I did a presentation at the Belgium Techdays in Antwerp. My session focussed on the Business Connectivity Service in SharePoint 2010. With the Business Connectivity Service you can integrate external data in the SharePoint and Office user experience. With the new powerfull .NET Assembl... [More]
5 things SQL Server does different from what many developers expect 06 February 2010 Nico-Jacobs That’s what I will talk about tomorrow at Techdays Belgium. I notice in my courses that many developers are sometimes still surprised with the way SQL Server responds to transactions, or try-catch blocks, or the way it handles stored procedures, indexes and statistics. So if you’re at Techdays, come... [More]