Ever tried to connect two data sets where the identifier is not precisely the same for the two tables? If this strikes a familiar chord with you, you have probably tried to perform fuzzy matching, whereby modellers seek to link two similar data entries, e.g....

Since its launch last October, Microsoft has sold more than 100 million licenses for Windows 8, despite its perceived slow adoption by industry analysts.

Windows 8 was aimed at increasing Microsoft’s penetration into the fast-growing mobile segment by radically...

Like Power Pivot and Power Maps (previously a project called “GeoFlow”), Microsoft Power Query is another Excel add-in that enhances the self-service Business Intelligence experience in Excel by enabling customers to easily search / access data, either internal or...

After instigating one of the most radical shake-ups of its Windows operating system in recent years, Microsoft has confirmed the much-loved Start button is to returning to the desktop mode’s taskbar for June’s Windows 8.1 ‘preview’ update.

Some commentators appear...

At the risk of alienating international readers and appearing a little insular, please excuse us for reporting on a local (Australian) highlight, albeit released to little fanfare.

What seems like 35 years after it was released to the rest of the world,...

April saw Microsoft announce the availability of the project currently code named “GeoFlow” Preview for Excel 2013 (a catchy title I thought), an add-in for Excel that allows users to view information over the twin parameters of space and time.

Essentially, chart...