November 2008 Monarch Report eNewsletter [Archive]

Mike Urbonas

November 13th, 2008, 07:42 PM

<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr><tr><td colspan="2"><H1 align=center> <img src="http://www.monarchforums.com/images/Monarch_Report.gif" alt="The Monarch Report"></H1></td><tr> <TD width=540> November 2008 The Monarch Report informs users of our Monarch-powered solutions of the latest product news, tips, user stories, upcoming events and more. This newsletter is sent to our online subscribers and anyone who has purchased or expressed interest in Datawatch products. </TD> <TD style="PADDING-LEFT: 10px; VERTICAL-ALIGN: top" rowSpan=14>Read More About our Solutions... <A href="http://www.datawatch.com/_products/monarch_overview.php" target=_blank>Monarch</A> is the de facto standard in Report Mining, trusted by over 400,000 users to easily mine data from reports, PDFs and more into live, actionable data without programming and without IT help. <A href="http://www.datawatch.com/_products/monarch_data_pump.php" target=_blank>Monarch Data Pump</A> is a server-based enterprise reporting and data ETL solution, creating and delivering customized data across your organization, at a fraction of the cost and time of alternative solutions, with no new database programming.<A href="http://www.datawatch.com/_products/monarch_bi_server.php" target=_blank>Monarch BI Server</A> is a web-based Business Intelligence solution built specifically to address the unique needs of small-to-medium sized businesses (SMBs) and department-level users. Highly cost-effective and implemented in just a day, easy-to-use Monarch BI Server stores and dynamically transforms existing reports and other business documents (a plentiful information source typically ignored by other BI solutions) into browser-based or Microsoft Excel spreadsheet tables, summaries and charts. This allows users to solve daily operational issues without the time and expense of building data marts, using complex data access query tools, programming or burdening the IT department with requests for custom reports.<A href="http://www.datawatch.com/_products/monarch_rms.php" target=_blank>Monarch|RMS</A> (Report Mining Server) turns any traditional COLD report archive or existing document management system into a powerful source for business intelligence. <A href="http://www.datawatch.com/_products/datawatch_es.php" target=_blank>Datawatch|ES</A> uniquely leverages existing reports as a source of web-enabled enterprise business intelligence, providing enterprise report management, online data analysis, MS Excel integration and more, at a fraction of the complexity and cost of other solutions.<A href="http://www.datawatch.com/_products/datawatch_bds.php" target=_blank>Datawatch|BDS</A> (Business Document Server) is a high speed, high volume document archive system, archiving text, images, intelligent data streams and unstructured content, complete with file compression. Unlike other document archive systems, Datawatch|BDS also offers advanced business benefits, including optional automatic email notification to end users of newly archived documents, as well as optional web-enabled transformation of reports and PDF files, into customized data using Monarch|RMS. <A href="http://www.datawatch.com/_products/datawatch_mailmanager.php" target=_blank>Datawatch|MailManager</A> is a highly scalable e-mail management solution that provides complete lifecycle, compliance, and storage management for Microsoft Exchange environments. Datawatch|MailManager captures internal, outgoing and incoming email correspondence, indexing it and managing its retention based on your corporate policies. In the case of audit or legal discovery, related e-mail can be instantly and accurately retrieved for rapid response.
<TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">In this Issue...</H3> <ul> <li>Don't miss our new Monarch Data Pump and Monarch BI Server webinar series. <a href="#article10">[more]</a></li> <li>European bank Crédit Agricole Selects Monarch. <a href="#article20">[more]</a></li> <li>Visit our new MonarchTV YouTube channel! <a href="#article30">[more]</a></li> <li>Monarch Tip: Special Summary Sorting Made Easy. <a href="#article40">[more]</a></li> <li>The Joe Monarch Caption Contest: We have a winner! <a href="#article50">[more]</a></li> <li>Monarch Training: More important then ever. <a href="#article60">[more]</a></li></ul></tr></td> <TR> <a name="article10"></a> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Announcing New Monarch Data Pump and Monarch BI Server Webinars</H3> Enterprise Information Delivery and Business Intelligence Made Easy Please join us for our new webinar series highlighting the enterprise business benefits offered by Monarch Data Pump and Monarch BI Server! <a href="http://www.datawatch.com/_solutions/form_monarch_webinar.php">Please register now</a> for any or all of these upcoming webinars! Monarch Data Pump: Programming-Free, Hassle-Free ETL THURSDAY, NOVEMBER 20 1:00PM EST / 10:00AM PST You will discover how Monarch Data Pump serves as an enterprise ETL solution to populate data marts and warehouses stored in SQL Server, Oracle, etc., all the while sidestepping the typically highly complex and error-prone processes of table-to-table data mapping and programming-based data cleansing. Dramatically less expensive and easier to maintain the alternative solutions, you will discover Monarch Data Pump will exceed your expectations, but not your budget! Monarch Data Pump and Microsoft SharePoint: A Powerful Combination for Enterprise Reporting and BI THURSDAY DECEMBER 4 4:00PM EST / 1:00PM PST Monarch Data Pump's enterprise information delivery capabilities include the ability to export Excel and other files created by Monarch Data Pump into Microsoft SharePoint repositories. Even better, Monarch Data Pump's features are designed to make data integration with Microsoft Office SharePoint Server (MOSS 2007) a snap. This webinar will feature Monarch Data Pump in action, automatically transforming an existing ERP report into customized, SharePoint-based business intelligence, complete with web-enabled Excel files and SharePoint KPIs! Monarch BI Server: Business Intelligence Made Easy for Manufacturing & Distribution TUESDAY, DECEMBER 9 4:00PM EST / 1:00PM PST Monarch BI Server is a web-based BI solution for daily decision-making by everyone in your SMB organization, not just the technology "power-users." Now, you can solve operational issues without the time and expense of building data marts or struggling with complex data analysis tools. Unlike traditional BI solutions, Monarch BI Server leverages report output as a new, web-enabled source of live, actionable data at a low cost and level of simplicity traditional BI solutions can't touch. You will discover the unique, simple yet powerful business intelligence Monarch BI Server can provide manufacturers and distributors, complete with a live demonstration of Monarch BI Server in action, plus a live Monarch BI Server guest customer testimonial! Monarch BI Server: Healthcare Business Intelligence Needs, Solved. THURSDAY, DECEMBER 11 1:00PM EST / 10:00AM PST With Monarch BI Server you can leverage report output from your existing healthcare information systems as live, actionable data and also store and transform those reports -- on demand -- into customized web-enabled data for online analysis and export. You will discover how St. Josephs Medical Center has utilized Monarch BI Server to inexpensively and rapidly deploy a web-enabled report warehouse providing business intelligence improving patient care and business performance! You will hear directly from the St. Joseph Medical Center Monarch BI Server team and see Monarch BI Server in action showing a real-world healthcare informational challenge solved by Monarch BI Server. <a href="http://www.datawatch.com/_solutions/form_monarch_webinar.php">Please register now!</a> </TD>
</TD> </TR><TR> <a name="article20"></a><TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Merci, Monarch! Crédit Agricole Selects Monarch for Excel-Based Banking Data Made Easy</H3>Crédit Agricole is one of the world's largest banks by shareholder equity with 170,000 employees in 70 countries. The bank recenly selected Monarch to transform existing banking reports to enable Excel-based data analysis by location. <a href="http://www.monarchforums.com/images/Monarch_Credit_Agricole_Case_Study.pdf" target=_blank>Read this case study (PDF).</a> </TD> </TR> <TR> <a name="article30"></a> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <img src="http://www.monarchforums.com/images/Monarch_V10_Pro_Standard.jpg" align=left><H3 style="COLOR: #f00">Monarch V10 Now On YouTube</H3> We have uploaded the What's New in Monarch V10 recorded demo on YouTube for the world to see! This video is just the first of many to appear on our new MonarchTV YouTube channel to broadcast the programming-free, hassle-free business intelligence available to anyone with Monarch! <a href="http://www.youtube.com/user/MonarchTV">Check out our MonarchTV Channel now.</a> Please also see our <a href="http://www.datawatch.com/product_literature/Monarch_V10_brochure.pdf">Monarch V10 Upgrade Brochure.</a> <a href="http://www.datawatch.com/_buy/buy_main.php" target=_blank>Please purchase</a> or <a href="http://www.datawatch.com/product_literature/OrderForm_monarchv10_FINAL.pdf" target=_blank>Upgrade</a> to Monarch V10 now! 
</TD> </TR> <TR> <a name="article40"></a><TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Tip: Sort Your Summaries Superbly</H3>A Monarch summary can be sorted based on a key field, usually either alphabetically or numerically by a measure, such as by sales, quantity, etc. (or also manually by using the "specified values" option). Perhaps you have certain "VIP" customers, products, vendors, etc. that you always want to display at the top of your Monarch summary, no matter what their level of business activity, followed by the rest. Here is a clever solutiuon, with thanks to Datawatch Europe Monarch trainer Steve Caiels. <a href="#article1">Read More...</a> </TD> </TR> <TR><a name="article50"></a> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">"Joey" Wins Joe Monarch Caption Contest</H3><img src="http://www.monarchforums.com/images/Joe_Monarch_V10.jpg" align=left>"Done already? This will give me an extra 45 minutes a day to play solitare!!"Well, that's what Joe Monarch is saying according to Monarch forums member Joey -- Yes, that's right, "Joey" won our <a href="http://www.monarchforums.com/blog.php?b=20">Joe Monarch caption contest</a>! -- apparently Joe Monarch is not on the career fast track despite his excellent Monarch V10 skills! "Joey," we are all very certain that your tongue was firmly in cheek with your caption ;) 
We hope Joey enjoys his Amazon gift certificate as a gift for sharing a laugh with us all. Check out the other captions and add one of your own
<a href="http://www.monarchforums.com/blog.php?b=20" _target=blank>on the Monarch blog right now!</a> </TD> </TR><TR> <TR> <a name="article60"></a><TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Training: Must-Have Training for Immediate Productivity and Business Benefits</H3>
 It bears repeating: Amid a tough economy, organizations need to determine 'nice' expenditures from 'necessary' ones. The 'necessary' expenses are those that deliver an immediate return on investment…exactly like the Monarch training classes offered by Datawatch. "When our clients see how we can transform their existing reports into data with Monarch, the response is always the same: They tell us, 'This is amazing; you’re getting information we don’t know how to get ourselves!' ..."I was first introduced to Monarch by one of our clients. Soon thereafter, I attended one of Datawatch Corporation’s Monarch training classes. At the class, I was just blown away by Monarch’s ability to turn the reports we use on an everyday basis into live data. Incidentally, the Monarch training class was among the best training sessions I have [ever] attended." -- Michael Hall, Associate Partner, Moore Stephens Tiller LLC <a href="http://www.datawatch.com/_services/training_overview.php" target=_blank>Visit our Monarch Training homepage</a> for full details and to find a Monarch class near you! 
<a href="#top">Return to top of page</a>
</TD> </TR> </TD></TR> </table>
<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr> <a name="article1"></a>
<TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Tip: Sort Your Summaries Superbly</H3> A Monarch summary can be sorted based on a key field, usually either alphabetically or numerically by a measure, such as by sales, quantity, etc. (or also manually by using the "specified values" option). Perhaps you have certain "VIP" customers, products, vendors, etc. that you always want to display at the top of your Monarch summary, no matter what their level of business activity, followed by the rest: <img src="http://www.monarchforums.com/images/Monarch_Tip_Lookup_Calc_Field_Example3.jpg"> Using specified values does not help because all the values must be individually chosen. In other words, if you have 100 customers in your report and you want 4 specific customers at the top, followed by the other 96 in any order, you have to manually select all 100 customers! Datawatch Europe Monarch trainer Steve Caiels noted that by creating a lookup calculated field in the table window, you can weight your chosen customers, products, etc. to appear at the top of the list and put all the others at the bottom. This example shows a very simple "Lookup" calculated field defining a value of 4 (our "biggest VIP customer") to 1 for our four VIP customers based on the customer ID code (Note also we indicate all other customer ID codes should result in a zero). <img src="http://www.monarchforums.com/images/Monarch_Tip_Lookup_Calc_Field_Example.jpg"> Include this new calculated field in your summary and specify you would like to sort the summary based on this value in descending order (see Sorting tab screenshot below). In Monarch V10 (or V9), you can even hide this column so that it does not show up in your data (see Display tab screenshot below). <img src="http://www.monarchforums.com/images/Monarch_Tip_Lookup_Calc_Field_Example2.jpg"> 
<a href="#top">Return to top of page</a></TD> </TR> </TD></TR> </table>