From the category archives:

Filtering

Overcoming Limitations and Developing Top N Tables

August 31, 2010
Image by sam_churchill

The ability of Monarch to sort key fields in both the Table and Summary windows is tremendously useful as it enables us to further analyze our data. The ability to focus only on the most important data can be critical when working with data sets of any size. Let’s assume that we have a list [...]

0 comments Click to continue...

Finding Critical Data with Monarch

November 23, 2009

Well here we are again with another unexpected interruption of the 30 Days to Become a Better Monarch Modeler series. This time around, I had to take an unplanned business trip that threw a bit of a proverbial wrench in my machine. This was followed by returning to a sick family, and eventually and inevitably, [...]

0 comments Click to continue...

Mining Data Diamonds with Monarch

April 27, 2009

Once you’ve built the templates and calculated fields required to extract all of the data within a given report with Monarch, do you save your model, close it, and carry on to the next project, or do you spend some additional time with the report to transform your model from being perfectly functional and workmanlike [...]

0 comments Click to continue...

Address Your Addresses with Monarch

November 10, 2008

It’s usually around this time of year that the panic starts in offices everywhere. It often begins with “We need a clean list of contact information for the annual mailing”, and is just as often followed by an inordinate amount of stress on the part of the person who’s responsible for compiling the list. The [...]

0 comments Click to continue...

Fine Tune Monarch

September 25, 2008

When I’m at my desk for anything longer than just a couple of minutes, you can almost guarantee that there will be music playing. And it’s usually one of the many songs I copied from my constantly growing CD collection to my computer. It’s no wonder that the iPod and portable media players in general [...]

0 comments Click to continue...

Filtering Data with Monarch

October 21, 2007

Finding the Needles in the Haystack One of the main reasons that we use data extraction tools is to help us make decisions based on that data. And while the entire data set is certainly useful, often it’s the outliers, the values that are distant from the rest, or the values that exceed certain upper [...]

6 comments Click to continue...

Copyright © 2007 - 2013 Excel with Monarch Training and Services. All rights reserved. Privacy Policy
Microsoft Excel™ Microsoft Corporation. Monarch and Monarch Pro™ Datawatch Corporation.