Mined Records

Category: Case Studies

  • Oracle Performance Tuning

    Overview

    Analysed AWR reports, added composite indexes, and refactored heavy CTEs.

    Impact

    70% reduction in p95 query time and improved batch window reliability.

  • Excel KPI Dashboard

    Overview

    We built a weekly reporting pack driven by a single refresh. Power Query ingested CSVs, standardised schemas, and fed model tables used by PivotCharts.

    Impact

    Cut reporting time from 6 hours to 20 minutes and improved KPI accuracy.

  • MySQL Cleanup & Migration

    Overview

    Profiled 1.2M records, implemented dedupe rules, and migrated to 3NF with foreign keys and constraints.

    Impact

    Reduced duplicate rate by 98% and enabled reliable downstream analytics.