Energy Information Administration publishes an impressive collection of data accompanied with features to view and access them. Datasets can be downloaded one at a time or visuals can be built on EIA website. Still the vastness of this collection makes it difficult to navigate and for power users of tools like Excel there is no inherent connection to access, build and analyze data and easily refresh it to update visuals and dashboards. The same is true for other modern Business Intelligence platforms like Power BI. OilStat Data Connector bridges this gap. You can view and search for the categories you are looking for using intuitive tables and connections. All the series in the categories you selected then can be easily accessed with one query and most importantly you can just Refresh the data to bring the latest dataset into your model and have your visuals updated.
OData is a data access technology that utilizes existing Web protocols like HTTP to connect and query data. It has been formally standardized by major IT companies and is supported across multiple platforms and applications. This includes most of the Business Intelligence (BI) platforms, Excel and ERP systems. It is also noteworthy that you do not need any additional tweaks if your queries are done behind your corporate firewall. Connecting to OData is through HTTP which is the same way you view and navigate the Web.
No add-on is needed to access the data series. OData connection provider is built into Excel and most Business Intelligence platforms. There are also some Enterprise Resource Planning (ERP) systems that support connecting to OData data sources out of the box with no additional tools or configurations.
Our provider supports querying and previewing commands of a typical OData client which should be enough for most of the use cases. In more advanced scenarios, you may need to filter or group the data. We have implemented the Date Filter option to allow you quickly filter the data based on your selected date criteria at the source. This has been described in the Applying Date Filter Options section above. For all other filtering / grouping applicationas you need to load all the data and apply the intended operation with the functionality of the client software and do not rely on OData commands.
You can access all the data series published by EIA through Open Data platform with a count of around 1.2 million. Complement to this offering are two additional datasets for Drilling Productivity Report (DPR) and Baker Hughes Rig Count.
Main factors that determine the load time are no of series and data points in the categories you selected for download. A typical category with around 50 data series and 8000 data points should be downloaded in less than 10 seconds. There are categories like Electricity Plant Level data that hold hundreds of thousands of data points. You should expect the connection to take minutes to have the data ready and loaded for them. During the data load, the size or number of rows may stay at the same number or the connection may show no visual indication of progress but sure enough the data is being loaded behind the scene. In addition to no of series in a given category, data load time depends on various other factors including your connection speed, latency and the performance of your local or cloud system that you are loading the data into.
No, you don't. Your query will be applied against a cache repository that is not connected to the EIA data source directly. This repository updates nightly.
Please contact us with your feedback. We appreciate it and may be able to tweak and enhance our offering based on it.