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
Planful
Score 8.4 out of 10
Enterprise companies (1,001+ employees)
Planful is a cloud-based enterprise performance management (EPM) suite. It includes financial applications for modeling, planning, consolidation, reporting and analytics.
$0
per year per user
Pricing
Microsoft BI (MSBI)
Planful
Editions & Modules
Power BI Pro
$14
per month per user
Power BI Premium
$24
per month per user
No answers on this topic
Offerings
Pricing Offerings
Microsoft BI (MSBI)
Planful
Free Trial
No
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Required
Additional Details
—
Please visit our website to submit a request for more information on pricing.
This was the most cost effective for the features our business needed. Centage and Microsoft's PowerBI did not offer everything we wanted. One Stream was a good alternative but very expensive for what our business needed.
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.
I think it is a useful tool from a reporting standpoint. It does a good job of data aggregation from different sources, even if slow at times. I think the tools for building forecasting and budgeting templates are straight forward but allow for a level of complexity that make it both easy to use but also allow for complex builds so that our models can take into account many different variables that drive our daily performance.
Creating forecasts for the month, quarter, and year
Creating new variables by using variables pre-defined and that are new in the system
Having a very simple setup in the reports section - not straying away from the old Excel model which most people are used to. I can speak for a lot of people when I say that tools that look new can easily be frightening! 😅
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.
Our new Comptroller understands the value of Planful, and we plan to utilize it further in the organization to enhance external reporting. Strangely enough, Planful had not previously been embraced by the former CFO, who argued that we were running two sets of books (of course, we were not). Fortunately, the before mentioned reconciliation of EBITDA to Net Income demonstrated that to the banks.
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.
The tool is extremely adaptable, and it enables very quick querying to give us opportunity to gain live insights into the business. Given its adaptability, we are also able to create scenario analyses very quickly in rapidly changing environments. The formatting also enables us to provide this information in a very consumable manner.
I only give a 9 rating rather than a 10 rating because it seems that every day around 2pm we see a slowdown in the use of Planful. I have requested our internal IT department verify that it is not an internal issue and have been assured it is the tool. We have not yet reached out to Planful to do extensive research to solve this issue.
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.
Again, the system is very reliable and, for the most part, runs very quick and smooth. When running larger queries, it does take some time, and during budgeting season our users experienced slower loading times, but nothing that raises concerns outside of normal network issues. Occasionally, as with any software we use, it will crash and you have to restart, but that does not happen very often.
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.
Sometimes we get great help when using Planful's support team and other times we don't. In particular, there is one person that often responds to our support tickets who is less than helpful, hence the reason for the 5 out of 10 rating. As a result, most of the time we reach out to our Planful consulting group as they provide faster and better support
My team has attended training offered several times before/during the Planful Perform conference. This training has been extremely useful and we always learn something we didn't know prior to the training. The trainers are always very knowledgeable and more than willing to help each and every user after the training with specific questions regarding their environment.
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.
Planful provides a lot of online training support. There's so many options for training. Admin Learning Courses, User Learning Courses. Plus they have several webinars devoted to the tool and the new features they release. New Releases can be practiced in a Sandbox Environment prior to going live in Production
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.
After going through the initial implementation with Host Analytics and a re-implementation with Cervello (due to an ERP change, not due to a poor initial implementation), I've learned that you really must rely on your internal staff to bear most of the implementation burden. Use the vendor or partners for ideas and best-practice suggestions, and some of the easy-but-time-consuming work. Since you will ultimately be using and maintaining the application, you should be able to do most of it yourself.
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.
Prior to joining the company, we tried to implement Vena but were unsuccessful. There we're a few reasons it didn't work out, but a lot of it related to the implementation team they provided. In just the first week with Planful, we achieved more progress than we did in several months with Vena.
From our experience, Planful is only used in 2 overhead departments in our organization. We easily added another overhead department, but they decided against using Planful for their workforce and financial planning. Removing them from our environment was extremely easy.
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.
