Data Warehousing on Azure and on SQL Server 2016

Data Warehousing on Azure and on SQL Server 2016

This blog post is intended for readers who already have some experience on building Data Warehouses with earlier versions of SQL Server (2008 or 2012) and are looking for updating their knowledge on how to do it today on SQL Server 2016 and/or on Azure. In addition, I included some insight on the technology trends on the matter.

"Cloud Wars" aren't over yet

"Cloud Wars" aren't over yet

Couple days ago The Economist published an article titled "Linux and AWS: Cloud chronicles". The article stressed the undeniable importance of Linux  and Amazon Web Services (AWS) in the upsurge of cloud computing and went on to explain how network effects have helped both grow in popularity. Despite similar paths, article predicted that their future will diverge and Linux will "happily plod along" whereas "AWS could end up dominating the IT industry just as IBM’s System/360, a family of mainframe computers, did until the 1980s".

What Gartner's Magic Quadrant for Advanced Analytics doesn't tell you

What Gartner's Magic Quadrant for Advanced Analytics doesn't tell you

tl;dr: Gartner's Magic Quadrant for advanced analytics doesn't do a good job in helping to decide which analytics tool(s) to acquire. It also misses the point that open source projects are the real leaders in advanced analytics. Vendors that position themselves to complement open source projects rather than competing against them will be ones to watch.

Microsoft Power BI – A new stone in the game

Microsoft Power BI – A new stone in the game

In BIGDATAPUMP, we have had two main BI visualization tool families in most active use in our customer projects: Qlik products and Tableau. However, also Microsoft’s Power BI started to look really promising, and in February it ranked really well in Gartner’s Magic Quadrant for Business Intelligence and Analytics Platforms.

Econometric tools and business analytics - Part 1: Introduction

Econometric tools and business analytics - Part 1: Introduction

Many people have a biased view of what econometrics really is and how it can be applied to business problems. In the following posts I will introduce some methods from applied econometrics, structural modelling and panel data/time series tools and show how they can be used to solve problems where standard statistical and machine learning tools do not work.