Data Manipulation & Data Mining - Clerical On Call, providing Virtual Assistant, Secretarial and Clerical services

Data Manipulation
Regardless of your database, most software systems enable the export of data to a common format such as .CSV, MS Excel or MS Access. From any of these formats we can then perform the following types of manipulation: Identify duplicate records and remove them if required. Update records in the data file according to your requirements. For example, updating all records listed for Queensland and Northern Territory to “Northern Region". Concatenate data or add more than one record together as a new record. For example, placing First Name and Last Name together in the one field (ie: \| Joe \| Bloggs \| becomes \| Joe Bloggs \|). Merge or add multiple data files together. For example, your company may have more than one Customer list and you want to create a Customer Master Database. Extracting specific information from a database in preparation for moving to a new system. This is usually required when changing Software Systems and can be quite expensive when performed by the Software provider. These are only a few examples of the types of work that we can perform to make your data more accurate, reliable and useful to you.
Data Mining
So many Companies have masses of data saved up in data files, but do not have the ability to access this invaluable information and present it in a way that they can use it to improve the way that they operate. Clerical On Call can unlock this untapped resource and allow you to take full advantage of the gold mine that you are sitting on. Data Mining is the process of extracting specific information from a database according to your set requirements and is usually done for reporting and analysis purposes. An example would be where you have a National Customer Database containing all of your sales information and you want a list of the "Top 10" Customers by "Sales Revenue" for each State, for the month. Clerical On Call can also provide assistance with reporting, using either MS Excel or MS Access. Contact us today, tell us your requirements and let Clerical On Call come up with a solution that fits your business.