
About Me

I’m Dr. Michael Chibuike Mgbeokwere, a dental surgeon and data analyst with a passion for transforming data into actionable insights. Leveraging my healthcare expertise and proficiency in Excel, Power BI, Tableau and SQL, i deliver clear, comprehensive and impactful analysis to drive decision making in organizations across various sectors such as healthcare, business, education and beyond.
Skills
-
Microsoft Excel: Data cleaning, Pivot tables, Data visualization, Dashboards, Power Query, Power Pivot, VBA for automation
-
Power BI: Data modeling, Power Query, DAX, Data visualization, Interactive dashboards, Row-Level security
-
Tableau: Data visualization, Calculated fields, Interactive dashboards, Storytelling
-
Microsoft SQL Server: Complex queries, Joins, Window functions, database optimization
-
Statistics and Mathematics: Descriptive Statistics, Probability, Inferential Statistics, Correlation and Regression, Data literacy
Projects
1. Analysis of Healthcare Accessibility in Africa (Power BI)
- Description: Developed interactive dashboards to analyze healthcare facility data across Africa, identifying urban-rural disparities and proposing data-driven recommendations to improve service delivery for governments and stakeholders.
- Tools: Microsoft Power BI
- Analysis Performed:
- Urban-Rural healthcare facility distribution.
- Funding disparities between urban and rural healthcare facilities.
- Relationship between emergency response time and funding.
- Efficiency of healthcare services.
- Recommendations: Rural healthcare access and infrastructure optimization, need-based funding distribution model, expand emergency response system and healthcare workforce and strnghten stakeholders collaboration.
- Files: View Healthcare Accessibility Dashboard.pdf
- Dashboard:

2. Water Access and Sanitation in Africa: A Case Study (SQL - SSMS)
- Objective: Analyzed water access and sanitation data across African communities using SQL in SQL Server Management Studio (SSMS) to identify patterns and propose data-driven recommendations for improving water infrastructure and reducing waterborne diseases.
- Tools Used: SQL (SSMS), Excel
- Analysis Performed:
- Calculated average water availability per country.
- Identified communities with non-functional water points and high waterborne disease rates (>20% incidence).
- Analyzed maintenance costs, distances to water sources, and support from government/NGOs.
- Recommendations: Proposed infrastructure rehabilitation, cost audits, clean water initiatives, Health interventions and expanded support for underserved communities.
- Project File: View Project Report (pdf)
Certificates
Cisco Networking Academy
Foresight BI
Great Learning
HP LIFE (HP Foundation)
Skillup by Simplilearn
Udemy
- Business Analyst Career Path: 22 Days BI Analytics Bootcamp - View Certificate
- Data Analysis with SQL, Tableau, Power BI and Excel; Real Projects - View Certificate
- Statistics for Data Science and Business Analysis - (instructors: 365 Careers) View Certificate
- SQL with SQL Server Management Studio (SSMS) - View Certificate
Connect with me for data analytics collaborations or opportunities!