Skip to content
View UgoIkem's full-sized avatar

Block or report UgoIkem

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
UgoIkem/README.md

Hi, I'm Ugo Ikem 👋

Data Analyst | SQL • Power BI • Tableau • Python • Excel

I transform operational, financial, and customer data into actionable insights that support better business decisions.

SQL Python Excel Power BI Tableau


👨‍💻 About Me

  • 📍 Based in Portugal
  • 📊 Experienced in analysing operational, financial, and customer data using SQL, Power BI, Tableau, Python, and Excel
  • 📈 Build interactive dashboards, KPI reporting solutions, and analytical models that turn complex data into clear business insights
  • 🔍 Interested in identifying trends, investigating anomalies, understanding business performance, and translating analysis into actionable recommendations

📂 Featured Projects

📊 Marketing Campaign Performance Analysis | Excel

Interactive marketing analytics project analysing campaign, channel, audience and geographic performance across approximately 200K campaign records.

Skills demonstrated

  • Excel, Power Query & Power Pivot
  • DAX & Data Modelling
  • Campaign ROI Analysis
  • Funnel & Conversion Analysis
  • Channel Performance Analysis
  • Month-over-Month Analysis
  • Business Insights & Recommendations

🔗 View Project Repository

📊 Finance Analytics Dashboard | Power BI

End-to-end financial analytics solution analysing transaction performance, customer behaviour, transaction status, geographic trends, and year-over-year performance.

Skills demonstrated

  • Power BI & Power Query
  • Data Modelling
  • DAX & Time Intelligence
  • Year-over-Year Analysis
  • Field Parameters & Dynamic Metrics
  • Interactive Filtering & Drill-through

🔗 View Project Repository
📊 View Live Power BI Dashboard


📊 HR Analytics Dashboard | Tableau

Interactive HR analytics dashboard exploring employee attrition, workforce demographics, job satisfaction, and employee trends.

Skills demonstrated

  • Tableau
  • Dashboard Design
  • Data Visualization
  • Interactive Filters
  • KPI Development
  • Business Storytelling

🔗 View Project Repository


🍽 Food Service Database | SQL Server

Designed and implemented a relational SQL Server database to support structured data storage, business queries, and analytical reporting.

Skills demonstrated

  • SQL Server
  • Relational Database Design
  • ERD Design
  • Normalization (3NF)
  • Stored Procedures
  • Views
  • Business Queries

🔗 View Project Repository


👥 User Segmentation Analysis | SQL

Analysed user engagement, feature adoption, and retention behaviour to identify customer segments and usage patterns.

Skills demonstrated

  • SQL Analysis
  • User Segmentation
  • Customer Analytics
  • Feature Adoption Analysis
  • Retention Analysis
  • Business Insights

🔗 View Project Repository


🎬 TMDB Movie Analysis | Python

Exploratory data analysis of movie data to uncover patterns in revenue, ratings, popularity, and genres.

Skills demonstrated

  • Python
  • Pandas
  • Data Cleaning
  • Exploratory Data Analysis
  • Data Visualization
  • Matplotlib

🔗 View Project Repository


🏥 Hospital Management Database | SQL Server

Developed a relational hospital database demonstrating database design, data integrity, and reusable SQL components.

Skills demonstrated

  • SQL Server
  • Relational Database Design
  • T-SQL
  • Constraints
  • Views
  • Functions
  • Stored Procedures
  • Triggers

🔗 View Project Repository


🤝 Let's Connect

📍 Portugal

LinkedIn

Email


⭐ Explore my repositories for examples of how I use data to investigate business problems, build analytical solutions, and communicate actionable insights.

Pinned Loading

  1. marketing-campaign-analysis-excel marketing-campaign-analysis-excel Public

    Interactive Excel marketing performance dashboard using Power Query, Power Pivot, DAX, data modeling, and dynamic KPI analysis.

  2. Finance-Analytics Finance-Analytics Public

    End-to-end Power BI finance analytics project featuring data modelling, DAX, time intelligence, dynamic metrics, YoY analysis and interactive dashboards.

  3. HR-Analytics-Dashboard-Tableau HR-Analytics-Dashboard-Tableau Public

    Interactive Tableau dashboard analysing employee attrition, workforce demographics and HR metrics.

  4. foodservice-database-project foodservice-database-project Public

    SQL Server database design and analysis project using restaurant, consumer and ratings data. Includes ERD, SQL queries, stored procedures and business insights.

  5. autogenai-user-segmentation-analysis autogenai-user-segmentation-analysis Public

    Data analytics project exploring user engagement, feature adoption, and retention patterns on an AI platform using MySQL.

  6. TMDB-PROJECT TMDB-PROJECT Public

    Exploratory data analysis of TMDB movie data using Python to uncover trends in revenue, ratings, popularity and genres.

    Jupyter Notebook