{"id":"515a8642-2c5b-4253-92e0-0c3620ec305b","title":"Data Warehouse Fundamentals: Studio — Projects and Templates","description":"Data Warehouse Fundamentals: Studio — Projects and Templates is designed for career starters and switchers aged 25–34 who need a concrete, portfolio-ready result instead of abstract theory. Across 8 lessons and about 17 hours, the curriculum focuses on course orientation and outcomes, core concepts and mental models, and tools, setup, and learning environment; the final deliverable is a KPI dashboard assembled with Python, pandas and Looker Studio.","contentLanguage":"en","coverUrl":"/course-covers/data-warehouse-fundamentals-studio-projects-and-temp-d21e132c-fd6.webp","createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:51:42.587Z","durationSeconds":61200,"authorId":"b7b61f5f-f940-4910-8d9a-462e51b8c2e2","rating":4.333333333333333,"reviewCount":6,"expectedLessonsCount":8,"trailerUrl":null,"faq":[{"answer":"No prior experience is required. The first lessons create a clean ramp-up before moving into applied scenarios.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 8 lessons and about 17 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a KPI dashboard plus reusable materials built around Python and pandas.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["advanced"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":79,"features":[],"highlighted":true}],"minPricingTierPrice":79,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"793b6434-b6b1-46bf-a5f3-a27960e281e0","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — course orientation and outcomes","description":"Lesson 1 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through course orientation and outcomes and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":0,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0349d902-06f3-4b2e-88f3-c03b5b3dfd94","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — core concepts and mental models","description":"Lesson 2 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through core concepts and mental models and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":1,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8352dc16-d78a-4dd6-a4c0-669f55e2d7bc","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — tools, setup, and learning environment","description":"Lesson 3 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through tools, setup, and learning environment and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":2,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b23a4581-ff3d-4649-bb4e-b5f74963249c","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — practical workflows and process design","description":"Lesson 4 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through practical workflows and process design and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":3,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"04183347-0256-4f97-ba76-b8390f3a24fd","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — real cases and guided practice","description":"Lesson 5 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through real cases and guided practice and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":4,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a36261d2-3b57-4252-829c-088c773c8ed7","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — project build and review","description":"Lesson 6 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through project build and review and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":5,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b22086c9-e829-4c68-998f-d10efca8c9c9","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — implementation, handoff, and next steps","description":"Lesson 7 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through implementation, handoff, and next steps and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":6,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8229d7e9-b6f9-41a7-a3b9-f93264d7e5df","title":"Data Warehouse Fundamentals: Studio — Projects and Templates — queries, models, and structure","description":"Lesson 8 of 8 in Data Warehouse Fundamentals: Studio — Projects and Templates: work through queries, models, and structure and turn the result into a reusable part of the final KPI dashboard using Python and pandas.","videoUrl":null,"videoFileName":null,"duration":7650,"position":7,"createdAt":"2026-05-26T07:47:27.680Z","updatedAt":"2026-05-26T07:47:27.680Z","courseId":"515a8642-2c5b-4253-92e0-0c3620ec305b","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"b7b61f5f-f940-4910-8d9a-462e51b8c2e2","name":"Michael Holland","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/c4d70ea6-6c69-4d3b-bd29-b90b09f273ec.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}