I am a passionate Data Analyst dedicated to transforming raw data into meaningful business insights through data cleaning, analysis, visualization, and interactive dashboard development.
I enjoy solving real-world business problems using Excel, SQL, and Power BI by combining data analysis, automation, and interactive dashboards to support data-driven decision-making.
- 📊 Passionate about Data Analytics and Business Intelligence
- 📈 Building interactive dashboards using Excel and Power BI
- 📚 Skilled in SQL, Excel, and Power BI
- 🧹 Experienced in data cleaning, transformation, and analysis
- 💡 Turning business data into actionable insights
- 🌍 Based in Nigeria
- 🚀 Currently expanding my knowledge in advanced analytics and Python
- Microsoft Excel
- SQL (MySQL)
- Microsoft Power BI
- Power Query
- DAX
- Pivot Tables
- Pivot Charts
- XLOOKUP
- IF / IFS
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- Conditional Formatting
- Data Validation
- Excel Dashboards
- Charts
- Lookup & Reference Functions
- Data Cleaning
- Data Cleaning
- Joins
- Window Functions
- Subqueries
- CASE Statements
- Aggregate Functions
- GROUP BY
- ORDER BY
- Business KPI Calculations
- Date Functions
- Data Modeling
- Power Query
- DAX
- DAX Variables (VAR)
- Interactive Dashboards
- KPI Cards
- Navigation Buttons
- Custom Tooltips
- Conditional Formatting
- Heat Maps
- Interactive Filtering
- Slicers
- Business Reporting
Designed and developed an Excel-based operations management dashboard to organize customer support tickets, automate ticket prioritization using VBA, streamline engineering workflows, and provide management with actionable operational insights.
The solution incorporates Pivot Tables, Pivot Charts, Conditional Formatting, Data Validation, Excel formulas, and VBA automation to improve ticket management, reporting efficiency, and engineering prioritization.
Tech Used: Microsoft Excel • VBA • Pivot Tables • Pivot Charts • Conditional Formatting • Data Validation • Excel Formulas
Interactive Power BI dashboard analyzing lending performance, loan portfolio quality, funding, repayments, borrower behavior, and financial KPIs.
Tech Used: MySQL • Power BI • Power Query • DAX
Business intelligence dashboard analyzing sales performance, customer purchasing behavior, Month-over-Month growth, product performance, and store operations using advanced DAX measures and SQL.
Tech Used: MySQL • Power BI • DAX • Power Query
Interactive sales dashboard analyzing restaurant performance, revenue trends, product performance, customer ordering behavior, and best/worst-selling pizzas.
Tech Used: MySQL • Power BI
Power BI dashboard exploring electric vehicle adoption, manufacturer performance, CAFV eligibility, electric range, and market trends.
Tech Used: Power BI • Power Query • DAX
SQL project analyzing election results using multiple relational tables, joins, aggregations, and business-focused analytical queries.
Tech Used: MySQL
- SQL (MySQL)
- Microsoft Excel
- Microsoft Power BI
- Power Query
- DAX
- KPI Reporting
- Dashboard Development
- Business Analysis
- Data Visualization
- Data Modeling
- Data Cleaning
- Data Transformation
- Data Validation
- Python for Data Analytics
- Data Storytelling
- Advanced Business Intelligence Techniques
My goal is to become a highly skilled Data Analyst who helps organizations make data-driven decisions through meaningful analysis, interactive dashboards, and business intelligence solutions.
Feel free to explore my repositories, review my projects, and connect with me. I'm always open to learning, collaboration, and new opportunities in Data Analytics and Business Intelligence.