Reader small image

You're reading from  Cloud Scale Analytics with Azure Data Services

Product typeBook
Published inJul 2021
PublisherPackt
ISBN-139781800562936
Edition1st Edition
Right arrow
Author (1)
Patrik Borosch
Patrik Borosch
author image
Patrik Borosch

Patrik Borosch is a cloud solution architect for data and AI at Microsoft Switzerland GmbH. He has more than 25 years of BI and analytics development, engineering, and architecture experience and is a Microsoft Certified Data Engineer and a Microsoft Certified AI Engineer. Patrik has worked on numerous significant international data warehouse, data integration, and big data projects. Through this, he has built and extended his experience in all facets, from requirements engineering to data modeling and ETL, all the way to reporting and dashboarding. At Microsoft Switzerland, he supports customers in their journey into the analytical world of the Azure Cloud.
Read more about Patrik Borosch

Right arrow

Discovering additional knowledge

The following is some advice that you might find useful.

Do:

  • Plan for security from day one: Where are your trade-offs between security and usability?
  • Enforce as much discipline as needed, but not more than is really necessary. Your data lake needs to serve your Data Scientists, as well as other communities in your company. Your modern data warehouse needs some agility.
  • Structure your zones clearly and stick to the plan. If you need to redesign, don't do so in your already started structure.
  • Implement a Data Catalog (we will talk about this in Chapter 14, Establishing Data Governance) to enable easy data discovery.
  • Integrate with DevOps for a controlled and repeatable system.

Don't:

  • Don't mix different formats. Always stick to one single file format per folder. You will often want to read all the files in a folder in one go.
  • Don't forget naming conventions!
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Cloud Scale Analytics with Azure Data Services
Published in: Jul 2021Publisher: PacktISBN-13: 9781800562936

Author (1)

author image
Patrik Borosch

Patrik Borosch is a cloud solution architect for data and AI at Microsoft Switzerland GmbH. He has more than 25 years of BI and analytics development, engineering, and architecture experience and is a Microsoft Certified Data Engineer and a Microsoft Certified AI Engineer. Patrik has worked on numerous significant international data warehouse, data integration, and big data projects. Through this, he has built and extended his experience in all facets, from requirements engineering to data modeling and ETL, all the way to reporting and dashboarding. At Microsoft Switzerland, he supports customers in their journey into the analytical world of the Azure Cloud.
Read more about Patrik Borosch