Rajanand Ilangovanrajanand.hashnode.net·Apr 1, 2023What is Data Warehousing?If you're curious about what a data warehouse is and why companies use it, then this post is for you. We'll cover the basics of data warehousing and how it can help businesses make better decisions. What is Data Warehousing? Data warehousing is a cen...Discussdata-warehousing
Constantin Lungucnstlungu.hashnode.net·Apr 2, 2023Using BigQuery Time TravelIn this practical BigQuery exercise, we’re going to look at BigQuery Time Travel and see how it can help us when working with data. It’s not as powerful as Marty McFly’s DeLorean in Back to the Future (nobody knows what your future data will look lik...Discuss·34 readsPractical BigQuerybigquery
Adam Stonefoundinblank.hashnode.net·Aug 21, 2018What’s a Data Stack?After a few years of learning and using R to perform cognitive neuroscience and psychology research, I joined Convo in March 2018 as their Data Scientist. I report to their Director of Engineering, which places me squarely on the same team as softwar...DiscussModern Data Analytics Stack
Aayush Kurupaayushkurup.hashnode.net·Apr 14, 2023From Relational to Analytical: The Power of Redshift Data Warehousing and AnalyticsI recently got my hands dirty working on data warehousing and found myself wondering why traditional databases like Postgres aren't commonly used for this task. After some research and experimentation, I discovered that specialized data warehousing s...Discuss·58 readsdata-warehousing
Rajanand Ilangovanrajanand.hashnode.net·Apr 4, 2023Beginner's Guide to ETL: Extract, Transform and LoadETL (Extract, Transform, Load) is a crucial process that enables organizations to extract data from various sources, transform it into a useful form, and then load it into a data warehouse system for further analysis. It involves three main steps: ex...DiscussETL
Constantin Lungucnstlungu.hashnode.net·Apr 2, 2023Using BigQuery Time TravelIn this practical BigQuery exercise, we’re going to look at BigQuery Time Travel and see how it can help us when working with data. It’s not as powerful as Marty McFly’s DeLorean in Back to the Future (nobody knows what your future data will look lik...Discuss·34 readsPractical BigQuerybigquery
Rajanand Ilangovanrajanand.hashnode.net·Apr 2, 2023OLAP vs OLTPIf you're new to databases, you may have come across the terms OLAP and OLTP. In this blog post, we'll explain what they mean, and the differences between them, and provide real-life examples to help you understand these concepts. OLAP and OLTP are t...DiscussOLAP
Rajanand Ilangovanrajanand.hashnode.net·Apr 1, 2023What is Data Warehousing?If you're curious about what a data warehouse is and why companies use it, then this post is for you. We'll cover the basics of data warehousing and how it can help businesses make better decisions. What is Data Warehousing? Data warehousing is a cen...Discussdata-warehousing
Adam Stonefoundinblank.hashnode.net·Aug 21, 2018What’s a Data Stack?After a few years of learning and using R to perform cognitive neuroscience and psychology research, I joined Convo in March 2018 as their Data Scientist. I report to their Director of Engineering, which places me squarely on the same team as softwar...DiscussModern Data Analytics Stack
