# Meredith Smith
MS in Data Analytics (Data Science Concentration)
## Skills
- Python
- SQL
- (Power BI)
- Machine Learning
- Pandas
- Scikit-Learn
- (AWS)
## Tentative Projects:
### Customer Churn Prediction
Predicts customer attrition using machine learning.
### Retail Sales Dashboard
Interactive Power BI dashboard built from SQL data.
### Data Engineering Pipeline
ETL pipeline using Python and cloud services.
## Contact
LinkedIn: ...
Email: ...
3 featured repositories.
GitHub
│
├── analytics-dashboard-project
├── customer-churn-prediction
├── data-engineering-pipeline
└── profile-readme
Repository name:
retail-sales-analytics-dashboard
Structure:
retail-sales-analytics-dashboard
│
├── data
├── sql
├── dashboard
├── screenshots
├── reports
└── README.md
README sections:
# Retail Sales Analytics Dashboard
## Business Problem
A retailer needs insights into sales performance.
## Tools
- SQL
- Python
- Power BI
## Key Findings
- Western region generated highest revenue.
- Product category X drove most profit.
- Seasonal demand spikes occurred in Q4.
## Dashboard
[Insert screenshots]
## Repository Contents
- SQL queries
- Data cleaning scripts
- Dashboard filescustomer-churn-prediction
Structure:
customer-churn-prediction
│
├── notebooks
├── data
├── models
├── visualizations
└── README.md
This README contains:
# Customer Churn Prediction
## Objective
Predict customers likely to cancel services.
## Dataset
Source description
## Process
1. Data Cleaning
2. Exploratory Analysis
3. Feature Engineering
4. Model Training
5. Evaluation
## Results
Accuracy: XX%
ROC-AUC: XX%
## Business Impact
Retention teams can prioritize high-risk customers.Includes:
- ROC curve
- Feature importance chart
- Confusion matrix
Repository name:
ecommerce-data-pipeline
Structure:
ecommerce-data-pipeline
│
├── ingestion
├── transformation
├── loading
├── workflow
├── diagrams
└── README.md
Includes an architecture diagram.
Example:
Raw Data
↓
Python ETL
↓
SQL Database
↓
Analytics Tables
↓
Power BI Dashboard
This shows data movement, not just analysis.
Each repo includes:
Problem
Approach
Tools
Results
Screenshots
Future Improvementsscreenshots/
with:
- Dashboards
- Charts
- Model results
Since most recruiters won't run code...
Include screenshots.
My best work.
Recommended:
- Retail Analytics Dashboard
- Customer Churn Prediction
- Data Engineering Pipeline
- Master's Capstone
- PL-300 Certification Project
- Personal Website
Simple portfolio site using:
- GitHub Pages
- Streamlit
- Tableau Public
- Power BI Public
Includes:
About Me
Resume
Projects
Certifications
Contact Information
Link is also on:
- On LinkedIn
- On your resume
- In your GitHub profile
Targeted stack before graduation:
SQL
Python
Power BI
Machine Learning
GitHub
AWS (basic)
And these 3 flagship projects:
- Business Dashboard (Power BI + SQL)
- Customer Churn Prediction (ML)
- Cloud/Data Pipeline Project
That portfolio aligns with the majority of entry-level Data Analyst, BI Analyst, Analytics Engineer, and Junior Data Scientist openings.