Automate and improve reliability of data collection
- Practice
- Équipe
1 Project Director, 1 Project Manager, 1 Technical Lead, 2 BI Developers
- Environnement technique
CHALLENGES
- AMBIONER was commissioned by BROCCOLINI (design, construction and management of real estate assets and complexes) to develop and implement an energy management plan for one of its new buildings: the new Maison Radio-Canada.
- Since this complex energy monitoring required them to use a large amount of collected information, AMBIONER 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
