DecodeLabs - Data Analytics Internship

Welcome to my DecodeLabs Data Analytics Internship repository.

This repository contains all internship tasks completed during my internship at DecodeLabs. Each task demonstrates practical data analytics skills and documents my learning journey throughout the internship.

📁 Repository Structure

Task 1 - Data Cleaning & Wrangling

• Data quality assessment
• Data validation
• Missing value handling
• Data preparation using Microsoft Excel

📊 Task 2 - Exploratory Data Analysis & Interactive Dashboard

Performed comprehensive exploratory data analysis on a retail sales dataset using Microsoft Excel. Designed Pivot Tables, Pivot Charts, KPIs, and an interactive dashboard with slicers to provide meaningful business insights.

Skills Demonstrated

• Exploratory Data Analysis (EDA)
• Statistical Analysis
• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Dashboard Design
• Data Visualization
• Business Analytics

🗄️ Task 3 – SQL Data Analysis

This project focuses on analyzing a retail sales dataset using MySQL. SQL queries were written to perform data exploration, filtering, sorting, aggregation, grouping, and business-oriented analysis.

Project Highlights

• Database Creation & Management
• Data Import into MySQL
• SQL Data Exploration
• Filtering & Sorting
• Aggregate Functions
• Product Performance Analysis
• Customer Behavior Analysis
• Payment Method Analysis
• Referral Source Analysis
• Order Status Analysis
• Business Insights Reporting

Skills Demonstrated

• SQL
• MySQL
• Data Analysis
• Database Management
• Business Intelligence
• Analytical Thinking

Task 4

To be updated.

🛠️ Tools & Technologies

• Microsoft Excel
• Python
• NumPy
• Pandas
• Matplotlib
• Seaborn
• Power BI
• MySQL

👨‍💻 Author

Muhammad Zain Chawala

BS Computer Science Student | Data Analytics Intern

---

This repository is maintained as part of the DecodeLabs Data Analytics Internship Program.