{"id":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","title":"Product Analytics: Residency — Projects for Portfolio and Interviews","description":"Product Analytics: Residency — Projects for Portfolio and Interviews is built for career starters and switchers aged 25–34 who want a concrete, portfolio-ready result rather than abstract theory. Across 7 lessons and about 18 hours, the course focuses on course orientation and outcomes, metrics design, and tools, setup, and environment; the capstone is a SQL project portfolio built with Power BI and SQL.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.064Z","durationSeconds":64800,"authorId":"9f6b703f-a7a0-4b5c-813d-30e594aa257a","rating":4.5,"reviewCount":6,"expectedLessonsCount":7,"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 3–5 hours per week. In total, the course includes 7 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 project portfolio plus reusable materials built around Power BI and SQL.","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":89,"features":[],"highlighted":true}],"minPricingTierPrice":89,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"076d6623-131f-434b-916a-f1d45a63d819","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — course orientation and outcomes","description":"Lesson 1 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through course orientation and outcomes and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9258,"position":0,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ed59878a-0e2c-448d-9735-616b6a1d51e9","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — metrics design","description":"Lesson 2 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through metrics design and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":1,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"35fa46ca-f9b9-4a90-b8e7-7913e671944d","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — tools, setup, and environment","description":"Lesson 3 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through tools, setup, and environment and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":2,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"5462a64a-8576-4131-bda9-aeb58f58ab83","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — experiments and validation","description":"Lesson 4 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through experiments and validation and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":3,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ae56af95-e409-4f80-99d9-13f553058859","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — workflow design and handoffs","description":"Lesson 5 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through workflow design and handoffs and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":4,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9eedaa17-04ec-433d-91e4-90692b7329a7","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — forecast review","description":"Lesson 6 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through forecast review and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":5,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"351dfdab-eb53-465e-b8cc-fb234a1be1de","title":"Product Analytics: Residency — Projects for Portfolio and Interviews — measurement and optimization","description":"Lesson 7 of 7 in Product Analytics: Residency — Projects for Portfolio and Interviews: work through measurement and optimization and convert the result into a reusable part of the final SQL project portfolio using Power BI and SQL.","videoUrl":null,"videoFileName":null,"duration":9257,"position":6,"createdAt":"2026-05-26T07:49:48.021Z","updatedAt":"2026-05-26T07:49:48.021Z","courseId":"791b5a86-bae5-4ece-8cdc-bb5bdf3248ec","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"9f6b703f-a7a0-4b5c-813d-30e594aa257a","name":"Andrew Greene","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}