Challenges
- The client dealt with a huge amount of data on a daily basis but was not able to utilize it properly for decision-making.
- The client needed to accumulate all of the data in one place, and convert it into actionable insights by generating relevant business reports.
Solutions
- Developed SSRS reports analyzing client’s data.
- Created SSIS packages for data refresh and for sending emails.
- Fixed technical glitches within existing reports.
- Provided a quick workaround for incident tickets for the end-users.
- Developed highly interactive Tableau dashboards for better UI.
Tools & Technologies
Microsoft SQL Server, Oracle, Tableau, Sharepoint
Key benefits
- The client can now easily and more efficiently analyze data and tender insights for better decision making.
- Enabled the client to gain deep insights into Carrier Performance Evaluation, Supplier Compliance Analysis, Capacity Planning, Routing, Scheduling, and various other areas.
- Availability of highly interactive Tableau dashboards for better UI and performance using the existing SSRS reports.
