Corporate Training Course Builder
Robust course builder web application for corporate training institute based at Australia.
![portfolio TOB 3 smaill cross floating icon](https://envitics.com/pictures/2023/07/icon_04.png)
![portfolio TOB 4 small triangle floating icon](https://envitics.com/pictures/2023/07/icon_03.png)
![portfolio TOB 5 small blue circle floating icon](https://envitics.com/pictures/2023/07/icon_02.png)
![portfolio TOB 6 small rhombus floating icon](https://envitics.com/pictures/2023/07/icon_01.png)
![portfolio TOB 7 floating star icon](https://envitics.com/pictures/2023/07/icon_05-1.png)
![portfolio TOB 8 TOB 3](https://envitics.com/pictures/2023/08/TOB-3.png)
Corporate Training Course Builder
Robust course builder web application for corporate training institute based at Australia.
![portfolio TOB 9 Group 457](https://envitics.com/pictures/2023/08/Group-457.png)
![portfolio TOB 10 introduction icon](https://envitics.com/pictures/2023/07/Group-22.png)
Description
Client: Allied digital
Challenge : A corporate training company heavily relies on an Excel macro for complex data processing and analysis, but it’s limited to a few users and lacks real-time collaboration depending upon access rights. They need a scalable solution accessible via the web.
![portfolio TOB 11 Frame 35](https://envitics.com/pictures/2023/07/Frame-35.png)
Solution
- Requirement Analysis: Understand the existing Excel macro's functionality and user requirements. Identify key features, data sources, processing logic and user roles.
- Technology Selection: Choose C# as the programming language for building the web application. Select a suitable web framework, such as ASP.NET MVC or ASP.NET Core.
- Data Modeling: Design a relational database schema to store the data previously managed in Excel. Identify data entities, relationships and required data transformations.
- UI/UX Design: Create a user-friendly web interface with responsive design for different devices. Plan the layout, navigation and visualization of data and results.
- Business Logic Implementation: Translate the Excel macro's logic into C# code to process data within the web application. Implement features like calculations, filtering and data manipulation.
- Real-time Collaboration: Integrate collaborative features to enable multiple users to work simultaneously.
- Data Import/Export: Implement data import and export mechanisms to handle Excel data, supporting various formats.
- Security and Authentication: Implement user authentication and authorization using technologies like ASP.NET Identity. Ensure data security and user privacy.
- Testing and Debugging: Perform thorough testing to identify and fix any issues in the application. Conduct user acceptance testing to ensure it meets the requirements.
- Deployment and Hosting: Deploy the application on a cloud platform like Heroku or AWS and configure the server environment and domain settings.
- User Training and Documentation: Provide user documentation and training to help users transition from the Excel macro to the web application.
- User Feedback and Iteration: Collect feedback from users and address any usability or performance concerns and continuously improve the application based on user input.
![portfolio TOB 12 Frame 6](https://envitics.com/pictures/2023/08/Frame-6.png)
Technology
- Asp .Net MVC
- SQL server
- Clean Architecture
![portfolio TOB 13 result and impact icon](https://envitics.com/pictures/2023/07/Group-27.png)
Results
The Excel macro was successfully transformed into a web application using C#, providing the company with several advantages:
- Scalability: Multiple users can access and use the application simultaneously.
- Real-time Collaboration: Users can collaborate on data processing and analysis.
- Access Anywhere: The application is accessible from any device with an internet connection.
- Enhanced Features: The application can include additional features like visualizations, notifications and reporting.
- Centralized Data: Data is stored in a secure, centralized database, reducing data integrity risks.