As a Legal Data Analyst at Mie Gacoan, the job isn't just tracking permits — it's answering the questions that protect the business from legal risk. Here are the 3 strategic questions this analysis addresses.
Strategic Questions
Q1: Which branches have critical legal compliance issues that need immediate action?
With 557 outlets, the legal team can't monitor everything manually. They need a prioritized list of branches with problematic IMB status, expiring leases, or lapsed halal certifications — ranked by urgency so resources are allocated to the highest-risk locations first.
Q2: Where are the lease expiration risks concentrated geographically?
Lease renewals involve significant financial commitments (Rp 150-800M per outlet per year). The CFO needs to know which provinces have clusters of expiring leases so budget can be allocated for renewals or relocation — before it becomes an emergency.
Q3: What's the geographic distribution of dispute levels across the outlet network?
Legal disputes (with landlords, neighbors, or local authorities) are costly and time-consuming. Understanding where disputes cluster helps operations identify systemic issues — is it a specific region, a property type, or a landlord pattern?
Analysis Framework
| Lens | Metric | Why It Matters |
|---|---|---|
| Permit Compliance | IMB status distribution, problematic rate by province | Identify outlets at risk of forced closure |
| Lease Risk | Days to expiry, renewal rate, rent per province | Prevent business disruption from expired leases |
| Halal Status | Certification rate, pending audits, renewal gaps | Ensure regulatory compliance with UU JPH |
| Dispute Analysis | Dispute level by province, correlation with density | Allocate legal resources to high-conflict areas |
💡 Legal Analyst vs General Analyst Thinking
A general analyst would report "19 leases are expiring." A legal data analyst asks: "Which 19? What's the financial exposure? Which ones are in high-revenue locations where closure would hurt most? What's the renewal timeline and who's the landlord?" Every metric in this portfolio connects to a legal action item.