Category: data
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
iOS7 design principles applied to visualizations
iOS7’s recently stated design principles are a good synopsis for design in general, and as applied to data visualizations. The key elements of sound information design are to strip away unnecess... 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
Time series overlay of cluster fault injection testing
Fault injection at scale is one of the more challenging performance testing scenarios that we’re asked to tackle. Not only are we dealing with deploying high scale workload simulations on comple... Read More
WSJ – Making Data Beautiful
An interesting article on the blending of art and the data sciences. http://online.wsj.com/article/SB10001424052702303299604577323743008395060.html At companies and universities, and far beyond, the g... Read More