Cleansing data in Data Explorer

Posted on 14 June 2013 by Koos van Strien

In the previous blogposts, I’ve provided an introduction to Data Explorer, as well as an introduction into the Data Explorer language. In this blogpost, we’ll put this knowledge to use by re-structuring less-structured data from a website. Our goal is Continue reading →

Data Explorer: Introduction to Data Explorer Language

Posted on 12 June 2013 by Koos van Strien

In my previous blogpost I wrote about how to load data from a less-structured data source into Excel, in order to further integrate and analyze the data with tools like PowerPivot and Excel’s Quick Analysis. The example was about displaying all gas Continue reading →

Data Explorer: Loading less-structured data inside Excel

Posted on 5 June 2013 by Koos van Strien

About Data Explorer The free Excel-plugin Data Explorer has been around for a few months now. For those who don’t know about Data Explorer yet: Data Explorer can be described as a self-service ETL-tool: it extracts data from all kinds of sources, Continue reading →

Excel 2010 / PowerPivot en local cube files

Posted on 16 February 2012 by Hans Geurtsen

Eén van de mogelijkheden die SQL Server Analysis Services al heel lang biedt, is het naar je desktop halen van gegevens uit een kubus. Je krijgt dan een zogenaamde local cube file, een bestand met de extensie .cub die je Continue reading →

VLOOKUP (VERT.ZOEKEN) in Excel sometimes returns wrong value (off by one row)

Posted on 7 July 2011 by Richard Zaat

Ever had that the Excel formula VLOOKUP start coming up with the wrong answer? Trouble is that most times it has the correct answer, but sometimes it doesn’t. I found the answer on the internet, see below: —————————————————————————————————- Sounds like Continue reading →