Get in Touch

Revamping Tableau Online using AWS at Fastned

Client Overview:

Fastned B.V. is a Fast Charging Company building a network of fast chargers all across Europe since 2012. They are constantly looking at new locations to build their stations and provide freedom to the electric driver.

Current Data Stack: MySQL, Tableau.

Implemented Data Stack: AWS Redshift, Tableau, AWS Sagemaker.

Challenges Faced:
  1. No Data Warehouse: Fastned didn’t have a dedicated Data Warehouse to perform Business Intelligence on. They were using a copy of the transactional database from AWS to MySQL.
  2. Fragmented IT Infrastructure: The Backend of the Fastned Software was based in AWS while the Databases for Tableau were based on MySQL.
  3. Lack of Actionable Insights: The current reporting infrastructure was showcasing charging sessions and sales and did not provide any analysis that could be leveraged by the business to move forward.
Solution:

KYD Analytics B.V. collaborated closely with Fastned to design and implement a robust data infrastructure solution tailored to their specific needs. The solution included:

  1. Data Warehousing: Set up a data warehousing solution in AWS using Redshift to make the integration between the backend systems and the analytics systems seamless.
  2. Actionable Insights: Instead of building dashboards to just show the state of the business, we started answering business problems and used the reports to support the decision making of the business.
  3. Advanced Analytics: Leveraged advanced regression analysis to find the next best station to build for fastned using the current sales information of Fastned coupled with EV data and accessibility of charging stations in the The Netherlands.
Results Achieved:
  • Improved Data Accessibility: The centralisation of the data infrastructure helped bridge the gaps between different systems and allowed efficient data processing.
  • Better Decision-Making: Fastned was trying to understand how to properly utilise their charging stations as throughout the day it seemed like the station was under utilised. We came up, in tandem, with the business with a metric that might provide more insight into the utilisation rate which was basically understanding how many cars are charging concurrently. This helped the business understand the bottlenecks they were facing and increase capacity accordingly.
  • Faster Location Hunting: Using Data to support new location hunting, Fastned was able to go from 114 stations in 2019 to 188 stations in 2021. Now they are at 297 at the time of writing.
Our Client's Testimonials

KYD Analytics helped revamp our data infrastructure. Ahad’s drive and eagerness to learn and solve problems really helped us in unlocking the value in our data. We highly recommend KYD Analytics to any organization seeking to harness the power of their data and build a robust data infrastructure.

    – Martijn Benjamin

    Head of Software Development, Fastned

    Conclusion: By partnering with KYD Analytics, Fastned was able to unlock the potential in their data and was able to make better decisions. Couple that with a robust infrastructure, Fastned is able to scale their use of data and build insights faster than before.