Data Analysis....


"Those who cannot remember the past are condemned to repeat it" (George Santayana)

Both spreadsheets and datatabases hold data in a grid consisting of rows and columns. The spreadsheet is limited in its storage capacity but working with the data is simple and immediate. The database requires active queries to modify the data but is much faster at processing large volumes of data and has virtually unlimited storage.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 >

A statistical model is a representation designed to show or explain the workings of a system or concept represented by data.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 is the process of extracting hidden patterns from data and is becoming an increasingly important tool to transform this data into knowledge. It is commonly used in a wide range of applications, such as marketing, fraud detection and scientific discovery.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 >

Analysis is....

  • A Literal translation of the Greek word "ἀνάλυσις" meaning "a breaking up".
  • The process of breaking a complex topic into smaller parts to gain a better understanding.
  • Deducing systematic relationships from observed behaviour.
  • See a JMP video which explains what analytics is about or download the white paper.

Our Skills....