Ruth-Chika/business-digital-readiness

Data analysis project assessing the digital readiness of local businesses in Abuja, Nigeria using SQL and Power BI # business-digital-readiness Data analysis project assessing the digital readiness of local businesses in Abuja, Nigeria using SQL and Power BI # 📊 Business Digital Readiness Dashboard > Analysis of 100 businesses in Abuja, Nigeria measuring digital transformation readiness SQL queries.txt !( .png) ## 🎯 Project Overview This project analyzes the digital readiness of local businesses across four industries in Abuja, answering key questions about website adoption, social media presence, and the relationship between technology and customer satisfaction. ### Key Findings - 📱 **91% use Instagram** but only 67% use Facebook - 🌐 **Only 55% have websites** in 2026 - 📱 **Just 44% are mobile-friendly** - ⭐ **No correlation found** between digital readiness and customer ratings (4.58-4.71 across all maturity levels) - 📸 **Photo Studios lead** (68.6/100 avg score), **Laundry services lag** (56.8/100) ### Business Questions Answered 1. How digitally ready are businesses overall? 2. What's the adoption rate of websites, social media, and online ordering? 3. Which categories are most/least digitally advanced? 4. Where are digitally lagging businesses located geographically? 5. Does digital readiness correlate with customer ratings? ## 🛠️ Tools & Technologies - **Data Collection:** Instant Data Scraper + Manual verification - **Database:** MySQL 8.0 - **Data Cleaning:** SQL (CASE statements, string manipulation) - **Analysis:** Power BI Desktop, DAX - **Visualization:** Power BI (dark theme, custom icons) - **Design:** Canva (for custom icons) ## 📂 Files Included - `dashboard.pbix` - Complete Power BI dashboard with all visuals and data model - `sql_queries.sql` - All SQL code (table creation, cleaning, feature engineering, analysis) - `dashboard.png` - Dashboard screenshot - `README.md` - Project documentation (you're reading it!) ## 📊 Dataset - **Sample Size:** 100 businesses - **Categories:** - Fashion Design (18) - Gym (30) - Laundry (19) - Photo Studio (33) - **L …