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 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..
SQL Server Analysis Services is a powerful analytics engine & Azure Analysis Services builds on it’s strengths & adds exciting new capabilities. Out of the box Scale up/out, high availability, a powerful semantic layer & now support for bi-modal analytics means that Azure Analysis Services may just have become a game changer.
“Where’s my raw data? Is this data set complete? Am I using dev or test data from the lake? Can I trust this data set, where did it come from and who owns it?” Data Lakes are a great design feature for a modern data warehouse however they can quickly deteriorate into a Data Swamp if there is no governance on their structure. But governance means process and process can be the enemy of agility. This post will introduce Azure…