Iffat Ayman Ahnaf

Data Analyst in Training

About Me

Iffat Ayman Ahnaf

I hold a degree in Islamic Economics and am currently advancing my expertise in Data Analytics to connect business insights with data-driven decision-making.

With a solid background in economic analysis and statistics, I thrive on transforming complex datasets into actionable insights that drive strategic decisions and enhance performance. My key interests lie in leveraging data to understand customer behavior, streamline operations, and predict future trends.

My Projects

RFM Segmentation

RFM Customer Segmentation Dashboard

Super Store Customer Segmentation Analysis Based on Recency, Frequency, and Monetary Model to Identify High-Value Customers and Optimize Business Strategy.

Case Study: web scraping

Web Scraping: Data Analyst Job Vacancy

This notebook shows the end-to-end workflow of scraping job listings from Jobstreet, cleaning the collected data, and performing exploratory analysis to identify top hiring companies, most active cities, and the most in-demand job categories.

Data Manipulation

Python Case Study: Data Manipulation

This notebook is a data analysis assignment on supermarket sales dataset. The primary goal is to apply data manipulation techniques (Filtering, Sorting, Grouping/Aggregation, Join/Merging, Pivot, Crosstab, Appending, and Datetime operations) to gain insights from the data.

SQL Intermediate Case Study

SQL Intermediate Case Study

This project showcases intermediate-level SQL queries applied to a retail relational dataset consisting of customers, orders, products, and order items. It covers multi-table JOINs, subqueries, CTEs, window functions, and advanced aggregations. All queries are executed in PostgreSQL using DBeaver.

Case Study: Basic SQL

SQL Basic Case Study

This project contains basic SQL query exercises for data manipulation and retrieval from two database schemas: dibimbing and dvdrental. It focuses on creating tables, inserting data, aggregate functions, conditional logic, JOIN, and UNION operations.

Technical Skillset

Data Visualization

  • Power BI
  • Excel Dashboards
  • Tableau

Data Analysis

  • SQL
  • Python
  • Data Cleaning & Transformation

Business & Analytics

  • Economic & Business Analysis
  • KPI Development
  • Basic Forecasting
  • Insight & Reporting

Send me a message

Interested in collaborating or have questions about my work? Kindly reach out!