This Power BI dashboard presents a full-scale financial and operational reporting solution for Meridian Silver Corp, a fictional silver mining company operating three mines across the United States. The underlying dataset was built from scratch using a custom Python data generator that produces twelve internally consistent CSV tables in a star schema — covering production, sales, costs, financial statements, budgets, safety, and maintenance — spanning five years of monthly history plus a 2026 budget year. The data encodes a realistic business narrative: cost inflation in 2022, operational improvements in 2023, a mine ramp-up in 2024, and silver price volatility in 2025, giving every chart meaningful movement rather than random noise.
The dashboard spans four pages — an Executive Overview, an Income Statement, a Maintenance analysis, and a Mine Operations Scorecard — and is supported by a library of over seventy DAX measures covering production KPIs, revenue analysis, cash cost and AISC calculations, time intelligence, safety rates, and equipment reliability metrics. The financial statement page features a full P&L hierarchy from revenue through to net income, including dynamically recalculated margin percentages that remain accurate across any time window, powered by a dedicated P&L structure dimension table. Custom dark-theme background layouts were designed in Python and imported as canvas backgrounds, and the data model follows star schema best practices with clearly defined relationships, sort-by-column assignments, and row-level subtotal suppression. The project demonstrates end-to-end dashboard development from data engineering and data modelling through to DAX authoring and visual design.
All data displayed in this dashboard is synthetic and generated solely for demonstration purposes. No real data is used.