NCLab - Data Literacy

Summer 1

Course Description

NCLab's Data Literacy program is a project-based series covering the core data analyst toolkit: exploratory analysis and predictive modeling in Excel, data cleaning and dashboarding in Sheets, and interactive dashboard design in Power BI.

Projects

Palmer Penguins Review: A Predictive Model Approach

Explored the Palmer Penguins dataset in Excel and built a linear regression model showing flipper length as a reliable predictor of body mass.

View Report

HR Attrition Analysis (Sheets Capstone)

Cleaned and profiled an HR attrition dataset in Google Sheets, then built a dashboard analyzing employee attrition patterns by department, satisfaction, and tenure.

HR Attrition dashboard

Download Spreadsheet (.xlsx)

Iris Review: A Power BI Dashboard (Capstone IV)

Built an interactive Power BI dashboard analyzing the Iris dataset, with dynamic filtering and slicers across sepal/petal measurements and species.

View Write-up · View Dashboard · Download Dataset (.csv)