Slowly Changing Dimensions: Application and Examples
Author: Jaysee Sunapho Managing the evolution of data through time is critical in relation to data warehousing and data analytics. Slowly Changing Dimensions (SCDs) are a collection of approaches for dealing with data changes in a systematic and consistent manner. This blog thoroughly explains SCDs, their different kinds, and real-world examples of how they may […]
Read More
Defining Analytics
Data Analytics used to be a buzzword. It no longer is. It is now a standard business requirement. Over the past decade we have gone from asking “Does your business need data analytics?”, to “How can data analytics transform your business?” Simply put, analytics has become essential to the growth and development of the modern […]
Read More
Azure Synapse Analytics – the essential SQL on-demand cheat sheet
Author: Etienne Oosthuysen Disclaimer: as Azure Synapse Analytics is still in Public Preview, some areas may not yet function as it will in a full General Availability stage. This article contains the Synapse SQL on-demand test drive as well as a cheat sheet that describes how to get up and running step-by-step. I then conclude […]
Read More
Common Data Service (CDS) – A Common Data Model. Accelerate your ability to provide insights into your business data
If you’ve been following Microsoft’s recent press releases, chances are you’ll have been exposed to the term “Common Data Service” (CDS). Read on as we shed light on the exact nature of CDS and what it can mean to your business. Back in November 2016, Microsoft released their Common Data Service to general availability. In […]
Read More
Networks Asset Data Mart – our Energy Infrastructure Provider case study
Exposé designed and developed a solution that saw an increasingly temperamental Networks Asset Analytical solution move to the Exposé developed Enterprise Analytics Platform. The solution now: • Allows staff to focus on business-critical tasks by utilising the data created by the system.• Reduces support costs due to the improved system stability.• Utilises the IT resources […]
Read More
Transforming the business into a data centric organisation through an Advanced Analytics and Big Data solution – our ACH Group case study
An Advanced Analytics and Big Data solution allows for the acquisition, aggregation and blending of large volumes of data often derived from multiple disparate sources. Incorporating IoT, smart devices and predictive analytics into the solution. Our ACH Group case study shows how a clever data platform architecture and design facilitates transformation into a data-centric organisation […]
Read More
From operational challenges to a modern, automated and simplified organisation – Our Business SA case study
An Exposé case study around our advanced analytics solution for the ‘voice of business in South Australia’, Business SA. The solution was an important component of a large digital transformation program that saw Business SA transition to a modern, automated and simplified organization which was underpinned by the following technology changes; • A cloud-first strategy which […]
Read More
Is the Data Warehouse Dead?
Author: Etienne Oosthuysen I am increasingly asked by customers – Is the Data Warehouse dead? In technology terms, 30 years is a long time. This is how old the Data Warehouse is – that makes the Data Warehouse an old timer. Can we consider it a mature yet productive worker, or is it a worker […]
Read More
From water cooler discussion to corporate Data Analytics in record time
Author: Etienne Oosthuysen For those who have been involved in conventional Business Intelligence projects, you will be all too familiar with the likely contiguous chain of events and the likely outcome. It typically goes something like this: The idea is incubated by someone (very often this would be within ICT), a business case for a […]
Read More