Nishant S.
tableau developer
India | Asia/Kolkata (USD)
Full-time : 30+ hrs/week
ABOUT ME
The scope of this project is to develop a product for Data analytics.
Automatic dashboard was mainly used by internal supervisor and manger to access and track jobs .Company already had a internal data query tool wrote sql query to run ETL jobs and dump them in to target database the api of the tool was built by other developers in order to call that api and dump data into target database first wrote sql queries and then wrote a python program to fetch data and visualize on tableau 10.3 report which was color coded on different colors to depict whether job has been successfully completed, waiting for completion or has failed which is refreshed as we have jobs completed this helped our internal team a lot to track the jobs and at every automated job finish an automated email was sent to every user or if a job fails an email was sent to users for alerting them. Data were saved as CSV files. It helped mainly to optimize failure, failing a job and data to be accurately measured.