I am a Data Analyst with an IT background and more than 10 years of experience in reporting, KPI performance, and business support in large telecommunications companies. I enjoy transforming raw data into clear insights and dashboards using Python, SQL, Excel, and visualization tools.
This portfolio highlights selected data analytics & business intelligence projects and a few supporting web development and programming projects that strengthen my technical foundation.
Code: Task-Intermediate-Level-Certification-Ichsan_batch34
Goal: Perform end‑to‑end analysis on an e‑commerce dataset to understand customers, orders, payments, delivery performance, and product trends.
What I did:
- Cleaned and prepared order, customer, payment, and product data for analysis using Python.
- Conducted exploratory data analysis (EDA) to identify sales trends, customer behavior, and product performance.
- Designed visualizations to show revenue trends, popular categories, and repeat customers.
- Summarized key findings and practical recommendations for business stakeholders.
Skills & Tools: Python (pandas, Matplotlib), SQL, EDA, business insights, dashboard planning.
Code: INSIGHT-DATA-SALES-PT.-TUMBUH-BERSAMA
Goal: Visualize and analyze monthly sales performance using Excel dashboards.
What I did:
- Cleaned and structured raw sales data by period, region, and product category.
- Built an interactive Excel dashboard with pivot tables and charts.
- Highlighted trends in sales growth and key product contributors to revenue.
Skills & Tools: Data cleaning, Excel (pivot table, formulas), dashboard design, business insights.
Code: Visualisasi-data-dengan-Google-Data-Studio
Goal: Build an online dashboard for monitoring business KPIs.
What I did:
- Connected processed data to Google Data Studio.
- Designed interactive reports with filters, scorecards, and time‑series charts.
- Enabled stakeholders to explore KPIs directly without needing raw data files.
Skills & Tools: Google Data Studio, data visualization, reporting, data storytelling.
Code: SQL-with-Google-BigQuery
Goal: Explore large datasets using SQL to answer business questions.
What I did:
- Wrote SQL queries with joins, aggregations, and filtering to explore the dataset.
- Used CTEs and grouping to analyze trends and segment performance.
- Documented key queries and results as a reference for future analysis.
Skills & Tools: SQL, BigQuery, joins, aggregation, query optimization mindset.
Code: File-Notebook-Python-Growia
Goal: Clean, transform, and analyze raw datasets using Python.
What I did:
- Handled missing values, duplicates, and outliers.
- Performed EDA to identify distributions, correlations, and patterns.
- Created visualizations to communicate insights from the data.
Skills & Tools: Python, pandas, Matplotlib, Seaborn, data preprocessing, EDA.
Code: Visualization-with-Tableau
Goal: Visualize KPIs and business insights using Tableau dashboards.
What I did:
- Designed interactive dashboards with filters and calculated fields.
- Combined multiple views to provide a high‑level overview of key metrics.
- Focused on usability so non‑technical audiences can read the charts easily.
Skills & Tools: Tableau, data visualization, KPI analysis, dashboard storytelling.
These projects show my background in web development and software fundamentals. They are supporting skills that help me collaborate with engineering and IT teams.
Code: webhozz
Goal: Build a complete PHP‑based website with MySQL integration.
Highlights: Learned layout design, CRUD operations, and basic UI for dynamic web pages.
Technology: PHP, MySQL, HTML, CSS, JavaScript
Code: sipusta
Goal: Develop a web‑based system to manage books, members, and borrowing.
Highlights: Implemented modules for catalog management, borrowing/returning, and printable transaction reports.
Technology: PHP, MySQL, HTML, CSS, JavaScript
Code: vionet
Goal: Create a website and admin dashboard for the Vision Owner Network (VIONET) community.
Highlights: Built public pages for news & events and an authenticated dashboard for managing membership data and cashflow (KAS).
Technology: PHP, MySQL, HTML, CSS, JavaScript, Bootstrap
Code: 17-feb-25-ichsanx
Goal: Build a responsive personal portfolio website.
Highlights: Implemented multi‑section layout (about, projects, contact) with responsive design.
Technology: HTML, CSS, JavaScript
Code: Algoritma-Pemograman-C
Goal: Practice algorithm design and basic procedural programming in C.
Highlights: Implemented interactive console programs focusing on control flow and problem solving.
Technology: C
Code: Python-Project-Coding-Studio
Goal: Learn Python fundamentals through hands‑on exercises.
Highlights: Created scripts using functions, loops, conditionals, and basic OOP.
Technology: Python
Code: Project-MySQL-Fundamental-Coding-Studio
Goal: Practice SQL database design and data manipulation.
Highlights: Used DDL & DML, joins, and queries to manage structured data.
Technology: MySQL
Code: Project-Excel-Intermediate
Goal: Strengthen Excel skills for analytics and reporting.
Highlights: Built reports using formulas, pivot tables, and charts to summarize data.
Technology: Microsoft Excel
- Bachelor of Information Technology – STMIK Mercusuar
2010 – 2014
Focus on database, algorithms, programming, and web development.
-
Growia Academy – Data Analyst Certification Program (2025)
End‑to‑end training in Python, SQL, Tableau, Excel, and business analytics. -
Coding Studio – Programming and Data Fundamentals (2025)
Python, SQL, Excel, and C for data and software solutions. -
RevoU – Fundamental Software Engineering Course (2025)
Front‑end fundamentals and responsive web design. -
WebHozz Training Center – Web Development (PHP & MySQL) (2016)
PHP website creation, layout design, CRUD, and project implementation. -
Digistar Connect – Boost Your Project Management Skill (2024)
Introduction to project management and collaboration.
Additional webinars and foundational certificates (fundamental Python/SQL/Excel, database, etc.) are available upon request.
Core Data Skills
- Python – data cleaning, EDA, basic visualization (pandas, NumPy, Matplotlib, Seaborn)
- SQL – joins, aggregation, grouping, CTEs, window functions
- Data Analysis – KPI tracking, trend analysis, cohort/segment analysis
- Data Visualization – Tableau, Google Data Studio, Excel dashboards
- Excel – formulas, pivot tables, lookup functions, reporting
Tools
- Jupyter Notebook
- Google BigQuery, MySQL
- Git & GitHub
- Excel & Google Sheets
- VS Code
Supporting Technical Skills
- Web Development – HTML, CSS, JavaScript, PHP, Bootstrap
- Programming – C
- Server & Virtualization – Proxmox VE, TrueNAS (basic administration)
- Completed a full Data Analyst Certification Program and delivered several end‑to‑end analytics projects using Python, SQL, and visualization tools.
- Supported business stakeholders with dashboards and reports for sales and KPI monitoring.
- Built data visualizations and reports that were used in internal presentations and assessments.
- Strengthened analytical and technical foundations through structured programs at Growia, Coding Studio, RevoU, and WebHozz.
- GitHub: github.com/ichsanx
- LinkedIn: linkedin.com/in/ichsan-saputra-561299101
- Portfolio Website: ichsanx.github.io/curriculum_vitae/