Client Overview
Our Client provides lasting and integrated solutions in water, environment, transportation, energy, and facilities to public and private clients worldwide. As a full-service engineering and construction firm, we deliver exceptional client service, quality results and enduring value across the entire project life cycle.
Challenge
The client wanted to develop multiple Qlik Sense reports that were critical for the business use from a single source Data Warehouse (EDW) that will have all the information needed to present in the reports. Currently the reports were generated from multiple sources ie Oracle EBS database, Project Financial Data Mart (PFDM), and Global Delivery Excellence Framework (GDEF), Salesforce, Ecosys and P6 applications. The client was facing multiple challenges such as it was getting different to rely on the quality of the data, data latency, scalability, refresh cycles, data consistency between reports.
Solution
AAITCS Pvt Ltd, worked with the Client and its partners to develop the Qlik Sense reports that were sourcing the data from a single data warehouse EDW that had all the information it needed to present in the reports. We took all the distributed business logic from multiple reports (some excel, some old Qlik reports) and consolidated it into Qlik applications that sourced the data from data warehouse. We used Qlik sense server: 13.x.x and AWS redshift database.
Business Highlights
- Resource Forecast Manager view:
- This report is based on hours and allocation of managers and projects information.
- Managers who have access to the reports:
- Technical delivery Manager, Group manager, Regional Team Leader, Supervisor, project manager etc.
- Resource Forecast Employee view:
- Showing information about all employees and assigned projects with allocated hours.
- Project labor forecast accuracy:
- Showing all details of labors involving in construction and sites (having hours and allocation percentage)
- Project Control specialist view:
- showing the information about all project’s specific scenario and control process.
- Projects summary:
- All projects details and actual and forecast hours.
Added most attractive and valuable reports for end business user and got appreciation to fulfill the business requirement for clients on time and with quality.
Why Qlik Report: Most Business Intelligence (BI) products can help you answer questions that are understood in advance. But what about your follow-up questions? The ones that come after someone reads your report or sees your visualization? With the Qlik Sense associative experience, you can answer question after question after question, moving along your own path to insight. With Qlik Sense you can explore your data freely, with just clicks, learning at each step along the way and coming up with next steps based on earlier findings.
About Us
AAITCS Private Limited is an innovative information technology services firm offering world class software solutions. We are client-centric and relationship-based company with a focus to provide a cost-effective software development and support solutions. We focus on quality and delivering business value.
Incorporated in the year 2018, AAITCS Pvt Ltd, has been actively helping global cooperation to innovate and transform their businesses utilizing IT. Our global delivery and engagement models help us to office affordable long-term software solutions that meet out clients IT challenges and add business value. We combine our capabilities to invent, develop, and deliver innovations for clients to transform legacy models to take their business to the next level and create the future.
AAITCS has a team of expert Data architects and engineers to help you build a robust, secure and scalable architecture for your data warehouse. We are highly experienced in constructing unique architecture and conceptual data model for a variety of domains and segments. We work with cutting edge technology into Data Warehouse Migration, Data Modernization and Data Analytics also application development and empower businesses through automation to help clients attain excellence.