Saurabh Dhariwalsaurabhdhariwal.hashnode.dev路Dec 4, 2024Cloud Data Warehousing: How to Leverage AWS, Azure, and Google CloudIn today's data-driven world, organizations are increasingly seeking cloud data warehousing solutions to store, manage, and analyze their data efficiently. Cloud data warehouses offer scalability, flexibility, and cost-effectiveness that traditional ...AWS
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
Mehul Kansalmehulkansal.hashnode.dev路Sep 30, 2024Week 18: Azure Synapse Key Concepts 馃攽Hey data folks! 馃憢 This week鈥檚 blog explores how to provision and use key features like Serverless SQL Pools, Dedicated SQL Pools, and Apache Spark Pools within an Azure Synapse workspace. We鈥檒l dive into creating external tables, loading data from A...Azure
Mehul Kansalmehulkansal.hashnode.dev路Sep 2, 2024Week 15: Lakehouse Architecture and Delta Engine 馃彔Hey data engineers! 馃憢 In this blog, we explore the Azure Lakehouse architecture, focusing on how Databricks Lakehouse integrates the benefits of data lakes and data warehouses. We'll dive into its core components, such as the storage layer, Delta La...Data-lake
neurontistneurontist.hashnode.dev路Sep 1, 2024Data Lakes vs Data Warehouses: How to Choose the Right OneWhen it comes to managing and analyzing vast amounts of data, businesses are often faced with a critical decision: should they invest in a data lake or a data warehouse? Choosing between a data lake and a data warehouse can feel like navigating a maz...Data Science
Danish bukshdanish2299.hashnode.dev路Aug 28, 2024Understanding AWS Redshift: A Comprehensive GuideIntroduction In the fast-paced world of big data and analytics, organizations need robust tools to store, manage, and analyze massive amounts of data efficiently. One such powerful tool is Amazon Redshift, a fully managed, petabyte-scale data warehou...AWS
Mehul Kansalmehulkansal.hashnode.dev路Aug 26, 2024Week 14: Delta Lake on Azure Databricks 馃殌Hey there! 馃憢 In this week's blog, we鈥檒l delve into the specific challenges associated with traditional Data Lakes and demonstrate how Delta Lake, an open-source storage layer, effectively addresses these issues, with hands-on examples using Azure Da...Azure
Emma Jonesdigitallyemma.hashnode.dev路Aug 22, 2024The Modern Data Warehouse: Bridging the Gap Between Data and Actionable InsightsA new era of data management has arrived, in which organizations are empowered to make informed decisions based on vast information. Data is an organization's lifeblood. However, with the speed at which data is growing and the demands of analytics ch...data-warehousing
Hana Satohanasato.hashnode.dev路Aug 16, 2024Data-as-an-Asset: Unlocking the True Value of InformationIn today's digital economy, data is no longer just a byproduct of business operations鈥攊t has become a critical asset that drives innovation, efficiency, and competitive advantage. As organizations increasingly recognize the strategic value of data, t...Data-as-an-Asset
Cavin Karemadata-engineering.hashnode.dev路Aug 4, 2024Data Warehousing SeriesWhat are dimension tables? Dimension tables group related attributes that provide context to a business process. They contain associated context with a business process or measurement event. Dimensions are descriptive in nature, they typically descri...data