Save Time and Money for your Small Business with 24/7 AT&T Tech Support.
tech360.att.com
Fast & Easy to use reporting solution. Create reports without writing any code! Customize, Analyze reports at will! Click here to download FREE trial
www.synaptris.com
Statistical Software for Quality Improvement, DOE, Gage R&R & More
www.Minitab.com
Download a Free Trial Copy of NCSS. Stats & Graphics. Comprehensive!
www.ncss.com
Direct Logic® creates custom databases for today's marketers
www.directlogicsolutions.com
Helping you understand the past To better shape the future
www.predictivetechnologies.com
Statistical & Data Analysis with Our Reliable XLSTAT Software.
www.XLSTAT.com/Probit
Business Intelligence, Analytics & Reporting Tools By MS Dynamics GP.
www.2020Software.com
Provider of custom applications software programming services specializing in custom database and intranet applications and provider of database consulting services. Products and services are sold to multiple industries. This company was capital...
www.allin.com
Save Time and Money for your Small Business with 24/7 AT&T Tech Support.
tech360.att.com
Provider of data center outsourcing and relational database services.
www.bluehilldata.com
Fast & Easy to use reporting solution. Create reports without writing any code! Customize, Analyze reports at will! Click here to download FREE trial
www.synaptris.com
Statistical Software for Quality Improvement, DOE, Gage R&R & More
www.Minitab.com
Database analysis is the process of extracting data from a database, cleaning it, associating it to other data and drawing conclusions based on these relationships. Data analysis requires a wide range of skills including specific knowledge of the business, statistical analysis and data-mining tools.
Businesses most commonly perform database analysis and management on their large store of data to understand customers and their behavior better. They then examine the customer data to identify the key customer groups and determine ways to increase sales to these groups.
The steps involved in db analysis are performed in distinct phases and have the following considerations:
1. Data extraction is frequently complicated by the fact that most databases develop through use rather than being designed. This step of database analysis is also made more difficult by poor documentation and missing data.
2. Cleaning the data first requires the correction of factual errors that have occurred over time. Analyze the data statistically and merge it with other data sources such as other databases or external data.
3. Analysis of the data involves the examination of data attributes like frequency and value which you use to make business conclusions.
Action Steps
The best contacts and resources to help you get it done
Select computer database analysis services for your small business
You should perform data analysis and design from a business rather a technical perspective. That is, a marketing research company is generally preferred over one that specializes in dba analysis.
I recommend: Find a consultancy like Dobney.com with expertise primarily in marketing and strategy development. They also have a good primer on the database analysis and design process. Practical Computer Applications provides consulting and desgn-built engineering services.
Get the correct database analysis and management tool for your needs.
You can generally divide database analysis tools can: those that are capable of analyzing data and those that analyze structure. Some tools are capable of both functions.
I recommend: Use the trial version from Data Assistance of the Database Analysis & Comparing Tool to see how these two functions can be combined into one application that provides graphical views and printed reports. Quest Software provides solutions for Oracle.
Maximize the return on your investment in database analysis
The key to effective database analysis lies in knowing the right questions to ask in order to identify previously undiscovered trends in your customer's behavior.
I recommend: Use a firm like Acxiom that is highly experienced in performing database analysis for the purpose of creating a more targeted marketing campaign. Look at Direct Logic Solutions, which provides advanced marketing solutions.
Tips & Tactics
Helpful advice for making the most of this Guide
- • A targeted marketing campaign is more cost effective than a mass marketing campaign because it reduces the offers you make to customers who would have purchased your product or service without an incentive.
- • It is important to establish the context when hearing the term 'database analysis.' It may describe the examination of the database's structure rather than the data it contains; a process more properly referred to as dba analysis.
Fast & Easy to use reporting solution. Create reports without writing any code! Customize, Analyze reports at will! Click here to download FREE trial


