{"id":"079f540e-ff93-4c4a-8622-7531764e26f5","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout","description":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout is built for career starters and switchers aged 25–34 who want a concrete, portfolio-ready result rather than abstract theory. Across 10 lessons and about 23 hours, the course focuses on course orientation and outcomes, SQL exploration, and foundations and working vocabulary; the capstone is a metrics dictionary built with Power BI and Python.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.177Z","durationSeconds":82800,"authorId":"ca30b505-9bd1-4788-96a9-9c1fa8ba32c3","rating":4.4,"reviewCount":5,"expectedLessonsCount":10,"trailerUrl":null,"faq":[{"answer":"A minimal base is recommended, but the opening block still aligns terminology, tools, and expectations before practice.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 10 lessons and about 23 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a metrics dictionary plus reusable materials built around Power BI and Python.","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":109,"features":[],"highlighted":true}],"minPricingTierPrice":109,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"fcc7c1fd-8e7b-450e-af06-437dcf6df1cf","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — course orientation and outcomes","description":"Lesson 1 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through course orientation and outcomes and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":0,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"cd93e2c8-b613-4864-88fd-b01c7242f401","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — SQL exploration","description":"Lesson 2 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through SQL exploration and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":1,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b00d60f5-ef88-490b-aab2-f06f1a44bdfa","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — foundations and working vocabulary","description":"Lesson 3 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through foundations and working vocabulary and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":2,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"d0ba04a9-f092-406f-91d2-d81cdd581a3d","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — implementation and adoption","description":"Lesson 4 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through implementation and adoption and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":3,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"3bbf6cf5-f473-431b-aa95-85a465221d5e","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — next-step roadmap","description":"Lesson 5 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through next-step roadmap and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":4,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e71105f3-4bd8-4db6-8b2d-2c2ed73180fc","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — workflow design and handoffs","description":"Lesson 6 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through workflow design and handoffs and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":5,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9badfe3f-59ff-40a3-a3d4-b08e6f9d1c01","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — guided cases and practice","description":"Lesson 7 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through guided cases and practice and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":6,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"60771e2b-138f-4bd6-94b8-7e7db5d3daf8","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — measurement and optimization","description":"Lesson 8 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through measurement and optimization and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":7,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"336e544f-fe75-4619-862c-4aa0d73bb563","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — dashboard logic","description":"Lesson 9 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through dashboard logic and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":8,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9ecad761-e314-4e0d-8a16-e88df8e251ec","title":"dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout — forecast review","description":"Lesson 10 of 10 in dbt and Data Modeling: Office Hours — Templates, Metrics, and Rollout: work through forecast review and convert the result into a reusable part of the final metrics dictionary using Power BI and Python.","videoUrl":null,"videoFileName":null,"duration":8280,"position":9,"createdAt":"2026-05-26T07:50:28.135Z","updatedAt":"2026-05-26T07:50:28.135Z","courseId":"079f540e-ff93-4c4a-8622-7531764e26f5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"ca30b505-9bd1-4788-96a9-9c1fa8ba32c3","name":"Jack Morgan","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/16a2a283-8cd8-4916-a2f6-9b70e0636908.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}