Part 3: Data Storage Recommendations

Part 3: Data Storage Recommendations

Size Of Data Warehouse The storage design (hardware & data modelling) vary based on the size of the data warehouse. Broadly, there are three different sizes of data warehouse: Small-Size Data warehouse: DWH databases ~ 200 GB Medium-Size Data warehouse: DWH...
Part 2: Data Storage Approaches

Part 2: Data Storage Approaches

In a Data Warehousing platform, data is classified into two categories; as follows, Hot Data  (Frequently accessed): data which needs to be live and immediately accessible to the user is Hot data. These data will be stored in the Data Warehouse and distributed to the...
Part 1: What is a Data Warehouse?

Part 1: What is a Data Warehouse?

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision-making process. Great. But what do these terms actually mean? Subject-Oriented: A Data warehouse is built and used to analyse any...
Power BI vs Tableau

Power BI vs Tableau

Over the past few years, business intelligence and analytics platforms have increasingly prioritised self-service, visual features that value ease of use and data discovery above all else. As of 2017, Microsoft Power BI and Tableau are the two clear market leaders in...
The Microsoft Build Tour 2017 | Sydney

The Microsoft Build Tour 2017 | Sydney

The Microsoft Build tour is the only way to experience Microsoft Build news first hand and meet the Microsoft team from Redmond. Sitting in a packed audience on the last leg of the Microsoft Build Tour 2017in Sydney, I was excited to learn more about using the...
Live Tour De France With Microsoft Power BI Dashboard

Live Tour De France With Microsoft Power BI Dashboard

Get live data, process it, create a beautiful dashboard, all with Microsoft Power BI and RStudio. The Tour de France is heating up! Dimension Data built and designed a comprehensive digital infrastructure to allow fans unprecedented access to real time data. Every...
Migration Statistics with Microsoft Power BI

Migration Statistics with Microsoft Power BI

As human beings, we have a natural migrating culture that has been around for centuries. The reason behind this change varies with every season. What doesn’t change is our want and need to move organically to try new things in new surroundings, and then there are the...
Is productivity growth dead?

Is productivity growth dead?

Michael and Gerard examine Productivity Growth in Australia, New Zealand and the United States “Change is the law of life. And those who look only to the past or present are certain to miss the future.” John F. Kennedy The world is changing faster than ever...
Talking Business Intelligence

Talking Business Intelligence

Business Intelligence Breakfast – Friday, 17 March 2017 Wellington With all the hype surrounding Business Intelligence (BI), it is easy to forget that it is an old concept. As early as the 1840s, Florence Nightingale was using data visualisations to change...