D
D R
Hi,
Looking for advice from a data analysis guru...
Constraints:
No budget, must be free
Must be legal
Limited time (same old story)
Home project (may later take to work)
Large amount of flat data in CSV format, many columns, different data
types (dates, integers, variable/static text), 200k rows and growing...
At home: Win XP Pro SP2
Office 2003 (no Access)
At work: Win 2000 Pro SP4
Office 2000 (no Access)
Background:
Data is backup job statistics from Veritas/Symantec NetBackup, in CSV
format, with data items such as:
Job ID Integer, Job Status Integer, Policy/Class Name, Client Name,
Schedule Name, Queued DateTime,
Actual Start DateTime, Elapsed Time, End Date TIme, Num Files
Integer, Num Kb Integer. Kb/sec Integer,
Media Server Name, Storage Unit Name
Data is clean, validated and structured. If I have any problems, I can
write my own code to clean it further.
Requirements:
Ability to filter any column, using values, patterns, wildcards, ranges,
exclusive/inclusive lookup from list (i.e. select multiple match/mismatch)
Ability to sub-total by selecting any (definitely one, but possibly two
or more?) columns/sets
Visualise in bar or pie format.
Preferably:
Extract data subset and save to CSV file
Print sub-totals, graph
Save and re-use selection/query
Resources:
Me. I'm fairly good at WSH/VBS (not WSF or WSC or HTA).
I also have a valid legal VB6 Licence - but I didn't really want to have
write a whole new app from scratch. my own
My initial questions are:
Any advice on how to go about analyzing a lot of data?
Does anyone know of, or where I might begin to search for a simple-ish free
tool?
I've spent hours searching the web for OLAP, MDX, "cubes" and other
related terms... ugh...
Does anyone know off a free multi-dimensional viewer for flat ASCII CSV (or
tabular) data? I'm not looking for a huge product. I once played with
Cognos PowerPlay (years ago, probably v1 or v2), and I'd like something
simple like that.
If I have to write my own app. do you think it could it be done in an HTA or
WSF or WSH or would it be better in VBA from within Excel itself?
Thanks in advance,
Dave.
Looking for advice from a data analysis guru...
Constraints:
No budget, must be free
Must be legal
Limited time (same old story)
Home project (may later take to work)
Large amount of flat data in CSV format, many columns, different data
types (dates, integers, variable/static text), 200k rows and growing...
At home: Win XP Pro SP2
Office 2003 (no Access)
At work: Win 2000 Pro SP4
Office 2000 (no Access)
Background:
Data is backup job statistics from Veritas/Symantec NetBackup, in CSV
format, with data items such as:
Job ID Integer, Job Status Integer, Policy/Class Name, Client Name,
Schedule Name, Queued DateTime,
Actual Start DateTime, Elapsed Time, End Date TIme, Num Files
Integer, Num Kb Integer. Kb/sec Integer,
Media Server Name, Storage Unit Name
Data is clean, validated and structured. If I have any problems, I can
write my own code to clean it further.
Requirements:
Ability to filter any column, using values, patterns, wildcards, ranges,
exclusive/inclusive lookup from list (i.e. select multiple match/mismatch)
Ability to sub-total by selecting any (definitely one, but possibly two
or more?) columns/sets
Visualise in bar or pie format.
Preferably:
Extract data subset and save to CSV file
Print sub-totals, graph
Save and re-use selection/query
Resources:
Me. I'm fairly good at WSH/VBS (not WSF or WSC or HTA).
I also have a valid legal VB6 Licence - but I didn't really want to have
write a whole new app from scratch. my own
My initial questions are:
Any advice on how to go about analyzing a lot of data?
Does anyone know of, or where I might begin to search for a simple-ish free
tool?
I've spent hours searching the web for OLAP, MDX, "cubes" and other
related terms... ugh...
Does anyone know off a free multi-dimensional viewer for flat ASCII CSV (or
tabular) data? I'm not looking for a huge product. I once played with
Cognos PowerPlay (years ago, probably v1 or v2), and I'd like something
simple like that.
If I have to write my own app. do you think it could it be done in an HTA or
WSF or WSH or would it be better in VBA from within Excel itself?
Thanks in advance,
Dave.