iEXCEL App
A Simulation Center business analytics and metrics application with advanced reporting, drill-down analytics, and real-time data capture. The iEXCEL App is a purpose-built technology solution for the Global Davis Center.
The application is designed to capture data from the center's activities, events, and simulations. The data is then used to measure the center's performance, manage resources, and make data-driven decisions. The application is designed to capture data from the center's activities, events, and simulations. The data is then used to measure the center's performance, manage resources, and make data-driven decisions.
A cloud hosted, scalable, and completely isolated infrastructure to host advanced data analytics for UNMC's iEXCEL program.
Simulation Center business analytics and metrics are a fairly new data science, and without clear KPI (Key Performance Indicators) being established at the Global Davis Center, the Data Capture team began to collect as much data as possible.
Project Design UI/UX Image CDN Cloud Hosted Analytics Data ETLs Azure Cognitive Services Lucene Graph Charting Report Builder E-Mail Services Auth/SSO Rules Engine Machine Learning Real-time Notifications
Angular Angular PWA Material Angular Bootstrap Azure Static Web Apps Azure Communication Services Asp.NET Azure SQL Server Azure Secure Enclave ML.NET MSFT Identity Azure Function Apps ETL Automation Azure API Gateway Azure Cognitive Services
Scope of work
Every design journey starts off with a wireframe of all the requested features and a plan for user flow through the web app.
All of these features were built out in a cloud hosted Azure app that is completely isolated and in a secure tenant. The app is built to scale and can be handed off to a production environment or solution owner.
This MVP build includes a ChatGPT, Bing Ai Search, Ai News and was stood up to capture the vision of the UNMC Ai Committee and faculty. We have discovered that many of the tools and resources are already available and can be integrated into the app. And that just having a physical place to explore Ai tools and resources is a great asset to spark the possible solutions for Ai.
Data Normalizing
- Status Quo Research
- Requirements Document
- Project Scope
UI/UX Design
- Wireframes
- User Flow
- Feature Requests
App Build
- Angular App
- API Gateway
- Azure Services
Research & Design
A lot of time was spent researching the current Ai tools and resources available to UNMC. This research was used to create a requirements document and project scope.
The project scope was used to create wireframes and a user flow for the app. The wireframes were used to create a feature list and a plan for the MVP build.
Data Capture
Simulation Center business analytics and metrics are a fairly new data science, and without clear KPI (Key Performance Indicators) being established at the Global Davis Center, the Data Capture team began to collect as much data as possible.
Casting a broad net, the data began to show growth opportunities, where the Global Davis Center shined, and interprofessional learning gaps. This data science led the team to create C-Suite dashboards, KPI's, and automated reporting for academic certification. Having access to timely and accurate activity data within the center enabled the staff to better manage resource utilization, inventory, and prep for upcoming activities.
Agile Development
Small apps solving big problems. The iEXCEL App is a purpose-built technology solution for the Global Davis Center. The application is designed to capture data from the center's activities, events, and simulations. The data is then used to measure the center's performance, manage resources, and make data-driven decisions.
Analytics & Tracking
The iEXCEL Measures of Success (MOS) are the key performance indicators (KPIs) that we use to better our organization. These KPIs are the metrics that we use to measure our performance. We use these metrics to help us make better decisions and to help us better understand our organization. We use these metrics to help us make better decisions and to help us better understand our organization.
Version 1
Version 1 of the iEXCEL App was a success. The app was built to replace a quarterly newsletter that staff at iEXCEL would spend hours calculating metrics to include in the report. Automating this process saved the team countless hours and also allowed us to create better ways to capture the data we needed. We designed processes to add value wherever they were being implemented. This allowed us to capture data that we had never captured before. This allowed us to create new metrics and to better understand our organization.
Green Tree Development
Deriving financial metrics from the data we were capturing was a challenge. Pricing models were created to help us understand the value of the data we were capturing, the utilization rates, the consumables used, and the cost of the staff. We were able to create a financial model that allowed us to understand the value of the data we were capturing. This allowed us to create new metrics and to better understand our organization.
Research & Design
What started out as a simple data capture tool has evolved into a powerful business analytics and metrics application. The processes being implemented for better analytics which led to better insights and better decisions.
The iEXCEL App was built in a maintainable way, allowing us to add new features and to make changes to the app as we learned more about our organization. We were also able to repeat this solution process for our other apps.
Dashboard
The dashboard was the starting point on redesigning the application. It is meant to be a top level look at everything, the thousand-foot view. From here, users can drill down into what they cared about, what floor they were on, or what room they were in. This was the first step in the redesign of the application.
Charting
The iEXCEL App has a robust charting system that allows users to visualize the data in a way that makes sense to them. Every data point can be displayed in multiple ways, and the user can choose the best way to display the data. This allows the user to see the data in a way that makes sense to them and to make better decisions.
UI Design
This web app is designed to be an analytics powerhouse, with top level analytics to guide decision-making and drill down analytics to drill down into the details. There is a gap in technology for simulation centers that are currently being filled by using a combination of tools meant for other industries. The iEXCEL App is a purpose-built technology, built by simulation center professionals for simulation center professionals. Our mission is to provide a single source of truth for the Global Davis Center.
The flexible charting features, calendars, and data source views in the UI design reflect this mission. Our design team worked closely with data scientists to make sure that the data was displayed in a way that made sense to the user. The UI design is meant to be approachable, intuitive and easy to use, with a focus a heavy on the user experience.
Code Coverage
This app served as the template for our future apps. It was scalable, maintainable, and had a robust system. But most important, it was testable. Every feature was tested and every bug was fixed. This allowed us to create a robust app that was reliable and that we could trust.
