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
Pricing
AvidXchange
Microsoft BI (MSBI)
Editions & Modules
AvidXchange
5,000
per license
Power BI Pro
$14
per month per user
Power BI Premium
$24
per month per user
Offerings
Pricing Offerings
AvidXchange
Microsoft BI (MSBI)
Free Trial
No
No
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
AvidXchange
Microsoft BI (MSBI)
Features
AvidXchange
Microsoft BI (MSBI)
Payment Management
Comparison of Payment Management features of Product A and Product B
AvidXchange
9.8
1 Ratings
27% above category average
Microsoft BI (MSBI)
-
Ratings
Customizable Approval Policies
10.01 Ratings
00 Ratings
Financial Document Management
9.01 Ratings
00 Ratings
Payment Status Tracking
10.01 Ratings
00 Ratings
Payment Audit Trail
10.01 Ratings
00 Ratings
Duplicate Bill Detection
10.01 Ratings
00 Ratings
Accounts Payable
Comparison of Accounts Payable features of Product A and Product B
AvidXchange
10.0
2 Ratings
35% above category average
Microsoft BI (MSBI)
-
Ratings
Automated Accounts Payable Processes
10.02 Ratings
00 Ratings
Vendor Management
10.02 Ratings
00 Ratings
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
AvidXchange
-
Ratings
Microsoft BI (MSBI)
9.5
51 Ratings
15% above category average
Pixel Perfect reports
00 Ratings
9.344 Ratings
Customizable dashboards
00 Ratings
9.651 Ratings
Report Formatting Templates
00 Ratings
9.649 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
AvidXchange
-
Ratings
Microsoft BI (MSBI)
9.1
51 Ratings
13% above category average
Drill-down analysis
00 Ratings
9.346 Ratings
Formatting capabilities
00 Ratings
8.951 Ratings
Integration with R or other statistical packages
00 Ratings
9.540 Ratings
Report sharing and collaboration
00 Ratings
8.651 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
AvidXchange
-
Ratings
Microsoft BI (MSBI)
9.3
50 Ratings
12% above category average
Publish to Web
00 Ratings
9.346 Ratings
Publish to PDF
00 Ratings
9.346 Ratings
Report Versioning
00 Ratings
9.042 Ratings
Report Delivery Scheduling
00 Ratings
9.345 Ratings
Delivery to Remote Servers
00 Ratings
9.525 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
AvidXchange is well suited for companies with multiple locations where approvals may be hard to get directly. A user can log on when they have time basically from anywhere to review, code and approve invoices. This would allow for processing of invoices centrally more efficiently then with appear invoices being moved from one place to another to be processed
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.
Our contractors and vendors can submit invoices electronically through AvidBill, removing the tedious task of sorting and coding mail. This feature saves on time and administrative duties.
Communication is key, and being able to log a comment or question in AvidInvoice allows for clarification and expedited approval process.
Having multiple properties, having the Property Code and % Allocation features allow us to ensure the correct entity is charged it's portion of expenses. For example, we may have a service that is coded to all 32 properties. With AvidInvoice we are able to allocate each entity's pro rata share of the invoice.
AvidPay needs some improvement to minimize the amount of time it takes to issue payment for invoices
The search features within AvidXchange on the advanced search screen sometimes do not function correctly (sorting by ascending / descending order doesn't work all of the time).
The log enhancement follow-up procedure could use some work.
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.
AvidXchange is very easy to use and the customer service is always there is you need help or more training. New employees even comment on how easy it is to pickup the program.
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.
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.
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.
We are presently evaluating a move to Concur Invoice, not because of any real lack of functionality from AvidXchange, but simply because we have other business functions already on Concur Invoice. From what we have seen so far, the functionality is similar, though I believe Concur Invoice is more expensive.
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 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.