Data Modelling, Warehousing & the Modern Data Stack is simply a system way of 12 lessons that build a complete, interview-ready knowing of the topic. Work done them successful order, past usage the quiz and flashcards successful each instruction to revise.
What this people covers
- How Analytics Data Is Stored: Databases, Warehouses & Lakes - Each retention type, what it optimises for, and erstwhile analytics uses which.
- Transactional versus Analytical Processing - Why the database moving the app is the incorrect spot to tally your analysis.
- Dimensional Modelling: Facts, Dimensions & Choosing the Grain - Fact and magnitude tables, and why declaring the atom first prevents astir bugs.
- Star Schema versus Snowflake Schema: Choosing a Design - Both designs compared connected query speed, retention and maintenance.
- Slowly Changing Dimensions & Keeping History - How to way an property that changes complete clip without corrupting past reports.
- Extract-Transform-Load versus Extract-Load-Transform Pipelines - The 2 pipeline shapes, and why the storage era flipped the order.
- The Modern Data Stack: Ingestion, Storage, Transformation & Serving - The 4 layers of a existent stack and the instrumentality categories successful each.
- Analytics Engineering: Transformation, Testing & Documented Models - Version-controlled transformation, exemplary tests and archiving arsenic portion of the job.
- The Semantic Layer & Metrics Store: One Definition of Truth - Why governed metric definitions became captious erstwhile devices started answering questions.
- Data Quality Testing, Freshness & Pipeline Monitoring - The tests that drawback a surgery pipeline earlier a stakeholder does.
- Event Tracking & Instrumentation: Clean Data astatine Source - Naming conventions, arena schemas and why astir information problems commencement here.
- Case Study: Designing a Warehouse Model for a Delivery Business - A afloat dimensional exemplary designed from a business brief, atom upwards.
English (US) · 
Indonesian (ID) ·