News
Stay informed with the latest updates on our company milestones, contract awards, technological innovations, and community impacts.
Avum creates Tableau Dashboard for the Navy’s eBusiness Team
March 13, 2018As part of a prototyping project for the Deputy Assistant Secretary of the Navy, Acquisition and Procurement (DASN(AP)), Avum created the DON Procurement Toolkit, which includes a robust dashboard/reporting capability that Avum developed to display Navy spending and contract-related data.
Avum compiles data from multiple sources, including FPDS-NG, Seaport, ACBIS, USASpending.gov and the DON Procurement Toolkit itself. This data is consolidated and managed in our database and is used to populate Tableau dashboards and reports. Avum set up the Tableau Server for Navy users to easily access, view, and export their own customized financial and contract data reports/dashboards. In addition to the Tableau dashboards, Avum developed a Java-based dashboard that gives DASN (AP) users the ability to have a “global view” of all of the Procurement Performance and Management Assessment Program (PPMAP) activity and results.
We use an iterative design, development, and integration process that involves continual customer review and feedback. Based off of the prioritized requirements and in accordance with the approved Project Management Plan (PMP), our team modifies the Toolkit application components and frequently incorporates the customer’s input. The required external data elements are documented in Avum’s project management system (Redmine), along with the source system’s interface specifications.
Avum's team implements the following iterative process to incorporate new components into the Toolkit:
Develop Toolkit components based off of the approved design plan.
Integrate the corresponding data feeds from external systems to the back-end SQL database.
Test the components using JUnit.
Migrate and deploy new components into the functional Toolkit prototype hosted on Avum’s secure cloud hosting environment.
Test entire Toolkit application and verify end-to-end functionality with new components.
Provide a demo to the customer and instructions for their own "hands-on” review.
Receive feedback and modify or add to the design plan.
Read More
Business Intelligence: Data Capture, Storage, and Visualization within a SAP Environment
June 1, 2015Information is everywhere, and it can be a daunting task to create tangible results from disconnected and seemingly endless streams of data. Analyzing and understanding your organization’s key performance indicators (KPIs) can make the difference between success and failure. Avum knows the intrinsic value of accurate Business Intelligence (BI), providing company leadership with informative data visualization tools to help guide their decision making process, mediating potential weaknesses or nurturing prospective strengths.
Avum designed, developed, and deployed a comprehensive BI solution for the Commander, Navy Installations Command (CNIC), Fleet and Family Readiness (F\&FR), improving their capabilities to oversee and manage the Navy’s global golf program. Utilizing the SAP suite of Business Intelligence tools, Avum crafted a custom solution that involved three main stages; data capture, data storage/transformation, and data visualization.
The Point of Sale (POS) systems across the entire golf program were heterogeneous, so CNIC F\&FR needed a universal application that could capture the same metrics uniformly from every course. KPIs were identified based off the current POS systems and input from the golf program managers. Avum then built a JEE 5 web application that the course staff use to record the day’s performance (i.e. rounds played, military rank of the player, equipment rented, weather conditions, etc). The web application was designed to be intuitive and straightforward to reduce the frequency of data entry errors and promote accurate data sets for analytics later in the process. To ensure accuracy and encourage diligent data entry, Avum built into the web application the ability for managers to generate data entry reports and fix any clerical errors. Also built into the web application is an automated email alert system that informs managers when no course data has been entered over a period of time. Avum tested and deployed the web application in CNIC F\&FR’s NetWeaver Application Server. We set up an OLTP SQL database to store the web application data and used DBconnect to establish the link into the SAP Business Warehouse (BW).
The SAP BW is the backbone of the overall architecture, enabling quantitative performance data from the web application to be combined with finical data from the client’s Enterprise Resource Planning (ERP) system. Regularly scheduled process chains are in place to move the data from its source system to the InfoCubes for storage and consolidation. Before the data can be stored it must be transformed and cleansed so it is useful at the presentation level. The first objects in the SAP BW are the Persistent Staging Areas (PSAs), temporarily storing unchanged data from the DataSource (SQL database, ERP database, flat file, etc.) in transparent relational database tables, allowing the tables to be transformed and stored in the following steps without having to constantly communicate with source systems. Process chains extract the data tables from the PSAs; the tables are joined and transformed, and then loaded in their respective DataStore Object (DSO). Data is again extracted, transformed, and loaded into the consolidated DSOs, where it is ready for the final extraction and transformation before being loaded into one of the four multidimensional InfoCubes. A MultiProvider was developed to combine data from the InfoCubes and feed it to the SAP Business Explorer (BEx) Queries that support the dashboard.
The BEx queries were developed, along with customer exit variables, to provide the dashboard with the requested analytics and drill down capabilities. The dashboard was designed and developed using SAP Design Studio and deployed into CNIC F\&FR’s NetWeaver Application Server. Design Studio provided many useful charting and navigational components, but in order to meet the client’s specific requirements, Avum decided to develop a set of custom components, allowing us to create very complex and interactive data visualization elements within the dashboard. The dashboard now provides its users with an up-to-date visual representation of the entire golf program and its performance. The user can view the performance at an individual course level, a regional level, a geographic level, or a global level and compare those values to the Naval average. The user can also view information spanning from daily to yearly values, enabling them to identify past trends and make informed discussions for the future of their program.
The solution that Avum provided CNIC F\&FR is adaptable to almost any organization, providing management with the tools and resources to make critical decisions off real and relevant performance data that is straightforward and easy to understand.
Read More
Avum develops customized business solution for CNIC F&FR
November 15, 2017Avum recently finished development on a custom analytic dashboard for CNIC F\&FR (Commander, Navy Installations Command, Fleet and Family Readiness) to facilitate the oversight and management of the Navys global golf program. Utilizing SAP business intelligence tools,
Avum created a three stage solution capable of tracking various metrics, including financial data, rounds played, courses, cart rentals and more (these are just samples of the capabilities of what metrics may be tracked).
The three stages consist of data capture, storage and visualization, providing a full range of configurations and capabilities.
Read MoreAvum creates Tableau Dashboard for the Navy’s eBusiness Team
March 13, 2018As part of a prototyping project for the Deputy Assistant Secretary of the Navy, Acquisition and Procurement (DASN(AP)), Avum created the DON Procurement Toolkit, which includes a robust dashboard/reporting capability that Avum developed to display Navy spending and contract-related data.
Avum compiles data from multiple sources, including FPDS-NG, Seaport, ACBIS, USASpending.gov and the DON Procurement Toolkit itself. This data is consolidated and managed in our database and is used to populate Tableau dashboards and reports. Avum set up the Tableau Server for Navy users to easily access, view, and export their own customized financial and contract data reports/dashboards. In addition to the Tableau dashboards, Avum developed a Java-based dashboard that gives DASN (AP) users the ability to have a “global view” of all of the Procurement Performance and Management Assessment Program (PPMAP) activity and results.
We use an iterative design, development, and integration process that involves continual customer review and feedback. Based off of the prioritized requirements and in accordance with the approved Project Management Plan (PMP), our team modifies the Toolkit application components and frequently incorporates the customer’s input. The required external data elements are documented in Avum’s project management system (Redmine), along with the source system’s interface specifications.
Avum's team implements the following iterative process to incorporate new components into the Toolkit:
Develop Toolkit components based off of the approved design plan.
Integrate the corresponding data feeds from external systems to the back-end SQL database.
Test the components using JUnit.
Migrate and deploy new components into the functional Toolkit prototype hosted on Avum’s secure cloud hosting environment.
Test entire Toolkit application and verify end-to-end functionality with new components.
Provide a demo to the customer and instructions for their own "hands-on” review.
Receive feedback and modify or add to the design plan.
Read MoreAvum develops customized business solution for CNIC F&FR
November 15, 2017Avum recently finished development on a custom analytic dashboard for CNIC F\&FR (Commander, Navy Installations Command, Fleet and Family Readiness) to facilitate the oversight and management of the Navys global golf program. Utilizing SAP business intelligence tools,
Avum created a three stage solution capable of tracking various metrics, including financial data, rounds played, courses, cart rentals and more (these are just samples of the capabilities of what metrics may be tracked).
The three stages consist of data capture, storage and visualization, providing a full range of configurations and capabilities.
Read MoreBusiness Intelligence: Data Capture, Storage, and Visualization within a SAP Environment
June 1, 2015Information is everywhere, and it can be a daunting task to create tangible results from disconnected and seemingly endless streams of data. Analyzing and understanding your organization’s key performance indicators (KPIs) can make the difference between success and failure. Avum knows the intrinsic value of accurate Business Intelligence (BI), providing company leadership with informative data visualization tools to help guide their decision making process, mediating potential weaknesses or nurturing prospective strengths.
Avum designed, developed, and deployed a comprehensive BI solution for the Commander, Navy Installations Command (CNIC), Fleet and Family Readiness (F\&FR), improving their capabilities to oversee and manage the Navy’s global golf program. Utilizing the SAP suite of Business Intelligence tools, Avum crafted a custom solution that involved three main stages; data capture, data storage/transformation, and data visualization.
The Point of Sale (POS) systems across the entire golf program were heterogeneous, so CNIC F\&FR needed a universal application that could capture the same metrics uniformly from every course. KPIs were identified based off the current POS systems and input from the golf program managers. Avum then built a JEE 5 web application that the course staff use to record the day’s performance (i.e. rounds played, military rank of the player, equipment rented, weather conditions, etc). The web application was designed to be intuitive and straightforward to reduce the frequency of data entry errors and promote accurate data sets for analytics later in the process. To ensure accuracy and encourage diligent data entry, Avum built into the web application the ability for managers to generate data entry reports and fix any clerical errors. Also built into the web application is an automated email alert system that informs managers when no course data has been entered over a period of time. Avum tested and deployed the web application in CNIC F\&FR’s NetWeaver Application Server. We set up an OLTP SQL database to store the web application data and used DBconnect to establish the link into the SAP Business Warehouse (BW).
The SAP BW is the backbone of the overall architecture, enabling quantitative performance data from the web application to be combined with finical data from the client’s Enterprise Resource Planning (ERP) system. Regularly scheduled process chains are in place to move the data from its source system to the InfoCubes for storage and consolidation. Before the data can be stored it must be transformed and cleansed so it is useful at the presentation level. The first objects in the SAP BW are the Persistent Staging Areas (PSAs), temporarily storing unchanged data from the DataSource (SQL database, ERP database, flat file, etc.) in transparent relational database tables, allowing the tables to be transformed and stored in the following steps without having to constantly communicate with source systems. Process chains extract the data tables from the PSAs; the tables are joined and transformed, and then loaded in their respective DataStore Object (DSO). Data is again extracted, transformed, and loaded into the consolidated DSOs, where it is ready for the final extraction and transformation before being loaded into one of the four multidimensional InfoCubes. A MultiProvider was developed to combine data from the InfoCubes and feed it to the SAP Business Explorer (BEx) Queries that support the dashboard.
The BEx queries were developed, along with customer exit variables, to provide the dashboard with the requested analytics and drill down capabilities. The dashboard was designed and developed using SAP Design Studio and deployed into CNIC F\&FR’s NetWeaver Application Server. Design Studio provided many useful charting and navigational components, but in order to meet the client’s specific requirements, Avum decided to develop a set of custom components, allowing us to create very complex and interactive data visualization elements within the dashboard. The dashboard now provides its users with an up-to-date visual representation of the entire golf program and its performance. The user can view the performance at an individual course level, a regional level, a geographic level, or a global level and compare those values to the Naval average. The user can also view information spanning from daily to yearly values, enabling them to identify past trends and make informed discussions for the future of their program.
The solution that Avum provided CNIC F\&FR is adaptable to almost any organization, providing management with the tools and resources to make critical decisions off real and relevant performance data that is straightforward and easy to understand.
Read More