Monarch

4.5 / 5 7 reviews

Who Uses This Software?

Business users who deal with data formatting, joining and cleaning in Excel


Average Ratings

7 Reviews
  • 4.5 / 5
    Overall
  • 4 / 5
    Ease of Use
  • 4.5 / 5
    Customer Service

Product Details

  • Free Trial
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Webinars
    Live Online
    In Person
  • Support
    24/7 (Live Rep)

Vendor Details

  • Datawatch
  • www.datawatch.com
  • Founded 1985
  • United States

About Monarch

Datawatch Monarch is an application that runs on your Windows desktop and as soon as you drop a file or web page onto the canvas it automatically begins to extract into analytics-ready rows and columns. You can also connect to all major relational, big data, and over 30 other sources, but often the most important information you need is locked away in existing reports or difficult sources that seem impossible to use without re-keying the data.


Monarch Features

  • Ad Hoc Reports
  • Collaboration
  • Dashboard Creation
  • Data Source Connectors
  • Data Visualization
  • Drag & Drop
  • Drill Down
  • Financial Reports
  • Marketing Reports
  • OLAP
  • Projections
  • Sales Reports
  • Scheduled / Automated Reports

Monarch Reviews Recently Reviewed!

Monarch has been invaluable with extracting data from our mortgage servicing reports

Aug 01, 2017
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Ease of use. When I first started, I was able to teach myself how Monarch worked and easily able to get answers for my one off questions through their discussion boards.

Cons: More knowledge around the mortgage industry reporting and how the data is presented and needs to be extracted. I had to find another user in our industry to get a lot of help with the reports.

Overall: easy data extraction into excel, text, and pdf formats

Powerful, Easy to Learn and Use

Jul 27, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: The ability to easily extract data and it also has many spreadsheet and database functionalities. Works very well with Excel and Access. Fantastic at extracting data from PDF files.

Cons: Expensive, some processes could be streamlined or be made more user friendly, some performance issues.

Overall: Increased efficiencies and greater flexibility with data.

Just the tool needed

Jul 24, 2017
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: It saves SOOO much time on a lot of tasks that would normally take way more time to complete and does it pretty effectively.

Cons: There is a learning curve before you can use the product efficiently. Took some of our users a few months to get proficient.

Overall: its a huge time saver

Monarch Complete turned a 5 year long project into a quarterly process.

Jul 24, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: It's so versatile. I use it to normalize data exported from various sources so that I can make apples to apples comparisons for reconciliation and identification. It's a tremendous help to me. My description above is speaking to the fact that my first use of Monarch Complete was to develop a process to create a data table of custodian cost basis data concatenating data from 20 separate proprietary text files into a single table so that I could compare it to the same data from our portfolio accounting system - to reconcile cost basis or our clients' eligible investment accounts. Incorporating Monarch Complete into my process, I reduced a manual process that took over 2 hours to complete down to about 10 minutes - and then I was able to use Excel to reconcile the cost basis and determine all out of balance issues and report them for resolution - thereby concluding my cost basis project. During the development stage in Monarch, I saved workspaces related to this process, which allows me to then duplicate the process, I just have to change the source file name and it's done.

Cons: Mistakes are not always reversible, as I have found out and I have spent countless hours learning this lesson. When you cannot recover from a mistake, you are forced to close the workspace without saving, so all changes you made since your last save are lost and you have to start over. Basically, if you are not very technically oriented, you may find it difficult to begin working with. But that's mostly a learning curve and thankfully Datawatch has a large community of users that can assist and their support staff are very knowledgeable as well.

Overall: See my review...

I use this software to compile multiple documents into one spreadsheet.

Jul 24, 2017
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: I love that this software allows me to save formats, so when I come back to a similar project in a couple of weeks, I don't have to re-format my new work.

Cons: The software can be confusing to use, especially at the beginning. Once you understand the way it works, it's okay, but initially learning how the software works can be challenging.

Overall: It used to take me hours to compile all my documents in to a format that was usable. Using Monarch has reduced the time spent per month dramatically.

Best Data mapping software

Nov 22, 2016
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Comments: I've used Datawatch for about 5 years now and have yet to find a mapping need that it couldn't perform for what we do. Its very fast and is incredibly robust. You get what you pay for. It isn't cheap but it will do what you need it to do! Saves us a ton of time in daily work.

Transfer unformatted data into Excel

Mar 20, 2015
4/5
Overall
2.5 / 5
Ease of Use
4.5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I like the ability to dump unformatted data into Excel. For me, this was especially useful with SAP reports that couldn't be exported to Excel cleanly. Also, I like having different models that automatically format reports depending on what I need to analyze.

Cons: Some of the functionality isn't intuitive, like editing models.

Recommendations to other buyers: Get training to steepen the learning curve. Unlike more intuitive products, training is beneficial.