Powering Energy Storage Beyond Excel

This talk focuses on transitioning complex data-intensive processes from Excel spreadsheets to a Django application, specifically for a company involved in battery energy storage solutions. It highlights the limitations of Excel for scalability, version control, and data integrity, and showcases how Django, with its robust features and ecosystem (including PostgreSQL, Django REST Framework, and a React-based frontend like Next.js), can provide a more reliable and scalable solution. The presentation also touches on best practices for managing this transition, including prototyping with Jupyter notebooks and the importance of comprehensive testing.