From the daily archives:

Sunday, October 21, 2007

Building Database Applications with Monarch

October 21, 2007

Importing Your Exports
You know that you can count on Monarch to mine data from your reports. You might even be using Monarch to combine data from various sources. But have you considered using Monarch as your main database program?
Developing database applications is usually the realm of programmers and systems analysts, but you may well have [...]

0 comments Read more...

Custom Reporting with Excel’s Pivot Tables

October 21, 2007

Driving Your Data to the Finish Line
You’ve worked hard to mine data from your reports. You’ve used calculated fields and external lookups to add value to your base data. You then used filters to isolate the most important data from the mountain of information you have at your disposal.
How are you going to present your [...]

0 comments Read more...

Dashboard Reporting with Monarch and Excel

October 21, 2007

Steer Your Organization Right
There are any number of software companies who want help you manage your organization by using their business intelligence programs. Often referred to as executive dashboards, these programs help organizations focus on both successful and problematic aspects of their operations so they can make ongoing positive improvements by identifying what is wrong [...]

0 comments Read more...

Making Your Excel Reports Unique

October 21, 2007

Customizing Excel Easily for a Personal Touch
If you’ve been working with Excel, or any of the Office products for that matter, you’ve seen your organization produce documents with the same basic look and feel time and time again. One of the easiest ways to shake things up a bit, and simultaneously give your documents a [...]

0 comments Read more...

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 or [...]

0 comments Read more...

Monarch’s calculated fields

October 21, 2007

Fields of Gold
Just like building formulas in Excel, Monarch lets you build your own formulas for your specific needs. One of the tools with which Monarch stores these formulas is called a “calculated field”.
Monarch categorizes its calculated fields as follows:

Formula-based fields. These are often very similar to the formulas you use in Excel.
Runtime parameter fields. [...]

0 comments Read more...

The Basics of Building Monarch’s Expressions

October 21, 2007

Avoiding Function Malfunctions
Apart from being aware of the functions at your disposal, and how they’re used, it’s really important to understand how the software is going to interpret your functions, and the order in which you want calculations to take place.
Central to this process is the topic of Boolean logic. Don’t get scared off if [...]

0 comments Read more...

← Previous Entries