Leveraging No-Code Tools for Enhanced Excel Dashboard Design: A Case Study
Technology Category
- Application Infrastructure & Middleware - Database Management & Storage
- Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
- Buildings
- Cement
Applicable Functions
- Product Research & Development
Use Cases
- Building Automation & Control
- Inventory Management
Services
- Testing & Certification
- Training
About The Customer
The customers of The Excel Dashboard Toolkit are individuals who understand Excel formulas but are rarely taught about the platform's design features. These users are looking for a comprehensive set of visualizations, design elements, and page designs that will allow them to build visually appealing dashboards in Excel. They are also interested in learning more about structuring their data for each visualization and developing their visual design skills in Excel. The customers value the ability to customize the pre-made visualizations and use them in their own projects.
The Challenge
Josh Cottrell, the founder of The Excel Dashboard Toolkit, faced the challenge of creating an application that would allow users to build visually appealing dashboards in Excel. He wanted to provide a comprehensive set of visualizations, design elements, and page designs that would enable users to create stunning dashboards. However, he needed a platform that would offer more control than traditional tools like Wordpress or Squarespace and allow him to build every feature from scratch without the need for coding. Additionally, he wanted to understand the development process more, which was rooted in his background in startups and product management.
The Solution
Josh chose Bubble, a no-code platform, to build his application. Bubble offered him the granular control he needed over the design features and was easy to understand, even for someone with limited knowledge of coding. The Excel Dashboard Toolkit was developed as an ecommerce platform, providing pre-made visualizations that illustrate complex design concepts. These visualizations can be customized and used in individual projects. Josh is also working on a more robust system that will allow users to quickly find an appropriate template and walk through fast and easy tutorials to understand how to structure their data for each visualization. He is also planning to allow people to sign up for monthly access to a learning hub that will enable them to easily develop their visual design skills in Excel.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
