### Analysis on ICT Acceptance in SMEs in Nigeria
Excel-Power BI Project | SMEs Data | From Raw Data To Business Data
### Table of Contents
* Project Overview
* Tools & Technology
* Dataset Overview
* Data Cleaning & Transformation
* Exploratory Data Analysis
* Power BI Dashboard
* Key Metrics
* Findings
* Recommendations
* Future Work
### Project Overview
This project investigates the acceptance of Information and Communication Technology (ICT) among small and medium enterprises (SMEs),
focusing on their ICT needs, business challenges, and the degree of ICT adoption.
Data was gathered via a structured questionnaire, capturing insights from SME representatives on their specific business requirements and challenges related to ICT.
The data was cleaned using Microsoft Excel's Power Query to ensure accuracy and consistency, followed by preliminary analysis and visualization in Excel.
Key findings were then presented in a dynamic Power BI dashboard and a Microsoft PowerPoint presentation for stakeholders.
The project's ultimate aim is to empower SMEs to enhance ICT integration within their operations, addressing adoption barriers and highlighting practical steps for digital transformation,
which is critical for boosting efficiency and competitiveness.
### Tools & Technology
* Excel
* Power BI
### Dataset Overview
Columns:
* Type of business (e.g., retail, services)
* Business status (e.g., registered, unregistered)
* Use of ICT tools in business operations
* Main purpose for using ICT tools (e.g., communication, accounting)
* Frequency of internet usage in business
* Major concerns about ICT adoption
* Major challenges faced in adopting ICT
* Beliefs about ICT’s potential to solve major business challenges
Sample Preview
| What kind of business do you run? | What is your business status? | How many employees do you have in the business you engage in? | Where is the business located |
|-----------------------------------|-------------------------------|------------ …