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
Report
Description
Explored the Palmer Penguins dataset in Excel and built a linear regression model showing flipper length as a reliable predictor of body mass.
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.
Iris Review: A Power BI Dashboard (Capstone IV)
Write-up
Dashboard
Description
Built an interactive Power BI dashboard analyzing the Iris dataset, with dynamic filtering and slicers across sepal/petal measurements and species.