Laserfiche WebLink
Section IV: Technical Approach <br /> In today's technology rich environment, state and local governments rely on a multitude of solutions to <br /> provide their constituents with the services necessary to support the public's need for service, safety, <br /> and convenience.Always in pursuit of"best-value"offerings,government IT cannot limit their choices to <br /> a single technology stack,vendor, database,or method of access. Now more than ever,their users have <br /> become consumers of technology in aspects of their daily life and,as such,demand specific capabilities. <br /> While cities such as Sunny Isles Beach have risen to the occasion and adopted the products and services <br /> necessary to modernize their IT infrastructure,they are now confronted with the daunting task of <br /> managing vast quantities of data from many disparate sources. With this data comes the ability realize <br /> additional levels of efficiency,transparency, and predictive analysis like never before. The goal of Aeon <br /> Nexus and our team of solution integrators and data architects, is to implement a reporting and <br /> analytics solution that responds to each of the specific requirements identified by Sunny Isles Beach in a <br /> manner that reduces complexity and maximizes accessibility to information when and where it's <br /> needed. Our technical approach will implement Microsoft Power BI and free Microsoft Office add-ons <br /> with the targeted approach described below. <br /> Data Identification and Consolidation <br /> The City of Sunny Isles Beach has identified a number of reports and dashboards necessary to meet their <br /> current business needs.The mixture of reporting types includes on-demand reports as well as scheduled <br /> reports to be generated and emailed to the appropriate staff. Once a thorough assessment of the <br /> current data sources and relationships has been completed,our team will begin the process of creating <br /> architectural data maps that will become the foundation of all development.The goal of our team will <br /> be to minimize the amount of data management necessary to obtain a "reportable state". While <br /> extraction of datasets from defined sources may need to be implemented in order to report from <br /> specific systems,this type of overhead adds to the maintenance and complexity of the final reporting <br /> solution. With modern business intelligence suites capable of connecting to multiple sources of data <br /> simultaneously, a significant reduction,or even elimination of data preparation efforts and custom <br /> coding can be achieved. Power BI excels in this arena by allowing the reporting engine to maintain <br /> multiple connections to different data sources and identify cross-platform relationships that will be <br /> crucial to the generation of complex dashboards. <br /> Through the intuitive online interface of Power BI, data sources and application gateways will be <br /> configured for each reporting requirement. Image 1 below displays the quick-add data source <br /> configuration panel in Power BI. All major databases and ODBC data sources are currently supported, <br /> and the addition of Power Query allows a user to add data from any query able dataset,web service, or <br /> collection. <br /> 8 <br /> 174 Glen Street I Glens Falls,NY 12801 T:518.338.1551 F:866.252.1251 aeonnexus.com <br />