Automate and improve reliability of data collection
- Practice
- Team
1 Project Director, 1 Project Manager, 1 Technical Lead, 2 BI Developers
- Technical environment
CHALLENGES
- 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
SOLUTION
- 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
BENEFITS
- 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
