A centralized repository documenting my data analytics workflow, methodologies, and actionable insights developed during my internship at DecodeLab.
- Spreadsheets: Microsoft Excel (Data cleaning, formatting, and initial manipulation)
- Database Querying: SQL (Relational data extraction and aggregation)
- Business Intelligence: Power BI (Interactive dashboards and visual reporting)
Status: Completed Tools Used: Excel
- Objective: To audit, clean, and standardize the raw dataset, ensuring high data integrity before any analysis or visualization takes place.
- Analytical Decisions: * Verified 100% data integrity across all structural columns.
- Audited duplicate
Customer_IDinstances, confirming them as valid repeat transactions to preserve statistical power. - Validated that temporal data complies with ISO 8601 and categorical variables strictly adhere to standard naming conventions.
- Audited duplicate
| Week/Task | Project Name | Description | Status |
|---|---|---|---|
| Week 1 | Data Cleaning Log | Structural integrity audit and dataset standardization. | Completed |
- GitHub: @Only-Eni