Skip to content
View ismailmdzani's full-sized avatar

Block or report ismailmdzani

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.

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
ismailmdzani/README.md

Hi there, I'm Ismail Md Zani πŸ‘‹

πŸŽ“ Final-year Mathematics undergraduate at Universiti Teknologi Malaysia (UTM)
πŸ“Š Aspiring Data Analyst with interests in data analytics, business intelligence and quantitative analysis
🧠 Experienced with Excel, SQL, Python and quantitative research
🌱 Currently expanding my skills in Power BI and data visualization
πŸ—£οΈ Languages: Malay, English


πŸ“Š Portfolio Projects

πŸ›’ SQL E-Commerce Analysis

View Project

Tools: SQL β€’ SQLite β€’ DB Browser for SQLite

Analysed a Brazilian e-commerce dataset to explore customer behaviour, sales performance, product trends, revenue and freight costs.

Key areas explored:

  • Customer and order analysis
  • Revenue and monthly sales trends
  • Product category performance
  • Freight cost analysis
  • Business insights from transactional data

πŸ“ˆ Maven Toys Sales & Inventory Dashboard

View Project

Tools: Microsoft Excel β€’ Data Model β€’ DAX β€’ PivotTables β€’ PivotCharts

Built an interactive Excel dashboard to analyse sales performance, profitability, product trends, store performance and inventory health.

Key areas explored:

  • Monthly revenue and profit trends
  • Product category and product performance
  • Store and location performance
  • Inventory value and stock status
  • Interactive filtering using slicers and timeline

☎️ JPD Call Centre Performance Dashboard

View Project

Tools: Microsoft Excel β€’ Advanced Formulas β€’ Named Ranges β€’ PivotTables β€’ Charts

Completed an advanced coursework-based Excel dashboard analysing 46,380 call centre records to monitor operational KPIs, service targets and agent performance.

Key areas explored:

  • Monthly call volume and service performance
  • Complaint rates and customer satisfaction
  • Call resolution and abandonment rates
  • Agent performance against operational targets
  • Interactive month selection and scrollable agent analysis

βš™οΈ Weekly Timesheet VBA Automation

View Project

Tools: Microsoft Excel β€’ VBA β€’ Excel Macros β€’ Named Ranges β€’ Formulas

Completed a coursework-based Excel VBA project that automates weekly timesheet creation, daily pay calculations and weekend rates.

Key features:

  • Creates a new weekly timesheet automatically
  • Collects the week-commencing date using an input box
  • Calculates weekday pay using a named hourly rate
  • Applies a 1.5Γ— rate for Saturday and Sunday
  • Generates daily formulas and the weekly total
  • Runs through a worksheet button or keyboard shortcut

πŸ† Achievements

  • πŸ₯‰ Bronze Award β€” IWP-IRC 2026

    • Awarded for research on rainfall trend analysis using polynomial regression
  • πŸ“„ First-Author Research Publication

    • Published research on rainfall trends in Pahang, Malaysia

πŸ”¬ Research & Publication


πŸŽ“ Certifications

Macquarie University

University of California, Davis

Universiti Teknologi Malaysia

  • πŸ“ˆ Data Analytics for Organisation

πŸ› οΈ Technical Skills

Data Analytics & Programming

Microsoft Excel SQL SQLite Python

Python Libraries

Pandas NumPy Matplotlib

Tools & Platforms

GitHub Jupyter

Other: GNU Octave β€’ DB Browser for SQLite β€’ Polynomial Regression β€’ Statistical Analysis


πŸ“« Connect with Me

LinkedIn Email

Pinned Loading

  1. SQL-Ecommerce-Analysis SQL-Ecommerce-Analysis Public

    SQL project analyzing an e-commerce dataset to uncover customer behavior, sales performance and business insights using SQLite.

  2. Maven-Toys-Sales-Inventory-Dashboard Maven-Toys-Sales-Inventory-Dashboard Public

    Interactive Excel dashboard analysing Maven Toys sales performance, product trends, store performance and inventory health.

  3. JPD-Call-Centre-Performance-Dashboard JPD-Call-Centre-Performance-Dashboard Public

    Advanced Excel coursework dashboard analysing 46,380 call centre records, service targets and agent performance.

  4. Weekly-Timesheet-VBA-Automation Weekly-Timesheet-VBA-Automation Public

    Excel VBA coursework project automating weekly timesheet creation, daily pay calculations and weekend rates.