EDFData Analysis and Visualization Platform
Category
Web
Solution
React
Technology
17+ Tech Stacks
Microscope Data Analysis Made Easy
EDF - EAS Data Fusion
EDF is a web-based platform that provides real-time statistical analysis and chart visualization by uploading spreadsheet data. It provides multi-analysis by directory and integrated analysis functions, consisting of an admin back office and a main application for users. Administrators can perform data management, user management, and statistical analysis functions, and users can experience various analyses and visualizations based on uploaded data.
Challenge
Diversified Analysis Methods and Spreadsheet File Upload System
Multi-angle analysis is possible through integrated, multiple, and composite analysis functions, and drag-and-drop file upload, data loading by sheet, and fast large file processing were implemented.
Dashboard and Chart Visualization
Various chart types and statistical values for each sheet were visualized. Linked analysis between multiple sheets is also possible through function settings.
Spreadsheet Filtering and Integrated Analysis
Converted uploaded spreadsheets into table format and implemented filtering and integrated analysis functions.
Solution
Technology Stack
Project Approach
Implemented intuitive UI/UX using React and MUI, efficiently performed server state management through React Query, and simplified API communication using Axios. Provided various chart visualization features using Chart.js, and managed user authentication with Firebase. Built a stable backend service through Python, Flask, and Google Cloud.
Impact
Innovation
100K+
Implemented real-time analysis of over 100,000 cells per file in the browser through parallel data processing using Web Worker.
User Experience
92% Improved
Enhanced dashboard response speed through component optimization using Memoization.
Performance
0 secs
Reduced UI blocking time to 0 seconds when processing over 100,000 rows of data through multi-threading and DB caching.
"Technology like an expert, communication like a friend, responsibility like family - a perfect development team we want to meet again!"