Business Scenario
The data from different sources is maintained in MySQL database. The data recorded contains various attributes of the call, such as time, duration, completion status, source number, and destination number and also automated data. The call detail record contains data fields that describe a specific instance of a telecommunication transaction, but does not include the content of that transaction. The client wanted to integrate the data from different sources and form a single data source using ETL tool and load it in to PostgreSQL and connect it with tableau to create dashboards.