Tag: data
Nerf Retaliator Chronograph Numbers
NERF data! A good part of the allure of the Nerf hobby is a new and interesting source of different data sets to explore. In this case the data that I found intriguing was the population statistics ar... Read More
useful Linux stuff
This is a collection of useful Linux commands and procedures that I compiled as a reference for me since I always forget this stuff. Hopefully it will prove to be useful for others too 🙂 &n... Read More
VBA dictionaries and arrays & performance log analysis
Back to the main data prep VBA page I’ve been experimenting recently with Excel VBA dictionaries and arrays to avoid writing to disk while parsing log files. I have been using a dictionary to ca... Read More
Extracting data with Excel VBA from SVMON output
Back to the main data prep VBA page This is a small Excel VBA script I wrote to pull the SVMON memory statistics for a specific PID that contains concatenated SVMON output. I’ve had to modify th... Read More
Extracting data with Excel VBA from DB2diag logs
Back to the main data prep VBA page Here’s a relatively obscure Excel VBA script that you would likely never use, but it is helpful if you care about IBM DB2 buffer cache sizes over time that ca... Read More
Extracting data with Excel VBA from DB2 snapshots
Back to the main data prep VBA page I use this script to compile data from multiple DB2 snapshots into a single time series table that can be used to generate time series plots for use in enterprise w... Read More
Extracting data with Excel VBA from NMON output
Back to the main data prep VBA page This is a script I use for extracting data of interest from NMON output. Often I need t0 extract data from a variety of tools a customer is comfortable using, an... Read More
Extracting data with Excel VBA from IOSTAT output
Back to the main data prep VBA page This is a sample script that I used in Excel VBA to extract data from IOSTAT output trapped at a regular interval (typically 15 seconds) to create a single row time... Read More
Extracting data with Excel VBA from Oracle AWR reports
Back to the main data prep VBA page This is an old script I created that imports HTML based reports into Excel, searches for the target headers in the file, then pulls key data I specified for the OLT... Read More
Using VBA to conduct Oracle Statspack time series analysis
Back to the main data prep VBA page I work within development organizations helping to tune high scale workloads for our large scale commercial customer base. These customers typically deploy in a var... Read More
Small animal shipping container temperatures
Shipping dart frogs long distances is a common practice in the dart frog hobby. I’ve been curious about in box temperature profiles during transit, so working with other hobbyists we began a pro... Read More
Interesting visualization on drivers license tracking
As more information is presented about what government agencies are doing with our data, new visualizations are popping up. This one caught my eye: This is a dynamic chart that walks you throug... Read More
Intention – Apple design video
Very cool animation from Apple on their design philosophy. These concepts can be extended to information design and visualization. A core philosophy of mine is the removal of all unnecessary colors, l... Read More
Visualizing data: welcome!
Often the most effective way to describe, explore, and summarize a large set of numbers – even a very large set – is to look at pictures of those numbers. Edward R. Tufte I’ve spen... Read More
Vivarium temperature and humidity data
Back to the main dart frog page EDIT 2022: This page is an old capture of my initial profiling of my dart frog vivarium temperature data to ensure I had the correct temperature patterns in various loc... Read More
Dart frog vivarium comparison to locale specific weather data
dart frog weather data... Read More
Outliers drive innovation
Interesting perspective on Forbes.com on driving innovation in an industry. The premise is innovation is driven by a “fresh” perspective on a problem from “non-experts”. I can ... Read More
Blending project and result for a unified graph
Most high scale performance engagements require a blend of sound project management processes and deep analytical profiling of system logs. Many customers do not anticipate the level of preparation an... Read More