Sumit Mondalsumit007.hashnode.dev·Apr 20, 2024A Beginner's Guide to Implementing Amazon Redshift on AWSIn the vast realm of cloud computing, Amazon Web Services (AWS) stands out as a powerhouse, offering a plethora of services to cater to diverse business needs. Among these, Amazon Redshift shines as a powerful data warehousing solution, enabling orga...DiscussAWS - HandsOnAmazon redshift
Data SenseiforSihan's Code Repocode-repo.hashnode.dev·Feb 20, 2024Nested IF in TSQL--nesting example DECLARE @Var1 INT = 15 IF @Var1 % 5 = 0 BEGIN IF @Var1 % 3 = 0 BEGIN print 'the number is divisible by 3 and 5' END ELSE BEGIN print 'the number is divisible by 5' END END ELSE BEGIN IF @Var1 %...DiscussSQL
VIVEK RAJYAGURUvivekrajyaguru.hashnode.dev·Dec 27, 2023Diving into Data Lakes and WarehousesLet’s break down these data things — Data Lakes and Data Warehouses. They’re like Batman and Robin in the data world, but each has its gig. So, what’s the deal? 1. What’s Their Deal: Data Lake: What it is: Think of it as a massive storage pond. It k...Discussdata
Pritesh Patelpritesh.hashnode.dev·Nov 7, 2023A Foodie's Guide to Data Warehouse vs Data LakeData lakes and warehouses are massive data storage systems utilized by data scientists, engineers, and business analysts. They are more dissimilar than similar, and these distinctions are critical for any aspiring data worker. Like genuine lakes, dat...Discuss·1 like·148 reads#datawarehouse
Lukayi Esther Kisakyelukayichosen.hashnode.dev·Oct 30, 2023A Comprehensive Guide to Data Warehouse Concepts and How They Work.A Comprehensive Guide to Data Warehouse Concepts and How They Work. In these days of fast-changing associated surroundings, institutions are turning to cloud-based technologies for accessible data collection, reporting, and analysis. This is where...Discuss·100 reads#datawarehouse
Raju MandalforTechMandalblog.rajumandal.com.np·Oct 2, 2023Amazon Redshift : Best PracticesAmazon Redshift, initially released in 2012, is a data warehouse product built on top of PostgreSQL technology from the massive parallel processing (MPP) to handle large scale data sets and database migrations. Redshift differs from Amazon's other ho...DiscussAWS Best Practicesbest practices
Kareem Olawaledatabasemonk.hashnode.dev·Jul 28, 2023Understanding Facts, Dimensions, and Attributes in Business Intelligence (2/2)Sales Analysis Eample In the example below, Table 1 represents the sales facts, including the date, product, quantity sold, and revenue. The facts represent the measurable metrics of the business. Table 2 represents the dimension of time, which provi...DiscussBUSINESS INTELLIGENCE
Saumya Guptasaumyagupta.hashnode.dev·Jul 4, 2023Dive into the Depths: Exploring the Power of DatalakesIntroduction In today's data-driven world, organizations are faced with an unprecedented influx of data from various sources. To harness the power of this vast sea of information, they require a robust and flexible storage and analysis solution. This...Discuss·10 likes#datamanagement
Rochak Dhakalrochakdh.hashnode.dev·May 10, 2023The Inner Workings of The Snowflake Warehouse: A Research-Based ExplorationSnowflake is a single, integrated platform delivered as-a-service. It is extremely elastic and is almost always available. Snowflake possesses capabilities for semi-structure and schema-less data storage, time traveling and end-to-end security. In th...Discuss·190 readssnowflake
abdessamad ouzninifordatafriendsdatafriends.hashnode.dev·Apr 30, 2023Business Intelligence 101: Exploring Dimensional Modeling — Part 3In the previous blog, we discussed the basic concepts of dimensional modeling. Now we dive deep into different techniques used in dimensional modeling such as star schema, and snowflake. Dimensional Modeling Techniques First, we must understand what ...Discuss·56 readsData Science