“Creating dependable, structured data.”
Excel Infoways has several tools that help you ensure that the data you collect is the data that should be there. Whether it is assessing the energy data warehouse maintained by Excel Infoways or connected to your own databases and spreadsheets, we help to put peace of mind into your data and analysis.
The Database fortress resides on your premises giving you full control over who has access to both critical real-time, historical and internally generated market data. At the same time, the Excel Infoways suite provides you with extreme flexibility in terms of access to data and your ability to use it for your daily activities and integration with downstream systems:
Not only does Excel Infoways integrate the software that helps to download and analyze market data, we are proactively monitoring every source site to ensure that it is importing as expected. If something goes down, we are on top of it right away and provide you with the updates as soon as humanly possible. We know that data is important to your business because it is important to ours.
- Data Auditing and Archiving
- Errors Checking and Data Validation
- Data Revision Tracking
- Data Activity Reports
Every corporation should know what is going on with their data and the database itself. Excel Infoways maintains a full log of when data and database objects have been changed or removed. Not only does Excel Infoways let you know when market data or table structures have changed, it lets you know when, how many times and by whom.
Your decisions are important, that’s why it is also important to make sure that the information used to support those decisions is clean and passes the logic check. You can always catch every mistake but you can definitely be smart about finding them. Excel Infoways uses multi-level checks and balances to make sure that the integrity of your data and analysis passes natural logic tests.
- Invalid or suspicious values
- Lower or higher than expected record counts
- Inverted numbers or misplaced decimals
- Erroneous dates
Excel Infoways data importing capabilities includes the ability to collect revisions and the reposting of market data. Excel Infoways is constantly back-checking source sites and files to import the latest data. Once Excel Infoways encounters a change, it imports the change and maintains when it was first imported, when it was last changed and how many iterations it has been through. Excel Infoways can also archives the previous values for auditing purposes.
Excel Infoways maintains a source by source activity log. It lets you know if sources were successful or if they failed. Sometimes source sites are not available or you lose a database connection, if this is the case, Excel Infoways tracks and logs the event and then tries to import the source again. You will also receive emailed activity reports on the frequency that you choose indicating the last 24 hours of activity. Excel Infoways job is not only to provide you data management and analysis tools, its job is to help you make decisions based on quality market data.
| 
