We have to calculate most all Lab / Pilot / Proposals sizing and results. The automated calculations in [Excel4apps] is awesome, as once you are familiar with them, it is easy to quickly implement them when needed.
Targit is very strong when the data is presented to the system. Because of this, we are able to report on almost all of the information that is valuable to us. When we have questions or ideas on how to better leverage Targit, they are great to work with. We track our sales progress/process in Targit and AP tracks things such as outstanding invoices, open invoices, etc
It is possible but difficult to retrieve data or set criteria from different module into a single report or retrieve. If it is more user friendly instead of having to create a complex formula to retrieve the data, this function will be utilized more often.
It will be nice to have visual (graphs, etc.) report template available
It is helpful if we can retrieve data for a range of date, instead of just YTD, PTD etc. and multi-year data all at once for comparison too.
Probably one of our biggest complaints from the user community is the inability for the user to see the details behind the data. I know with the tool you can write reporting services reports that would allow users to see the detail by right clicking on a measure and selecting Actions, but for a very lean IT shop there simply has not been time to build these Actions for every possible scenario a user might want to see detailed reporting on.
Another complaint I've heard is the inability for the user to know exactly what the data represents from the source. If Targit had maybe some type of capability to hover over a measure or dimension and see a pop up of a more detailed description this might help resolve that issue.
The most difficult concepts to teach our users is how and when to use comparisons and the syntax for calculations. Creating comparisons has become much simpler with the 2k11 release but it is still difficult for my users.
It is very easy to use and I am proficient at this point to be able to figure out how to run most of the reports I need. I have had the time to "play around" in TARGIT and really teach myself about the visibility settings and other aspects - though other users have needed help with some of these aspects - but once you conceptually understand how to build the reports, it is very simple from a power user perspective.
I am not a power user of Excel. So I find Exel4apps a friendlier version of the things that I could do on Excel and making it easier with a magic wand.
Everything on the back end needs to be correct, which sometimes it may not be set up or missing some variables. Some of the more difficult parts of Targit require a lot more attention and object creation to work properly
Everyone I've dealt with at Targit genuinely cares about me and my success, and they respond to questions quickly and accurately. There is literally nothing more I could ask for from their support.
Make sure all of the back end work is done prior to getting Targit set up. Every variable you may need for calculations needs to be correct and every item needs to be uniform so it is read properly.
Excel4apps is more user friendly and can retrieve data much easier and in a nicer format than Jaspersoft. Qlik Sense is useful and have more visual reporting and dashboard. However, it is usually used for higher level of analyses and review. Yardi is used for specific purpose, which is different than Excel4apps. Excel4apps can pull all the financial data from Oracle, including billing and collections.
It really met our business requirements when we were searching for a reporting/Bi tool and the flexible business model of being able to introduce additional functionally as your organization grows and requires it made the investment decision the right one for us. The functionality available in comparison to the investment is well worth it.
