Automate and improve reliability of data collection

  • Practice
  • Team

1 Project Director, 1 Project Manager, 1 Technical Lead, 2 BI Developers

  • Technical environment
IoT captors
Specific measures
Very large
Data flows
  • Our customer was commissioned to carry out a complete and accurate energy analysis of one of its buildings, the future headquarters of a famous radio station.
  • Since this complex energy monitoring required them to use a large amount of collected information, our client was motivated to set up a powerful tool enabling them to automate data collection.
  • A major technological challenge lies in the ability to massively process data from a wide variety of connected objects (IoT) in very large numbers
  • To meet their needs, it quickly became apparent that the combination of SNOWFLAKE for data warehousing and POWER BI for the proposed reporting functions was the most appropriate solution.
  • Regarding the large flow of data to be processed daily, the ELT functionality of Snowflake was more than necessary to fulfill this mission.
  • Then, these data and results are organized to be returned in the form of clear, readable and understandable reports, with the data visualization solution from Microsoft: POWER BI
  • Significant time saving on processes for updating the document
  • Simplification, optimization & modernization of the reporting process
  • Day-to-day Data management for each user through their account
  • More reliable reports with nearly zero errors