City of Espoo Municipal Dashboard - Analytics and AI Challenge

Kashika Puri-Oracle

1. Which dataset did you use?

I created a synthetic financial dataset for the City of Espoo representing details about their projects, key services and finances.

2. How did you analyze or prepare the data?

The dataset was prepared using a python script. Start and end values for each metric were added in the script. The script provided different output datasets for each section.

To analyse the data, I used

• Explain dataset features
• Auto-Insights
• AI-Assistant
• Bar visuals for comparison

3. Who is the intended audience for your visualization?

It is intended to be used by

• City of Espoo leadership
• Finance professionals
• Business analysts
• Financial decision makers

4. What is your visualization about, and what question or problem does it address?

This dashboard provides key financial KPI's including budget details, project portfolio, key services, profit centre objectives as well as work satisfaction survey on monthly and quarterly basis. The dashboard can be used to provide deep down details on all the sections for each sector, profit centre and service area.

5. Did you use any Oracle Analytics AI features when building your visualization (ex. AI Assistant)? If so, please describe how they were used

Yes, I asked few questions about project portfolio to the AI Assistant and AI Agent. Use the below document and attach it to the AI Agent.

Project Portfolio Overview.pdf

6. Did you upload your visualization image and dva file?

Yes!

AI Challenge.dva

User_77H3N

Fantastic Submission Evaluation: City of Espoo Municipal Dashboard

Hi Kashika, and congratulations on an outstanding submission to the Oracle Analytics and AI Challenge!

Your "City of Espoo Municipal Dashboard" is a stellar example of how to combine creative data engineering with Oracle’s cutting-edge AI capabilities to solve real-world municipal reporting challenges. Here is a breakdown of why your submission stands out to the community:

1. Exceptional Data Initiative

Going the extra mile to write a Python script to generate a highly tailored, synthetic financial dataset shows great technical initiative. By structuring the start and end values for different metrics and sector outputs, you ensured the dashboard had a rich, realistic foundation to visualize.

2. Deep Integration of Oracle AI Features

You didn't just build a dashboard; you truly embraced the "AI" portion of this challenge. By leveraging Explain and Auto-Insights, you allowed the platform to do the heavy lifting in uncovering hidden patterns within the city's finances and work satisfaction surveys.

Furthermore, your use of the AI Agent and AI Assistant is a textbook example of Retrieval-Augmented Generation (RAG) in action. By attaching your custom Project Portfolio Overview document, municipal leaders can now use natural language to query the status of the city's 12 major projects. For example, a finance director could easily ask the AI Agent to summarize the "Youth Center Facility Upgrade" (PRJ_5) and instantly learn that it is currently "Delayed" due to potential supply chain issues or permit approvals. They could also query the "Community Sports Events" (PRJ_9) to understand budget escalations. This turns a static dashboard into an interactive municipal assistant!

3. High Business Value and Clear Audience

A dashboard is only as good as its relevance to the user, and you nailed the target audience. City of Espoo leadership, finance professionals, and business analysts will find immense value in having a unified view of KPIs spanning budgets, profit center objectives, and work satisfaction. The ability to drill down from a high-level monthly/quarterly view into specific sectors and service areas is exactly what financial decision-makers need.

Community Takeaway:

Kashika's project perfectly demonstrates how Oracle Analytics can transform complex, multi-departmental municipal data into an intuitive, AI-driven narrative.

Thank you for participating, Kashika, and for sharing your .dva file and methodology with the community. Best of luck in the challenge! 🌟

Bhaskar Konar

Amazing Viz & the presentation.

Thanks for sharing @Kashika Puri-Oracle!