August 2, 2021
CHALLENGE
A global aircraft lessor wanted to use the Power BI business intelligence tool to enhance their reporting capabilities.
Zeevo professionals worked with the lessor to implement a data warehouse solution that leveraged the data from Leasepoint® and a collection of data warehouse aware MS Excel spreadsheets to fill any reporting data gaps.
APPROACH
- The available Leasepoint web services was used to source data and save it to an on-premise data warehouse SQL database, with scheduled periodic refreshes
- Implemented a collection of controlled MS Excel spreadsheets to collect and transform required data values, capable of reading from and saving to the data warehouse
- Designed the SQL data views and functions to deliver the Power BI data model requirements
OUTCOME
- The client benefited from a suite of MS Excel spreadsheets connected to the data warehouse and the ability for users to input, transform, and save any data required for operations or reporting
- The data warehouse incorporated the data repository needed to build out the required Power BI reports and dashboards
- Integrated data was made available for use in Power BI, advanced reporting and analytics, and other third- party tools
ZEEVO’S VALUE ADD
- In-depth knowledge of Leasepoint®, including the underlying data model
- Designed, developed, tested, and implemented the required MS Excel spreadsheets for recording required additional data values
- Designed, developed, and implemented the Leasepoint web services to SQL data warehouse solution
- Subject matter specialization to design and implement the data warehouse
DOWNLOAD CLIENT CASE STUDY (.pdf)
Related reads:
- Deploying a Solution to Perform Repeatable Fleet Utilization Analysis
- Designing and Implementing a Technical Specification Report with an Optimized ADS Template
- Enhancing Aircraft Technical Project Management with Web Application Integrating Fleet and Contract Summary Data
- Automating Aircraft Transition Reporting to Ensure Compliance with Lease Obligations
- Optimizing and Enhancing Maintenance Reserves Analysis Capabilities
- Maintaining Accurate Utilization and Technical Data for Aircraft Components
- Sourcing, Inputting, and Validating Technical and Contractual Data in Leasepoint
- Leasepoint System Optimization
- Delivering a Scenario-based, End-user Training for Leasepoint® with Manuals and Desktop Procedures
- Facilitating the Transition to New ERP and Contract & Asset Management Applications Systems
- CMS System Optimization
LET’S TALK
John McCartney
Phone: +1 760 933 8607
jmccartney@zeevogroup.com