Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$14
per month per user
QuickBooks Online
Score 8.1 out of 10
N/A
QuickBooks Online is a SaaS version of the QuickBooks product. It contains all of the features found in the local version. Higher-priced plans include greater automation, payment management, inventory and time tracking, and analytics features.
Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.
QBO is a great solution for small and midsize companies. If the goal is to record all transactions and pull reliable financial reports, QBO is a great option. QBO is also a great solution if most operations are run in a system like Ramp. It syncs well with systems like that and turns the data into something management can use to make decisions. QBO is great because so many people use it. It is easy to find training online, and many people have experience with it.
Workflows for accounts payable invoice review are terrific.
Bill payment allows you to pay vendors online via ACH or check without having to write a physical check, which reduces admin time.
The cloud based login lends well to a remote or hybrid work environment for staff.
QuickBooks Online allows you to pre-configure vendors' general ledger expense accounts. This helps with general ledger coding accuracy and consistency.
QuickBooks Online integrates with Rippling HRIS, Coast, Capital One, JPMorgan Chase, etc., which lends well to an efficient month-end closing and reduced administrative time.
I dislike that the online bill pay option through QuickBooks is required for their invoicing.
The auto-fill portion of the customer setup, specifically the company name, is listed, but it also auto-fills in the name portion, which is inconvenient and time-consuming to remove.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
It like the product 'right out of the box' and I trust Intuit will continually improve it over the years based on my experience with their desktop products. The large providers of Apps makes customizing the entire package relatively easy and seamless for a wide variety of business types.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
Beyond being overkill for a small org's needs, QBO is constantly stealing screen real estate and attention by hammering users for account upgrades, connecting to one of their approved consultants or buying add-ons. The idea of using a simple configurable bookeeping and light accounting interface is completely missing. At the very least, we should be able to hide functions like inventory that we will never use.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.
In my experience, most representatives keep me on the phone for hours, literally, for a single issue and then usually cannot resolve it satisfactorily. I have 10 open cases that need resolution and, in my experience, there has been NO follow-up communication on any of them.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
The person in charge of QB needs to be very accurate with record keeping and is recommended to stay on top of tasks. The biggest issue we have is reconciliation, and those issues occur only when too much time has occurred between reconciliations
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
As a freelance bookkeeper, the Desktop version of QuickBooks Online doesn't allow for ease of access from any device. Having to be on a computer with the software downloaded creates additional work to gain access to all required filings etc. Also, I personally find the linking functionality on the Online version to be much more streamlined and user friendly.
As we have grown along our professional path, we have also expanded our use of QB. The scalability is easy and features seem to be waiting for you until you need them. We have increased profits by over 10x from our first year in business to the current and have yet to find a reason to look elsewhere
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
QuickBooks has given us a useful portal by which to get an overview of our financials.
QuickBooks has given us a relatively easy way to send out invoices quickly and efficiently.
Due to the customization limitations on QuickBooks, we've had to get creative in third-party implementations to better represent our brand and to track financials.
