Government & Integration · Public-sector projectsLocal Government Economic Development Bureau

Closing the gap between data and decisions.

National data, local reports and consultant studies were scattered across divisions and systems, with no way to turn them into policy advice in real time. We built an automated intelligence pipeline so decision-makers work from a precise, live and ready-to-use map of the economy, not an outdated static report.

Industry analytics platform (illustrative)
Illustrative
80–100 data sources · updated regularly
Year2025AreaCitywideIndustryAll
Industry activity indexIndex (illustrative)
Semiconductors
Auto parts
Logistics
Electronic components
Click an industry to drill down to districts and companies
Summarize the semiconductor sector over the last quarter as briefing notes
Briefing draft | Semiconductors · last quarter
  • More news of park companies expanding and hiring
  • Power and water applications are rising; supply worth watching
  • Suggested question: local supply-chain partnership needs
Sources: industry database, news digest (illustrative)
Export briefing draft
Client
Local Government Economic Development Bureau
Period
Since 2024
Data sources
Roughly 80 to 100, updated regularly
Technology
Microsoft Fabric, RAG, AI Agent
80–100data sources aggregated automatically
Minutesto a data-backed briefing draft
Phone · tableton hand for council hearings and site visits
Challenge

Plenty of data, too little of it in decisions.

National data, local reports and consultant studies sat in different divisions and systems. A single industry analysis took days of manual compilation and could be out of date by the time it reached senior officials.

Preparing briefing notes meant combing through hundreds of pages of PDFs. The core mission of this project was to close the gap between data and decisions.

How we did it
01 · Data backbone

Many sources, flowing into one governance layer

We introduced Microsoft Fabric, an enterprise-grade data management platform, and used its data lake to bring SQL, API and manually uploaded data into a single governance layer, breaking down data silos.

  • In-house crawlers collect open data from city bureaus, news and industry trends, replacing manual compilation
  • Industry trend reports from consultants such as Nomura Research Institute (NRI) are turned into structured data
  • Roughly 80 to 100 data sources connected and updated regularly
Data hub · pipelines (illustrative)
Illustrative
80–100 data sources · updated regularly
Sources
Open data from city bureaus
SQL · API · Today 06:00
National & local statistics
API · Today 05:30
Manually uploaded reports
Excel · CSV · Nov 7
News & industry trends
Crawler · Today 07:30
Consultant reports (NRI)
PDF, structured · Oct 28
Microsoft Fabric data lake
One governance layer
Ingest & schedule (ETL)
Cleanse & structure
Access & version control
Feeds
Industry database
Interactive dashboards
AI Agent (RAG)
Schedules healthyNext refresh today 12:00
02 · AI Agent

Ask directly, with every answer sourced

The platform includes an interactive AI Agent grounded in the structured data gathered by the data hub, covering every statistic used in the dashboards. Users simply ask a question and get an interpretation of industry trends and statistics.

  • Built on a RAG knowledge base, so every answer traces back to its data source
  • Keeps the model from making things up
  • A trustworthy analysis partner
AI Agent · industry Q&A (illustrative)
Illustrative
How many electronic-component plants opened in the North District over the past year? What’s the trend?
AI Agent

Over the past year, 12 new plants opened (illustrative). New openings every quarter, more in the second half, mostly around the industrial parks.

New plants per quarter (illustrative)
Q1Q2Q3Q4
Sources
1Factory registrations · 2025-11-032Company registrations · 2025-11-013Industry news digest · 2025-11-10
Every answer traces back to its data source
Compare with prior yearList the companies
Ask a question, e.g. how has logistics in the city changed in 3 years?
03 · AI briefing notes

A briefing draft in minutes

Staff no longer page through hundreds of PDF pages. They talk to the AI Agent, which searches the latest industry data, summarizes the trends and context, and produces a data-backed briefing draft within minutes.

  • Searches the latest data in real time
  • Summarizes trends and context automatically
  • Drafts cite their data sources; staff polish and finalize
AI briefing notes
AI draft · finalized by staff
RegenerateExport to WordIllustrative
Briefing draft: semiconductor supply chain update (illustrative)
Generated 2025-11-11 09:20 · cites 3 datasets
Key points

Over the last quarter, the city’s semiconductor supply chain has centered on capacity expansion and equipment investment; companies are watching power, water and talent supply.

What the data shows
  • Semiconductor-related factory registrations are up year on year[1]
  • A growing share of industry news mentions expansion and equipment investment[2]
  • Consultant reports point to advanced-packaging demand opening doors for local suppliers[3]
Suggested talking points

Outline the city’s existing support for land matching, utilities coordination and talent development, and ask companies what local supply-chain partnerships they need.

Sources
[1]Factory registrations (industry database) · 2025-11-03
[2]News & industry trends digest · 2025-11-10
[3]Consultant industry trend report (NRI) · 2025-10-28
04 · Interactive BI

Council hearings and site visits, right on a phone

Interactive charts were designed together with industry consultants and support live filtering and drill-down. A responsive layout lets senior officials pull up complete industry intelligence on a tablet or phone during council hearings or field visits.

  • Live filtering and drill-down
  • Easy to read on tablets and phones
  • Analysis that once took days of manual work is now on the dashboard
09:415G
Industry intel
Industry analytics platform
CitywideNorth DistrictElectronic components
Year2025AreaNorth DistrictIndustryElectronic components
New in the past year
12plants
Up on prior yearIllustrative
New plants by year (illustrative)
20212022202320242025
Tap a bar to drill down to the company list
Pulled up on a phone during a council hearing
Results

Analysis that took days is now on the dashboard.

AreaOutcome
Data foundationRoughly 80 to 100 data sources feed a regularly updated industry database, the data foundation for industrial governance
Analysis speedIndustry analysis that once took days of manual compilation is now available on visual dashboards
Lighter workloadBriefing drafts went from combing through hundreds of PDF pages to a few minutes of conversation with AI
Mobile accessComplete industry intelligence on tablets and phones, anytime
Contact us

Start your AI transformation today.

They chose OakMega