Trusted Data Platforms Financial Billing Dashboard & Data Model

2023 NACo Achievement Award Winner

Miami-Dade County, Fla., FL

Image of AchAwards_text.png

About the Program

Category: Information Technology (Best in Category)

Year: 2023

The Data Management & Integration In collaboration with IT Administrative Services and Enterprise Resource Planning the Trusted Data Platforms Financial Billing Dashboard and Data Model was developed using Azure Analysis Service and Power BI to address critical challenges faced by finance professionals and managers in handling their workforce. The data model integrates data from the Informs Financial Database, including billing, labor distribution, and human resource information. The Azure Analysis Service processes the data and creates a scalable and secure analytical solution that provides real-time data-driven insights into financial and billing data. The interactive visualizations and reports created using Power BI allows financial managers to analyze the data more effectively and identify potential issues quickly. With the automation and real-time data-driven insights provided by the Trusted Data Platforms Financial Billing Dashboard and Data Model, finance professionals, and managers can make informed decisions that improve financial outcomes. In summary, the collaboration between the Data Management & Integration and Administrative Services divisions, Azure Analysis Service, and Power BI has resulted in a comprehensive and automated process that provides accurate and up-to-date financial and billing data to support effective management for multiple Miami-Dade County Departments. The Trusted Data Platforms Financial Billing Dashboard and Data Model is a valuable tool that empowers finance professionals and managers to manage their workforce more effectively and make informed decisions based on real-time data-driven insights.