Hartoni Agung Permana (hartoniagungpermana)

2025: This project delivers an end-to-end business intelligence solution that transforms raw sales data from six disparate sources into a strategic narrative to drive decision-making for a bike company. By engineering a robust ETL pipeline and architecting a modern data warehouse, this analysis uncovers the compelling story of a business in a high-growth but precarious phase�exposing critical operational bottlenecks and revenue concentration risks that threaten its long-term stability.

This work moves beyond data analysis to demonstrate a full-cycle business intelligence capability, structured around three core pillars:

1. ?? Data Engineering & ETL: Ingesting, cleaning, and validating complex data from multiple sources to create a reliable foundation for analysis. The process addresses significant data quality issues, including historical records, inconsistent formats, and invalid entries.

2. ?? Data Warehousing & Modeling: Architecting a scalable data warehouse using the Medallion framework (Bronze, Silver, Gold layers) and designing a star schema data model optimized for high-performance analytical queries.

3. ? Analytics & Strategic Insights: Translating the modeled data into actionable business intelligence. The analysis covers customer segmentation, product profitability, and operational efficiency, culminating in six data-driven recommendations to mitigate risk and unlock sustainable growth.

Ultimately, this project showcases a complete cycle of data maturation: from chaotic, raw information to a polished, actionable strategy that can secure a company's financial future.

2025: This project presents an end-to-end analysis of the audiobook market, transforming a raw, unstructured dataset of over 87,000 titles into a strategic business intelligence report. The central objective was to uncover the key drivers of success in a highly concentrated market and provide data-driven recommendations for authors and publishers.

The project showcases a complete data analytics workflow, including:

1. Data Cleaning and Transformation (ETL) using advanced SQL to handle complex inconsistencies in text, dates, and numerical data.

2. In-depth Data Analysis to answer 14 critical business questions regarding market dynamics, author productivity, pricing strategy, and consumer behavior.

3. Insight Generation and Visualization using Tableau to build compelling charts and visuals that translate complex data into clear, actionable stories.

The final output is not just an analysis but a strategic guide, delivering actionable recommendations designed to help stakeholders navigate the audiobook landscape, optimize their release strategies, and maximize audience engagement.

2025: This project demonstrates an end-to-end Lakehouse architecture integrating CRM and ERP systems into a unified analytics platform.

I designed and implemented a Medallion Architecture (Bronze�Silver�Gold) using Databricks and Delta Lake, transforming raw operational data into a dimensional star schema optimized for business intelligence consumption in Power BI.

The project covers the full data lifecycle:

1. Multi-source data ingestion (CRM & ERP)

2. ELT transformation using Spark & SQL

3. Dimensional modeling (Fact & Dimensions)

4. Business metric engineering

5. BI-ready Gold layer

6. Dashboard consumption layer

This simulates an enterprise-grade data platform rather than a dashboard-only project.

2025: The FlipMart Sales Performance Dashboard is an interactive business intelligence project developed using Microsoft Excel. It showcases the ability to transform raw transactional data (2019�2022) into actionable business insights through a clean and dynamic dashboard design.

This project was built to demonstrate data analysis, visualization, and storytelling skills using Excel�s core analytical tools � Pivot Tables, Pivot Charts, and Slicers � while simulating a real-world BI workflow through external data connections.

The dashboard tracks key business metrics such as Profit, Sales, Quantity Sold, and Transactions, helping stakeholders monitor company performance across markets, segments, and time periods.

Designed with an emphasis on clarity, usability, and analytical depth, this project serves as a portfolio piece that bridges the gap between technical competency and strategic decision-making.