🚀 DecodeLabs Data Analytics Internship

Welcome to my DecodeLabs Data Analytics Internship repository!

This repository showcases the practical projects I completed during my internship at DecodeLabs, where I gained hands-on experience across the complete data analytics lifecycle—from cleaning raw data to building interactive dashboards.

---

👨‍💻 About Me

Hi, I'm Alabi Timilehin Victor, a Mechatronics Engineering graduate with a passion for Data Analytics and Business Intelligence.

Throughout this internship, I strengthened my analytical thinking and technical skills by working on real-world datasets using Microsoft Excel, SQL, and Power BI.

---

📂 Internship Projects

Project	Description	Tools
📊 Project 1	Data Cleaning & Preparation	Excel
📈 Project 2	Exploratory Data Analysis (EDA)	Excel
🗄 Project 3	SQL Data Analysis	MySQL Workbench
📉 Project 4	Interactive Sales Dashboard	Power BI

---

📊 Project Highlights

📌 Project 1 – Data Cleaning

Objective

Cleaned and prepared raw sales data for analysis.

Tasks Performed

• Removed duplicates
• Handled missing values
• Standardized text formatting
• Formatted dates and currency values
• Improved data consistency

---

📌 Project 2 – Exploratory Data Analysis (EDA)

Objective

Explored the cleaned dataset to uncover trends and patterns.

Analysis Included

• Summary Statistics
• Best Selling Products
• Highest Revenue Products
• Most Used Payment Method
• Most Common Order Status

---

📌 Project 3 – SQL Data Analysis

Objective

Performed data analysis using SQL queries.

SQL Concepts Used

• SELECT
• WHERE
• ORDER BY
• GROUP BY
• COUNT()
• SUM()
• AVG()
• LIMIT

---

📌 Project 4 – Data Visualization

Objective

Developed an interactive Sales Performance Dashboard using Microsoft Power BI.

Dashboard Features

• KPI Cards
• Revenue Analysis
• Best Selling Products
• Payment Method Distribution
• Order Status Distribution
• Interactive Slicers

Skills Applied

• Data Visualization
• Dashboard Design
• DAX Measures
• Business Intelligence
• Data Storytelling

---

🛠 Tools & Technologies

• Microsoft Excel
• MySQL Workbench
• Microsoft Power BI
• Git & GitHub

---

💡 Skills Gained

• Data Cleaning
• Data Preparation
• Exploratory Data Analysis
• SQL Query Writing
• Dashboard Development
• DAX
• Data Visualization
• Business Intelligence
• Data Storytelling
• Problem Solving

---

📷 Dashboard Preview

Upload a screenshot of your Power BI dashboard inside the Project-4-Data-Visualization folder and replace the filename below if necessary.

![Sales Dashboard](Project-4-Data-Visualization/Dashboard_Screenshot.png)

---

📈 Internship Outcome

This internship significantly improved my ability to transform raw data into actionable insights using industry-standard tools.

Through these projects, I gained practical experience in:

• Cleaning messy datasets
• Performing exploratory data analysis
• Writing SQL queries for business insights
• Designing interactive dashboards in Power BI
• Communicating findings through data storytelling

---

🤝 Connect With Me

LinkedIn:
www.linkedin.com/in/timilehin-alabi-4b7537204

GitHub:
https://github.com/Timmydiamond16

---

⭐ Thank you for visiting my repository. Feedback and suggestions are always welcome!