Last Week Reading (2019-06-02)

Hello data folks. Here you have some updates from the data world.

Press

Where should I clean my data?
James Serra’s (T) guidance when using ADF, DW, maybe Databricks…

How To Trigger A Power BI Dataset Refresh Using An Azure Data Factory Web Activity
Dave Ruijter (T) shows secure with Azure Key Vault step-by-step recipe.

Getting started with Azure Data Factory Mapping Data Flows
Matt How (T) describes MDF with a simple example – read it if you don’t know Mapping Data Flow yet.

Using Azure Data Factory Mapping Data Flows to populate Data Vault
Another loading pattern with ADF.

Scripting out SQL Server Data as Insert statements via PowerShell
Phil (T) built a script for you – script your data to native BCP format either.

Upgrading a data model from Power BI to Tabular got a lot harder
Although it’s not supported by Microsoft, worth to know the trick, especially if you do it to an earlier than 2019 version.

ASF 022: Guy in a Cube interview (part 2)
Have you had a chance to listen to the latest episode with Adam and Patrick?

A word from Microsoft’s CEO

Great to be visiting Sweden today, where we’re announcing our ambition to build datacenters in the country that will be among the most sustainable in the world. https://t.co/zHE3nf7cwn

— Satya Nadella (@satyanadella) 29 May 2019

Video: Self-driving cars

Smile Corner