The Modern Data Platform – Part 1 – a Brief History of Data Warehousing

The Modern Data Platform – Part 1 – a Brief History of Data Warehousing

The phrase “Modern Data Platform” is increasingly being used, but what is it?  Is it just the latest name for Data Warehouse (DW) or something different? Will it support my big data/near real time streaming needs?  What if I don’t know what those needs are yet?  And why do I even need a “Modern Data Platform”?  This post, the first in a series, will provide one perspective on that question by firstly examining the history of data warehousing and how…

Read More Read More

So you want to run an Azure Hothouse?

So you want to run an Azure Hothouse?

This blog will lay out the key aspects of a hothouse, show how it differs from the standard hackathon and cover some of the key Azure technologies that work well in the tight schedules of this approach. These technologies (such as Power BI, Azure SQL DB, Logic Apps, Cosmos DB etc ) take away much of the configuration and infrastructure work allowing participants to focus on functionality.

GDPR – Implementing a Taxonomy in Azure Data Catalog Step by Step

GDPR – Implementing a Taxonomy in Azure Data Catalog Step by Step

This blog contains a commentary on the GDPR, as Microsoft interprets it, as of the date of publication. The tools and services referenced herein are not designed to ensure GDPR compliance but to assist you and your organization with your data classification and categorization, an important step in the journey to compliance. The application of GDPR is highly fact-specific and not all aspects and interpretations of GDPR are well-settled. As a result, this blog is provided for informational purposes only…

Read More Read More

What exactly is a GDPR Taxonomy and how can Azure Data Catalog help?

What exactly is a GDPR Taxonomy and how can Azure Data Catalog help?

This blog contains a commentary on the GDPR, as Microsoft interprets it, as of the date of publication. The tools and services referenced herein are not designed to ensure GDPR compliance but to assist you and your organization with your data classification and categorization, an important step in the journey to compliance. The application of GDPR is highly fact-specific and not all aspects and interpretations of GDPR are well-settled. As a result, this blog is provided for informational purposes only…

Read More Read More

Analytics & GDPR compliance – leave the data where it lives with Azure Analysis Services

Analytics & GDPR compliance – leave the data where it lives with Azure Analysis Services

Standard Data Warehousing data movement practices can leave multiple copies of GDPR sensitive data in place across the pipeline. This post presents Analysis Services as an alternative, providing very quick response times whilst leaving GDPR data essentially in one place

Solving GDPR Discovery via Azure Data Catalog

Solving GDPR Discovery via Azure Data Catalog

Solving the GDPR Discovery problem – Azure Data Catalog is
Microsoft’s solution to understanding & cataloguing the data estate of any organisation.  Designed to promote self serve data discovery it has several capabilities which support the GDPR process and furthermore, as a SaaS solution it has a minimal footprint, low start up cost, requires minimal training and can therefore be rapidly deployed at scale..

Which Way In? Power BI’s 3 query methods

Which Way In? Power BI’s 3 query methods

Power BI is Microsoft’s Data Discovery Tool however it has 3 distinct methods for data access.  How do these differ and how do we choose between them? Power BI is designed first and foremost as a self-service data discovery tool aimed at  business analysts and data miners however it can also be used to build rich dashboards and BI “applications” for more casual users.  What isn’t necessarily obvious however is that it has 3 distinct data access methods, “Import”, “DirectQuery”…

Read More Read More