Analytics Engineering Digestthatjuanpablo.hashnode.dev·Oct 4, 2024Dimensional Data Model for App Help Center PageIntroduction The success of a digital product heavily depends on providing users with efficient support and guidance. One of the key tools for achieving this is a well-structured help center that users can navigate to find solutions to their problems...Discussdimensional modelling
Shani Riversshanirivers.hashnode.dev·Oct 3, 2024How to Kickstart Your Career in DataWhy did I give you a roadmap instead of writing courses on the basics of SQL, HTML, CSS, and Javascript? Because, there are so many great and free stuff out there that I feel do more than a great job at getting a beginner up to speed, especially befo...DiscussData Science
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Sep 27, 2024Dimensional Data Modeling for an E-Commerce StoreIntroduction: Understanding the Business Process In an online retail environment like Walmart, there are multiple critical processes involved in fulfilling customer orders. These include capturing customer details, managing product inventories, proce...Discussdata-engineering
Prajwal Urkudeprajwalurkude.hashnode.dev·Sep 22, 2024🚀 Boost Your Side Projects with These Free, Production-Level Databases:Whether you're building a hobby project or experimenting with new ideas, these free databases can provide the reliability and scalability you need: Neon Database Exploring Neon Database: Features, Usage, and Code Implementation Introduction Neon ...Discuss·30 likes·103 readsneondatabase
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Sep 20, 2024Dimensional Data Model for Airbnb and VRBOUnderstanding the Business Domain Before diving into the data model, it's crucial to understand the key entities and relationships in an online marketplace for short-term homestays. Here are the primary entities: Users: Guests and hosts Properties:...Discussanalytics engineering
Saarthak Mainisaarthakmaini.hashnode.dev·Sep 14, 2024Indexing in DatabasesWhen working with databases, performance is often a key concern, especially as data grows in size. Efficient data retrieval becomes critical for applications that demand quick query results. One of the most effective ways to enhance database performa...DiscussDatabases
Muhammad Abdiel Al Hafizabdiel.hashnode.dev·Sep 7, 2024Pentingnya Normalisasi Database untuk Konsistensi dan Integritas DataData yang konsisten dan akurat merupakan fondasi dalam pengambilan keputusan yang tepat. Untuk memastikan data tetap terstruktur dengan baik dan terhindar dari inkonsistensi, salah satu teknik penting yang digunakan adalah normalisasi. Teknik ini san...Discuss·1 like2NF
Amitesh Vermaamiteshverma.hashnode.dev·Aug 26, 2024Understanding Data Replication in Databases: What It Is and How It WorksData is a crucial part of any organization because it drives the entire business. Therefore, it's essential for any organization to securely store and serve data to clients.The following properties are important for any database: Scalability (abilit...Discuss·1 like·26 readsDatabases
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Aug 16, 2024Dimensional Data Model for Ride-Sharing App AnalyticsCover photo credits: Ehsan Haque via Pexels "Dimensional models are gracefully extensible to accommodate change. The predictable framework of a dimensional model withstands unexpected changes in user behavior" - Ralph Kimball Understanding the Busi...Discussanalytics engineering
Swatipbtechnicalblogss.hashnode.dev·Aug 5, 2024SQL CommandsData Definition Language (DDL): It changes the structure of the table by creating, deleting, or altering the table. DDL commands are auto-committed, meaning they save all changes in the database. Create: This command is used to create a new table in...Discuss·1 likesqueal
