Challenges 

The oil services company dealt with extensive data spread across multiple tables and databases, making it difficult to acquire a 360-degree visualization of field asset health. The data access was limited to expert analysts, who spent considerable time recreating reports using custom database queries and Excel. 

Solutions 

Neal Analytics built a Power BI dashboard that enables instantaneous report generation based on filters that help in 360-degree asset visualization of field asset health. We also created connections to multiple data sources and current production figures. ​

The solution involved joining datasets using Power Query that allowed the customer to discover, connect, combine, and refine data sources to meet analysis needs. We then leveraged user feedback to iterate on visualizations to tailor views to user needs rapidly.

Results 

The Neal Analytics Power BI solution helped to increase awareness of available data across the organization. It also increased engagement in the application of advanced data inquiries. ​