CaseWare in Ontario offers IDEA, a data analysis and data extraction tool supporting audit processes. The vendor states IDEA integrates with various solutions to make obtaining and exporting data easy, such as SAP solutions, accounting packages, CRM systems and other enterprise solutions for a single version of the truth.
N/A
Microsoft Power BI
Score 8.4 out of 10
N/A
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
One example of specific scenario in [CaseWare] IDEA is the ability to run samples separately and then based off of the results, compare and contrast the values recorded and easily discern if there are any variables or discrepancies within the data itself. Also, we can test journal entries with certain parameters to check the audit for any issues that may arise pertaining to the criteria. By testing, we are able to make sure the data is accurate and sufficient.
In operations we use the tool for many different topics, from factory quality systems to high level reviews. We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand. Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.
Can use on large quantities of data and quickly analyze them.
Uses logic that can be followed if one is an auditor. I, for example, could understand the logic in a number of samples, i.e how the number of samples thrown changes when risk changes from low to moderate in proportion taking in consideration the materiality.
Other audit firms are using 2 software for the process that IDEA alone can do. So IDEA has a definite advantage here.
The desktop app is great but needs a lot of performance improvements
No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs
Premium Cloud Version of Power BI is awfully expensive
On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription
On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises
At this point, I think we all know who has taken the lead in the business intelligence and analytics market worldwide. With fresh new updates every other day on top of an already robustly built product with all features that one can dream of is a no brainer, I feel. Microsoft will invariably be synonymous with quality and professionalism.
I can't really speak to the support overall, [but] I will say that in the almost three years I have used the system, I have only needed to contact their support team once. I think the team was helpful, but it did take some time for us to resolve the issues/ request that they had. I guess the good news is that the system is pretty stable, and I personally have rarely needed to contact their technical support team.
I have used Microstart and would definitely vote for IDEA because IDEA combines what Microstart does with the help of one/more softwares. Where Microstart just gives a number of samples, IDEA selects the number of samples based on materiality, risk, and other factors. It selects those samples from the population leaving out line items that are invalid/ zero. I would prefer using IDEA any day.
[Microsoft] Power BI is practical and effective, like a hammer for a nail, it is easy to use and produces very quickly the results that in most cases are urgently required by clients (nice reports to share on the web). To start using [Microsoft] Power BI you need a business email address, with that you create an account in Power BI Service and in less than 1 hour you will have installed Power BI Desktop, a report will have been created and it will have been published on the web .
