by Dzaky Jayalaksono
My Portfolio
A showcase of BI dashboards, AI automations, and data projects I’ve built to turn insights into business impact.
HORME - Sales & Financial Dashboard
Power BI prototype for a hardware retailer that unifies sales and finance. Tracks Revenue, Margin%, and Cost with Actual vs Budget and YoY. Drill into top and bottom products and store locations, and review P&L in context. Built from staging warehouse with complex Power Query, robust modeling, and advanced DAX.
EIA - Crude Oil & Gas Executive Dashboard
Tableau dashboard built for an oil & gas executive team using real data from the U.S. Energy Information Administration (EIA). It tracks production, imports, consumption, and stock performance with year-over-year and three-year trend comparisons.
ECCO - Delivery Tracking Dashboard
Prototype Power BI dashboard for ECCO to explore how delivery and distribution tracking could be managed in one page. Built with client-provided data, it highlights ordered vs delayed quantities, on-time delivery rates, and root causes of delays across origins and destinations.
BRI - L&D Training Analytics Dashboard
Power BI dashboard for Bank BRI’s Corporate University to track training delivered with Algoritma Data Science School. Summarizes program volume, learning outcomes, and feedback, with drilldowns by division, training, and participant. Built from Google Sheets with full Power Query prep, data modeling, and DAX, then deployed to Power BI Service for stakeholder access.
SUPERSTORE - Store Profit Analysis Dashboard
Interactive Power BI dashboard built using the Superstore dataset to showcase end-to-end BI capabilities. It visualizes sales, profit, discount impact, and customer segmentation across states, categories, and shipping modes. Designed to highlight DAX measures, data modeling, and visualization best practices, this project demonstrates how actionable insights can be drawn even from a simple retail dataset.
ALGOSERA - Cohort Analysis
Storypoint dashboard in Tableau designed to analyze user retention and subscription behavior for Algosera, a simulated online learning platform inspired by Coursera. The project explores cohort patterns, subscription timelines, and churn indicators. Built entirely with Tableau Story features, this project demonstrates data storytelling techniques for turning cohort insights into business actions
Indonesian Stock Market Research Agent
This project focuses on leveraging n8n to create a multi-agent system for financial research based on real-time data from the Sectors Financial API. The agent is also equipped with web search tools and a vector store for RAG capabilities. This project demonstrates the ease of use of n8n in creating an advanced AI agent systems.
SUPERSTORE - Sales & Profit Dashboard
Interactive Looker Studio dashboard built using the Superstore dataset. It visualizes sales, profit, discount impact, and customer segmentation across states, categories, and shipping modes. Designed to highlight visualization best practices, this project demonstrates how actionable insights can be drawn even from a simple retail dataset.