Welcome to my Data Analytics Portfolio.
This repository serves as a central hub for my analytics projects, showcasing end-to-end solutions built using Python, MySQL, Microsoft Excel, and Power BI.
This portfolio demonstrates my ability to complete end-to-end data analytics projects using industry-standard tools and best practices. And each project demonstrates my ability to transform raw data into actionable business insights through data cleaning, exploratory analysis, SQL querying, visualization, dashboard development, and business recommendations.
Each project follows a structured workflow:
- Business Problem
- Business Questions
- Data Cleaning
- Exploratory Data Analysis (EDA)
- SQL Analysis
- Dashboard Development
- Business Insights
- Actionable Recommendations
The portfolio spans multiple domains, including retail, supply chain, education, and human resources, showcasing transferable analytical skills across industries.
- Data Cleaning
- Exploratory Data Analysis (EDA)
- SQL Querying
- Data Visualization
- Dashboard Development
- Business Intelligence
- Statistical Analysis
- Reporting
| Tool | Purpose |
|---|---|
| Python | Data Cleaning & Analysis |
| MySQL | SQL Analysis |
| Microsoft Excel | Data Analysis & Dashboards |
| Power BI | Interactive Dashboards |
| Git & GitHub | Version Control |
| Project | Domain | Description | Tools | Status |
|---|---|---|---|---|
| 🛍️ Retail Sales Performance Analysis | Retail Analytics | End-to-end retail analytics dashboard and business insights | Python, MySQL, Excel, Power BI | ✅ |
| 🌾 Agricultural Supply Chain Analysis | Supply Chain | Supply chain performance and operational analysis | Python, MySQL, Excel, Power BI | 🚧 |
| 🎓 Student Performance Analysis | Education | Educational performance analytics and dashboard | Python, MySQL, Excel, Power BI | 🚧 |
| 🛒 Supermarket Sales Performance Analysis | Retail Analytics | Retail analytics dashboard and business insights | Excel | ✅ |
| 💰 Furniture Sales Performance Analysis | Retail Analytics | Retail analytics dashboard and business insights | Excel | ✅ |
| 👥 HR Analytics | Human Resources | Workforce analytics and employee insights | Excel | 🚧 |
| 💰 Dexa Sales Analysis | Retail Analytics | Retail analytics dashboard and business insights | Power Query, Power BI | ✅ |
Future portfolio projects include:
- Customer Churn Analysis
- Financial Sales Dashboard
- Marketing Campaign Analysis
- E-Commerce Customer Segmentation
- Healthcare Analytics
- Banking Analytics
- Supply Chain Analytics
- HR Workforce Analytics
Blessing Usieme
Data Analyst - Business Intelligence | Data Visualization and Storytelling