Development in Alteryx and PowerBI visual dashboards

Alteryx Requirements. 1. Preparation of the flow to loading the data from the SmartAE database and structure the data as defined by SmartAE representatives in a manner which can be successfully loaded and utilized in PowerBi 2. The data need to be loaded from the SmartAE database and structured and cleaned data to be pushed and stored back to the SmartAE database 3. The data structured data need to be cleaned with the set of rules of frequency defined by SmartAE 4. The flow must be defined per building i.e. all the related tables of a building need to be combined together in one master table of the building 5. The frequency of the data stored in SmartAE database is once a day hence the frequency of flow to run to be accordingly as well 6. A POC need to completed in order to showcase the outcome of the flow before running it into production PowerBI requirements 1. Loading the structured and cleaned data from the SmartAE database to PowerBI 2. Utilizing the data, preparing analytical HVAC and energy dashboards in order to analyse performance parameters of equipment and chiller 3. Preparing a summary report page for the buildings which will be shared with the SmartAE clients 4. Report generation/sharing of the summary report Prerequisites 10+ years of experience as data scientist/ analyst. Selecting features, building and optimizing classifiers using machine learning techniques. Data mining using state-of-the-art methods. Enhancing data collection procedures to include information that is relevant for building analytic systems. Processing, cleansing, and verifying the integrity of data used for analysis. Experience with Alteryx & PowrBI. Azure is a plus.