Airtable vs. Microsoft BI (MSBI)

Airtable is an ideal platform for small and growing businesses to keep track of just about EVERYTHING they need to keep things running smoothly. It's a great way to keep tasks organized, and keep everyone on the same page with progress on all things. Our company finds the kanban particularly useful, as products go through a lifecycle from ideation to retirement, it's good to keep a database of what is in production, what's working, and what we've tried before. I can see the platform being challenging with much larger businesses, but for the small to medium businesses I've used the platform with, it is ideal.

Incentivized

Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.

• I can create tables, create and customize fields
• Airtable has capabilities commonly found in spreadsheet applications, but also has some of the features found in databases.
• The ability to filter fields. I set up a filter on the status field, so when a project is marked, complete, on hold, or canceled, that record is hidden from my current projects table view. If it is marked complete, the record is moved to the completed projects table view. In this way I can easily access a record of past projects
• Being able to duplicate tables and create alternate views
• Collapse and expand records. When I collapse the rows, I can easily scan current projects, next steps, project status, and due dates. When I expand the row, or field, I can see more detailed information about that field or record very easily. I can also expand or open the entire record. This is is helpful, when I am entering a lot of information to multiple fields in that record.

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

• When records are deleted, there could be more options for what happens to associated records in other tables.
• Multi-select fields should be sortable.
• The per-user pricing model can be cumbersome when you need to share bases with third parties but can't use a publicly accessible URL.

Incentivized

• The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
• Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
• Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.

Incentivized

We will 10/10 renew the use of Airtable because it has brought great value to our team. Not only is Airtable affordable, but it's also user-friendly and helps our team be efficient. We no longer need to rely on Excel spreadsheets being passed from person to person via email. Furthermore, we aren't dealing with corrupt Excel spreadsheets and the need to salvage data when a file is accidentally altered.

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.

IMO the usability of this product is its greatest asset. The UI is clean and the menus are intuitive to the point where I'd feel confident having a non-spreadsheety colleague take on building an Airtable for the first time with next to no training. I can't say that about every table-like software product that I've used such as Notion.

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 have rarely experience downtime, compared to other tools, and given how much time we spend on the tool. Even if there were to be, their updates on it are very timely, and our support team are able to provide any questions regarding

Incentivized

The product has been reliable.

I never had any issues with load time, even with the integrations that we use today (google sheets) However, I'm curious if adding additional layers of integrations would slow down performance. We do carry quite a bit of data in Airtable, but, again, no impact on overall performance

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.

Airtable has great support. They have a variety of support features to answer any questions. They have great self teaching instructions for templates and product tours. They also have support for teams and project management. They also have a fantastic customer help line. They are able and willing to answer customer questions and never have customers waiting long

Incentivized

While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.

This training was done in-house, but the Airtable team provided resources and how to guides to ensure that we covered all components of the system

Incentivized

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

Recorded trainings were provided by the Airtable team. Great as an evergreen resources to new team members and for anyone that wants to refresh their Airtable knowledge

Incentivized

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.

Training all users was an important part of the implementation, which did take considerable time and effort. At first glance without training, the content calendar can be overwhelming because of the amount of data. The features within Airtable seem to be endless but our team was able to identify the most important to be successful.

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.

Airtable was a really good fit for this specific use case as it provided a huge number of collaboration features in an intuitive and pleasant-to-use interface. The free tier worked initially with our work, and the upgrade pathway was fair and made sense for us.

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

I did not help purchase the product, but Airtable's per user pricing structure is inconvenient when some users only need occasional or read-only use.

Incentivized

There are TONS of opportunity to scale, but I think it's a matter if you have the time and resources to do so because the initial setup can be fairly time consuming and prioritized dedication

Incentivized

• It gives us a real-time experience of working.
• Through this platform, I always have the idea bout which of my team member is working on which particular part of the project, I can easily track their progress, and also I can easily correct them where it is required by adding sticky notes, by sending the attachments and URLs.
• Quality services.

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