From the monthly archives:

March 2008

Presentation Matters

March 26, 2008

I was watching a music documentary on television recently, and one of the comments made really, um, struck a chord with me.
The interviewee in one particular segment was talking about how the introduction of music video in the 1980’s changed the industry, and how the careers of talented musicians such as Supertramp arguably ended almost [...]

0 comments Read more...

Executive Opinions of Business Intelligence Software

March 23, 2008

This is really fascinating.
It potentially reveals the common beliefs of a large group of business executives, based on what is likely a representative sample. This is exceedingly important, as this collective group, and the decisions they make, can have a huge impact on the economy of not just their home country, but globally.
On a single [...]

1 comment Read more...

Comparing Monarch’s Internal and External Lookups

March 21, 2008

One of Monarch’s greatest strengths is its ability to add even more related data to the new data that has just been extracted.
This gives all kinds of flexibility and analytical capabilities to your main information system, be it a small accounting package or a large ERP system, that it doesn’t currently provide. Imagine being able [...]

3 comments Read more...

Alternatives to Monarch Software

March 15, 2008

A visitor to the site was recently seeking information on viable alternatives to using Monarch software. Exactly what those alternatives are is a fair question, and one that should be properly addressed.
Here are just ten ways you could achieve Monarch’s results without using Monarch:

Re-key all of the data from the outputs of one system into [...]

1 comment Read more...

Handling Floating or Missing Values with Monarch

March 13, 2008

From time to time you may run into a report designed by some renegade programmer who thought that having values shift positions from line to line on the report was actually a good idea. Additionally, maybe she thought that, rather than display zero values, it would be best if the report simply doesn’t display anything [...]

0 comments Read more...

Revise Excel Formulas Quickly with Search and Replace

March 4, 2008

You can save yourself a lot of manual editing, or even copying and pasting, in Excel by using the search and replace (Ctrl-h) feature. This will replace all occurrences of one value, or even a part of a formula, with a different value.
Say you defined a lookup range improperly, setting the rightmost column to H, [...]

0 comments Read more...

Use Multiple Monarch Models

March 3, 2008

You may find that with a particular report you need often different layouts or fields in the table window, depending upon how you will use the data. Instead of modifying the structure of the table layout of your original model every time your requirements change, instead save as many versions of the model that you [...]

0 comments Read more...