
Database and Spreadsheet Applications - Making data useable.
The first step in Data Analysis is getting the data into a useable form. For many purposes this could be in the form of an Excel spreadsheet, but for larger amounts of data a database is unavoidable. Excel 2007 can handle 16 thousand columns by 1 million rows, but it's advisable to switch to database technology before these limits are reached unless you are using a workstation class computer. Get help >
Statistical Modeling - Summarising what your data is telling you.
With data in a useable form the second step is to find ways to understand the data and the relationships present within it. At the simplest level, this may be through visual techniques such as graphs and diagrams but can include more mathematical descriptive statistics (e.g. averaging) or more complicated inferential statistics (e.g. hypothesis testing). Get help >
Data Mining - Extracting hidden patterns from data.
Business data volume is increasing at an exponential rate as more of life is processed through computers. In 2003 a Berkeley University study forecast that data volumes would double every 3 years, but that now seems to be a low growth estimate. With these enormous data volumes Data Mining uses Artificial Intelligence and Pattern Recognition algorithms to automatically identify and model hidden patterns within data so that business insight can be gained and applied. Get help >