Selasa, 15 April 2008

Data Cleansing and matching

Data Cleansing and matching is covering some processes as follow:

1. Data Definition
Intake process ( Extract) Data of Database and or from other system, from various format type and data base type like Oracle, AS400, Dbase, Foxpro, SQL, Excel, Text, and others). Data Extract can be conducted by 2 methods:
• Direct Method
Data taken by connect is direct the than Database, with snapshot technique - only read henceforth to process.
• Indirect Method
Data taken indirectly from Database conducted process degradation of Data beforehand to format . txt henceforth to process.

2. Verification and Data Integration
Process Verification Data is process inspection of data per record pursuant to the data type and field of like format of date, ascii, numeric. etc
Target of process the data verification is to ascertain entire/all data to be processed have as according to format of Source got Data of Text / Database..

3. Data Cleansing
Process Data of Cleansing, in this case that is doing standardization in entire/all database to be content than the data base as a whole according to the format form or standard of [is] same, like determination :
• Writing of Block letters / Lower Case
• Writing of title
• Uniforming of Abbreviation word
• Tanda baca (Ex : - _ . , ; and etc)
• Conversion Letter of Romawi (ex: V = 5)
• etc

4. Data Identification
Process identify can be done by using some conditions pursuant to fringe which have been determined. As for obtained result from identifying data earn like.:
• Active Customer number
• Customer Non Active (based on criteria)
• Data Duplication
• Single Data

5. Data Matching
Adjustment process or adaptation of data ( " Match" or " Note of Match") pursuant to some alternatives like :Nama Customer dan Alamat Customer
• Customer Number
• etc

We could assist you to data cleansing and matching of your database. Please see our services.

Senin, 14 April 2008

Data quality

From Wikipedia, the free encyclopedia

Data Quality refers to the quality of data. Data are of high quality "if they are fit for their intended uses in operations, decision making and planning" (J.M. Juran). Alternatively, the data are deemed of high quality if they correctly represent the real-world construct to which they refer. These two views can often be in disagreement, even about the same set of data used for the same purpose.

1. Data Quality refers to the degree of excellence exhibited by the data in relation to the portrayal of the actual phenomena. GIS Glossary

2. The state of completeness, validity, consistency, timeliness and accuracy that makes data appropriate for a specific use. Government of British Columbia

3. The totality of features and characteristics of data that bears on their ability to satisfy a given purpose; the sum of the degrees of excellence for factors related to data.

Step by step automatic database backup using SQL Server

I would share you information about step by step database backup automaticly using SQL Server :

1. Open SQL Server Enterprice manager
2. Click name of your database (ex : localhost)
3. Click Managament
4. Right click on Database Maintenance Plans. Then choose New Maintenance Plans Menu
5. It will appear new window-form wizard. Follow the instruction then click Next
6. Choose the database which will be backup then click NEXT
7. After Update Data Optimazation Information form appeared (there is nothing to do at this form). You just click NEXT
8. After Database Integrity Check form appeared (there is nothing to do at this form). You just click NEXT
9. After Specify Database Backup Plans form appeared, click CHANGE to arrange schedule of backup process then click NEXT.
10 After Specify Backup Disk Directory form appeared, Specify the directory in wich to store the backup file. then click NEXT.
11. After SpecifyThe Transaktion Log Backup Plans form appeared, check Back up the transaction log as part of maintenance plan if you want to make log , if you dont, ignore this instruction then click NEXT.
13. After that follow the instruction on the form until Completing the Database Maintenance Plan Wizard form appeared then input name of Plan: then Click Finish

NB : you have to switch off SQL Server Agent service before

Minggu, 13 April 2008

Our Services

Stock & Control Inventory
1. Assisting to selecting continuous stock items for the process of " test reconciliation".
2. Assisting to comparing the values of goods with value which is on " General Ledger "
3. Assisting to checking ordering and usage to improve rotation of current supply of products
4. Assisting to developing Stock report and High Value Balance" using some selected criteria
5. Assisting to testing and checking correctness of user's task completely
6. Assisting to compiling and grouping rotation of stock in a report
7. Assisting to testing and checking duplication data of products on field item no, goods name and price
8. Assisting to dissociating difference of data of price standard using other currency
9. Assisting to dissociating and analysing big transaction value based on Value, Group and others
10. Assisting to developing of profit-loss report based on product ordered ( Low-High, High-Low
11. Assisting to analysing difference between "Standard of Cost" with "Actual Cost"
12. Assisting to identifying products which have null quantity dan null price/amount
13. Assisting to equalizing and comparing accepted stock with general ledger of Vendor
14. Assisting to checking volume ordering of product based on items, depository warehouse and Vendor
15. etc

Account Receivable
1. Assisting to Developing report of recieving amount in a few formats (as your request)
2. Assisting to identifying credit notes, and balances and Invoice
3. Assisting to grouping the amount of Invoice based on Customer, Invoice, amount of payment and others
4. Assisting to making report of existence of number which lose / jumped in number sequence of invoice which have been made "
5. Assisting to Identifying data duplication of Invoice, Credit or ordered Consignment of goods
6. Assisting to Summarizing payment by client, representative sales, region and others
7. Assisting to Calculating missing revenue of un-paid invoice by client and others
8. Assisting to Making average value of sales amount based on product, representaive sales, region and others
9. Etc.

Account Payable
1. Assisting to dissociating cash of payment data based on Vendor/ supplier for the process of Audit verification
2. Assisting to Summarizing Data payment based on Customer, Bank, Vendor / others and supplier
3. Assisting to Collecting datas of voucher or of invoice which have in posting and compared to the amount of its Purchase Orders
4. Assisting to Dissociating data of invoices per year to check vendor's discount
5. Assisting to Dissociating difference of vendor's price unit based on product, overtime and others
6. etc

Salary and Payroll
1. Assisting to Summarizing salary data of employees based on criteria which select as review general
2. Assisting to Dissociating all remuneration datas where salaries amount exceed from accepted amount
3. Etc

Sales Analysis
1. Assisting to developing report of sales profitability based on product, customer and others
2. Assisting to Summarizing product sales based on region, cutomer, others and category
3. Assisting to Analysing Sales Trends based on period
4. Assisting to identifying acceptance volume based on product, customer, representative sales and others
5. Assisting to Dissociating all sale datas for Auditing based on customer, product and others
6. Assisting to Comparing between sale of product with posting of sale for the analysis of demand
7. Assisting to Summarizing Delivery of warehouse upon which analyse product distribution
8. etc.

Purchase Orders
1. Assisting to Dissociating data of price and acceptance for each product based on vendor data and purchase order data.
2. Assisting to Identifying duplication of purchase order data.
3. Assisting to Acceptance reconciliation based on difference of payment accretion on accepted item
4. Assisting to Analysing delay of product delivery which is causing on the delaying of work
5. etc

Sales Order Control
1. Assisting to developing report relation between product delivery with product order.
2. Assisting to Analysing current order with current invoice based on customer for the observation of credit
3. etc

Data Entry, Data Conversion & Data Migration Services
Outsourced delivery of online & off-line Data Entry Services for Data Conversion, Data Manipulation, Document Transcription, Word Processing, Database Migration, and Transformation. Excellent data processing skills (touch typing, fast key punching) and experience with major software applications such as MS Office – Word, Excel, PowerPoint, Access; We also provide Document Transcription services various document formats (PDF, HTML, DOC, TXT, ASCII) with output compatible with any word processing package or data processing software of your choice.

Jumat, 11 April 2008

Accomplishing Data Integrity

Data integrity is elementary concept of information system audit. Data integrity mean data have attribute: correctness, completeness, wholeness, soundness and compliance with the intention of the creators of the data.

Data integrity can be compromised in a number of ways:
# Human errors when inputed data
# Errors that occur when data is transmitted.
# Software bugs
# Data corrupt cause of viruses.
# Hardware damaged, such as disk crashes
# Force majure, such as fires and floods

There are many ways to minimize these threats to data integrity. These include:
# Backing up data periodicly, For example twice a week
# Controlling access to data via security mechanisms
# Designing user interfaces that prevent the input of invalid data
# Using error detection and correction software when transmitting data