Engineering firm CDG boosts data accuracy and reporting with Aptude and Microsoft
Aptude, CDG, Inc., & Azure SQL and Power BI
Engineering firm CDG, Inc., had relied on manual processes for storing its financial
data and project information. To generate monthly reports for analysis, the firm was also manually downloading data to an Excel spreadsheet. These processes were error prone and of limited use. CDG turned to IT consulting and development company Aptude, which helped the firm modernize its data storage and project management and improve its reporting by implementing a Microsoft Azure SQL driven approach, supplemented by the reporting capabilities of Power BI.
CDG provides engineering, consulting, and development services to public entities, private enterprises, and the petroleum industry. Data is key to its success, but the slow, manual data entry processes it had been relying on left room for errors. CDG had been using the Deltek Vantagepoint solution for storing the firm’s data and using an OLAP cube to connect the data, but the cube alone wasn’t capable of storing historical data. In addition, the firm also found the overall usability of the data it needed for accurate reporting to be limited, and it couldn’t easily create data visualizations and surface actionable insights.
To act on its job to date (JTD) reporting with confidence, CDG needed greater accuracy and improved insights in reviewing its accounting data at the end of each month. As the firm’s data was stored in an additional database and OLAP cube, the data is now extracted using an MDX query from the cube to another database using a linked server. The steps to capture the historical and JTD accounting data are then entered in the stored procedure by combining MDX and Microsoft Azure SQL queries. The project uses SQL to gather multiple datasets to organize accounting cycle cashflows into a pipeline reporting dashboard and .pdf in Power BI.
“By automating its data collection and report formatting, CDG now saves significant time and resources.”
“The firm also enjoys greatly improved confidence in the veracity of its data.”
“CDG can easily drill down into detailed datasets and develop custom analytics.”
We provided our client with a solution based on their expectation using Microsoft Power BI and Azure SQL. They spend much time doing manual tasks using excel, which is time-consuming and not scalable. Therefore, we automate this process entirely. Dawan Reddy from our BI Team was part of this solution and provided good development and support.
Erich DeJesus, Chief Architect Power Platform – Aptude, LLC
By adopting an Azure SQL based approach to data, CDG has peace of mind that it has eliminated the potential for errors that plagued its previous manual processes. In addition, CDG can now take advantage of the far more robust dashboard and reporting capabilities provided by Power BI to create information rich visualizations and surface actionable insights.
Keep Moving Forward with Aptude
Aptude is your own personal IT professional services firm. We provide our clients with first class resources in a continuous, cost-containment fashion.
Our support services will free your senior IT staff from the overwhelming burden of day-to-day maintenance issues. They’ll have time to launch those new projects and applications you’ve been waiting for. Simply put, we can free up your resources and contain your costs. Let’s have a quick chat to discuss our exclusive services.