samhita sarkarsamhita-sarkar.hashnode.dev·Nov 11, 2024Deciding When to Normalize or Denormalize Data for Best ResultsNormalisation and denormalisation are essentially design patterns in databases that determine how data is stored and used. Storage pattern : The key difference between normalisation and denormalisation is their storage patterns, which are essentially...1 like·54 readsDatabases
PULKIT KAPOORblog.pulkitkapoor.com·Nov 11, 2024Understanding Amazon Redshift Data Sharing FeaturesAWS Redshift is the data-warehousing solution provided by Amazon Web Services. As part of the Datawarehouse offering, Amazon Redshift provides a very useful feature known as data sharing. In this short article, we will get an understanding of when to...35 readsAWS
Hana Satohanasato.hashnode.dev·Oct 28, 2024Understanding Data Source Integration: Key Factors for Your EDWThe role of an Enterprise Data Warehouse (EDW) in data warehousing has become increasingly critical as organizations look to make data-driven decisions across all functions. To keep pace with the demand for data accessibility and actionable insights,...edw data
Abhishek Jaiswaldataplumbing.hashnode.dev·Jul 15, 2024Comprehensive Guide to DBT (Data Build Tool)What is dbt? dbt (Data Build Tool) is an open-source command-line tool that helps analysts and engineers transform data in their data warehouse. It allows you to manage your data transformations with SQL in a version-controlled and collaborative envi...10 likesdata-engineering
EW Solutionsdatawarehousemodels.hashnode.dev·Apr 25, 2024Creating A Data Warehouse Data Model From ScratchWith primary knowledge about digital security structures and algorithms, you craft your very own information storage model from scratch. If not, you can also collaborate with industry professionals to craft a custom metadata model that can properly m...data warehouse data model
Ian Santillanievsantillan.hashnode.dev·Jun 21, 2020Core tenets of agile methodology and Kimball best practicesFocus on delivering business value. This has been the Kimball mantra for decades. Value collaboration between the development team and business stakeholders. Like the agile camp, we strongly encourage a close partnership with the business. Stress o...agile