End-to-End Data Analytics Project

Choose ONE of the following project tracks. Each track presents a unique challenge and allows you to specialize in a specific area of data analytics.

Regardless of which project option you choose, your project must include ALL of the following components:

Your final submission must include all of the following files in your Google Drive folder:

Folder Structure

Data-Analytics-Final-Project-[YourName]/
├── README.md                      # Project overview, setup instructions, key findings
├── data/
│   ├── raw/                       # Original, unprocessed data files
│   └── processed/                 # Cleaned and transformed data
├── sql/
│   └── queries.sql                # All SQL queries with comments
├── excel/
│   └── analysis.xlsx              # Excel analysis with pivot tables
├── notebooks/
│   ├── 01_data_exploration.ipynb  # EDA notebook (if using Python)
│   └── 02_analysis.ipynb          # Advanced analysis notebook
├── powerbi/
│   └── dashboard.pbix             # Power BI dashboard file
├── tableau/
│   └── dashboard.twbx             # OR Tableau workbook (if using Tableau)
├── docs/
│   ├── executive_summary.pdf      # Executive summary document
│   └── data_dictionary.md         # Data dictionary
├── screenshots/
│   ├── dashboard_page1.png        # Dashboard screenshots
│   ├── dashboard_page2.png
│   └── dashboard_page3.png
└── presentation/
    └── final_presentation.pdf     # Optional presentation slides

Create a Google Drive folder with the exact name shown below and share with view access:

Your final project will be graded on the following criteria:

Grading Scale