{"id":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery","description":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery 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 18 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 SQL query pack assembled with Power BI, pandas and Excel.","contentLanguage":"en","coverUrl":"/course-covers/data-warehouse-fundamentals-studio-real-cases-and-de-4e8e29cb-090.webp","createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:51:42.589Z","durationSeconds":64800,"authorId":"e02c14d0-486a-41ab-b475-fd3c396768da","rating":4.4,"reviewCount":10,"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 18 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a SQL query pack plus reusable materials built around Power BI and pandas.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["intermediate"],"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":"6ebdc8d2-79ee-4de5-b217-7e310f56333d","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — course orientation and outcomes","description":"Lesson 1 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through course orientation and outcomes and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":0,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b8ea4882-5d70-42c5-ad8d-8bf4737e6c89","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — core concepts and mental models","description":"Lesson 2 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through core concepts and mental models and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":1,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"d8495189-d1f8-4c2c-8873-ed57d0e846f9","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — tools, setup, and learning environment","description":"Lesson 3 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through tools, setup, and learning environment and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":2,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bba85e59-2759-48a8-b8d5-5707e02c9d4f","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — practical workflows and process design","description":"Lesson 4 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through practical workflows and process design and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":3,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"12f3a089-e0d2-4abf-8d2b-8bcb53f4fcf0","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — real cases and guided practice","description":"Lesson 5 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through real cases and guided practice and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":4,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c6653b64-d4e0-4063-9771-1ea167e57395","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — project build and review","description":"Lesson 6 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through project build and review and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":5,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"aacf7b0c-929e-42c2-93d5-d29a912cd481","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — implementation, handoff, and next steps","description":"Lesson 7 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through implementation, handoff, and next steps and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":6,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"937c70c0-d2f1-4016-a5fb-e026c379703c","title":"Data Warehouse Fundamentals: Studio — Real Cases and Delivery — metrics, quality, and decision criteria","description":"Lesson 8 of 8 in Data Warehouse Fundamentals: Studio — Real Cases and Delivery: work through metrics, quality, and decision criteria and turn the result into a reusable part of the final SQL query pack using Power BI and pandas.","videoUrl":null,"videoFileName":null,"duration":8100,"position":7,"createdAt":"2026-05-26T07:47:21.802Z","updatedAt":"2026-05-26T07:47:21.802Z","courseId":"9a01e41c-56d6-407c-9df3-86b9d8fd5374","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"e02c14d0-486a-41ab-b475-fd3c396768da","name":"Charles Greene","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}