Apple Numbers vs. Microsoft BI (MSBI) vs. Microsoft Excel

Apple Numbers is the PERFECT tool if you are looking to plan a conference at your church. Furthermore, if you are a youth pastor, Apple Numbers is incredibly useful in keeping track of how much each of your high school students has accumulated funds towards their summer camp bill. Lastly, Apple Numbers is perfect if you are trying to keep track of all your upcoming preaching opportunities.

Incentivized

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.

Incentivized

I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.

Incentivized

• Data security provided by Apple on its all the software.
• Very well integration within the Apple ecosystem.
• It is very well compatible with MS Excel also.
• It is available on iOS also. We can use it on our Apple mobile phones and on our iPads also.

Incentivized

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Incentivized

• It is very good at embedded formulas and tying cells to one another
• It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
• It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.

Incentivized

• Doesn’t have all the bells and whistles as excel.
• Sometimes you have to save it in a different format for others to view
• Could include more options on the menu bar rather than clicking on some of the drop downs.

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
• Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
• Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.

Incentivized

I just really like it

Incentivized

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.

Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.

Incentivized

The interface once familiar allows for quick work, and easy to use. very intuitive. Its easy to create beautiful spreadsheets, ones that capture interest and can communicate data in a easy to understand with Apple Numbers ability to organize, and make good looking with styles. Collaboration is great for our teams to all contribute the to document at the same time.

Incentivized

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.

Incentivized

I'm giving it a 7 because it is my go to. But the fact other prefer Google Sheets when working with a team does get irritating. I've used the online version of Microsoft Excel that other teams can get into and it still seems behind Google Sheets. It's a little clanky and slow? If that's even a term.

Incentivized

The product has been reliable.

I have rarely, if ever, had issues with its availability.

Incentivized

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.

Excel load and performs calculations immediately. It integrate well with all Microsoft Office applications and does not slow them down.

Incentivized

It is visually appealing and easy to use

Incentivized

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.

Incentivized

I have not had to use it often, but it is good.

Incentivized

This training was more directed toward what the product was capable of rather than actual programming.

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.

Implementing Numbers effectively, whether for personal use or within an organization, requires understanding its strengths and limitations to maximize productivity

Incentivized

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.

Apple Numbers lags behind Google Sheets when it comes to real-time collaboration and editing between multiple users (especially when you consider that Numbers is iOS based and anyone can use Google Sheets, regardless of the kind of device and operating system they have). However, Numbers is easier to navigate, which can be a benefit for some users.

Incentivized

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.

Incentivized

Out of Microsoft Excel, Microsoft Power BI, IBM SPSS, and Google Sheets, Microsoft Excel is by far the most common tool used for anything data-related across organizations. Accordingly, our organization has also implemented Microsoft Excel as a first-step tool. We recently adopted Microsoft Power BI (the free version), and use it occasionally (mostly for creating dashboards), but it is less commonly understood by stakeholders across our organization and by our clients. Accordingly, Microsoft Excel is more user-friendly and because of its popularity, we can easily look up how to do things in the program online. Google Sheets is a comparable alternative to Microsoft Excel, but because it's cloud-based and we have sensitive data that needs to be protected, we chose against using this software. Finally, a few users (including myself) have access to and utilize IBM's SPSS. For my role, it's a helpful tool to do more rigorous analyses. However, because of its cost and limited functionality as a simple spreadsheet, we only use it for more complex analyses.

Incentivized

N/A I was not involved in this process.

Incentivized

Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise

Incentivized

• Apple Numbers is a free software ...huge ROI!
• Apple Numbers is upgraded frequently and automatically without charge
• Enormous time saver when integrating Apple Numbers spreadsheet into word processor and presentation software
• easily exporter in pdf format. Ideal to share information
• On the negative side , it misses some advances macro and programmable functions features present in Excel
• Exportation as an Excel document sometimes defective
• Importation from Excel sometimes missions some features

Incentivized

• 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.

Incentivized

• Excel has positively impacted the business as it has increased our efficiency.
• It also saves us the time that we would have spent on making the calculations that it does for us.
• Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative.