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
Most BI Delivery teams will recognise the weekly or monthly grind of producing the “Executive update dashboard” powerpoint deck. The new bookmarking option in Power BI can accelerate that process in a secure & flexible approach.
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.
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”…