45 Days
BEGINNER TECHNOLOGY & DATA INTERNSHIP
Data Foundations & Visual Analytics (Excel/SQL)
Data Foundations & Visual Analytics (Excel/SQL) is a Beginner internship track focused on Foundational skills, syntax, basic tools, and core industry workflows.
2 Months
Beginner
Choose portfolio projects from your selected level
Beginner internship certificate and mentor-guided learning
Real-world assignments in Data Cleaning & Normalization (DataOps)
Enrollment Form
Secure your seat
Connect With Our Team
Fill your details and our team will contact you shortly.
Outcomes
What this program helps you build by the end
Outcome-focused highlights designed to make the value of the program easy to understand at a glance.
3 Portfolio Projects Required
Project requirement for this tier
Technology & Data
Career domain
Curriculum
Build practical skills through structured module work
Every module is sequenced to help learners move from guided basics to stronger, portfolio-worthy execution.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Messy CRM Data Sanitizer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Messy CRM Data Sanitizer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL script using string functions to clean trailing spaces, standardize capitalization, and fix typos in client names
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Messy CRM Data Sanitizer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Duplicate Vendor Record Merger in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Duplicate Vendor Record Merger into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL CTEs and GROUP BY logic to find duplicate company entries and merge their purchase histories
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Duplicate Vendor Record Merger against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for E.164 Phone Number Formatter in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break E.164 Phone Number Formatter into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Excel macro/SQL function to convert inconsistent phone number inputs into a standard global format
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test E.164 Phone Number Formatter against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Address Parsing Utility in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Address Parsing Utility into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL script that splits a single comma-separated address string into Street, City, State, and Zip columns
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Address Parsing Utility against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Inconsistent Date Format Standardizer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Inconsistent Date Format Standardizer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Standardizes messy string dates like "12-Oct-22" or "10/12/2022" into strict YYYY-MM-DD ISO formats
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Inconsistent Date Format Standardizer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Missing Value Imputation Script in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Missing Value Imputation Script into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Uses COALESCE or ISNULL to replace missing financial data with departmental averages
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Missing Value Imputation Script against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Multi-Currency Normalization Pipeline in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Multi-Currency Normalization Pipeline into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL join that matches daily transactions to a currency exchange rate table to output all revenue in USD
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Multi-Currency Normalization Pipeline against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Monthly SaaS Churn Rate Calculator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Monthly SaaS Churn Rate Calculator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL query calculating the percentage of users who cancelled subscriptions month-over-month
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Monthly SaaS Churn Rate Calculator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Quarterly Revenue Aggregator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Quarterly Revenue Aggregator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Groups daily sales data into fiscal quarters and calculates year-to-date (YTD) totals
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Quarterly Revenue Aggregator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Departmental Budget Variance Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Departmental Budget Variance Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Compares Allocated_Budget vs Actual_Spend and flags departments exceeding their budget by >5%
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Departmental Budget Variance Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Invoice Payment Aging Report in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Invoice Payment Aging Report into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Categorizes unpaid corporate invoices into 30, 60, and 90+ days overdue buckets
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Invoice Payment Aging Report against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Sales Commission Calculator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Sales Commission Calculator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL logic that calculates variable tiered commission rates based on individual sales rep performance
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Sales Commission Calculator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Subscription Proration Engine in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Subscription Proration Engine into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Calculates the exact daily refund amount owed to a user who cancels their software plan mid-month
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Subscription Proration Engine against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Average Order Value (AOV) Trend Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Average Order Value (AOV) Trend Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Analyzes e-commerce transaction tables to track how AOV fluctuates on weekends vs. weekdays
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Average Order Value (AOV) Trend Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Employee Turnover & Retention Analytics in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Employee Turnover & Retention Analytics into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Calculates the average tenure of employees who left the company in the last fiscal year
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Employee Turnover & Retention Analytics against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Leave/PTO Balance Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Leave/PTO Balance Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Aggregates accrued vacation time minus taken days to output a final liability report for HR
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Leave/PTO Balance Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Salary Band Distribution Report in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Salary Band Distribution Report into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Creates statistical buckets (min, max, median) to ensure employee salaries fall within corporate bands
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Salary Band Distribution Report against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Headcount & Hiring Cost Projection in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Headcount & Hiring Cost Projection into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Excel model projecting the cost of hiring 50 new engineers factoring in recruitment fees and hardware
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Headcount & Hiring Cost Projection against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Diversity & Inclusion Metric Dashboard in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Diversity & Inclusion Metric Dashboard into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL queries summarizing demographic distribution across executive vs. entry-level roles
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Diversity & Inclusion Metric Dashboard against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Performance Review Scoring Aggregator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Performance Review Scoring Aggregator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Normalizes 1-5 manager ratings across different departments to find the top 10% eligible for bonuses
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Performance Review Scoring Aggregator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Shift Overlap & Compliance Checker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Shift Overlap & Compliance Checker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL window functions to flag employees who were scheduled with less than 8 hours of rest between shifts
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Shift Overlap & Compliance Checker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Reorder Point Alert Generator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Reorder Point Alert Generator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Flags SKUs where Current_Stock falls below the Minimum_Threshold and generates a reorder CSV
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Reorder Point Alert Generator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Warehouse Stock Aging Report in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Warehouse Stock Aging Report into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Identifies "dead stock" items that have sat in the warehouse for over 365 days without a sale
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Warehouse Stock Aging Report against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Supplier Lead Time Analyzer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Supplier Lead Time Analyzer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Calculates the average number of days between a Purchase Order (PO) creation and physical warehouse delivery
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Supplier Lead Time Analyzer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Bill of Materials (BOM) Cost Rollup in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Bill of Materials (BOM) Cost Rollup into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
A recursive SQL query or Excel model that calculates the total cost to build a product based on its raw components
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Bill of Materials (BOM) Cost Rollup against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Inventory Shrinkage & Loss Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Inventory Shrinkage & Loss Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Compares system inventory numbers against physical audit numbers and calculates the financial loss
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Inventory Shrinkage & Loss Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Freight Cost Allocation Engine in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Freight Cost Allocation Engine into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Distributes bulk shipping costs across individual items based on their cubic weight
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Freight Cost Allocation Engine against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Peak Season Demand Forecaster in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Peak Season Demand Forecaster into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Analyzes historical Q4 sales data to project required inventory levels for the upcoming holiday season
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Peak Season Demand Forecaster against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Lead Conversion Funnel Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Lead Conversion Funnel Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL script measuring the drop-off rate from Website_Visit -> Account_Created -> Paid_Subscription
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Lead Conversion Funnel Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Email Campaign Engagement Aggregator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Email Campaign Engagement Aggregator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Calculates Open Rates and Click-Through Rates (CTR) grouped by email subject lines
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Email Campaign Engagement Aggregator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Customer Lifetime Value (CLV) Estimator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Customer Lifetime Value (CLV) Estimator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Calculates total historic revenue per user minus their customer acquisition cost
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Customer Lifetime Value (CLV) Estimator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for RFM (Recency, Frequency, Monetary) Segmentation in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break RFM (Recency, Frequency, Monetary) Segmentation into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL logic scoring customers 1-5 to identify "VIPs" vs "At-Risk" accounts
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test RFM (Recency, Frequency, Monetary) Segmentation against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Ad Spend vs. Return (ROAS) Dashboard in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Ad Spend vs. Return (ROAS) Dashboard into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Joins marketing spend data from Facebook/Google with Shopify sales data to calculate profitability
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Ad Spend vs. Return (ROAS) Dashboard against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Cart Abandonment Recovery Report in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Cart Abandonment Recovery Report into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Identifies users who added items to cart but didn't purchase within 24 hours to trigger retargeting emails
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Cart Abandonment Recovery Report against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Net Promoter Score (NPS) Trend Analyzer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Net Promoter Score (NPS) Trend Analyzer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Aggregates 1-10 survey responses and calculates the official NPS score for the quarter
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Net Promoter Score (NPS) Trend Analyzer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for IT Helpdesk Ticket SLA Breach Detector in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break IT Helpdesk Ticket SLA Breach Detector into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Flags support tickets that were not responded to within the 4-hour Service Level Agreement window
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test IT Helpdesk Ticket SLA Breach Detector against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Server Uptime & Downtime Log Aggregator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Server Uptime & Downtime Log Aggregator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Parses system logs to calculate the monthly availability percentage (e.g., 99.99%) of a core server
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Server Uptime & Downtime Log Aggregator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Hardware Asset Lifecycle Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Hardware Asset Lifecycle Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Identifies corporate laptops that are older than 3 years and due for IT replacement
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Hardware Asset Lifecycle Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Software License Utilization Reporter in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Software License Utilization Reporter into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Compares purchased Adobe/Microsoft licenses against actual active log-ins to find wasted spend
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Software License Utilization Reporter against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Suspicious Login Attempt Identifier in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Suspicious Login Attempt Identifier into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
SQL query grouping failed password attempts by IP address to flag potential brute-force attacks
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Suspicious Login Attempt Identifier against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for VPN Bandwidth Usage Report in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break VPN Bandwidth Usage Report into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Identifies the top 5% of users consuming the most remote network bandwidth
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test VPN Bandwidth Usage Report against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Cloud Cost Apportionment in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Cloud Cost Apportionment into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Joins AWS billing exports with departmental tags to charge back cloud server costs to the correct teams
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Cloud Cost Apportionment against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Automated Daily KPI Tracker in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Automated Daily KPI Tracker into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
An Excel dashboard using VLOOKUP/XLOOKUP and Pivot Tables that updates when a raw SQL data dump is pasted in
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Automated Daily KPI Tracker against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Dynamic Sales Territory Heatmap in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Dynamic Sales Territory Heatmap into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Using conditional formatting and Excel Map charts to visualize regional sales performance
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Dynamic Sales Territory Heatmap against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Executive Financial Summary in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Executive Financial Summary into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
A clean, board-ready Excel dashboard utilizing Slicers to filter revenue by month and product line
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Executive Financial Summary against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Cohort Retention Matrix in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Cohort Retention Matrix into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
A SQL query that outputs month-by-month user retention data, visualized as a color-coded matrix in Excel
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Cohort Retention Matrix against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Year-over-Year (YoY) Growth Barometer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Year-over-Year (YoY) Growth Barometer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Visualizing this year's sales vs last year's sales using bullet graphs or combo charts
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Year-over-Year (YoY) Growth Barometer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Inventory Treemap Visualizer in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Inventory Treemap Visualizer into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
Visualizing warehouse footprint by product category to optimize storage space
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Inventory Treemap Visualizer against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Project Gantt Chart Generator in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Project Gantt Chart Generator into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
A dynamic Excel Gantt chart that automatically plots start/end bars based on raw SQL task data
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Project Gantt Chart Generator against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Define Project Brief
Write the objective, scope, inputs, constraints, and acceptance criteria for Automated P&L (Profit & Loss) Statement in Data Foundations & Visual Analytics (Excel/SQL).
Submission
Brief document with objective, scope, assumptions, and acceptance criteria.
AI Review Focus
Checks clarity, scope, realism, and alignment with the selected course topic.
Plan Workflow
Break Automated P&L (Profit & Loss) Statement into milestones, required tools, source data, validation rules, and final output format.
Submission
Milestone checklist with tools, data requirements, and review plan.
AI Review Focus
Checks sequencing, tool fit, completeness, and execution readiness.
Build Core Output
A strictly formatted financial report that aggregates raw ledger data into standard accounting rows
Submission
Project file, repository, design link, spreadsheet, report, or implementation artifact.
AI Review Focus
Checks whether the artifact is complete, structured, practical, and reviewable.
Document and Review
Explain key decisions, test Automated P&L (Profit & Loss) Statement against the brief, and record fixes or limitations.
Submission
README, decision log, quality checklist, screenshots, or demo notes.
AI Review Focus
Checks reasoning quality, evidence of review, and portfolio presentation readiness.
Why Choose This Course
Strong reasons learners choose this track over passive learning
Clear, high-signal benefits designed to make the decision easier and faster.
Guided Practical Workflow
The track breaks Data Foundations & Visual Analytics (Excel/SQL) into clear tasks, checkpoints, and submission expectations.
Career-Relevant Output
You finish with a concrete project artifact that helps show your learning progress.
Structured Internship Path
The program is organized by tier, duration, and portfolio requirements so learners know exactly what to complete.
Social Proof
Real learner signals that build trust before they enroll
Testimonial cards designed to feel credible, clear, and easy to scan.
“
A
Aarav Mehta
Technology & Data Learner
Data & Analytics
The structure helped me understand Data Foundations & Visual Analytics (Excel/SQL) through practical tasks and clear checkpoints.
“
N
Nisha Kapoor
College Student
Data & Analytics
I liked that every module ended with something concrete to submit, review, and improve.
FAQs
Clear answers for the final questions learners usually ask
Short, direct answers that remove hesitation without slowing down the decision.
No. The beginner tier starts with foundations and then moves into applied tasks.
Yes. The curriculum is organized around structured assignments, submissions, and reviewable portfolio outputs.
This is a 45 Days Beginner tier track with 3 Portfolio Projects Required.
Final Step
Ready to start your journey?
Join a structured learning path built to turn clarity into output and output into confidence.
Limited seats available and the next batch is filling soon.
Partner With Engineers Clinic
Tell us about your institution and our partnership team will connect with you for the next steps.
Referral Rewards
Give 10% • Get 10%
Invite friends to Engineers Clinic and unlock rewards together.
Your referral code
Referral link preview
12
Successful Referrals
₹2.4k
Rewards Earned
3
Pending Rewards
How it works
01
Share Link
02
Friend Enrolls
03
Both Get Rewards